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
Kamal
Re 'Agent is Unreachable (REASON = Connection refused) but the host is UP'
Dear Mr Paresh ,The output is as follows.
$ $ORA_CRS_HOME/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....H1.inst application ONLINE ONLINE nmhdb1
ora....H2.inst application ONLINE ONLINE nmhdb2
ora.NMH.db application ONLINE ONLINE nmhdb1
ora....T1.inst application ONLINE ONLINE nmhdb1
ora....T2.inst application ONLINE ONLINE nmhdb2
ora.TEST.db application ONLINE ONLINE nmhdb1
ora....SM1.asm application ONLINE ONLINE nmhdb1
ora....B1.lsnr application ONLINE ONLINE nmhdb1
ora.nmhdb1.gsd application ONLINE ONLINE nmhdb1
ora.nmhdb1.ons application ONLINE ONLINE nmhdb1
ora.nmhdb1.vip application ONLINE ONLINE nmhdb1
ora....SM2.asm application ONLINE ONLINE nmhdb2
ora....B2.lsnr application ONLINE ONLINE nmhdb2
ora.nmhdb2.gsd application ONLINE ONLINE nmhdb2
ora.nmhdb2.ons application ONLINE ONLINE nmhdb2
ora.nmhdb2.vip application ONLINE ONLINE nmhdb2
$ $ORA_CRS_HOME/bin/srvctl start listener -n nmhdb2
$
Pls guide me what to do next
With Kind Regards
kamal
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 Mr.Prakash
above is the out put and the error iam getting
kamal
Agent is Unreachable (REASON = Connection refused) but the host is UP Reply to Thread
Yes Mr.pareshjavkar,it oocured from that time,I wasn,t here that time
But I noticed after I join this concern,I donno what happened,They said they rebounced the Db on that day and from that day they got this error.Pls help me out
With Kind Regards
Kamal