Oracle 11.2.0.4 manually create EM
Failed to start dbconsole after installing Oracle
[Oracle @ elearning admin] $ emctl start dbconsole
Enter the name of the Host Name _ elearning not found.
After oracle was installed, no em was configured. The configuration steps are as follows:
1. Delete the old EM data archives
[Oracle @ elearning admin] $ emca-repos drop
EMCA started at 16:08:25
EM Configuration Assistant, 11.2.0.3.0 official version
Copyright (c) 2003,201 1, Oracle. All rights reserved.
Enter the following information:
Database SID: elearning
Listener port: 1521
SYS User Password: rning
Password of the SYSMAN User:
----------------------------------------------------------------------
Warning the database enters the silent mode when you delete the archive.
----------------------------------------------------------------------
Continue? [Yes (Y)/NO (N)]: Y
16:08:49 oracle. sysman. emcp. EMConfig perform
Information: The operation is being recorded in/u01/oracle/app/export toollogs/emca/elearning/emca_2016_05_03_16_08_25.log.
16:08:49 oracle. sysman. emcp. util. GeneralUtil initSQLEngineLoacly
Warning ORA-01017: invalid username/password; logon denied
16:08:49 oracle. sysman. emcp. ParamsManager checkListenerStatusForDBControl
Warning: An error occurred while initializing the SQL connection. Unable to execute SQL operation
16:08:50 oracle. sysman. emcp. EMReposConfig invoke
Information: deleting the EM archives. This operation may take some time )...
16:14:24 oracle. sysman. emcp. EMReposConfig invoke
Information: The archive has been deleted successfully.
The Enterprise Manager configuration has been completed successfully.
EMCA ended at 16:14:24
2. Create a New EM data archive
[Oracle @ elearning admin] $ emca-config dbcontrol db-repos create
EMCA started at 16:14:49
EM Configuration Assistant, 11.2.0.3.0 official version
Copyright (c) 2003,201 1, Oracle. All rights reserved.
Enter the following information:
Database SID: elearning
Listener port: 1521
The listener ORACLE_HOME [/u01/oracle/app/product/11.2.0/dbhome_1]:
SYS user password:
DBSNMP user password:
Password of the SYSMAN User:
Email Address of the notification (optional ):
Notification sending (SMTP) server (optional ):
-----------------------------------------------------------------
The following settings have been specified:
Database ORACLE_HOME ....../u01/oracle/app/product/11.2.0/dbhome_1
Local host name...
Listening program ORACLE_HOME ........../u01/oracle/app/product/11.2.0/dbhome_1
Listener port number ...... 1521
Database SID ......
Email Address of the notification ...............
Notification sending (SMTP) server ...............
-----------------------------------------------------------------
Continue? [Yes (Y)/NO (N)]: Y
16:15:33 oracle. sysman. emcp. EMConfig perform
Information: The operation is logged to/u01/oracle/app/export toollogs/emca/elearning/emca_2016_05_03_16_14_49.log.
16:15:34 oracle. sysman. emcp. EMReposConfig createRepository
Information: creating the EM archives (this operation may take some time )...
16:26:35 oracle. sysman. emcp. EMReposConfig invoke
Information: You have created a Data Archiving database.
16:26:40 oracle. sysman. emcp. EMReposConfig uploadConfigDataToRepository
Information: The configuration data is being uploaded to the EM archives (this operation may take some time )...
16:28:02 oracle. sysman. emcp. EMReposConfig invoke
Information: configuration data has been uploaded successfully.
16:28:06 oracle. sysman. emcp. util. DBControlUtil secureDBConsole
Information: Protecting Database Control (this operation may take some time )...
16:28:13 oracle. sysman. emcp. util. PlatformInterface executeCommand
Warning: An error occurred while executing/u01/oracle/app/product/11.2.0/dbhome_1/bin/emctl secure dbconsole-host elearning.gz.cvte.cn-sid elearning.
16:28:13 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration
Warning: An error occurred while protecting Database control.
16:28:13 oracle. sysman. emcp. EMDBPostConfig setWarnMsg
Information: An error occurred while protecting Database Control. Database Control is enabled in non-secure mode. To protect Database Control, run the following command:
1) set the environment variable ORACLE_UNQNAME to the unique name of the database.
2)/u01/oracle/app/product/11.2.0/dbhome_1/bin/emctl stop dbconsole
3)/u01/oracle/app/product/11.2.0/dbhome_1/bin/emctl config emkey-repos-sysman_pwd <SYSMAN user's password>
4)/u01/oracle/app/product/11.2.0/dbhome_1/bin/emctl secure dbconsole-sysman_pwd <SYSMAN User Password>
5)/u01/oracle/app/product/11.2.0/dbhome_1/bin/emctl start dbconsole
To protect the EM key, run/u01/oracle/app/product/11.2.0/dbhome_1/bin/emctl config emkey-remove_from_repos-sysman_pwd <SYSMAN user's password>
16:28:13 oracle. sysman. emcp. util. DBControlUtil startOMS
Information: Starting Database Control (this operation may take some time )...
16:28:17 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration
Information: The Database Control has been started successfully.
16:28:18 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration
Information: >>>>>>>>>> Database Control URL is http: // elearning. Host Name: 5500/em <
3. logon Verification
Http: // host name: 5500/em