oralce 11.2.0.4手动创建EM

橡皮草帽

这里使用的版本是RedHat7.0，Oracle 11.2.0.4

1.dbconsole启动失败
[oracle@redhat75 ~]$ emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

2.删除旧的EM资料档案库
[oracle@redhat75 ~]$ emca -repos drop
STARTED EMCA at Nov 11, 2019 4:31:52 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.
Enter the following information:
Database SID: orcl--输入sid
Listener port number: 1521--端口号
Password for SYS user: --密码
Password for SYSMAN user: --密码
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.--建议避开业务高峰期
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y--yes
Nov 11, 2019 4:32:21 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2019_11_11_16_31_51.log.
Nov 11, 2019 4:32:22 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-28000: the account is locked
Nov 11, 2019 4:32:22 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Nov 11, 2019 4:32:22 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 11, 2019 4:32:51 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully--配置成功
FINISHED EMCA at Nov 11, 2019 4:32:51 PM

3.创建em资料库档案
[oracle@redhat75 ~]$ emca -config dbcontrol db -repos create
STARTED EMCA at Nov 11, 2019 4:33:11 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.
Enter the following information:
Database SID: orcl--输入sid
Listener port number: 1521--端口号
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0.1/dbhome_1 ]:
Password for SYS user:  --密码
Password for DBSNMP user: --密码
Nov 11, 2019 4:33:33 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-28000: the account is locked
Password for SYSMAN user:  --密码
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.1/dbhome_1
Local hostname ................ redhat75
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.1/dbhome_1
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y--yes
Nov 11, 2019 4:33:52 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2019_11_11_16_33_11.log.
Nov 11, 2019 4:33:53 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 11, 2019 4:35:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 11, 2019 4:35:30 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 11, 2019 4:36:02 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 11, 2019 4:36:04 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 11, 2019 4:36:09 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 11, 2019 4:36:09 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 11, 2019 4:36:45 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 11, 2019 4:36:45 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://redhat75:1158/em <<<<<<<<<<<--可以测试访问
Nov 11, 2019 4:36:47 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING: --（该密钥丢失后，加密文件将不可用）
************************  WARNING  ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0.1/dbhome_1/redhat75_orcl/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully--配置成功
FINISHED EMCA at Nov 11, 2019 4:36:47 PM

登录/注册后可看大图