If at time of EM configuration we get below warning it means EM is not configure properly . Reason behind it some thing is missing or wrong in listener or host file .
WARNING: Error starting Database Control.Execute the following command(s).
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /home/oracle/db_1/bin/emctl start dbconsole
Apr 26, 2013 12:42:31 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to /home/oracle/db_1/oui
Apr 26, 2013 12:42:31 AM oracle.sysman.emcp.EMConfig perform
CONFIG:
Error starting Database Control.Execute the following command(s).
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /home/oracle/db_1/bin/emctl start dbconsole
Apr 26, 2013 12:42:31 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Passing warning to the caller:
Apr 26, 2013 12:42:31 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to /home/oracle/db_1/oui
Below the steps to resolve the issue:
1 check listener is up if not the up it
#lsnrctl status
#lsnrctl start
2. Check if IP address or machine name is mentioned in listener.ora if IP address is mentioned then replace it with machine name.
3. restart the listener
#lsnrctl reload
4. Replace in tnsnames.ora file from an IP number to a machine name.
5. Check if entries are correct in /etc/hosts add hostname into this file if not exists
127.0.0.1 localhost
172.16.113.128 MYDBmachine MYDBmachine.domain.com
6. recreate the em repository
emca -config dbcontrol db -repos recreate
STARTED EMCA at Sep 3, 2012 7:40:07 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
7. Check status of EM
emctl status deconsole
No comments:
Post a Comment