To connect to an Oracle database server that resides on a network, you must specify the proper connect descriptor in the Server box on the Connection tab of the Database Profile Setup dialog box for your Oracle interface. The connect descriptor specifies the connection parameters that Oracle uses to access the database.
For help determining the proper connect descriptor for your environment, see your Oracle documentation or system administrator.
The syntax of the connect descriptor depends on the Oracle client software you are using.
If you are using Net version 8.x or later, the syntax is:
OracleServiceName
If you are using SQL*Net version 2.x, the syntax is:
@ TNS: OracleServiceName
Parameter |
Description |
---|---|
@ |
The at ( @ ) sign is required |
TNS |
The identifier for the Oracle Transparent Network Substrate (TNS) technology |
: |
The colon ( : ) is required |
OracleServiceName |
The service name assigned to your server in the Oracle configuration file for your platform |
Net version 8.x example To use Net version 8.x or later client software to connect
to the service named ORA8, type the following connect descriptor
in the Server box on the Connection tab of the Database Profile
Setup dialog box for Oracle 8.x and later: ORA8
.