Kbase 14111: How to setup SQL*NET for Oracle Dataserver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to setup SQL*NET for Oracle Dataserver
DRAFT COPY - Currently under review and edit.
This entry describes how to setup the Oracle Dataserver version 7
with SQL*NET version 2. There are slight variation in the connect
statement and setup with SQL*NET version 1.1. Oracle version 7.0
and 7.1 is bundle with SQL*NET version 2.
WHY YOU NEED TO KNOW THIS:
===========================
You want to use Oracle's networking i.e SQL*NET instead of Progress
Networking for your Client/Server network when using Progress Oracle
Dataserver.
WHAT IT IS:
===========
SQL*NET ------------
----- | Unix - |---
------------ \ | Progress | |
| Unix or MS-|------- | Server | Oracle
| Windows - | | | Database
| Progress | ------------
----| Client v7 |
| | & Oracle |
| | Dataserver|
| ------------
Progress
Schema Holder
Configuration: Progress V7 for windows or Unix to Oracle on Unix
Minimun Software Requirement:
Oracle Dataserver - (Runtime client; contact PSC Presales for other
configurations).
SQL*NET version 2 - (Oracle Corporation's product).
Steps to perform on Unix Server:
**Assumption: Oracle and SQL*NET has been successfully installed **
1. Find a service-name and a port from your services file.
# ypcat services | grep portname /* yellow page is installed */
# cat services | grep portname /* without yellow page */
where # is your unix prompt
portname is the same as a service-name e.g. demosv
/* */ comment statements
2. Set environment variable ORACLE_HOME to the directory where Oracle
is installed.
# ORACLE_HOME=/usr2/oracle7; export ORACLE_HOME
3. Echo $ORACLE_HOME, please note what the environment variable is
set to.
# echo $ORACLE_HOME
4 Set environment variable TNS_ADMIN to the directory where your
listener.ora and tnsnames.ora file resides.
# TNS_ADMIN=$ORACLE_HOME
etwork/admin; export TNS_ADMIN
5. Set environment variable ORACLE_SID.
# ORACLE_SID=oracle; export ORACLE_SID
6. Echo $ORACLE_SID, please note what the environment variable is
set to.
# echo $ORACLE_SID
7. Check the listener.ora file and make appropriate changes.
HOST is set to server machine name
PORT is set to the port number in Services file
SID_NAME is set to the value of $ORACLE_SID
ORACLE_HOME is set to the value of $ORACLE_HOME
LOG_DIRECTORY_LISTENER to your working directory
TRACE_DIRECTORY_LISTENER to your working directory.
Below is a sample of listener.ora file:
IRENE=(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=hp8g50)
(PORT=2082)))
SID_LIST_LISTENER=
(SID DESC=
(SID_NAME=doggy)
(ORACLE_HOME=/usr2/oracle7))
STARTUP_WAIT_TIME=0
CONNECT_TIMEOUT_LISTENER=10
TRACE_DIRECTORY_LISTENENER=/usr1/irene
TRACE_FILE_LISTENER=tstlstnr.trace
LOG_DIRECTORY_LISTENER=/usr1//irene
LOG_FILE_LISTENER=tstlstnr.log
8. Check the tnsnames.ora file and make appropriate changes.
HOST is set to server machine name
PORT is set to the port number in Services file
SID is set to the value of $ORACLE_SID
Below is a sample of tnsnames.ora file:
sports = (DESCRIPTION=
(ADDRESS =
(PROTOCOL=TCP)
(HOST=hp8g50)
(PORT=2082))
(CONNECT_DATA =
(SID=doggy)))
9. Start the Oracle Sqlnet server.
# lsnrctl start listener
For this example: # lsnrctl start sports
10. Check the Oracle instance is running.
# ps -ef | grep ora
On the client side:
**Assume that SQL*NET version 2 successfully installed **
1. Copy your tnsnames.ora file to the client.
2. Start a Progress Server for your schema holder if you want
multi-user access.
# Proserve schemaholder -S service-name -H client-machine -N tcp
where service-name is a different from the one use for
sql*net above.
3. Connect to schemaholder and Oracle database.
mpro schemaholder -S service-name -H client-machine -N tcp
-db oracledbname -U userid@service -P password
where service is "sports" from the tnsnames.ora file above
userid is the owner of Oracle tables
password is the password of the owner.
4. Expected results: You should be able to connect via SQL*NET to the
Oracle database and access,add,update,delete the data in the
Oracle database.
ONLINE PROCEDURES OR UTILITIES:
===============================
If you are having problem connecting to the Oracle database; make
sure that SQL*NET is properly installed by logging into SQL*PLUS
and executing some queries.
REFERENCES TO WRITTEN DOCUMENTATION
====================================
DataServer for Oracle Guide
Oracle documentation
Progress Software Technical Support Note # 14111