Wednesday, October 12, 2016

How To Change Configuration For Enterprise Manager


Symptoms: If you have red arrows for instane, listener on enterprise manager page; or if you have all green arrows but page doesn't ask you any password to log in.

To change listener port, sysman password etc. for enterprise manager run the following command. It'll let you reconfigure EM with the correct information

bash-3.00$ emca -config dbcontrol db

STARTED EMCA at 24.08.2008 01:58:01
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

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

Database hostname ................ xxxxx
Listener port number ................ 1521
Database SID ................ XXX
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
24.08.2008 01:58:44 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/product/10.2.0/cfgtoollogs/emca/EPA/emca_2008-08-24_01-58-01-AM.log.
24.08.2008 01:58:46 oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
24.08.2008 01:58:57 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
24.08.2008 02:00:39 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
24.08.2008 02:00:39 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://xxxxx:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at 24.08.2008 02:00:39

No comments:

Post a Comment

How To Fix Hive – Partition Table Query Failed When Stored As Parquet

This article is about the bug in Hive filtering option, when the partition table query stored as parquet. Big data developers will help y...