Listener issue on oracle 10g RAC

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 5 Mar 2008 14:09:01 -0500
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E02C23@ex2003.metratech.com>

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.lo g
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_at_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_at_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 - 13:09:01 CST