OraFAQ Forum: RAC & Failsafe » Oracle RAC on Compaq TRU64- Connection Problems

Home » Server Options » RAC & Failsafe » Oracle RAC on Compaq TRU64- Connection Problems

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Oracle RAC on Compaq TRU64- Connection Problems [message #136315 is a reply to message #136287]

Wed, 07 September 2005 08:44

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

> target/object doesn't exist

This sounds like a networking problem. When it happens again, try to ping both IP's to see if they respond.

Best regards.

Frank

Report message to a moderator

Re: Oracle RAC on Compaq TRU64- Connection Problems [message #136324 is a reply to message #136287]

Wed, 07 September 2005 09:13

maura
Messages: 4
Registered: July 2005

Junior Member

Hi Frank,
thanks a lot for your answer.
What I don't understand is why the WFR tnsname functions when WFRXX doesn't function. IP address respond to ping.
Thanks
Regards
Maura

Report message to a moderator

Re: Oracle RAC on Compaq TRU64- Connection Problems [message #136533 is a reply to message #136315]

Thu, 08 September 2005 10:15

maura
Messages: 4
Registered: July 2005

Junior Member

Hi Frank,
I send two pictures about my error.
WFR connection is successfull, WFRXX gives the error in the same network conditions.
Let me know if you have any ideas...
Thanks alot
Kind Regards
maura

Attachment: pictures.zip
(Size: 159.43KB, Downloaded 1758 times)

Report message to a moderator

Previous Topic:	Parallel query and RAC
Next Topic:	Number of connected users to RAC system

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 19:49:13 CDT 2025