Database Administration (MOSC)

MOSC Banner

Sql Developer (1.5.1) connection to RAC

edited May 20, 2009 9:02AM in Database Administration (MOSC) 9 comments
Hello, I get a connection error

"Status : Failure -Test failed:lo exception: SO Exception was generated"

when connection type is TNS.

Here is extract from tnsnames.ora file;

TESTSPI =
(DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host_name>)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = <host_name>)(PORT = 1521))
(LOAD_BALANCE = yes) (FAILVOER = yes))
(CONNECT_DATA =
(SERVICE_NAME = oratest)
(failover_mode =
(type = select) (method = basic)
(RETRIES = 20) (DELAY = 5)) ) )

I can connect using sqlplus user/<password>@TESTSPI.

Any help gladly received.

Robert

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center