Home » Server Options » RAC & Failsafe » Listener problem (Oracle 10g RAC Load Balance Faile Safe, Linux)
Listener problem [message #354303] Fri, 17 October 2008 09:13 Go to next message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

I am facing a product with listener.

[oracle@acmds1 ~]$ /u01/app/oracle/product/crs/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....db1.srv application ONLINE ONLINE acmds1
ora....db2.srv application ONLINE ONLINE acmds2
ora....cmdb.cs application ONLINE ONLINE acmds1
ora....b1.inst application ONLINE ONLINE acmds1
ora....b2.inst application ONLINE ONLINE acmds2
ora.acmdb.db application ONLINE ONLINE acmds1
ora....S1.lsnr application ONLINE ONLINE acmds1
ora.acmds1.gsd application ONLINE ONLINE acmds1
ora.acmds1.ons application ONLINE ONLINE acmds1
ora.acmds1.vip application ONLINE ONLINE acmds1
ora....S2.lsnr application ONLINE ONLINE acmds2
ora.acmds2.gsd application ONLINE ONLINE acmds2
ora.acmds2.ons application ONLINE ONLINE acmds2
ora.acmds2.vip application ONLINE ONLINE acmds2

whereas listener shows error on node1 of RAC:
LSNRCTL> show current_listener
Message 1042 not found; No message file for product=network, facility=TNS

Node2 shows:
LSNRCTL> show current_listener
Current Listener is LISTENER

Parameter file shows:
SQL> show parameter listener

NAME TYPE VALUE
----------------------------------------------
local_listener string
remote_listener string LISTENERS_ACMDB

Can anyone help me?
  • Attachment: LISTENER.txt
    (Size: 0.84KB, Downloaded 1413 times)
Re: Listener problem [message #354305 is a reply to message #354303] Fri, 17 October 2008 09:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
LSNRCTL> show current_listener Message 1042 not found; No message file for product=network, facility=TNS

It has mostly to do with the environment.
Check your ORACLE_HOME and PATH values.
Re: Listener problem [message #354518 is a reply to message #354305] Mon, 20 October 2008 03:08 Go to previous messageGo to next message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

All the variables are set. You may review that on problematic node1.

[oracle@acmds1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/db_1

[oracle@acmds1 ~]$ echo $ORACLE_BASE
/u01/app/oracle

[oracle@acmds1 ~]$ echo $PATH
/usr/j2sdk/bin:.:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/u01/app/oracle/product/10.2.0/db_1/b in:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/app/oracle/common/oracle/bin

I can see some files in Node2 that are not present in Node1:
[oracle@acmds2 ~]$ ls -lrt /u01/app/oracle/product/10.2.0/db_1/network/mesg/
total 620
-rw-r----- 1 oracle oinstall 5895 May 29 1996 nmpus.msg
-rw-r----- 1 oracle oinstall 4658 May 29 1996 snlus.msg
-rw-r----- 1 oracle oinstall 17859 Apr 28 1998 nnfus.msg
-rw-r----- 1 oracle oinstall 12464 May 16 2000 nmrus.msg
-rw-r----- 1 oracle oinstall 67325 Oct 8 2001 nnlus.msg
-rw-r----- 1 oracle oinstall 9539 Aug 9 2002 naukus.msg
-rw-r----- 1 oracle oinstall 51997 Dec 17 2002 niqus.msg
-rw-r----- 1 oracle oinstall 18822 May 28 2004 ncrus.msg
-rw-r----- 1 oracle oinstall 14907 Feb 21 2005 nlus.msg
-rw-r----- 1 oracle oinstall 12274 Mar 30 2005 nzus.msg
-rwxrwxrwx 1 oracle oinstall 9216 Jun 22 2005 naukus.msb
-rw-r----- 1 oracle oinstall 6656 Jun 22 2005 ncrus.msb
-rw-r----- 1 oracle oinstall 11776 Jun 22 2005 nlus.msb
-rw-r----- 1 oracle oinstall 9728 Jun 22 2005 niqus.msb
-rw-r----- 1 oracle oinstall 4608 Jun 22 2005 nmrus.msb
-rw-r----- 1 oracle oinstall 3584 Jun 22 2005 nmpus.msb
-rw-r----- 1 oracle oinstall 8704 Jun 22 2005 nnfus.msb
-rw-r----- 1 oracle oinstall 6144 Jun 22 2005 snlus.msb
-rw-r----- 1 oracle oinstall 11776 Jun 22 2005 nzus.msb
-rw-r----- 1 oracle oinstall 242709 Jun 22 2005 tnsus.msg
-rw-r----- 1 oracle oinstall 46592 Jun 22 2005 tnsus.msb

I cannot copy these files on Node1. Is this the problem of listener.
Re: Listener problem [message #354570 is a reply to message #354518] Mon, 20 October 2008 06:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>All the variables are set.
Quote:
/usr/j2sdk/bin:.:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/u01/app/oracle/product/10.2.0/db_1/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/app/oracle/common/oracle/bin

What would be the second one?
Re: Listener problem [message #354578 is a reply to message #354570] Mon, 20 October 2008 07:47 Go to previous messageGo to next message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

yeah! /u01/app/oracle/common/oracle/bin is not any think. It was set by x-dba. Enterprise Manager is running with local listener and emagent.trc shows errors of node1 connections.
Re: Listener problem [message #354583 is a reply to message #354570] Mon, 20 October 2008 08:00 Go to previous message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

yeah! /u01/app/oracle/common/oracle/bin is not anything. It was set by x-dba. Enterprise Manager is running with local listener and emagent.trc shows errors of node1 connections.

[Updated on: Mon, 20 October 2008 08:00]

Report message to a moderator

Previous Topic: RAC Nodes
Next Topic: JDBC thin client connection to RAC
Goto Forum:
  


Current Time: Tue Mar 19 03:04:52 CDT 2024