Problem with Listener in Oracle RAC 11.2.0
Date: Thu, 20 Oct 2011 16:19:20 -0700 (PDT)
Message-ID: <1d3641df-6a33-4b2c-a44a-b653ab3a33ad_at_v38g2000yqf.googlegroups.com>
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? Received on Thu Oct 20 2011 - 18:19:20 CDT