Home » RDBMS Server » Networking and Gateways » SRVCTL STATUS: Listener is not running [Merged]
SRVCTL STATUS: Listener is not running [Merged] [message #342961] Mon, 25 August 2008 11:42 Go to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Respected Gurus,
By running the following command, I came to know that my listener is not running.

:~$ srvctl status nodeapps -n ora1
VIP is running on node: ora1
GSD is running on node: ora1
Listener is not running on node: ora1
ONS daemon is running on node: ora1


But when I do a LSNRCTL STATUS, it shows me the list of services its listening to. Excep that it doesn't show that its servicing the second instance of a DB.

upon this, I do a CRS_STAT -t and see that the service of that instance are OFFLINE.

:~$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....AG.lsnr application    OFFLINE   OFFLINE
ora....cd2.srv application    OFFLINE   OFFLINE


the name of the listener above is AG.lsnr, whereas when I run the following command it gives me a differnet name.

:~$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk '{print $9}'
LISTENER


Am I looking at right stuff? What do I need to do in order to fix this?

Thanks,
Pinky

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343003 is a reply to message #342961] Mon, 25 August 2008 18:23 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What is the output of:

crs_stat | grep lsnr

Have you tried to stop the listener and then start it with:

srvctl start listener -n <node_name>

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343217 is a reply to message #343003] Tue, 26 August 2008 12:00 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Yes, I was able to start the listener manually. But thanks for the help though, I appreciate that.

However, I still have a concern as to why upon the restart of the machine my listener wouldn't start?

When I do a LSNRCTL STATUS, it would show me the status, but in fact "crs_stat" shows it OFFLINE .

Could you guide me through troubelshoot this problem?

Thanks,
Pinky

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343289 is a reply to message #343217] Tue, 26 August 2008 18:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It's hard to answer your questions when you don't answer the questions I ask.

Have you tried to un-register the listener with netca and then re-register them?

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343493 is a reply to message #343289] Wed, 27 August 2008 07:24 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Like I said, I was able to start the listener the same way you had described afterwards.

How can I unregister and then re-register teh listener? Is stopping and restarting through srvctl command refered to as unregistering and registering?

Thanks for your reply.

Report message to a moderator

LSNRCTL STATUS - Servicing local instance only -- 2-node RAC [message #343610 is a reply to message #342961] Wed, 27 August 2008 11:24 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Michel,
I haev three DBs on a 2-node RAC. Upon doing a lsnrctl status, for one of these 3 DBs, it shows only one instance (local) being serviced. Same is true for the node-2.

I also tried ALTER SYSTEM REGISTER on this particular DB. But no help.

Status:
crs_stat -t shows everyting ONLINE


Background:
This all happened after I restarted the nodes. It might interest you to know while diagnosing the problem that when the node starts, by defualt it loads a listener that is sitting in my /u01/app/oracle/product/10.2.0/asm/network/admin/ folder instead of /u01/app/oracle/product/10.2.0/db/network/admin/ folder.

I came to know this by lsnrctl status and seeing the 'Listener Parameter File' path, right after the node is restarted. And at this moment if I try to connect through my client machiens (windows), I receive a "No Listener Error". However, if I do a lsnrctl stop followed by a lsnrctl start (withouth exporting any path), and do a lsnrctl status then the 'Listener Parameter File' path changes to /u01/app/oracle/product/10.2.0/db/network/admin/ automatically, and my client machines can connect to the server DB.

Also, For some reasons sqlnet.log file got emptied on node-2 while I was performing a step through a GUI SSH software, and after that I never saw any entry in that. Is it normal?

Let me know if you need any specific results from me.

Thanks,
Pinky

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343618 is a reply to message #343003] Wed, 27 August 2008 11:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
ebrian wrote on Mon, 25 August 2008 19:23
What is the output of:

crs_stat | grep lsnr

Have you tried to stop the listener and then start it with:


How about this question?

You have to use netca to register/un-register the listener(s) with CRS.

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343626 is a reply to message #343618] Wed, 27 August 2008 12:07 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
 
crs_stat -t | grep lsnr
ora....AG.lsnr application    ONLINE    ONLINE    node1
ora....AG.lsnr application    ONLINE    ONLINE    node2


I haven't done netca step yet, but I ran
ALTER SYSTEM REGISTER

on the database whose both instances are not showing up in lsnrctl status.

It didn't work.

What do you propose here?

Thanks

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343644 is a reply to message #343626] Wed, 27 August 2008 13:22 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
No, the command is:

crs_stat | grep lsnr


Since the status shows ONLINE, you should also be able to run:
ps -ef | grep tns

You will not have a default listener name, therefore you can't just issue lsnrctl status.

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343646 is a reply to message #343644] Wed, 27 August 2008 13:31 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Didn't notice you wanted it without -t. Here it is:

$ crs_stat | grep lsnr
NAME=ora.node1.LISTENER_NODE1.lsnr
NAME=ora.node2.LISTENER_NODE2.lsnr


And here is the resultof the second one:
$ ps -ef | grep tns
  oracle  3481     1   0 10:39:43 ?           0:10 /u01/app/oracle/product/10.2.0/db/bin/tnslsnr LISTENER -inherit
  oracle 10010  8538   0 14:29:06 pts/3       0:00 grep tns


Quote:
You will not have a default listener name, therefore you can't just issue lsnrctl status.


I didn't quite get that.

Thanks for working with me on this. awaiting your reply!

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343677 is a reply to message #343646] Wed, 27 August 2008 16:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Based on the crs_stat output, it appears that the listeners are registered with CRS correctly. What is the output of:

/u01/app/oracle/product/10.2.0/db/bin/lsnrctl status listener_node1

Can you also post the output of your listener.ora and tnsnames.ora files in /u01/app/oracle/product/10.2.0/db/network/admin/ ?

[Updated on: Wed, 27 August 2008 16:34]

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343704 is a reply to message #343677] Wed, 27 August 2008 19:13 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Quote:
Based on the crs_stat output, it appears that the listeners are registered with CRS correctly. What is the output of:

/u01/app/oracle/product/10.2.0/db/bin/lsnrctl status listener_node1


Here's the output: (it contains strange errors, which I never saw because I was simply running lsnrctl status)

$ lsnrctl status LISTENER_NODE1
LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 27-AUG-2008 19:53:21

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Solaris Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-aggr1-vip.nipa.org)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
Start Date                27-AUG-2008 10:39:42
Uptime                    0 days 9 hr. 13 min. 38 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.nipa.org)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "port_db.nipa.org" has 1 instance(s).
  Instance "portdb1", status READY, has 1 handler(s) for this service...
