Install oracle client 10g (ORACLE ENTERPRISE LINUX 5)

16 Sep

Install oracle client 10g (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/10204/oracle-instantclient-basic-10.2.0.4-1.i386.rpm
b. http://download.oracle.com/otn/linux/instantclient/10204/oracle-instantclient-devel-10.2.0.4-1.i386.rpm
c. http://download.oracle.com/otn/linux/instantclient/10204/oracle-instantclient-devel-10.2.0.4-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/10.2.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-10.2.0.4-1.i386.rpm
[root@iscdd ~]# rpm -ivh oracle-instantclient-devel-10.2.0.4-1.i386.rpm
[root@iscdd ~]# rpm -ivh oracle-instantclient-sqlplus-10.2.0.4-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/10.2.0/db_1; export ORACLE_HOME
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib; export LD_LIBRARY_PATH
TNS_ADMIN=/u01/app/oracle/product/10.2.0/db_1/network/admin; export TNS_ADMIN

b. membuat tnsnames.ora
[oracle@iscdd ~]$ mkdir -p /u01/app/oracle/product/10.2.0/db_1/network/admin
[oracle@iscdd ~]$ vi /u01/app/oracle/product/10.2.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

4 Responses to “Install oracle client 10g (ORACLE ENTERPRISE LINUX 5)”

  1. lukman December 19, 2008 at 8:45 am #

    mas kalau untuk install oracle client di linux enterpise 64bit cara2 nya sama kah seperi diatas ..mohon pencerahannya mas.

    thanks

    • setijoagus December 20, 2008 at 2:54 am #

      untuk install oracle client di linux enterpise 64bit, memang belum ada, tetapi tolong dicoba dulu cara installnya oracle client di linux enterpise 32bit, kalau sudah sukses tolong khabari ya ?!?!……..

  2. lukman December 23, 2008 at 10:51 am #

    hallo pak setijoagus aku ada reference untuk oracle installation link dapat dari teman saya tapi lum implementasi mudah-mudahan bisa pak

    http://www.putera.com/tanya/lofiversion/index.php/t46812-Cx_oracle—&%2362%3B-Success&%2333%3B-Yeaahoooooooo.html

  3. setijoagus December 26, 2008 at 12:50 am #

    kl dilihat dari hasil link itu, sepintas kayak install oracle “SERVER” di linux enterpise 64bit ………….dan kayaknya kepanjangan he…he…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: