1.删除档案库

  1. $
  2. [oracle@centos6 admin]$ emca -repos drop
  4. STARTED EMCA at Mar 17, 2021 11:20:59 AM
  5. EM Configuration Assistant, Version 11.2.0.3.0 Production
  6. Copyright (c) 2003, 2011, Oracle.  All rights reserved.
  8. Enter the following information:
  9. Database SID: orcl
  10. Listener port number: 1521
  11. Password for SYS user:
  12. Password for SYSMAN user:
  14. ----------------------------------------------------------------------
  15. WARNING : While repository is dropped the database will be put in quiesce mode.
  16. ----------------------------------------------------------------------
  17. Do you wish to continue? [yes(Y)/no(N)]: y
  18. Mar 17, 2021 11:21:15 AM oracle.sysman.emcp.EMConfig perform
  19. INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2021_03_17_11_20_59.log.
  20. Mar 17, 2021 11:21:16 AM oracle.sysman.emcp.EMReposConfig invoke
  21. INFO: Dropping the EM repository (this may take a while) ...

2.删除em

  2. [oracle@centos6 admin]$ emca -deconfig dbcontrol db -repos drop
  4. STARTED EMCA at Mar 17, 2021 11:24:49 AM
  5. EM Configuration Assistant, Version 11.2.0.3.0 Production
  6. Copyright (c) 2003, 2011, Oracle.  All rights reserved.
  8. Enter the following information:
  9. Database SID: orcl
  10. Listener port number: 1521
  11. Password for SYS user:
  12. Password for SYSMAN user:
  14. ----------------------------------------------------------------------
  15. WARNING : While repository is dropped the database will be put in quiesce mode.
  16. ----------------------------------------------------------------------
  17. Do you wish to continue? [yes(Y)/no(N)]: y
  18. Mar 17, 2021 11:25:05 AM oracle.sysman.emcp.EMConfig perform
  19. INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2021_03_17_11_24_48.log.
  20. Mar 17, 2021 11:25:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
  21. WARNING: ORA-01017: invalid username/password; logon denied
  23. Mar 17, 2021 11:25:05 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
  24. WARNING: Error initializing SQL connection. SQL operations cannot be performed
  25. Mar 17, 2021 11:25:05 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
  26. WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
  27.  1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
  28.  2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
  29. Mar 17, 2021 11:25:05 AM oracle.sysman.emcp.EMReposConfig invoke
  30. INFO: Dropping the EM repository (this may take a while) ...
  31. Mar 17, 2021 11:25:06 AM oracle.sysman.emcp.EMReposConfig invoke
  32. INFO: Repository successfully dropped
  33. Enterprise Manager configuration completed successfully
  34. FINISHED EMCA at Mar 17, 2021 11:25:06 AM

3.创建em

或者直接执行 emca -config dbcontrol db -repos recreate

  1. [oracle@centos6 admin]$ emca -config dbcontrol db -repos create
  3. STARTED EMCA at Mar 17, 2021 11:25:49 AM
  4. EM Configuration Assistant, Version 11.2.0.3.0 Production
  5. Copyright (c) 2003, 2011, Oracle.  All rights reserved.
  7. Enter the following information:
  8. Database SID: orcl
  9. Listener port number: 1521
  10. Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:
  11. Password for SYS user:
  12. Password for DBSNMP user:
  13. Password for SYSMAN user:
  14. Email address for notifications (optional):
  15. Outgoing Mail (SMTP) server for notifications (optional):
  16. -----------------------------------------------------------------
  18. You have specified the following settings
  20. Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
  22. Local hostname ................ centos6
  23. Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
  24. Listener port number ................ 1521
  25. Database SID ................ orcl
  26. Email address for notifications ...............
  27. Outgoing Mail (SMTP) server for notifications ...............
  29. -----------------------------------------------------------------
  30. Do you wish to continue? [yes(Y)/no(N)]: y
  31. Mar 17, 2021 11:26:13 AM oracle.sysman.emcp.EMConfig perform
  32. INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2021_03_17_11_25_49.log.
  33. Mar 17, 2021 11:26:14 AM oracle.sysman.emcp.EMReposConfig createRepository
  34. INFO: Creating the EM repository (this may take a while) ...