Re: Listener issue on oracle 10g RAC

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_at_metratech.com> 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_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
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l