Search This Blog

Tuesday, March 27, 2007

Status Pending




When we receive above error ... then first place to check tns_entry.
Are you able to connect "user/pwd@tns_entry".

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 27 10:46:05 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn system@db01
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Now i am troubleshoot ORA-12154 error and check my OEM status again.
SQL> conn system/oracle@db01
Connected.

1.emoms.trc
2.emagent.trc
Location : $ORACLE_HOME/hostname.domainname_SID/sysman/log

You can also check "agent status"



Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 18.61%


If number of XML files pending upload if greater than 0 then you should wait to load all pending files then try to change OEM status.



Note : May be more reason but i am face all this error so i share my exprience.

No comments: