Re: Listener issue on oracle 10g RAC

From: Dan Norris <dannorris_at_dannorris.com>
Date: Wed, 05 Mar 2008 22:02:07 -0600
Message-ID: <47CF6CBF.4030703@dannorris.com>

I'll bet US$1 that your TNS entry is using the base IP address of the host (which I assume to be 192.168.1.137) instead of the VIP address which is where the listener is listening.

I'd like to see the lsnrctl status of the listener after you start it manually. I'm going to guess/expect that it has some difference from the status output you've shown below. While you're at it, throw in the contents of the /opt/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora too and we should be able to figure out what's up.

Having said all that, I don't see any reason why the connection below should fail. So far, you've only included details about the non-working configuration. Since you've got an alternative that works, include the same details about that and it should help us debug with you.

Dan

Harvinder Singh wrote:

Hi,

 

We are not able to connect to RAC instance unless we stop the listener using svrctl command and restart it again using lsnrctl command,

Do I need to add anything in tnsnames.ora files since out listener name is listener_dev-rhas2 and not listener?

 

$ srvctl status nodeapps -n dev-rhas2
VIP is running on node: dev-rhas2
GSD is running on node: dev-rhas2
Listener is running on node: dev-rhas2
ONS daemon is running on node: dev-rhas2
-bash-3.00$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 05-MAR-2008 13:43:57

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

Connecting to (ADDRESS=(PROTO =tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

-bash-3.00$ lsnrctl status listener_dev-rhas2

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 05-MAR-2008 13:44:11

Copyright (c) 1991, 2006, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_DEV-RHAS2
Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date 05-MAR-2008 13:33:09
Uptime 0 days 0 hr. 11 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File
/opt/oracle/oracle/product/10.2.0/db_1/network/log/listener_dev-rhas2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.137)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "netmeter" has 1 instance(s).
Instance "netmeter2", status READY, has 1 handler(s) for this service...
Service "netmeter1" has 1 instance(s).
Instance "netmeter2", status READY, has 1 handler(s) for this service...
Service "netmeter2" has 1 instance(s).
Instance "netmeter2", status READY, has 1 handler(s) for this service...
Service "netmeter3" has 1 instance(s).
Instance "netmeter2", status READY, has 1 handler(s) for this service...
Service "netmeterXDB" has 1 instance(s).
Instance "netmeter2", status READY, has 1 handler(s) for this service...
Service "netmeter_XPT" has 1 instance(s).
Instance "netmeter2", status READY, has 1 handler(s) for this service...
The command completed successfully

Following is entry in tnsnames.ora:
linux2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.137)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = netmeter)
(instance_name = netmeter2)
)
)

C:\orasupport>tnsping linux2

 

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 05-MAR-2

008 13:57:33

 

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

 

Used parameter files:

C:\app\hsingh\product\11.1.0\client_1\network\admin\sqlnet.ora

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)

(HOST = 192.168.1.137)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = netmeter)

(instance_name = netmeter2)))

OK (0 msec)

C:\orasupport>sqlplus dblair/dblair@linux2

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Mar 5 13:46:47 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12516: TNS:listener could not find available handler with matching protocol
stack

This only works If i stop the listener using svrctl then start the listener with lsnrctl start.

 

srvctl stop listener -n dev-rhas2

lsnrctl start

 

C:\orasupport>sqlplus dblair/dblair@linux2

 

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Mar 5 14:01:26 2008

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

 

SQL>

 

Thanks

--Harvinder

 

-- http://www.freelists.org/webpage/oracle-l Received on Wed Mar 05 2008 - 22:02:07 CST