Home » Server Options » RAC & Failsafe » Listener of Node2 doesn't work!!
icon3.gif  Listener of Node2 doesn't work!! [message #196624] Fri, 06 October 2006 05:02 Go to next message
nisaluck
Messages: 4
Registered: November 2005
Junior Member
Hi, everyone. I've installed RAC on MSA1000(SAN) Disk Array with 2 nodes named rac1 and rac2 on Windows2003, following this document :
http://www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnWindows2003UsingVMware.php#check_status_of_rac

I checked status of both nodes by srvctl and lsnrctl. I found that there is a problem with rac2's listener.

--------------------------------------------------------------

C:\Documents and Settings\Administrator>srvctl config database -
d RAC
rac1 RAC1 C:\oracle\product\10.2.0\db_1
rac2 RAC2 C:\oracle\product\10.2.0\db_1
--------------------------------------------------------------C:\Documents and Settings\Administrator>srvctl status database -d RAC
Instance RAC1 is running on node rac1
Instance RAC2 is running on node rac2
--------------------------------------------------------------
C:\Documents and Settings\Administrator>lsnrctl status rac1

LSNRCTL for 64-bit Windows: Version 10.2.0.1.0 - Production on 06-OCT-2006 16:47
:13

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip.localdomain)(PO
RT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=RAC.WORLD)(INSTANCE_NAME=
RAC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC1
Version TNSLSNR for 64-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 05-OCT-2006 11:00:01
Uptime 1 days 5 hr. 47 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener_rac
1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.44)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.41)(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 "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "RAC.WORLD" has 1 instance(s).
Instance "rac1", status READY, has 2 handler(s) for this service...
Service "RAC_XPT.WORLD" has 1 instance(s).
Instance "rac1", status READY, has 2 handler(s) for this service...
The command completed successfully
--------------------------------------------------------------

C:\Documents and Settings\Administrator>lsnrctl status rac2

LSNRCTL for 64-bit Windows: Version 10.2.0.1.0 - Production on 06-OCT-2006 16:47
:16

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip.localdomain)(PO
RT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=RAC.WORLD)(INSTANCE_NAME=
RAC2)))
TNS-01189: The listener could not authenticate the user
---------------------------------------------------------------

I tried to connect rac2 by sqlplus and got this error.(no problem with rac1)
SQL> conn sys/password@rac2 as sysdba
ERROR:
ORA-12521: TNS:listener does not currently know of instance requested in
connect descriptor


Warning: You are no longer connected to ORACLE.
---------------------------------------------------------------

What should I solve this problem? Please could you help me?
Re: Listener of Node2 doesn't work!! [message #196639 is a reply to message #196624] Fri, 06 October 2006 05:50 Go to previous message
nisaluck
Messages: 4
Registered: November 2005
Junior Member
More information:
I logged on to sqlplus by rac1 and enter this command.


SQL> select * from v$active_instances;

INST_NUMBER INST_NAME
----------- ----------------------------------------------------
1 RAC1:rac1

-----------------------------------------------------------
Here is listener.ora of rac1.
# listener.ora.rac1 Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora.rac1
# Generated by Oracle configuration tools.

LISTENER_RAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.41)(PORT = 1521)(IP = FIRST))
)
)

SID_LIST_LISTENER_RAC1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

-----------------------------------------------------------
tnsname.ora of rac1.
# tnsnames.ora.rac1 Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora.rac1
# Generated by Oracle configuration tools.

RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.41)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.42)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.WORLD)
)
)

LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
)

RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.WORLD)
(INSTANCE_NAME = RAC2)
)
)

RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.WORLD)
(INSTANCE_NAME = RAC1)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

-----------------------------------------------------------

listener.ora of rac2.
# listener.ora.rac2 Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora.rac2
# Generated by Oracle configuration tools.

LISTENER_RAC2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.42)(PORT = 1521)(IP = FIRST))
)
)

SID_LIST_LISTENER_RAC2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)


-----------------------------------------------------------

tnsname.ora of rac2.
# tnsnames.ora.rac2 Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora.rac2
# Generated by Oracle configuration tools.

RAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.41)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = RAC.WORLD)
)
)

LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
)

RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.WORLD)
(INSTANCE_NAME = RAC2)
)
)

RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.WORLD)
(INSTANCE_NAME = RAC1)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Previous Topic: Multiple versions of Linux for one RAC database.
Next Topic: voting disk in RAC
Goto Forum:
  


Current Time: Thu Mar 28 16:12:31 CDT 2024