Service "port_db_XPT.nipa.org" has 1 instance(s).
  Instance "portdb1", status READY, has 1 handler(s) for this service...
Service "all_db" has 2 instance(s).
  Instance "alldb1", status READY, has 2 handler(s) for this service...
  Instance "alldb2", status READY, has 1 handler(s) for this service...
Service "all_db_XPT" has 2 instance(s).
  Instance "alldb1", status READY, has 2 handler(s) for this service...
  Instance "alldb2", status READY, has 1 handler(s) for this service...
Service "portdbXDB.nipa.org" has 1 instance(s).
  Instance "portdb1", status READY, has 1 handler(s) for this service...
Service "portdb_taf.nipa.org" has 1 instance(s).
  Instance "portdb1", status READY, has 1 handler(s) for this service...
Service "alldbXDB" has 2 instance(s).
  Instance "alldb1", status READY, has 1 handler(s) for this service...
  Instance "alldb2", status READY, has 1 handler(s) for this service...
Service "alldb_taf" has 2 instance(s).
  Instance "alldb1", status READY, has 2 handler(s) for this service...
  Instance "alldb2", status READY, has 1 handler(s) for this service...
Service "testdb.nipa.org" has 2 instance(s).
  Instance "testdb1", status READY, has 2 handler(s) for this service...
  Instance "testdb2", status READY, has 1 handler(s) for this service...
