Home » Server Options » RAC & Failsafe » listener error (oracle database 10gR2,10.2.0.1.0 RHEL4Up4)
listener error [message #281360] Fri, 16 November 2007 09:15 Go to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
RAC is installed and running, now using netca utility I've created listener. Netca run listener but using 'srvctl status nodeapps' I get listener down on both nodes.

[oracle@itsm-cldb1a ~]$ srvctl status nodeapps -n itsm-cldb1a
VIP is running on node: itsm-cldb1a
GSD is running on node: itsm-cldb1a
PRKO-2016 : Error in checking condition of listener on node: itsm-cldb1a
ONS daemon is running on node: itsm-cldb1a

Instead with ps -ef I see listener running and also using:
[oracle@itsm-cldb1a ~]$ $CRS_HOME/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....1A.lsnr application OFFLINE OFFLINE
ora....b1a.gsd application ONLINE ONLINE itsm-cldb1a
ora....b1a.ons application ONLINE ONLINE itsm-cldb1a
ora....b1a.vip application ONLINE ONLINE itsm-cldb1a
ora....1C.lsnr application ONLINE ONLINE itsm-cldb1c
ora....b1c.gsd application ONLINE ONLINE itsm-cldb1c
ora....b1c.ons application ONLINE ONLINE itsm-cldb1c
ora....b1c.vip application ONLINE ONLINE itsm-cldb1c

Listener is running on second node (and it's right) and down on first node (right, was get down using srvctl stop nodeapps but same command is not able to start it):

[oracle@itsm-cldb1a ~]$ srvctl start listener -n itsm-cldb1a
CRS-0210: Could not find resource ora.itsm-cldb1a.LISTENER_ITSM-CLDB1A.lsnr.

Seems not to be normal... any hint?
Re: listener error [message #281381 is a reply to message #281360] Fri, 16 November 2007 10:48 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Can you connect to node 1 with service like this

sqlplus user/pass@node1 ??
Re: listener error [message #281485 is a reply to message #281360] Sat, 17 November 2007 06:34 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
i didnt create the database yet.
after creating the listener when i check srvctl status nodeapps -n ctmisdb1 or 2 am getting this error.
Re: listener error [message #281871 is a reply to message #281485] Mon, 19 November 2007 14:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Stop and restart all services .
Re: listener error [message #281950 is a reply to message #281360] Tue, 20 November 2007 02:34 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
I had done wat u had said but still am finding the same issue.

this is error which i got when i try to start the instance in second node

[oracle@ctmisdb2 ~]$ srvctl start instance -d ctmis -i ctmis2
PRKP-1001 : Error starting instance ctmis2 on node ctmisdb2
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.ctmis.ctmis2.inst' has placement error.


oracle@ctmisdb2 ~]$ srvctl status database -d ctmis
Instance ctmis1 is running on node ctmisdb1
PRKO-2015 : Error in checking condition of instance on node: ctmisdb2

[oracle@ctmisdb2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....s1.inst application ONLINE OFFLINE
ora....s2.inst application ONLINE UNKNOWN ctmisdb2
ora.ctmis.db application ONLINE ONLINE ctmisdb1
ora....B1.lsnr application ONLINE ONLINE ctmisdb1
ora....B1.lsnr application ONLINE ONLINE ctmisdb1
ora....db1.gsd application ONLINE ONLINE ctmisdb1
ora....db1.ons application ONLINE ONLINE ctmisdb1
ora....db1.vip application ONLINE ONLINE ctmisdb1
ora....B2.lsnr application ONLINE ONLINE ctmisdb2
ora....B2.lsnr application ONLINE ONLINE ctmisdb2
ora....db2.gsd application ONLINE ONLINE ctmisdb2
ora....db2.ons application ONLINE ONLINE ctmisdb2
ora....db2.vip application ONLINE ONLINE ctmisdb2
[oracle@ctmisdb2 ~]$
[oracle@ctmisdb2 ~]$
[oracle@ctmisdb2 ~]$ srvctl start instance -d ctmis -i ctmis2
PRKP-1001 : Error starting instance ctmis2 on node ctmisdb2
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.ctmis.ctmis2.inst' has placement error.
[oracle@ctmisdb2 ~]$
[oracle@ctmisdb2 ~]$
[oracle@ctmisdb2 ~]$ srvctl start instance -d ctmis -i ctmis1
[oracle@ctmisdb2 ~]$
[oracle@ctmisdb2 ~]$ srvctl status database -d ctmis
Instance ctmis1 is running on node ctmisdb1
PRKO-2015 : Error in checking condition of instance on node: ctmisdb2
[oracle@ctmisdb2 ~]$


am sending the attachments for your reference please reply as soon as possible




  • Attachment: ctmisdb.rar
    (Size: 145.33KB, Downloaded 1489 times)
Re: listener error [message #281996 is a reply to message #281950] Tue, 20 November 2007 05:43 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Can't say it's exactly the same issue you are having, but I've seen situations for whatever reason the listener seemed to register with CRS correctly but encountered issues when trying to manage it via srvctl.

You may want to try and go thru netca to remove the listeners and therefore unregister them with CRS. I would recommend rebooting after this. At this point, see if you can manage your database via CRS. If you don't encounter any errors, then try to create the listeners again and re-register them with CRS.

If you still encounter problems, you may want to submit an SR with Oracle.
Previous Topic: Oracle RAC Installation
Next Topic: ORACLE 10g RAC On Solaris
Goto Forum:
  


Current Time: Thu Mar 28 04:50:49 CDT 2024