-bash-4.1$ ./emca -config dbcontrol db -repos recreate
STARTED EMCA at Jul 27, 2016 1:55:15 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: ssaerp
Listener port number: 1521
Listener ORACLE_HOME [ /ora/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
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 ................ /ora/app/oracle/product/11.2.0/dbhome_1
Local hostname ................ afi-ssaerp2n
Listener ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ ssaerp
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 27, 2016 1:55:36 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /ora/app/oracle/cfgtoollogs/emca/ssaerp/emca_2016_07_27_13_55_15.log .
Jul 27, 2016 1:55:36 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: ORA-12541: TNS:no listener
Jul 27, 2016 1:55:36 PM oracle.sysman.emcp.EMConfig perform
SEVERE:
Database connection through listener failed. Fix the error and run EM Configuration Assistant again.
Some of the possible reasons may be:
1) Listener port 1521 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service ssaerp is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset OR ACLE_HOSTNAME environment variable.
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.
6) /etc/hosts does not have correct entry for hostname.
Refer to the log file at /ora/app/oracle/cfgtoollogs/emca/ssaerp/emca_2016_07_27_13_55_15.log for more detai ls.
Could not complete the configuration. Refer to the log file at ora/app/oracle/cfgtoollogs/emca/ssaerp/emca_ 2016_07_27_13_55_15.log for more details.
Define Virtual name of host
-bash-4.1$ ORACLE_HOSTNAME=lh-ora-rs
-bash-4.1$ export ORACLE_HOSTNAME
-bash-4.1$ ./emca -config dbcontrol db -repos recreate
STARTED EMCA at Jul 27, 2016 1:56:15 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: ssaerp
Listener port number: 1521
Listener ORACLE_HOME [ /ora/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
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 ................ /ora/app/oracle/product/11.2.0/dbhome_1
Local hostname ................ lh-ora-rs
Listener ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ ssaerp
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 27, 2016 1:56:34 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /ora/app/oracle/cfgtoollogs/emca/ssaerp/emca_2016_07_27_13_56_15.log .
Jul 27, 2016 1:56:35 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jul 27, 2016 1:59:08 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jul 27, 2016 1:59:08 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 27, 2016 2:05:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 27, 2016 2:05:03 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 27, 2016 2:06:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jul 27, 2016 2:06:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 27, 2016 2:06:18 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 27, 2016 2:06:18 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 27, 2016 2:06:34 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 27, 2016 2:06:34 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://lh-ora-rs:1158/em <<<<<<<<<<<
Jul 27, 2016 2:06:36 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: /ora/app/oracle/product/11.2.0/dbhome_1/lh-ora-rs_ssaerp/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 Jul 27, 2016 2:06:36 PM
-bash-4.1$
