Progress
DataServer
for ORACLE Guide
Connecting Through SQL*Net or Net 8
SQL*Net and Net 8 are ORACLE network interfaces that allow you to access an ORACLE RDBMS instance running on a remote machine. You do not need any Progress-supplied software on the machine where ORACLE is running. However, you need SQL*Net or Net 8 installed on the client machine and an ORACLE Listener on the machine where the ORACLE instance is running.
To access an ORACLE distributed database, you connect through SQL*Net or Net 8, just as you would connect to a single instance. The DataServer detects all the links that make up the distributed database. DataServer access to a distributed database is transparent and requires no additional commands or startup parameters.
Follow these steps to connect to an ORACLE instance through SQL*Net or Net 8:
- Make sure that the remote ORACLE instance is running.
- Make sure that SQL*Net or Net 8 is running on the client machine.
- Supply the following connection parameters in your Progress startup command or parameter file. The SQL*Net and Net 8 connection parameters require that you specify the identifier you configured in the
tnsnames.ora
file for the entry that points to the ORACLE instance you are accessing. SQL*Net and Net 8 also require that the client process have read access to thetnsnames.ora
file in the$TNS_ADMIN
directory, which is indicated by the TNS_ADMIN variable in theoracle.ini
file. See the ORACLE documentation for information on configuringtnsnames.ora
.NT or Windows Client — SQL*Net or Net 8
UNIX Client — SQL*Net or Net 8
For example, the following command starts Progress on a UNIX machine, connects a local schema holder oholder in read-only mode and connects the remote ORACLE instance orademo with the ORACLE_SID X and uses the srvr1 service. The username is scott and the password is tiger. The -dt and -ld parameters are optional:
If you are connected through SQL*Net or Net 8, the Progress USERID function returns
scott@oserviceA,
instead of justscott
.If you use a sqlnet connection string, it must be part of the username. You can use either of these forms:
You should not use the sqlnet connection string as part of the password, as in the following example:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |