hi,
we have RAC database oracle 10gR2 on wndows OS.
the client has installed a client software and an application software is accessing the database with tnsname.
the problem is that whn we click for the first time it gives ora-12545 , but clicking second times it connects...some times u we need to click thrice or 4th time on application exe and so on...
Actually i am new in RAC world and not able to figure out what is happening.
the listener.ora file on both node is as follows.
on node 192.0.0.9 LISTENER.ORA is
SID_LIST_LISTENER_PCSDB2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER_PCSDB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pcsdbvip2)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.9)(PORT = 1521)(IP = FIRST))
)
)
and node 192.0.0.8 LISTENER.ORA
SID_LIST_LISTENER_PCSDB1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER_PCSDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pcsdbvip1)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.8)(PORT = 1521)(IP = FIRST))
)
)
on node 192.0.0.8 hosts file is
#PUBLIC IP
192.0.0.8 pcsdb1
192.0.0.9 pcsdb2
#PRIVATE IP
10.0.0.1 pcsdbp1
10.0.0.2 pcsdbp2
#VIRTUAL IP
192.0.0.10 pcsdbvip1 pcsdbvip1.smf.com
192.0.0.11 pcsdbvip2 pcsdbvip2.smf.com
#PUBLIC IP
192.0.0.8 pcsdb1
192.0.0.9 pcsdb2
#PRIVATE IP
10.0.0.1 pcsdbp1
10.0.0.2 pcsdbp2
#VIRTUAL IP
192.0.0.10 pcsdbvip1
192.0.0.11 pcsdbvip2
so where i am committing mistake..
many thanks