Specifying the Oracle server connect descriptor
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.
Specifying a connect
descriptor
The syntax of the connect descriptor depends on the Oracle client
software you are using.
If you are using Net9 or later, the syntax is:
|
1 |
OracleServiceName |
If you are using SQL*Net version 2.x, the syntax is:
|
1 |
@ TNS: OracleServiceName |
|
Parameter |
Description |
|---|---|
|
@ |
The at ( @ ) sign is required |
|
TNS |
The identifier for the Oracle Transparent Network |
|
: |
The colon ( : ) is required |
|
OracleServiceName |
The service name assigned to your server in the |
Net9 example
To use Net9 client software to connect to the service named ORA9,
type the following connect descriptor in the Server box on the
Connection tab of the Database Profile Setup dialog box for Oracle9i and
later: ORA9.