Monday, July 1, 2013

OEM Configuration for Single db in Oracle

 We can execute below command in db level any location.
-bash-3.00$ emca -repos create
STARTED EMCA at Mar 18, 2013 5:16:44 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TEST1
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 18, 2013 5:17:00 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oradb/db/tech_st/11.1.0/cfgtool
Mar 18, 2013 5:17:01 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Mar 18, 2013 5:56:58 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Mar 18, 2013 5:56:58 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 18, 2013 6:27:38 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager Configuration completed successfully
FINISHED EMCA at Mar 18, 2013 6:27:38 AM
-Bash-3.00$ emca -config dbcontrol db
STARTED EMCA at Mar 18, 2013 6:28:55 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TEST1
Database Control is already configured for the database TEST1
You have chosen to configure Database Control for managing the database TEST1
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [Yes(Y)/no (N)]: Y
Listener port number: 1521
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/oradb/db/tech_st/11.1.0
Local hostname................ AAA.bbb.com
Listener port number ................ 1521
Database SID................ TEST1
Email address for notifications...............
Outgoing Mail (SMTP) server for notifications...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 18, 2013 6:29:37 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oradb/db/tech_st/11.1.0/cfgtoollogs/emca/TEST1/emca_2013_03_18_06_28_55.log.
Mar 18, 2013 6:29:40 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 18, 2013 6:32:33 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Mar 18, 2013 6:49:46 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Mar 18, 2013 6:49:58 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Mar 18, 2013 6:49:58 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Mar 18, 2013 6:50:18 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Mar 18, 2013 6:50:18 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while)...
Mar 18, 2013 6:50:40 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Mar 18, 2013 6:50:40 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while)...
Mar 18, 2013 6:51:56 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Mar 18, 2013 6:51:56 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://AAA.bbb.com:5500/em <<<<<<<<<<<
Mar 18, 2013 6:52:06 AM 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/oradb/db/tech_st/11.1.0/AAA.bbb.com_TEST1/sysman/config/emkey.ora.   Please 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 Mar 18, 2013 6:52:06 AM
_________________________________________________________________________________
Then we have to enable the port 5500 from server side.
Once the port 5500 enabled we will check the URL https://AAA.bbb.com:5500/em in internet explorer (or) chrome it will ask username and password. Then
We will give the SYSMAN username and password
                                                  (Or)
  We will give the SYS username and password as SYSDBA
Once password authentication done we will get the Oracle enterprise manager page.
                                 So Finally OEM Configuration has successfully completed
------------------------------------------------**********************---------------------------------------------------
 Errors:
                           We will get the below errors while implementing OEM.
-bash-3.00$ emca -repos create
First time whenever we implement OEM we have to give above command only to create repository
But sometimes  we will get the error like SYSMAN user already exist .in that situation we have to give the  emca -repos recreate command .
-bash-3.00$ emca -repos recreate
Error2:-
If you get any below error after passing the user name and password
1.       It will take long time to authenticate  (or)
2.        internet explorer cannot display the page error
Check the space for SYSAUX, SYSTEM and TEMP Table space.
Note: -   OEM is consuming very high TEMP tablespace



No comments:

Post a Comment