Connect a Oracle database using tnsnames.ora

Connect a Oracle database using tnsnames.ora

Hello!

I got a applications manager version 9 Build 9005. I have a question: How can I connect a Oracle database using entrys are stored in the tnsnames.ora?

My tnsnames.ora:

test =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MyOracleDb)(PORT = 1521))
           (LOAD_BALANCE = YES)
      (FAILOVER = ON)
    )
    (CONNECT_DATA =
      (SID = tms)
      (SERVER = DEDICATED)
    )
  )
 
A direct connection to MyOracleDb without a tnsnames entry works!

John























      • Topic Participants

      • Fazu

                New to ADSelfService Plus?