Oracle – Linux – Network

Install oracle client 11g Linux (ORACLE ENTERPRISE LINUX 5)
1. file – file yang dibutuhkan :
a. oracle-instantclient-basic
b. oracle-instantclient-devel
c. oracle-instantclient-sqlplus

2. download – download
a. http://download.oracle.com/otn/linux/instantclient/11106/oracle-instantclient-basic-11.1.0.1-1.i386.rpm
b. http://download.oracle.com/otn/linux/instantclient/11106/oracle-instantclient-devel-11.1.0.1-1.i386.rpm
c. http://download.oracle.com/otn/linux/instantclient/11106/oracle-instantclient-sqlplus-11.1.0.1-1.i386.rpm

3. buat user dan folder
[root@iscdd ~]# groupadd oinstall
[root@iscdd ~]# groupadd dba
[root@iscdd ~]# groupadd oper
[root@iscdd ~]# groupadd asmadmin
[root@iscdd ~]# useradd -u 500 -g oinstall -G dba,oper,asmadmin oracle
[root@iscdd ~]# mkdir -p /u01/app/oracle/product/11.1.0/crs
[root@iscdd ~]# mkdir -p /u01/app/oracle/product/11.1.0/db_1
[root@iscdd ~]# chown -R oracle:oinstall /u01

4. extract oracle-instantclient-basic, oracle-instantclient-devel, oracle-instantclient-sqlplus
[root@iscdd ~]# rpm -ivh oracle-instantclient-basic-11.1.0.1-1.i386.rpm
[root@iscdd ~]# rpm -ivh oracle-instantclient-devel-11.1.0.1-1.i386.rpm
[root@iscdd ~]# rpm -ivh oracle-instantclient-sqlplus-11.1.0.1-1.i386.rpm

5. setup oracle bash_profile dan tnsnames.ora
a. tambahkan pada .bash_profile
[oracle@iscdd ~]$ vi .bash_profile
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
LD_LIBRARY_PATH=/usr/lib/oracle/11.1.0.1/client/lib; export LD_LIBRARY_PATH
TNS_ADMIN=/u01/app/oracle/product/11.1.0/db_1/network/admin; export TNS_ADMIN

b. membuat tnsnames.ora
[oracle@iscdd ~]$ mkdir -p /u01/app/oracle/product/11.1.0/db_1/network/admin
[oracle@iscdd ~]$ vi /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
ppc =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.141.25)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ppc)
(INSTANCE_NAME = ppc)
)
)
c. logout
[oracle@iscdd ~]$ exit

6. test koneksi
[oracle@iscdd ~]$ sqlplus scott@ppc/tiger
SQL> select * from dept;
DEPTNO DNAME          LOC
———- ————– ————-
10 ACCOUNTING     NEW YORK
20 RESEARCH       DALLAS
30 SALES          CHICAGO
40 OPERATIONS     BOSTON
SQL> exit