Listener issue on oracle 10g RAC

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@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

Other related posts: