Oracle 10g 配置OEM/DB CONSOLE


下面是测试一下Oracle 10g中怎么配置DB CONSOLE，EM这个东西平时用得太多了，一点不熟悉

测试环境：OS:SOLARIS 10,DB :10.2.0.1

1，EMCA创建

  1. $ emca -config dbcontrol db -repos create
  3. STARTED EMCA atDec 22, 2012 12:30:09 PM
  4. EM Configuration Assistant, Version 10.2.0.1.0 Production
  5. Copyright (c) 2003, 2005, 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 notifications (optional):
  14. Outgoing Mail (SMTP) server for notifications (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 ................ 10rac1
  22. Listener port number ................ 1521
  23. Database SID ................ htz
  24. Email address for notifications ...............
  25. Outgoing Mail (SMTP) server for notifications ...............
  27. -----------------------------------------------------------------
  28. Do you wish tocontinue? [yes(Y)/no(N)]: Y
  29. Dec 22, 2012 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/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log.
  31. Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig createRepository
  32. INFO: Creating the EM repository (this may take a while) ...
  33. Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
  34. SEVERE: Error creating the repository
  35. Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
  36. INFO: Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_repos_create_<date>.log for more details.
  37. Dec 22, 2012 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/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details.
  40. Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details

晕，报错了，数据库是新创建的，查看一下原因。

2，日志查看

  1. $ cd $ORACLE_HOME/cfgtool*/
  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, 2012 12:31:01 PM 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, 2012 12:31:01 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
  10. CONFIG: SQLEngine created successfully and connected
  11. Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.ParamsManager setFlag
  12. CONFIG: Flag 'asm_db'settofalse
  13. Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.ParamsManager setFlag
  14. CONFIG: Flag 'asm_db'settofalse
  15. Dec 22, 2012 12:31:03 PM oracle.sysman.emcp.ParamsManager setParam
  16. CONFIG: Setting param: PORT value: 1521
  17. Dec 22, 2012 12:31:05 PM oracle.sysman.emcp.ParamsManager getParam
  18. CONFIG: No value was setfor the parameter SYS_PWD.
  19. Dec 22, 2012 12:31:05 PM 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, 2012 12:31:05 PM 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.executeScript(SQLEngine.java:841)
  25. at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
  26. at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(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.performConfiguration(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, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
  36. SEVERE: Error creating the repository
  37. Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
  38. INFO: Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_repos_create_<date>.log for more details.
  39. Dec 22, 2012 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/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details.
  42. Dec 22, 2012 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.performConfiguration(EMConfigAssistant.java:1123)
  50. at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
  51. at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
  53. 再看另一个日志
  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('SYSMAN');
  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. 报用户已经存在，原来没有创建过EM，DBCA创建数据库的时候也没有勾上。
  • 1
  • 2
  • 下一页

相关内容

    暂无相关文章