Oracle – Linux – Network

Install TORA (“Toolkit for Oracle”)

Kalau di windows ada TOAD di linux pakai apa ya selain sqldeveloper (maaf : lambat sekali……….)
Salah satu pilihannya adalah Tora (“Toolkit for Oracle”), Tora adalah program GUI-based database
development program, yang dapat digunakan untuk SQL worksheets dan database browser.
Berikut cara – cara instalasinya :

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

7. install tora (error: Failed dependencies)
[oracle@iscdd ~]$ su – root
[root@iscdd ~]# rpm -ivh tora-1.3.23-1.el5.i386.rpm
error: Failed dependencies:
libclntsh.so.10.1 is needed by tora-1.3.23-1.el5.i386
libqscintilla.so.7 is needed by tora-1.3.23-1.el5.i386
libqt-mt.so.3 is needed by tora-1.3.23-1.el5.i386
qscintilla >= 1.7 is needed by tora-1.3.23-1.el5.i386

8. download untuk kebutuhan tora
ftp://ftp.pbone.net/mirror/people-redhat.com/than/rhel4/qt-3.3.3-9.4.i386.rpm
ftp://rpmfind.net/linux/fedora/releases/8/Everything/i386/os/Packages/qscintilla-1.7.1-3.fc8.i386.rpm

[root@iscdd ~]# rpm -ivh qt-3.3.3-9.4.i386.rpm
[root@iscdd ~]# rpm -ivh qscintilla-1.7.1-3.fc8.i386.rpm

9. install tora
[root@iscdd ~]# rpm -ivh tora-1.3.23-1.el5.i386.rpm
error: Failed dependencies:
libclntsh.so.10.1 is needed by tora-1.3.23-1.el5.i386

10. cek libclntsh.so, karena sudah melakukan langkah – langkah diatas, harusnya ada
[oracle@iscdd ~]$ locate libclntsh.so
/usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so
/usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1

[root@iscdd ~]# rpm -ivh –nodeps /home/oracle/tora-1.3.23-1.el5.i386.rpm
Preparing…    ########################################### [100%]
1:tora      ########################################### [100%]
[root@iscdd ~]# exit

11. test
[root@iscdd ~]$ tora