Install TORA


Install TORA
Kalau di windows DB Manager ada TOAD, di linux ada sqldeveloper, tetapi banyak yang bilang kalau sqldeveloper lambat. Salah satu pilihan lainya 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
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@db~]# groupadd oinstall
[root@db ~]# groupadd dba
[root@db ~]# groupadd oper
[root@db ~]# groupadd asmadmin
[root@db ~]# useradd -u 500 -g oinstall -G dba,oper,asmadmin oracle
[root@db ~]# mkdir -p /u01/app/oracle/product/10.2.0/db_1
[root@db ~]# chown -R oracle:oinstall /u01

4. extract oracle-instantclient-basic, oracle-instantclient-devel, oracle-instantclient-sqlplus

[root@db ~]# rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm
[root@db ~]# rpm -ivh oracle-instantclient-devel-10.2.0.4-1.i386.rpm
[root@db ~]# 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@db ~]$ 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@db ~]$ mkdir -p /u01/app/oracle/product/10.2.0/db_1/network/admin
[oracle@db ~]$ vi /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
ppc =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.##)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl)
)
)

c. logout

[oracle@db ~]$ exit

6. test koneksi

[oracle@db ~]$ 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@db ~]$ su – root
[root@db ~]# 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@db ~]# rpm -ivh qt-3.3.3-9.4.i386.rpm
[root@db ~]# rpm -ivh qscintilla-1.7.1-3.fc8.i386.rpm

9. install tora

[root@db ~]# 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@db ~]$ 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@db ~]# rpm -ivh –nodeps /home/oracle/tora-1.3.23-1.el5.i386.rpm
Preparing…    ########################################### [100%]
1:tora      ########################################### [100%]
[root@db ~]# exit

11. test

[root@db ~]$ tora

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