OraFAQ Forum: RAC & Failsafe

Home » Server Options » RAC & Failsafe » listener error (oracle database 10gR2,10.2.0.1.0 RHEL4Up4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

listener error [message #281360]

Fri, 16 November 2007 09:15

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?

Report message to a moderator

Re: listener error [message #281381 is a reply to message #281360]

Fri, 16 November 2007 10:48

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Can you connect to node 1 with service like this

sqlplus user/pass@node1 ??

Report message to a moderator

Re: listener error [message #281485 is a reply to message #281360]

Sat, 17 November 2007 06:34

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.

Report message to a moderator

Re: listener error [message #281871 is a reply to message #281485]

Mon, 19 November 2007 14:50

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Stop and restart all services .

Report message to a moderator

Re: listener error [message #281950 is a reply to message #281360]

Tue, 20 November 2007 02:34

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 663 times)

Report message to a moderator

Re: listener error [message #281996 is a reply to message #281950]

Tue, 20 November 2007 05:43

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.

Report message to a moderator

Previous Topic:	Oracle RAC Installation
Next Topic:	ORACLE 10g RAC On Solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 29 07:45:15 CDT 2023