Service "testdbXDB.nipa.org" has 2 instance(s).
  Instance "testdb1", status READY, has 1 handler(s) for this service...
  Instance "testdb2", status READY, has 1 handler(s) for this service...
Service "testdb_XPT.nipa.org" has 2 instance(s).
  Instance "testdb1", status READY, has 2 handler(s) for this service...
  Instance "testdb2", status READY, has 1 handler(s) for this service...
Service "testdb_taf.nipa.org" has 2 instance(s).
  Instance "testdb1", status READY, has 2 handler(s) for this service...
  Instance "testdb2", status READY, has 1 handler(s) for this service...
The command completed successfully


Quote:
Can you also post the output of your listener.ora and tnsnames.ora files in /u01/app/oracle/product/10.2.0/db/network/admin/ ?


Here's the tnsnames.ora:
# tnsnames.ora.node1 Network Configuration File: /u01/app/oracle/product/10.2.0/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

port_db =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = port_db.nipa.org)
    )
  )

portdb1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = port_db.nipa.org)
      (INSTANCE_NAME = portdb1)
    )
  )

portdb2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = port_db.nipa.org)
      (INSTANCE_NAME = portdb2)
    )
  )

all_db =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = all_db)
    )
  )

alldb1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = all_db)
      (INSTANCE_NAME = alldb1)
    )
  )

alldb2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = all_db)
      (INSTANCE_NAME = alldb2)
    )
  )

TESTDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb.nipa.org)
    )
  )

TESTDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb.nipa.org)
      (INSTANCE_NAME = testdb1)
    )
  )

TESTDB2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb.nipa.org)
      (INSTANCE_NAME = testdb2)
    )
  )

LISTENERS_port_db =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
  )

LISTENERS_all_db =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
  )

LISTENERS_TESTDB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
  )

portdb_TAF =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = portdb_taf.nipa.org)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

alldb_TAF =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = alldb_taf)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

TESTDB_TAF =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-aggr1-vip.nipa.org)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb_taf.nipa.org)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )


...and here's the listener.ora:
# listener.ora.node1 Network Configuration File: /u01/app/oracle/product/10.2.0/db/network/admin/listener.ora.node1
# Generated by Oracle configuration tools.

LISTENER_node1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-aggr1-vip.nipa.org)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.101)(PORT = 1521)(IP = FIRST))
    )
  )


For Your Information: My listener version is 10.2.0.4 whereas DB version is 10.2.0.3. Also, tnsnames.ora is the same on node2.

I am very surprized to see the difference of out put between lsnrctl status and lsnrctl status [listner name]

Waiting for your reply impatiently.

[Updated on: Wed, 27 August 2008 19:18]

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343713 is a reply to message #343704] Wed, 27 August 2008 21:46 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
So you are using a listener from a different home ? If so, is there a particular reason why ?

I would expect an additional entry such as the following in your listener.ora file:

SID_LIST_LISTENER_node1 =
  (SID_LIST=
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db)
      (PROGRAM=extproc)))


Did you use the netca utility from the 10.2.0.3 or 10.2.0.4 home ?

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #343723 is a reply to message #343713] Wed, 27 August 2008 22:41 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Quote:
So you are using a listener from a different home ? If so, is there a particular reason why ?


Not that I am aware of. This is how the system was setup before me. My other post under this thread is about exactly the same issue. That upon crs_stop/start [listener_name], it loads the listener from /u01/app/oracle/product/10.2.0/asm instead of db. But since my .profile loads ORACLE_HOME as /u01/app/oracle/product/10.2.0/db, after doing a lsnrctl stop/start it loads from ORACLE_HOME.

If I see the listener.ora file in /asm/network/admin, I find these entries along with the one I have already posted.

SID_LIST_LISTENER_NODE1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/asm)
      (PROGRAM = extproc)
    )
  )


