Home » RDBMS Server » Networking and Gateways » Listener support no services (oracle 11.2.0.1 RAC of two nodes,solaris10)
Listener support no services [message #540596] Tue, 24 January 2012 12:58 Go to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
hi,
i have created a listener for my db and register the service to it some 2 years back now i have checked it and it display as follows
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date                24-JAN-2012 13:45:44
Uptime                    0 days 0 hr. 3 min. 59 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/11.2.0/dbhome_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.x.x.x)(PORT=1521)))
The listener supports no services
The command completed successfully


now i have stop and then restart but same status? so how can i manually register it again or anyother solution as i cant run netmgr

kindly guide

Regards
janakors
Re: Listener support no services [message #540597 is a reply to message #540596] Tue, 24 January 2012 13:02 Go to previous messageGo to next message
BlackSwan
Messages: 26748
Registered: January 2009
Location: SoCal
Senior Member
when no DB is available, then listener has nothing to do.
Re: Listener support no services [message #540600 is a reply to message #540597] Tue, 24 January 2012 13:06 Go to previous messageGo to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
BlackSwan wrote on Tue, 24 January 2012 13:02
when no DB is available, then listener has nothing to do.


well db is there ? but why it is showing this and how can i re register it

Regards
Re: Listener support no services [message #540601 is a reply to message #540597] Tue, 24 January 2012 13:08 Go to previous messageGo to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
BlackSwan wrote on Tue, 24 January 2012 13:02
when no DB is available, then listener has nothing to do.


well db is there,in fact i have stop it and restart it that is why it is showing little up time ? but why it is showing this and how can i re register it

Regards
Re: Listener support no services [message #540603 is a reply to message #540601] Tue, 24 January 2012 13:14 Go to previous messageGo to next message
John Watson
Messages: 8399
Registered: January 2010
Location: Global Village
Senior Member
You can just wait a couple of minutes and the PMON process will register with the listener automatically. Or if you can't wait:
ALTER SYSTEM REGISTER;
It's nothing to do with netmgr.
Re: Listener support no services [message #540604 is a reply to message #540603] Tue, 24 January 2012 13:16 Go to previous messageGo to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
thanks john.let me then try it at DC..

Regards

Re: Listener support no services [message #540606 is a reply to message #540603] Tue, 24 January 2012 13:18 Go to previous messageGo to next message
BlackSwan
Messages: 26748
Registered: January 2009
Location: SoCal
Senior Member
Oracle RDBMS (tries to) register itself to listener once every 60 seconds.
DB will succeed to register itself when no OS/Networking mis-configuration exists
Re: Listener support no services [message #540669 is a reply to message #540606] Wed, 25 January 2012 05:00 Go to previous messageGo to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
hi,
Quote:

ALTER SYSTEM REGISTER;


well i checked it but again same issue, i have checked the alert log and it have these messages
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 45)
Wed Jan 25 11:42:11 2012
dispatcher 'D000' encountered error getting listening address
Wed Jan 25 11:42:14 2012
found dead dispatcher 'D000', pid = (28, 46)
Wed Jan 25 11:42:15 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 47)
Wed Jan 25 11:42:18 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 48)
Wed Jan 25 11:42:21 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 49)
Wed Jan 25 11:42:24 2012
dispatcher 'D000' encountered error getting listening address
Wed Jan 25 11:42:27 2012
found dead dispatcher 'D000', pid = (28, 50)
Wed Jan 25 11:42:27 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 51)
Wed Jan 25 11:42:30 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 52)
Wed Jan 25 11:42:33 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 53)
Wed Jan 25 11:42:36 2012
dispatcher 'D000' encountered error getting listening address
Wed Jan 25 11:42:39 2012
found dead dispatcher 'D000', pid = (28, 54)
Wed Jan 25 11:42:39 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 55)
Wed Jan 25 11:42:42 2012
dispatcher 'D000' encountered error getting listening address

also listener parameter
SQL> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string
remote_listener                      string
SQL>

and these messages are continuously coming.

@BlackSwan, what kind of OS issues can be there as i doubt it?


Kindly Guide

Regards
janakors
Re: Listener support no services [message #540671 is a reply to message #540669] Wed, 25 January 2012 05:07 Go to previous messageGo to next message
John Watson
Messages: 8399
Registered: January 2010
Location: Global Village
Senior Member
Your listener is not listening on the default addess, so you have to tell the instance where it is:

alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=10.x.x.x)(PORT=1521))';
alter system register;

(I don't know what the correct address is, because in your post you replaced part of it with x.x.x for some reason)
Re: Listener support no services [message #540673 is a reply to message #540671] Wed, 25 January 2012 05:13 Go to previous messageGo to next message
John Watson
Messages: 8399
Registered: January 2010
Location: Global Village
Senior Member
I've just noticed that you say this is an 11.2 two node RAC. That changes everything. Your node listeners and scan listeners should be running off your grid infrastructure home, and you should not be attempting to run a listener off the database home at all. I think you had better start again!
Have you looked at the scan listeners and node listeners? Are your instances and services correctly registered with them?
Re: Listener support no services [message #540781 is a reply to message #540673] Wed, 25 January 2012 12:51 Go to previous messageGo to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
hi john,
No the listener is on single instance DB server which is only built to have RMAN and this is our backup server.
i have created a service at production which connect RMAN catalog so when it try to connect so it give this error about listener.
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jan 25 09:36:09 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN>
connected to target database: GRID112 (DBID=307973015)

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: 
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor



and also the listener parameters
SQL> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string
remote_listener                      string
SQL>

i will implement your suggestion sir.


Regards

janakors

[Updated on: Wed, 25 January 2012 12:56] by Moderator

Report message to a moderator

Re: Listener support no services [message #540783 is a reply to message #540781] Wed, 25 January 2012 12:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67466
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a SID for an instance (usually a database instance) that either
 has not yet dynamically registered with the listener or has not been
 statically configured for the listener. This may be a temporary condition
 such as after the listener has started, but before the database instance
 has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Re: Listener support no services [message #540786 is a reply to message #540783] Wed, 25 January 2012 13:14 Go to previous messageGo to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
Quote:

Check for an event in the listener.log file.


i hope you are talking about xml file .if yes so how to read that.
ouput of "lsnrctl services listener" is
 
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 25-JAN-2012 10:26:26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
The listener supports no services
The command completed successfully.


Re: Listener support no services [message #540808 is a reply to message #540786] Wed, 25 January 2012 16:33 Go to previous messageGo to next message
BlackSwan
Messages: 26748
Registered: January 2009
Location: SoCal
Senior Member
post results from following OS command

ps -ef | grep -i pmon
Re: Listener support no services [message #540946 is a reply to message #540808] Thu, 26 January 2012 12:23 Go to previous message
janakors
Messages: 227
Registered: September 2009
Senior Member
Quote:

alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=10.x.x.x)(PORT=1521))';
alter system register;


Problem solved.listener registered and working fine

thanks to all


Regards

janakors
Previous Topic: one ip address..two listeners and two db instances
Next Topic: TNS issue
Goto Forum:
  


Current Time: Sun Oct 25 18:04:39 CDT 2020