unable to start instance with srvctl
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: unable to start instance with srvctl

  1. #1
    Join Date
    May 2002
    Posts
    193

    unable to start instance with srvctl

    I have configured the listener as per the Oracle documentation:

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DCDELBILL1)(PORT = 1525))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /home/oracle/product/920)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = ccccc)
    (ORACLE_HOME = /home/oracle/product/920)
    (SID_NAME = ccccc1)
    )
    )

    In the same way I have included ccccc2 and ccccc3 on the listener.ora in the respective nodes!

    I get the following output when I type services:

    ----------------------------------------------------------------------------------------------------
    $ lsnrctl status

    LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 20-MAR-2007 10:29:45

    Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DCDELBILL3)(PORT=1525)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
    Start Date 20-MAR-2007 10:01:58
    Uptime 0 days 0 hr. 27 min. 46 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /home/oracle/product/920/network/admin/listener.ora
    Listener Log File /home/oracle/product/920/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DCDELBILL3_svs)(PORT=1525)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
    Services Summary...
    Service "ccccc" has 1 instance(s).
    Instance "ccccc1", status READY, has 1 handler(s) for this service...
    Service "ccccc2" has 1 instance(s).
    Instance "ccccc2", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    ---------------------------------Actual problem with registering the Instances-----------------------------------------------------------------------------------
    $
    $
    $
    $ srvctl start instance -d ccccc -i ccccc1
    PRKP-1040 : Failed to get status of the listeners associated with instance ccccc1 on nodeDCDELB
    ILL1
    PRKP-1001 : Error starting instance ccccc1 on node DCDELBILL1
    $

    Could any one point out where the issue is? if it is with the configuration of listener or elsewhere?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you will have the parameter REMOTE_LISTENERS set you need to confifure the tnsnames and listener files to understand what that is set to. Look up the rac network documentation

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