Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem with Listener in Oracle RAC 11.2.0

243 views
Skip to first unread message

Big George

unread,
Oct 20, 2011, 7:19:20 PM10/20/11
to
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?




Mladen Gogala

unread,
Oct 20, 2011, 11:37:30 PM10/20/11
to
A) 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@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
0 new messages