Install Oracle 7 client on server1/Solaris 26
- Choose ONLY the following three for client installation:
SQL*Net 2.3.4
SQL*Plus
TCP/IP
- ORACLE_BASE: /export/home/oracle/product
- 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
- Add a line to /etc/services
sqlora 1521:tcp
- No listener control is needed for client installation
- $ sqlplus system/manager@sqlora
You should be able to connect to DB server
- 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