Search This Blog

Total Pageviews

Monday 14 March 2011

OEM troubleshooting commands

https://apt-lnx-tst-01.site:1158/em/console/aboutApplication
Logs are generated in directory /opt/oracle/product/10.2/apt-lnx-tst-01.site_orcl/sysman/log
INFO: >>>>>>>>>>> The Database Control URL is https://apt-lnx-tst-01.site:1158/em <<<<<<<<<<<
http://apt-lnx-tst-01.site:5560/isqlplus
http://apt-lnx-tst-01.site:5560/isqlplus/dba
oracle@apt-lnxtst-01:/opt/oracle/product/10.2/cfgtoollogs/emca> vi /opt/oracle/product/10.2/apt-lnx-tst-01.site_orcl/sysman/config/emd.properties
oracle@apt-lnxtst-01:/opt/oracle/product/10.2/cfgtoollogs/emca> vi /opt/oracle/product/10.2/apt-lnx-tst-01.site_orcl/sysman/config/emd.properties
oracle@apt-lnxtst-01:/opt/oracle/product/10.2/cfgtoollogs/emca> emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
http://apt-lnxtst-01.aptus.co.uk:5500/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
oracle@apt-lnxtst-01:/opt/oracle/product/10.2/cfgtoollogs/emca> emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
http://apt-lnxtst-01.aptus.co.uk:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...................... started.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/10.2/apt-lnxtst-01.tus.co.uk_orcl/sysman/log
oracle@apt-lnxtst-01:/opt/oracle/product/10.2/cfgtoollogs/emca> emca -config dbcontrol db -repose recreate

STARTED EMCA at 14-Oct-2010 16:35:45
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
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 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 ................ /opt/oracle/product/10.2

Database hostname ................ apt-lnxtst-01.tus.co.uk
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
14-Oct-2010 16:36:11 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/product/10.2/cfgtoollogs/emca/orcl/emca_2010-10-14_04-35-45-PM.log.
14-Oct-2010 16:36:12 oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
14-Oct-2010 16:36:21 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
14-Oct-2010 16:37:09 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
14-Oct-2010 16:37:09 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
14-Oct-2010 16:38:46 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
14-Oct-2010 16:38:46 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://apt-lnxtst-01.tus.co.uk:5500/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at 14-Oct-2010 16:38:46
oracle@apt-lnxtst-01:/opt/oracle/product/10.2/cfgtoollogs/emca> vi /opt/oracle/product/10.2/apt-lnx-tst-01.site_orcl/sysman/config/emd.properties
oracle@apt-lnxtst-01:/opt/oracle/product/10.2/cfgtoollogs/emca> emca -config dbcontrol db -repos recreate

STARTED EMCA at 14-Oct-2010 16:42:11
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
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 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 ................ /opt/oracle/product/10.2

Database hostname ................ apt-lnxtst-01.tus.co.uk
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
14-Oct-2010 16:42:34 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/product/10.2/cfgtoollogs/emca/orcl/emca_2010-10-14_04-42-11-PM.log.
14-Oct-2010 16:42:35 oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
14-Oct-2010 16:42:43 oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
14-Oct-2010 16:44:19 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
14-Oct-2010 16:44:19 oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
14-Oct-2010 16:47:33 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
14-Oct-2010 16:47:38 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
14-Oct-2010 16:48:33 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
14-Oct-2010 16:48:33 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
14-Oct-2010 16:50:12 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
14-Oct-2010 16:50:12 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://apt-lnxtst-01.aptus.co.uk:5500/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at 14-Oct-2010 16:50:12







orapwd FILE=filename PASSWORD=password ENTRIES=max_users











oracle@apt-lnxtst-01:/opt/oracle/product/10.2/cfgtoollogs/emca> emca -config dbcontrol db -repos recreate

STARTED EMCA at 14-Oct-2010 16:42:11
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
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 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 ................ /opt/oracle/product/10.2

Database hostname ................ apt-lnxtst-01.aptus.co.uk
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
14-Oct-2010 16:42:34 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/product/10.2/cfgtoollogs/emca/orcl/emca_2010-10-14_04-42-11-PM.log.
14-Oct-2010 16:42:35 oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
14-Oct-2010 16:42:43 oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...

Oracle DBA

anuj blog Archive