Oracle RAC on Compaq TRU64- Connection Problems [message #136287] |
Wed, 07 September 2005 07:14 |
maura
Messages: 4 Registered: July 2005
|
Junior Member |
|
|
Hallo everybody,
we have istalled oracle rac 9.2.0 on Compaq TRU64 Cluster. Then we have istalled on client host Oracle Driver (9.0) and defined our tnsnames.ora file like
WFRXX =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.28.152.104)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.28.152.105)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = WFR)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = basic)
)
)
)
Sometimes we can't connect to Database; we get timeout error or 'target/object doesn't exist' error. When we get this error, if we try to connect to Database with this string:
WFR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.28.152.105)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.28.152.105)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = WFR)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = preconnect)
)
)
)
we haven't any error!
Has anybody experienced similar connection problem?
On my host I've istalled Oracle driver v.8 and I've not this problem. Could it be related to the driver's version? Or could it be also an Oracle Configuration on Compaq TRU64???
I really don't understand why I've this problem in a randomic way...
Anybody can help me???
Thanks a lot
Regards
Maura
|
|
|
|
|
|