Kbase P57540: How to configure SQL*NET or Net8 to use Local Oracle Dataserver via SQL*NET
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/10/2008 |
|
Status: Verified
GOAL:
How to configure SQL*NET or Net8 to use Local Oracle Dataserver via SQL*NET
GOAL:
How to connect to the local Oracle Database via SQL*NET
FACT(s) (Environment):
Oracle DataServer
All Supported Operating Systems
FIX:
SQL*Net and Net8 are ORACLE network interfaces that allow you to access an ORACLE RDBMS instance running on a remote machine. If you choose this type of connection you do not need any Progress-supplied software on the machine where ORACLE database 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 the Oracle Listener is running on the database server machine.
3. Configure a service for the SQL*Net or Net8 on the client machine.
4. Use tnsping (Oracle utility) to test the connection using the service created in the step 3. (eg: tnsping <service-name> )
5. Make sure that you have a Schema holder ready (see Solution P4968 for more information on how to create a schema holder if you don't have one ready)
6. Supply one of the following connection parameters in your Progress startup command or parameter file.
On Windows Clients use:
prowin32 -db schema-holder-name -RO -db oracle-dbname -dt "oracle" -U userid@service-name -P password
On UNIX Clients use:
pro -db schema-holder-name -RO -db oracle-dbname -dt "oracle" -U userid@service-name -P password
The SQL*Net and Net 8 connection parameters requires you specify the identifier configured in the tnsnames.ora file for the entry that points to the ORACLE instance you are accessing. SQL*Net and Net 8 also required 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.