Oracle: what is the "instantclient" connection string format?

oracle connection-string instantclient
Mark Harrison picture Mark Harrison · Apr 19, 2009 · Viewed 14.3k times · Source

and how does it differ from the regular connection string?

Answer

dpbradley picture dpbradley · Apr 19, 2009

Connecting with the instant client is no different than with the full stack client - all connect string formats are the same. If you installed the instant client in a non-standard location on the filesystem or are having problems connecting to the database listener, be sure that your TNS_ADMIN environment points to the directory that contains your tnsnames.ora and sqlnet.ora files,

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