Is your local_listener parameter set in your init.ora or spfile? If so, what does it say? On Wed, Mar 5, 2008 at 1:09 PM, Harvinder Singh < Harvinder.Singh@xxxxxxxxxxxxx> 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 > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'