Install Oracle 7 client on server1/Solaris 26

  1. Choose ONLY the following three for client installation:
    SQL*Net 2.3.4
    SQL*Plus
    TCP/IP

  2. ORACLE_BASE: /export/home/oracle/product

  3. After the successful installation, edit $HOME/network/admin/tnsnames.ora to set aliases

    sqlora =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= 10.10.3.107)(Port= 1521)
    (CONNET_DATA = (SID = ORCL))
    )


    NOTE:
    Host: indicate IP of DB Server
    Port= 1521: use the default port=1521
    SID=ORACLE_SID

  4. Add a line to /etc/services

    sqlora 1521:tcp

  5. No listener control is needed for client installation

  6. $ sqlplus system/manager@sqlora
    You should be able to connect to DB server

  7. Add following lines to .profile to set environment.

    ORACLE_HOME=
    ORACLE_SID=ORCL #Server DB name
    TWO_TASK=sqlora #Server machine name
    PATH=/usr/bin;$ORACLE_HOME:/bin