Visit Counter

Wednesday, July 27, 2016

Dbcontrol Repository already exists. Fix the error(s) and run EM Config




-bash-4.1$ ./emca -config dbcontrol db -repos create

STARTED EMCA at Jul 27, 2016 2:27:47 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/dbhome1104 ]:
Password for SYS user:
Password for DBSNMP user:
Jul 27, 2016 2:34:12 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01017: invalid username/password; logon denied

Jul 27, 2016 2:34:20 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

Jul 27, 2016 2:41:14 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01017: invalid username/password; logon denied

Invalid username/password.
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/dbhome1104

Local hostname ................ afi-ssaerp
Listener ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome1104
Listener port number ................ 1521
Database SID ................ ssaerp
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 27, 2016 2:42:50 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /ora/app/1104/oracle/cfgtoollogs/emca/ss                                                                                        aerp/emca_2016_07_27_14_27_46.log.
Jul 27, 2016 2:42:51 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Config                             Duration Assistant again in standalone mode.




Solution




-bash-4.1$ ./emca -config dbcontrol db -repos recreate

STARTED EMCA at Jul 27, 2016 2:51:34 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/dbhome1104 ]:
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/dbhome1104

Local hostname ................ afi-ssaerp
Listener ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome1104
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 2:51:59 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /ora/app/1104/oracle/cfgtoollogs/emca/ssaerp/emca_2016_07_27_14_51_33.log.
Jul 27, 2016 2:52:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jul 27, 2016 2:53:55 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jul 27, 2016 2:53:56 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 27, 2016 2:58:38 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 27, 2016 2:58:41 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 27, 2016 3:00:12 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jul 27, 2016 3:00:13 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for afi-ssaerp
Jul 27, 2016 3:00:14 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 27, 2016 3:00:24 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 27, 2016 3:00:24 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 27, 2016 3:00:53 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 27, 2016 3:00:54 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://afi-ssaerp:1158/em <<<<<<<<<<<
Jul 27, 2016 3:00:56 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/dbhome1104/afi-ssaerp_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 3:00:56 PM


-bash-4.1$


No comments:

Post a Comment