-
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
-
Zilch
Originally Posted by kamaldba
At this state I really dont know how to make it work...
It its obvious you don't know anything (zilch) about RAC.
You do not start/stop the listener with lsnrctl but rather with srvctl and it seems you have misconfigured the RAC.
Better resign and let the company hire someone with better understanding of RAC.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Let us know the result of crs_stat -t ... i am sure the services pertaining to listener might have been stopped.
$ORA_CRS_HOME/bin/crs_stat -t
$ORA_CRS_HOME/bin/srvctl start listener -n nodename
Regards,
Paresh
-
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
-
Dear Kamal,
How are you trying to connect to the instance?
Paste the exact output of you getting an error.
Regards,
Paresh
-
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"
Rgds
Parag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|