Install oracle client 11g Linux (ORACLE ENTERPRISE LINUX 5)

16 Sep

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

em02

JUAL ebook 10g Real Application Clusters on vmware DETAIL

2 Responses to “Install oracle client 11g Linux (ORACLE ENTERPRISE LINUX 5)”

  1. farid March 8, 2011 at 9:42 am #

    sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

    cara mengatasinya gmn, saya pakai centos 5.5 oracle 11gr1

    • setijoagus March 8, 2011 at 3:01 pm #

      coba diinstall terlebih dulu libaio

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: