How to make SQL*Net connect string from tnsnames.ora entry?

oracle connection-string cognos tnsnames
Tahir Akram picture Tahir Akram · Jun 4, 2014 · Viewed 7.9k times · Source

I am creating a data source on a reporting tool of IBM (Cognos). That asks SQL*Net connect string.

Following is my tnsnames.ora entry. I am able to connect with SQLPLUS and TNSPING from the client.

OVDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.1.180)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = OVDB) ) )

What would be my SQL *Net connect string? Is it OVDB?

Cognos wants to connect with Oracle database through it (OCI).

enter image description here

Answer

Andrew picture Andrew · Jun 4, 2014

Yes, it's the name (or alias, or whatever) of the entry in your TNSNames file.

IBM support documentation 'Where do I find the SQL*Net connect string to connect to an Oracle Database?'

Related questions

Java JDBC - How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I …

Read More
Default Schema in Oracle Connection URL

I'd like to set default database schema in Oracle Connection URL jdbc:oracle:thin:@<server>:<port1521>:<sid> My sample SQL statement: select monkey_name from animals.monkey I need to query database without schema …

Read More
Oracle connection string without tnsnames.ora file

I am using the .NET framework with the System.Data.OracleClient namespace. I have the oracle 11 client installed on my computer. I do not want to use the tnsnames.ora file to store connection information. Could someone please tell me …

Read More