DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Agent is Unreachable (REASON = Connection refused) but the host is UP

  1. #1
    Join Date
    Sep 2008
    Posts
    8

    Exclamation 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

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Thumbs down Zilch

    Quote 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

  3. #3
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    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

  4. #4
    Join Date
    Sep 2008
    Posts
    8

    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

  5. #5
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Dear Kamal,

    How are you trying to connect to the instance?

    Paste the exact output of you getting an error.

    Regards,
    Paresh

  6. #6
    Join Date
    Sep 2008
    Posts
    8

    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

  7. #7
    Join Date
    Sep 2008
    Posts
    8

    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

  8. #8
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by kamaldba
    Dear Mr.Prakash
    above is the out put and the error iam getting
    kamal
    Dear Kamal,

    The error seems to be have come on June 30 2008, is the error reoccuring ???

    Regards,
    Paresh

  9. #9
    Join Date
    Sep 2008
    Posts
    8

    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

  10. #10
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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
  •  


Click Here to Expand Forum to Full Width