Re: SQLNET with Rdb 7.0

Here are the instructions we received from support, it was pretty easy to set up and we have been using it without any problems so far.

Steps to setting up SQL*Net for Rdb7:

1. Start the OCI dispatcher. A dispatcher called "OCI_DISP" is provided by the installation.
2. Enable a database for use with SQL*Net Rdb. Or, use the sample database created by the installation and skip to step 3. While attached to an Rdb database do:
   1. _at_sys$library:sql_functions.sql or sql_functions70.sql (if you are Rdb multiversion)
   2. _at_sys$library:rdb_natconn_prepare.sql or rdb_natconn_prepare71.sql if you are SQL/Services multiversion)
3. OCI service set up. A service called "OCI_SAMPLE" is provided by the installation.
   1. In the OCI_SAMPLE service definition add the attach string for your Rdb database. Alternatively if you have decided to use the sample database provided by the installation, you can use the following attach string: attach 'filename sys$common:[syshlp.examples.sqlsrv]oci_sample' or attach 'filename sys$common:[syshlp.examples.sqlsrv71]oci_sample'
   2. Start the OCI_SAMPLE service.
4. Modify and deploy tnsnames.ora, listener.ora and sqlnet.ora.
   1. A file called "listener.ora_sample" is provided by the installation. Look in sys$common:[sqlsrv.sqlnet.network.admin] (or "sqlsrv71" if multiversion sql/services).
      (1) Copy listener.ora_sample to listener.ora.
      (2) OCI_DISP acts as the sqlnet listener. It is defined in
      listener.ora as "OCI_LISTENER." Edit listener.ora and modify the host name to the node on which you have SQL*Net for Rdb7 installed.
      (3) If you do NOT have Oracle server installed on the same system as
      SQL*Net for Rdb, leave listener.ora in the same file location. Else, if you do have Oracle server installed on the system, copy listener.ora to oracle_home [.network.admin] subdirectory. If there is already a listener.ora file then combine the information from both files into one listener.ora file.
   2. A file called "tnsnames.ora_sample" is provided by the installation. Look in sys$common:[sqlsrv.sqlnet.network.admin] (or "sqlsrv71" if multiversion sql/services).
      (1) Copy tnsnames.ora_sample to tnsnames.ora.
      (2) Modify tnsnames.ora
      
      • Modify the host name to the node on which you have SQL*Net for Rdb7 installed.

        OCI_SAMPLE.world =  <-- alias name
          (DESCRIPTION =
            (ADDRESS_LIST =
                (ADDRESS =
                  (COMMUNITY = TCP_COM.world)
                  (PROTOCOL = TCP)
                  (Host = yournode)   <-- your node
                  (Port = 1527)       <-- port defined in listener.ora
                )
            )
            (CONNECT_DATA =
              (SERVICE = OCI_SAMPLE)  <-- servicename in SQL/Services
                 (GLOBAL_NAME = OCI_SAMPLE.world)  <-- name of db (optional)




        (3) Copy tnsnames.ora onto the system from which you will


            be accessing Rdb.  For example, if you are using SQL*Plus
            From Windows NT, copy tnsnames.ora to C:\orant\network\admin.

    c) A file called "sqlnet.ora_sample" is provided by the installation. Look in sys$common:[sqlsrv.sqlnet.network.admin] (or "sqlsrv71" if multiversion sql/services).

       Copy sqlnet.ora_sample to sqlnet.ora and copy this file onto the system from which you will be accessing Rdb such as C:\oranet\network\admin if this file does not already exist in that directory.

5. Attach to the database using sqlplus. The format is:

    $ sqlplus username/password_at_oci_sample

Where the username/password is a valid user on the system where SQL*Net for Rdb7 is installed. OCI_SAMPLE is the alias name defined in tnsnames.ora.

me wrote in message <6qhgbo$ma3$1_at_camel19.mindspring.com>...

>Does anyone have experience accessing Rdb 7.0 from Oracle SQL plus or OEM?
>After installing SQLNET on the VAX what else needs to be done?
>What would be the SID of the Rdb database "XYZ" on VAX node "ABC"?
>
>Any help is appriciated.
>
>Merashid_at_gapac.com
>Mrashidi_at_mindpsring.com
>
>
>