Home > Developer > Oracle

Detailed introduction to the reconstruction process of the EM Console of the Oracle database

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

Oracle DatabaseInEM Console ReconstructionEM startup error. The error code is as follows:

 
 
    
  
  
  1. C:\Documents and Settings\GAOYANG>set ORACLE_SID=rman 
    2. 
  
  
  2.  
    3. 
  
  
  3. C:\Documents and Settings\GAOYANG>emctl start dbconsole  
    4. 
  
  
  4.  
    5. 
  
  
  5. OC4J Configuration issue. D:\oracle\product\10.2.0  
    6. 
  
  
  6.  
    7. 
  
  
  7. \db_1/oc4j/j2ee/OC4J_DBConsole  
    8. 
  
  
  8.  
    9. 
  
  
  9. _192.100.8.188_rman not found. 
    10.

As a result, we will analyze the problems that may occur during reconstruction:

 
 
    
  
  
  1. 1.EM Configuration issue  
    2. 
  
  
  2.  
    3. 
  
  
  3. 2.OC4J Configuration issue 
    4.

Follow these steps to recreate the Oracle 10g EM Console.

 
 
    
  
  
  1. C: \ Documents ents and Settings \ GAOYANG> emca-config dbcontrol db-repos
    2. 
  
  
  2.  
    3. 
  
  
  3. Recreate
    4. 
  
  
  4.  
    5. 
  
  
  5. EMCA started at 9:28:19
    6. 
  
  
  6.  
    7. 
  
  
  7. EM Configuration Assistant 10.2.0.1.0 official version
    8. 
  
  
  8.  
    9. 
  
  
  9. Copyright (c) 2003,200 5, Oracle. All rights reserved.
    10. 
  
  
  10.  
    11. 
  
  
  11. Enter the following information:
    12. 
  
  
  12.  
    13. 
  
  
  13. Database SID: rman
    14. 
  
  
  14.  
    15. 
  
  
  15. Listener port: 1158
    16. 
  
  
  16.  
    17. 
  
  
  17. SYS user password:
    18. 
  
  
  18.  
    19. 
  
  
  19. DBSNMP user password:
    20. 
  
  
  20.  
    21. 
  
  
  21. Password of the SYSMAN User:
    22. 
  
  
  22.  
    23. 
  
  
  23. Email Address of the notification (optional ):
    24. 
  
  
  24.  
    25. 
  
  
  25. Notification sending (SMTP) server (optional ):
    26. 
  
  
  26.  
    27. 
  
  
  27. -----------------------------------------------------------------
    28. 
  
  
  28.  
    29. 
  
  
  29. The following settings have been specified:
    30. 
  
  
  30.  
    31. 
  
  
  31. Database ORACLE_HOME ...... D: \ oracle \ product \ 10.2.0 \ db_1
    32. 
  
  
  32.  
    33. 
  
  
  33. Database Host Name...
    34. 
  
  
  34.  
    35. 
  
  
  35. Listener port number ...... 1158
    36. 
  
  
  36.  
    37. 
  
  
  37. Database SID ...... rman
    38. 
  
  
  38.  
    39. 
  
  
  39. Email Address of the notification ...............
    40. 
  
  
  40.  
    41. 
  
  
  41. Notification sending (SMTP) server ...............
    42. 
  
  
  42.  
    43. 
  
  
  43. -----------------------------------------------------------------
    44. 
  
  
  44.  
    45. 
  
  
  45. Continue? [Yes (Y)/no (N)]: Y
    46. 
  
  
  46.  
    47. 
  
  
  47. 9:28:36 oracle. sysman. emcp. EMConfig perform
    48. 
  
  
  48.  
    49. 
  
  
  49. Information: The operation is logged to D: \ oracle \ product \ 10.2.0 \ db_1.
    50. 
  
  
  50.  
    51. 
  
  
  51. \ Export toollogs \ emca \ rman \ emc
    52. 
  
  
  52.  
    53. 
  
  
  53. A_2009-05-06_09-28-19-Morning. log.
    54. 
  
  
  54.  
    55. 
  
  
  55. 9:28:40 oracle. sysman. emcp. EMReposConfig dropRepository
    56. 
  
  
  56.  
    57. 
  
  
  57. Information: deleting the EM archives. This operation may take some time )...
    58. 
  
  
  58.  
    59. 
  
  
  59. 9:28:42 oracle. sysman. emcp. EMReposConfig invoke
    60. 
  
  
  60.  
    61. 
  
  
  61. Information: The archive has been deleted successfully.
    62. 
  
  
  62.  
    63. 
  
  
  63. 9:28:43 oracle. sysman. emcp. EMReposConfig createRepository
    64. 
  
  
  64.  
    65. 
  
  
  65. Information: creating the EM archives (this operation may take some time )...
    66. 
  
  
  66.  
    67. 
  
  
  67. 9:28:43 oracle. sysman. emcp. EMReposConfig invoke
    68. 
  
  
  68.  
    69. 
  
  
  69. Severe: An error occurred while creating the archive.
    70. 
  
  
  70.  
    71. 
  
  
  71. 9:28:43 oracle. sysman. emcp. EMReposConfig invoke
    72. 
  
  
  72.  
    73. 
  
  
  73. Information: For more information, see log files in D: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ rman \ emca_repos_create _ <date>. log.
    74. 
  
  
  74.  
    75. 
  
  
  75. 9:28:43 oracle. sysman. emcp. EMConfig perform
    76. 
  
  
  76.  
    77. 
  
  
  77. Severe: An error occurred while creating the archive.
    78. 
  
  
  78.  
    79. 
  
  
  79. For more information, see log files in D: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ rman \ emca_2009-05-06_09-28-19-am. log.
    80. 
  
  
  80.  
    81. 
  
  
  81. Configuration cannot be completed. For more information, see log files in D: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ rman \ emca_2009-05-06_09-28-19-am. log.
    82. 
  
  
  82.  
    83. 
  
  
  83. 3. If an error is reported in oracle. sysman, resulting in failure
    84. 
  
  
  84.  
    85. 
  
  
  85. A. drop user sysman cascade;
    86. 
  
  
  86.  
    87. 
  
  
  87. B. drop role MGMT_USER;
    88. 
  
  
  88.  
    89. 
  
  
  89. C. drop user MGMT_VIEW cascade;
    90. 
  
  
  90.  
    91. 
  
  
  91. D. drop public synonym MGMT_TARGET_BLACKOUTS;
    92. 
  
  
  92.  
    93. 
  
  
  93. E. drop public synonym SETEMVIEWUSERCONTEXT;
    94. 
  
  
  94.  
    95. 
  
  
  95. F. emca-config dbcontrol db-repos create
    96. 
  
  
  96.  
    97. 
  
  
  97. C: \ Documents ents and Settings \ GAOYANG> sqlplus/as sysdba
    98. 
  
  
  98.  
    99. 
  
  
  99. SQL * Plus: Release 10.2.0.1.0-Production on Wed May 6 09:29:31 2009
    100. 
  
  
  100.  
    101. 
  
  
  101. Copyright (c) 1982,200 5, Oracle. All rights reserved.
    102. 
  
  
  102.  
    103. 
  
  
  103. Connected:
    104. 
  
  
  104.  
    105. 
  
  
  105. Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
    106. 
  
  
  106.  
    107. 
  
  
  107. With the Partitioning, OLAP and Data Mining options
    108. 
  
  
  108.  
    109. 
  
  
  109. SQL> drop user sysman cascade;
    110. 
  
  
  110.  
    111. 
  
  
  111. User dropped.
    112. 
  
  
  112.  
    113. 
  
  
  113. SQL> drop role MGMT_USER;
    114. 
  
  
  114.  
    115. 
  
  
  115. Role dropped.
    116. 
  
  
  116.  
    117. 
  
  
  117. SQL> drop user MGMT_VIEW cascade;
    118. 
  
  
  118.  
    119. 
  
  
  119. User dropped.
    120. 
  
  
  120.  
    121. 
  
  
  121. SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
    122. 
  
  
  122.  
    123. 
  
  
  123. Synonym dropped.
    124. 
  
  
  124.  
    125. 
  
  
  125. SQL> drop public synonym SETEMVIEWUSERCONTEXT;
    126. 
  
  
  126.  
    127. 
  
  
  127. Synonym dropped.
    128. 
  
  
  128.  
    129. 
  
  
  129. SQL> exit
    130. 
  
  
  130.  
    131. 
  
  
  131. Disconnected from Oracle Database 10g Enterprise Edition Release
    132. 
  
  
  132.  
    133. 
  
  
  133. 10.2.0.1.0-Pr
    134. 
  
  
  134.  
    135. 
  
  
  135. Oduction
    136. 
  
  
  136.  
    137. 
  
  
  137. With the Partitioning, OLAP and Data Mining options
    138. 
  
  
  138.  
    139. 
  
  
  139. C: \ Documents ents and Settings \ GAOYANG> emca-config dbcontrol db-repos
    140. 
  
  
  140.  
    141. 
  
  
  141. Create
    142. 
  
  
  142.  
    143. 
  
  
  143. EMCA started at 9:32:24
    144. 
  
  
  144.  
    145. 
  
  
  145. EM Configuration Assistant 10.2.0.1.0 official version
    146. 
  
  
  146.  
    147. 
  
  
  147. Copyright (c) 2003,200 5, Oracle. All rights reserved.
    148. 
  
  
  148.  
    149. 
  
  
  149. Enter the following information:
    150. 
  
  
  150.  
    151. 
  
  
  151. Database SID: rman
    152. 
  
  
  152.  
    153. 
  
  
  153. Listener port: 1158
    154. 
  
  
  154.  
    155. 
  
  
  155. SYS user password:
    156. 
  
  
  156.  
    157. 
  
  
  157. DBSNMP user password:
    158. 
  
  
  158.  
    159. 
  
  
  159. Password of the SYSMAN User:
    160. 
  
  
  160.  
    161. 
  
  
  161. Password of the SYSMAN User: email address of the notification (optional ):
    162. 
  
  
  162.  
    163. 
  
  
  163. Notification sending (SMTP) server (optional ):
    164. 
  
  
  164.  
    165. 
  
  
  165. -----------------------------------------------------------------
    166. 
  
  
  166.  
    167. 
  
  
  167. The following settings have been specified:
    168. 
  
  
  168.  
    169. 
  
  
  169. Database ORACLE_HOME ...... D: \ oracle \ product \ 10.2.0 \ db_1
    170. 
  
  
  170.  
    171. 
  
  
  171. Database Host Name...
    172. 
  
  
  172.  
    173. 
  
  
  173. Listener port number ...... 1158
    174. 
  
  
  174.  
    175. 
  
  
  175. Database SID ...... rman
    176. 
  
  
  176.  
    177. 
  
  
  177. Email Address of the notification ...............
    178. 
  
  
  178.  
    179. 
  
  
  179. Notification sending (SMTP) server ...............
    180. 
  
  
  180.  
    181. 
  
  
  181. -----------------------------------------------------------------
    182. 
  
  
  182.  
    183. 
  
  
  183. Continue? [Yes (Y)/no (N)]: Y
    184. 
  
  
  184.  
    185. 
  
  
  185. 9:40:34 oracle. sysman. emcp. EMConfig perform
    186. 
  
  
  186.  
    187. 
  
  
  187. Information: The operation is logged to D: \ oracle \ product \ 10.2.0 \ db_1.
    188. 
  
  
  188.  
    189. 
  
  
  189. \ Export toollogs \ emca \ rman \ emc
    190. 
  
  
  190.  
    191. 
  
  
  191. A_2009-05-06_09-40-00-Morning. log.
    192. 
  
  
  192.  
    193. 
  
  
  193. 9:40:36 oracle. sysman. emcp. util. DBControlUtil stopOMS
    194. 
  
  
  194.  
    195. 
  
  
  195. Information: The Database Control is being stopped (this operation may take some time )...
    196. 
  
  
  196.  
    197. 
  
  
  197. 9:40:42 oracle. sysman. emcp. ParamsManager getLocalListener
    198. 
  
  
  198.  
    199. 
  
  
  199. Warning An error occurred while retrieving the 192.100.8.188 listener.
    200. 
  
  
  200.  
    201. 
  
  
  201. 9:40:44 oracle. sysman. emcp. util. DBControlUtil startOMS
    202. 
  
  
  202.  
    203. 
  
  
  203. Information: Starting Database Control (this operation may take some time )...
    204. 
  
  
  204.  
    205. 
  
  
  205. 9:41:34 oracle. sysman. emcp. EMDBPostConfig
    206. 
  
  
  206.  
    207. 
  
  
  207. PerformConfiguration
    208. 
  
  
  208.  
    209. 
  
  
  209. Information: The Database Control has been started successfully.
    210. 
  
  
  210.  
    211. 
  
  
  211. 9:41:35 oracle. sysman. emcp. EMDBPostConfig
    212. 
  
  
  212.  
    213. 
  
  
  213. PerformConfiguration
    214. 
  
  
  214.  
    215. 
  
  
  215. Warning: The Database Control shortcut cannot be created.
    216. 
  
  
  216.  
    217. 
  
  
  217. 9:41:35 oracle. sysman. emcp. EMDBPostConfig
    218. 
  
  
  218.  
    219. 
  
  
  219. PerformConfiguration
    220. 
  
  
  220.  
    221. 
  
  
  221. Information: >>>>>>>>>> Database Control URL is http: // 192.100.8.188: 5500/em
    222. 
  
  
  222.  
    223. 
  
  
  223. <
    224. 
  
  
  224.  
    225. 
  
  
  225. <
    226. 
  
  
  226.  
    227. 
  
  
  227. The Enterprise Manager configuration has been completed successfully.
    228. 
  
  
  228.  
    229. 
  
  
  229. EMCA ended at 9:41:35
    230.

Set the IP address!

4. Open the service: emctl start dbconsole

5. An error is reported in the following scenario: Enter the prompt folder in the specified directory and check that there is no prompt folder in the specified directory. There is only one folder similar to the prompt folder in cp-r. Run emctl start dbconsole again.

6. view the current status: emctl status dbconsole

7. Check the file $ ORACLE_HOME/install/portlist. ini on the port number.

This article introduces the reconstruction of the EM Console of the Oracle database. If you want to learn more about the Oracle database, you can refer to the article http://database.51cto.com/oracle/, which will surely bring you the opportunity!

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More