Oracle 10g configuration OEM/DB CONSOLE

The following is a test on how to configure the db console in Oracle 10 Gb. EM is usually used too much and is not familiar with it.

Test environment: OS: SOLARIS 10, DB: 10.2.0.1

1. EMCA Creation

1. $ Emca-config dbcontrol db-repos create
3. Started emca atDec 22,201 2 12:30:09
4. EM Configuration Assistant, Version 10.2.0.1.0 Production
5. Copyright (c) 2003,200 5, Oracle. All rights reserved.
7. Enter the following information:
8. Database SID: htz
9. Listener port number: 1521
10. Passwordfor SYS user:
11. Passwordfor DBSNMP user:
12. Passwordfor SYSMAN user:
13. Email address for communications (optional ):
14. Outgoing Mail (SMTP) server for communications (optional ):
15. -----------------------------------------------------------------
17. You have specified the following settings
19. Database ORACLE_HOME ....../u01/app/oracle/product/11.2.0/db_1
21. Database hostname...
22. Listener port number... 1521
23. Database SID ...... htz
24. Email address for communications ...............
25. Outgoing Mail (SMTP) server for communications ...............
27. -----------------------------------------------------------------
28. Do you wish tocontinue? [Yes (Y)/no (N)]: Y
29. Dec 22,201 2 12:31:12 PM oracle. sysman. emcp. EMConfig perform
30. INFO: This operation is being logged at/u01/app/oracle/product/11.2.0/db_1/export toollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log.
31. Dec 22,201 2 12:31:13 PM oracle. sysman. emcp. EMReposConfig createRepository
32. INFO: Creating the EM repository (this may take a while )...
33. Dec 22,201 2 12:31:13 oracle. sysman. emcp. EMReposConfig invoke
34. SEVERE: Error creating the repository
35. Dec 22,201 2 12:31:13 oracle. sysman. emcp. EMReposConfig invoke
36. INFO: Refer to the log file at/u01/app/oracle/product/11.2.0/db_1/export toollogs/emca/htz/emca_repos_create _ <date>. log for more details.
37. Dec 22,201 2 12:31:13 PM oracle. sysman. emcp. EMConfig perform
38. SEVERE: Error creating the repository
39. Refer to the log file at/u01/app/oracle/product/11.2.0/db_1/export toollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details.
40. Cocould not complete the configuration. Refer to the log file at/u01/app/oracle/product/11.2.0/db_1/export toollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details

Dizzy. An error is reported. The database is newly created. Check the cause.

2. View logs

