Re: Problem with Listener in Oracle RAC 11.2.0

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 21 Oct 2011 03:37:30 +0000 (UTC)
Message-ID: <pan.2011.10.21.03.37.30_at_gmail.com>



On Thu, 20 Oct 2011 16:19:20 -0700, Big George wrote:

> Hello
> I've got a problem with listener
>
> O/S: Windows Server 2008
> Database: Oracle RAC 11.2.0
> Number of Nodes: 2
> Storage: ASM
>
> Node A does not connect to ASM. However Node B does and database is up.
> In NodeB, I can connect to database via sqlplus. No problem.
>
> Problem is that clients can't connect to database because of this
> problem: ORA-12541: TNS No listener
>
> In Node B, if I try to start listener I got:
> ------------------------------
> C:\>lsnrctl stat
>
> LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 20-
> OCT-2011 17:17:10
>
> Copyright (c) 1991, 2010, Oracle. All rights reserved.
>
> Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-12541:
> TNS:no listener
> TNS-12560: TNS:protocol adapter error
> TNS-00511: No listener
> 64-bit Windows Error: 61: Unknown error
>
> C:\>lsnrctl start
>
> LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 20-
> OCT-2011 17:17:19
>
> Copyright (c) 1991, 2010, Oracle. All rights reserved.
>
> Starting tnslsnr: please wait...
>
> TNS-12560: TNS:protocol adapter error
> TNS-00530: Protocol adapter error
>
> ------------------------------
>
> What should I do? Recreate listener? I would prefer to just modify file:
> C:\app\11.2.0\grid\NETWORK\ADMIN\listener.ora If something goes wrong, I
> can have a backup.
>
> If I change in file listener.ora of Node B, should I made the same
> changes in Node A?

  1. In RAC environment you shouldn't be starting listener with lsnrctl, it goes to $ORACLE_HOME instead of $GRID_HOME. Most likely, you don't even have $ORACLE_HOME/network/admin/listener.ora. You should start listener by issuing the following command:

   srvctl start listener -n <node name>

B) Check the log file. There is a utility called "adrci" and you can use

   it like this:

[oracle_at_medo ~]$ adrci

ADRCI: Release 11.2.0.3.0 - Production on Thu Oct 20 23:31:03 2011

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

ADR base = "/oracle"
adrci> show homes
ADR Homes:

diag/tnslsnr/medo/listener
diag/rdbms/home/O11
diag/clients/user_oracle/host_3516727102_80
diag/clients/user_oracle/host_3516727102_11
adrci> set home diag/tnslsnr/medo/listener adrci> show problem

ADR Home = /oracle/diag/tnslsnr/medo/listener:



0 rows fetched

adrci> show alert -tail 3
2011-10-20 23:02:58.514000 -04:00
20-OCT-2011 23:02:58 * service_update * O11 * 0 2011-10-20 23:05:31.612000 -04:00
20-OCT-2011 23:05:31 * service_update * O11 * 0 2011-10-20 23:06:52.681000 -04:00

The "show problem" command should tell you whether you have a problem. For the particular occurrence, you can check "show incident" command. Here is a great tutorial for the ADRCI utility:

http://www.dbasupport.com/oracle/ora11g/ADRCI-Extended-Commands.shtml

-- 
http://mgogala.byethost5.com
Received on Thu Oct 20 2011 - 22:37:30 CDT

Original text of this message