Do I need an Oracle ”TNS client” to be able to use Oracle wtih ALM?

  • Questions
  • Do I need an Oracle ''TNS client'' to be able to use Oracle wtih ALM?
Question ID: 107767
1
0

We were wondering if we need to involve our Oracle DBA to setup an Oracle TNS client on our ALM server to be able to communicate with our Oracle instance from ALM server.

Are there other options?

Marked as spam
Posted by (Questions: 87, Answers: 6)
Asked on July 25, 2017 9:15 pm
3 views
Answers
1
Private answer

You can use ALM with or without your TNS Client (tnsnames.ora):

The patterns for the ''connect string'' are below:

**With TNS:**

jdbc:mercury:oracle:TNSNamesFile=<_Path and TNSNames file_> :TNSServerName= <_TNSServerName_>

jdbc:mercury:oracle:TNSNamesFile=C:Oraclenetworkadmintnsnames.ora;TNSServerName=ORA11G_PROD

**Without TNS, it would look like:**

jdbc:mercury:oracle:// <_host server_> : <_port_> ; sid= <_SID_>

jdbc:mercury:oracle://ORACLE11G:1521;sid=ORA11G

Marked as spam
Posted by (Questions: 3, Answers: 448)
Answered on July 25, 2017 9:25 pm