Agent is Unreachable (REASON = Connection refused) but the host is UP
Dear All,
I have two instances on RAC
1) NMH.newsource.com_NMH1 30 1 8 +ASM1_nmhdb001.newsource.com
2) NMH.newsource.com_NMH2
2nd Instance it gave critical error that
Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
then that details giving as
I got Critical Error in OEM that
Jun 30, 2008 9:20:17 AM Agent is Unreachable (REASON = Connection refused) but the host is UP
I tried to start listener
but it said
LSNRCTL> start LISTENER_nmhdb002
TNS-01106: Listener using listener name LISTENER_nmhdb002 has already been started
then status says
LSNRCTL> listener_nmhdb002 status
NL-00853: undefined command "listener_nmhdb002". Try "help"
LSNRCTL> STATUS
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nmhdb002-vip)(PORT=1521)(IP=FIRST))
STATUS of the LISTENER
------------------------
Alias LISTENER_nmhdb002
Version TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
Start Date 30-JUN-2008 09:24:14
Uptime 91 days 3 hr. 57 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File /u01/oracle/oracle/product/10.2.0/db/network/log/listener_nmhdb
.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=178.1.2.212)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=178.1.2.205)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "NMH.newsource.com" has 2 instance(s).
Instance "NMH1", status READY, has 1 handler(s) for this service...
Instance "NMH2", status READY, has 2 handler(s) for this service...
Service "NMHXDB.newsource.com" has 2 instance(s).
Instance "NMH1", status READY, has 1 handler(s) for this service...
Instance "NMH2", status READY, has 1 handler(s) for this service...
Service "NMH_XPT.newsource.com" has 2 instance(s).
Instance "NMH1", status READY, has 1 handler(s) for this service...
Instance "NMH2", status READY, has 2 handler(s) for this service...
Service "TEST.newsource.com" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 2 handler(s) for this service...
Service "TESTXDB.newsource.com" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
Service "TEST_XPT.newsource.com" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 2 handler(s) for this service...
The command completed successfully
LSNRCTL>
above I found
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "NMH.newsource.com" has 2 instance(s).
=========================================================
then
One of my friend gave the following steps
The ASM instance is not registered, so we can force the registration by doing the following.
$ export ORACLE_SID=+ASM
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Sep 29 13:13:02 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> alter system register;
alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
when it tried above it endedup saying the above statement
========================================
At this state I really dont know how to make it work and so please kindly send me ur comments and solution
Early help is appreciated
With Kind Regards
Agent is Unreachable (REASON = Connection refused) but the host is UP
Dear All,
I have two instances on RAC
1) NMH.newsource.com_NMH1 30 1 8 +ASM1_nmhdb001.newsource.com
2) NMH.newsource.com_NMH2
2nd Instance it gave critical error that
Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
then that details giving as
I got Critical Error in OEM that
Jun 30, 2008 9:20:17 AM Agent is Unreachable (REASON = Connection refused) but the host is UP
I tried to start listener
but it said
LSNRCTL> start LISTENER_nmhdb002
TNS-01106: Listener using listener name LISTENER_nmhdb002 has already been started
then status says
LSNRCTL> listener_nmhdb002 status
NL-00853: undefined command "listener_nmhdb002". Try "help"
LSNRCTL> STATUS
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nmhdb002-vip)(PORT=1521)(IP=FIRST))
STATUS of the LISTENER
------------------------
Alias LISTENER_nmhdb002
Version TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
Start Date 30-JUN-2008 09:24:14
Uptime 91 days 3 hr. 57 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File /u01/oracle/oracle/product/10.2.0/db/network/log/listener_nmhdb
.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=178.1.2.212)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=178.1.2.205)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "NMH.newsource.com" has 2 instance(s).
Instance "NMH1", status READY, has 1 handler(s) for this service...
Instance "NMH2", status READY, has 2 handler(s) for this service...
Service "NMHXDB.newsource.com" has 2 instance(s).
Instance "NMH1", status READY, has 1 handler(s) for this service...
Instance "NMH2", status READY, has 1 handler(s) for this service...
Service "NMH_XPT.newsource.com" has 2 instance(s).
Instance "NMH1", status READY, has 1 handler(s) for this service...
Instance "NMH2", status READY, has 2 handler(s) for this service...
Service "TEST.newsource.com" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 2 handler(s) for this service...
Service "TESTXDB.newsource.com" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
Service "TEST_XPT.newsource.com" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 2 handler(s) for this service...
The command completed successfully
LSNRCTL>
above I found
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "NMH.newsource.com" has 2 instance(s).
=========================================================
then
One of my friend gave the following steps
The ASM instance is not registered, so we can force the registration by doing the following.
$ export ORACLE_SID=+ASM
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Sep 29 13:13:02 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> alter system register;
alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
when it tried above it endedup saying the above statement
========================================
At this state I really dont know how to make it work and so please kindly send me ur comments and solution
Early help is appreciated
With Kind Regards
I am not sure but i am kind of confused why you are trying crs_stat and register your ASM and all things.
You are getting this error in EM "Agent is Unreachable (REASON = Connection refused) but the host is UP " I guess its main error as agent is the one who communicates with db collects all metrics and send it to repository. and EM reads data from repository and shows you in form of HTML.
Now check on second host if your agent is up or not. Do you installed agent with same oracle user or some other user login to that user and try "emctl status agent"
Agent is Unreachable (REASON = Connection refused) but the host is UP
Reply With Quote
Zilch
Originally Posted by kamaldba
Bookmarks