-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|