Did you notice /asm at the end? Is that because this listener is sitting in /u01/app/oracle/product/10.2.0/asm/network/admin folder?

Quote:
Did you use the netca utility from the 10.2.0.3 or 10.2.0.4 home ?


I have not run the netca yet. Also, my local_listener and remote_listener parameters in spfile are NULL.

Finally, before adding the entries in listener.ora that you suggested in last post, I wanted to ask you about the entries similar to your suggestion in /asm/network/admin folder.

Like i mentioned before, if that /asm/ listener is loaded, nothing connects from my client (windows) machine, where I am using TOAD.

I greatly appreciate your time and effort that you are taking in resolving this issue. Waiting for your reply.

Bundle of Thanks.

[Updated on: Wed, 27 August 2008 23:05]

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #344091 is a reply to message #343713] Thu, 28 August 2008 14:21 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Brian,
Does this seem ok to you?

SQL>show parameter %ner;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string
remote_listener                      string


Is this the reason why only the local instance is being serviced and not all?

-Pinky

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #344094 is a reply to message #343723] Thu, 28 August 2008 14:33 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
I was wrong about the database version. They are all 10.2.0.4.

Sorry.

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #344395 is a reply to message #344094] Fri, 29 August 2008 12:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
To be honest, I've kinda lost scope of everything going on with this post. Information overkill I guess.

To ensure proper registration with remote listener, you should incorporate the following entries in your RAC databases:

alter system set remote_listener = 'LISTENERS_<db_name>' scope=both sid='*';
alter system set local_listener = 'LISTENER_<instance1_name>' scope=both sid='<sid1>';
alter system set local_listener = 'LISTENER_<instance2_name>' scope=both sid='<sid2>';

I would also include the following entry in the tnsnames file on each node.

LISTENER_<instance1_name> =
	(ADDRESS_LIST =
	   (ADDRESS = (PROTOCOL = TCP)(HOST = <node1-vip_ip>)(PORT = 1521))
	)

LISTENER_<instance2_name> =
	(ADDRESS_LIST =
	   (ADDRESS = (PROTOCOL = TCP)(HOST = <node2-vip_ip>)(PORT = 1521))
	)

LISTENERS_<db_name> =
	(ADDRESS_LIST =
	   (ADDRESS = (PROTOCOL = TCP)(HOST = <node1-vip_ip>)(PORT = 1521))
	   (ADDRESS = (PROTOCOL = TCP)(HOST = <node2-vip_ip>)(PORT = 1521))
	)


Just replace the <text> above with your appropriate information.

HTH

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #344608 is a reply to message #344395] Sat, 30 August 2008 23:55 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Thanks Brian,

Quote:
alter system set remote_listener = 'LISTENERS_<db_name>' scope=both sid='*';


... worked for me.

Just one last question though.

Can a parameter file contain multiple local_listener values at the same time, like for DB_1 and DB_2?

Thank you very much for helping. Greatly appreciated.

Thanks!

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #344609 is a reply to message #344608] Sun, 31 August 2008 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
deepmachine wrote on Sat, 30 August 2008 21:55
Thanks Brian,

Quote:
alter system set remote_listener = 'LISTENERS_<db_name>' scope=both sid='*';


... worked for me.

Just one last question though.

Can a parameter file contain multiple local_listener values at the same time, like for DB_1 and DB_2?

Thank you very much for helping. Greatly appreciated.

Thanks!



What happened after you tested/tried to do so?

Report message to a moderator

Re: SRVCTL STATUS: Listener is not running [message #344665 is a reply to message #344609] Sun, 31 August 2008 15:54 Go to previous message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Quote:
What happened after you tested/tried to do so?


remote_listener value from my init.ora got deleted somehow, and so LSNRCTL STATUS command would only show local instances serviced by the service_name on both nodes. With the alter system command suggested by Brian, I was again able to see both instances serviced by the service_name.

Thanks.

Report message to a moderator

Previous Topic: listener getting hanged
Next Topic: Help !!! - listener state:blocked
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 10 01:50:05 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.