Re: Oracle on Solaris 2.2

From: Roderick Manalac <rmanalac_at_oracle.COM>
Date: Sat, 14 Aug 1993 07:35:08 GMT
Message-ID: <1993Aug14.073508.13216_at_oracle.us.oracle.com>


csoderbe_at_garond.cray.com (Curt Soderberg) writes:
|> On page 23-4 of the Oracle Tools for UNIX Administrator's Reference Guide
|> it says that SQL*Net V1 aliases are not supported on Oracle7 (bummer). I'm
|> not sure how to work around this since I'm just installing 7.0.13 and this
|> is news to me.

Actually with Oracle7 on Unix, the SQL*Net V1 and V2 aliases can now be placed in /etc/tnsnames.ora or /var/opt/oracle/tnsnames.ora depending on your platform.

Format of the file is as follows:

aliasname = connect_string

Example (of V1 and V2 entry):



sales = t:prodhp:sales
sales_v2 = (description=
              (address=(protocol=tcp)(host=prodhp)(port=1521))
              (connect_data=(sid=sales))
           )

Hope this helps.

Roderick Manalac
Oracle Corporation Received on Sat Aug 14 1993 - 09:35:08 CEST

Original text of this message