1. $ Cd $ ORACLE_HOME/export tool */
2. $ Ls
3. Cfgfw configToolAllCommands dbca emca netca oui
4. $ Cd emca/htz
5. $ Vi emca_2012-12-22_12-30-09-PM.log
6. CONFIG: No value was setfor the parameter SYS_PWD.
7. Dec 22,201 2 12:31:01 oracle. sysman. emcp. util. GeneralUtil initSQLEngine
8. CONFIG: SQLEngine connecting with SID: htz, oracleHome:/u01/app/oracle/product/11.2.0/db_1, anduser:
9. Dec 22,201 2 12:31:01 oracle. sysman. emcp. util. GeneralUtil initSQLEngine
10. CONFIG: SQLEngine created successfully and connected
11. Dec 22,201 2 12:31:01 oracle. sysman. emcp. ParamsManager setFlag
12. CONFIG: Flag 'asm _ db' settofalse
13. Dec 22,201 2 12:31:01 oracle. sysman. emcp. ParamsManager setFlag
14. CONFIG: Flag 'asm _ db' settofalse
15. Dec 22,201 2 12:31:03 oracle. sysman. emcp. ParamsManager setParam
16. CONFIG: Setting param: PORT value: 1521
17. Dec 22,201 2 12:31:05 PM oracle. sysman. emcp. ParamsManager getParam
18. CONFIG: No value was setfor the parameter SYS_PWD.
19. Dec 22,201 2 12:31:05 oracle. sysman. emcp. util. GeneralUtil initSQLEngine
20. CONFIG: SQLEngine connecting with SID: htz, oracleHome:/u01/app/oracle/product/11.2.0/db_1, anduser: SYS
21. Dec 22,201 2 12:31:05 oracle. sysman. emcp. util. GeneralUtil initSQLEngine
22. CONFIG: SQLEngine created successfully and connected
23. "Emca_2012-12-22_12-30-09-PM.log" 370 lines, 26004 characters
24. At oracle.sysman.assistants.util.sqlEngine.SQLEngine.exe cuteScript (SQLEngine. java: 841)
25. At oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.exe cuteScript (SQLPlusEngine. java: 265)
26. At oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.exe cuteScript (SQLPlusEngine. java: 306)
27. At oracle. sysman. emcp. EMReposConfig. createRepository (EMReposConfig. java: 360)
28. At oracle. sysman. emcp. EMReposConfig. invoke (EMReposConfig. java: 182)
29. At oracle. sysman. emcp. EMReposConfig. invoke (EMReposConfig. java: 124)
30. At oracle. sysman. emcp. EMConfig. perform (EMConfig. java: 142)
31. At oracle. sysman. emcp. EMConfigAssistant. invokeEMCA (EMConfigAssistant. java: 479)
32. At oracle. sysman. emcp. EMConfigAssistant. Configure mconfiguration (EMConfigAssistant. java: 1123)
33. At oracle. sysman. emcp. EMConfigAssistant. statusMain (EMConfigAssistant. java: 463)
34. At oracle. sysman. emcp. EMConfigAssistant. main (EMConfigAssistant. java: 412)
35. Dec 22,201 2 12:31:13 oracle. sysman. emcp. EMReposConfig invoke
36. SEVERE: Error creating the repository
37. Dec 22,201 2 12:31:13 oracle. sysman. emcp. EMReposConfig invoke
38. INFO: Refer to the log file at/u01/app/oracle/product/11.2.0/db_1/export toollogs/emca/htz/emca_repos_create _ <date>. log for more details.
39. Dec 22,201 2 12:31:13 PM oracle. sysman. emcp. EMConfig perform
40. SEVERE: Error creating the repository
41. Refer to the log file at/u01/app/oracle/product/11.2.0/db_1/export toollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details.
42. Dec 22,201 2 12:31:13 PM oracle. sysman. emcp. EMConfig perform
43. CONFIG: Stack Trace:
44. Oracle. sysman. emcp. exception. EMConfigException: Error creating the repository
45. At oracle. sysman. emcp. EMReposConfig. invoke (EMReposConfig. java: 194)
46. At oracle. sysman. emcp. EMReposConfig. invoke (EMReposConfig. java: 124)
47. At oracle. sysman. emcp. EMConfig. perform (EMConfig. java: 142)
48. At oracle. sysman. emcp. EMConfigAssistant. invokeEMCA (EMConfigAssistant. java: 479)
49. At oracle. sysman. emcp. EMConfigAssistant. Configure mconfiguration (EMConfigAssistant. java: 1123)
50. At oracle. sysman. emcp. EMConfigAssistant. statusMain (EMConfigAssistant. java: 463)
51. At oracle. sysman. emcp. EMConfigAssistant. main (EMConfigAssistant. java: 412)
53. Look at another log
55. $ Vi emca_repos_create_2012-12-22_12-31-13-PM.log
56. Emca_repos_create_2012-12-22_12-31-13-PM.log 21 lines, 911 characters
58. Check if repos user already exists.
60. Old 6: WHERE username = UPPER ('& EM_REPOS_USER ');
61. New 6: WHERE username = UPPER ('sysmance ');
62. Old 8: IF ('& EM_CHECK_TYPE' = 'exists') THEN
63. New 8: IF ('not _ exists' = 'exists') THEN
64. Old 11: raise_application_error (-20000, '& EM_REPOS_USER does not exists ..');
65. New 11: raise_application_error (-20000, 'sysman does not exists ..');
66. Old 14: ELSIF ('& EM_CHECK_TYPE' = 'not _ exists') THEN
67. New 14: ELSIF ('not _ exists' = 'not _ exists') THEN
68. Old 17: raise_application_error (-20001, '& EM_REPOS_USER already exists ..');
69. New 17: raise_application_error (-20001, 'sysman already exists ..');
70. Old 21: raise_application_error (-20002, 'invalid Check type & EM_CHECK_TYPE ');
71. New 21: raise_application_error (-20002, 'invalid Check type NOT_EXISTS ');
72. DECLARE
73. *
74. ERROR at line 1:
75. ORA-20001: SYSMAN already exists ..
76. ORA-06512: at line 17
78. The user already exists, and no EM has been created before, and the DBCA has not been checked during database creation.

1 2 Next Page