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:

  1. Make sure that the remote ORACLE instance is running.
  2. Make sure that SQL*Net or Net 8 is running on the client machine.
  3. 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 the tnsnames.ora file in the $TNS_ADMIN directory, which is indicated by the TNS_ADMIN variable in the oracle.ini file. See the ORACLE documentation for information on configuring tnsnames.ora.
NT or Windows Client — SQL*Net or Net 8

prowin32 schema-holder-name -db oracle-dbname
  -U userid@service-name -P password 

UNIX Client — SQL*Net or Net 8

pro schema-holder-name -db oracle-dbname
  -U userid@service-name -P password 

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:

pro oholder -RO -db oradb -dt ORACLE -ld orademo
  -U scott@oserviceA -P tiger 

If you are connected through SQL*Net or Net 8, the Progress USERID function returns scott@oserviceA, instead of just scott.

If you use a sqlnet connection string, it must be part of the username. You can use either of these forms:

CONNECT <logical name> -U <user@sqlnetstring> -P <password>. 
CONNECT <logical name> -U <user/password@sqlnetstring>  

You should not use the sqlnet connection string as part of the password, as in the following example:

CONNECT <logical name> -U <user> -P <password@sqlnetstring>  


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095