TOAD 8 run PCLINUXOS 2007 November 15, 2008
Posted by setijoagus in Linux, Oracle Tools, oracle.Tags: Linux, oracle, toad
add a comment
source :
http://nik.chankov.net/2007/05/04/how-to-run-toad-86-on-ubuntu/
Step 1. Installing wine
[root@it99 ~]# apt-get install wine
[test@it99 /]# exit
[test@it99 /]$ wine –version
wine-0.9.58
Step 2.) Configuring wine
[test@it99 /]$ winecfg
Step 3.) Downloading Instant client for Oracle (instantclient-basic-win32-10.2.0.3-20061115.zip)
Step 4.) Creating directories for instant client
[test@it99 ~]$ cd ~
[test@it99 ~]$ cd .wine
[test@it99 .wine]$ cd drive_c
[test@it99 drive_c]$ mkdir -p ORA/BIN
[test@it99 drive_c]$ mkdir -p ORA/NETWORK/ADMIN
Step 5.) Decompress contents from instant client archive
Decompress files to $HOME/.wine/drive_c/ORA/BIN
[test@it99 ~]$ unzip instantclient-basic-win32-10.2.0.3-20061115.zip
Archive: instantclient-basic-win32-10.2.0.3-20061115.zip
creating: instantclient_10_2/
inflating: instantclient_10_2/classes12.jar
inflating: instantclient_10_2/oci.dll
inflating: instantclient_10_2/ocijdbc10.dll
inflating: instantclient_10_2/ociw32.dll
inflating: instantclient_10_2/ojdbc14.jar
inflating: instantclient_10_2/orannzsbb10.dll
inflating: instantclient_10_2/oraocci10.dll
inflating: instantclient_10_2/oraociei10.dll
[test@it99 ~]$ cp ~/instantclient_10_2/* ~/.wine/drive_c/ORA/BIN/
Step 6.) Creating Oracle Related Variables (ORACLE_HOME)
[test@it99 ~]$ wine regedit
create key Oracle as example. in that key add label ORACLE_HOME with value C:ORA
add ot PATH C:ORA;C:ORABIN. PATH value is under HKEY_LOCAL_MACHINE > System > CurrentControlSet > Control > SessionManager > Environment
Step 7.) Create/Get copy of tnsnames.ora
[test@it99 ~]$ vi ~/.wine/drive_c/ORA/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)
)
)
Step 8.) Copy folder Toad from windows to ~/.wine/drive_c
[test@it99 TOAD]$ ls
BACKUP/ ReportParams.ini*
Cfx4032.dll* Reports/
CHC.REV* Revbase.dll*
CONNECTIONS.INI* RNetCHK.dll*
CVS.dll* RNetPin.dll*
DatabaseProbe.txt* Rnetpin.ini*
DBA.sdf* ROBOEX32.DLL*
desktops.xml* RuleSets/
docs/ RuleUniverse.XML*
FmtOptions.exe* Sample Project/
FmtOptions.INI* SCC.dll*
FmtPlus0.dll* Schema Objects.sdf*
FmtPlus.dll* ScriptMgr/
FmtPlus.exe* SfxBar.dll*
FmtPlus_V1.4.1.106_IDE.exe* SPServer.dll*
FMTUSER.INI* SQLMNTR.chm*
FullToad.lic* SQLMonitor.exe*
Help/ sqlnet.log*
INETWH32.dll* SQLS.DAT*
INSTALL.LOG* temps/
install.txt* TOAD.chm*
kbasemap.dat* TOAD.exe*
KXauth.dll* TOAD_GUI.INI*
KXpertPLSQLSetup80.exe* TOAD.INI*
mfc42.dll* toad.lic*
Oracle 8i Data Dictionary.sdf* toadload.wav*
PERSSQLS.DAT* TOADMAIL.INI*
Project_bak.tpr* TOADMONITORS.INI*
ProjectConfig.txt* TOADReports.exe*
Project.tpr* TOADServerSide.exe*
PVCS.dll* TOAD_SESSBROWFILTERS.INI*
QC0450.chm* Tuning_Lab/
QSAuth11.key* UnidbHook.dll*
QSR.chm* unidbsrv.dll*
qsr.exe* Uninstall.exe*
readonly.lic* unixjobs/
reflector.class* VSS.dll*
relnotes_top.gif*
[test@it99 TOAD]$
Step 9.) Run Toad
[test@it99 TOAD]$ wine TOAD.exe
reverse engineering November 12, 2008
Posted by setijoagus in Oracle Tools, oracle.Tags: oracle, Reverse Engineering
add a comment
Reverse Engineering dibutuhkan oleh developer, untuk mengetahui ER Diagram.
Software – software yang telah beredar dan sering digunakan adalah :
- Sybase’s PowerDesigner
- Toad
- oracle Designer
software yang open source dan multi O/S salah satunya adalah DBDesigner yang dapat didownload di
http://www.fabforce.net/downloadfile.php
DBDesigner support :
Hasil DBDesigner :
Oracle Quick Check November 12, 2008
Posted by setijoagus in Oracle Tools, oracle.Tags: informasi, oracle
add a comment
Kadang kala kita ingin mengetahui informasi server dengan cepat, ada tool
freeware yang bisa dicoba yaitu Oracle Quick Check yang dapat di download di
From: http://www.ensyncsolutions.com/library/OraQuickChk.zip
1. Tools ini jalan di windows
2. extract OraQuickChk.zip
3. jalankan file OraQuickChk
4. hilangkan tanda centang di Analysis options
- please have eNSNYC call me abaout DBA support
- please have eNSNYC email me an analysis
5. isikan connection info username, password, connection (sesuai server anda)
6. informasi yang didapat :
- warning, seperti tablespace yang punya sisa sedikit
- Disk I/O : Read/Write
- Tablespace : size/used/free/%
- Redo Log
- Cache Ratios
1 machine, more than 1 instance database November 11, 2008
Posted by setijoagus in Oracle Install, oracle.Tags: oracle, Instance
add a comment
a. install software database oracle 11g
b. create database with dbca (GUI)
[oracle@isc ~]$ ORACLE_SID=isc; export ORACLE_SID
[oracle@isc ~]$ dbca
c. Again, create database with dbca (GUI)
[oracle@isc ~]$ ORACLE_SID=isc2; export ORACLE_SID
[oracle@isc ~]$ dbca
d. cek listener.ora
[oracle@isc ~]$ cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
# Public
172.20.141.78 isc.localdomain isc
[oracle@isc ~]$ cat $ORACLE_HOME/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = isc.localdomain)(PORT = 1521))
)
)
e. cek tnsnames.ora
[oracle@isc ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
ISC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = isc.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = isc2)
)
)
ISC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = isc.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = isc)
)
)
f. test connection
[oracle@isc ~]$ vi exit.sql
select * from dept;
exit;
[oracle@isc ~]$ sqlplus scott/tiger@isc @exit
SQL*Plus: Release 11.1.0.6.0 – Production on Fri Nov 14 04:48:47 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@isc ~]$ sqlplus scott/tiger@isc2 @exit
SQL*Plus: Release 11.1.0.6.0 – Production on Fri Nov 14 04:48:47 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
g. startup database
[oracle@isc ~]$ ORACLE_SID=isc; export ORACLE_SID
[oracle@isc ~]$ sqlplus / as sysdba
SQL> startup;
ORACLE instance started.
Total System Global Area 1389391872 bytes
Fixed Size 1299848 bytes
Variable Size 687868536 bytes
Database Buffers 687865856 bytes
Redo Buffers 12357632 bytes
Database mounted.
Database opened.
SQL> exit
[oracle@isc ~]$ ORACLE_SID=isc2; export ORACLE_SID
[oracle@isc ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Fri Nov 14 04:40:38 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1033670656 bytes
Fixed Size 1304448 bytes
Variable Size 285214848 bytes
Database Buffers 742391808 bytes
Redo Buffers 4759552 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@isc ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 14-NOV-2008 04:40:26
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.1.0.6.0 – Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/isc/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isc.localdomain)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date 14-NOV-2008 04:40:28
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/isc/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isc.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
h. shutdown database
[oracle@isc ~]$ ORACLE_SID=isc; export ORACLE_SID
[oracle@isc ~]$ sqlplus / as sysdba
SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[oracle@isc ~]$ ORACLE_SID=isc2; export ORACLE_SID
[oracle@isc ~]$ sqlplus / as sysdba
SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[oracle@isc ~]$ lsnrctl stop
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 14-NOV-2008 04:55:18
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
oracle 11g – Starting the Oracle Enterprise Manager Console November 7, 2008
Posted by setijoagus in Oracle Tools, oracle.Tags: EM, Enterprise Manager, oracle
5 comments
1. startup db
[oracle@isc ~]$ ORACLE_SID=isc; export ORACLE_SID
[oracle@isc ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Sun Nov 9 22:52:26 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1389391872 bytes
Fixed Size 1299848 bytes
Variable Size 838863480 bytes
Database Buffers 536870912 bytes
Redo Buffers 12357632 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2. listener start
[oracle@isc ~]$ ORACLE_SID=isc; export ORACLE_SID
[oracle@isc ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 09-NOV-2008 22:52:00
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.1.0.6.0 – Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/isc/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isc.localdomain)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date 09-NOV-2008 22:52:03
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/isc/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isc.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
3. Oracle Enterprise Manager start
[oracle@isc ~]$ ORACLE_SID=isc; export ORACLE_SID
[oracle@isc ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://isc.localdomain:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ………… started.
——————————————————————
Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/isc.localdomain_isc/sysman/log
4. Test
browser : https://isc.localdomain:1158/em/
isc.localdomain : 172.20.141.78
Install sqldeveloper – Windows XP November 3, 2008
Posted by setijoagus in Oracle Tools, oracle.Tags: oracle, sqldeveloper, windows
add a comment
1. download
From: http://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-5440.zip
Note : This zip file includes the JDK 1.5.0_06
2. Extract sqldeveloper.zip into any folder, using folder names
3. Within that folder, open the sqldeveloper folder
4. Double-click sqldeveloper.exe
5. test
Install sqldeveloper – Oracle Enterprise Linux November 3, 2008
Posted by setijoagus in Oracle Tools, oracle.Tags: Linux, oracle, sqldeveloper
add a comment
1. Linux BOX
[root@test oracle]# uname -a
Linux test 2.6.18-53.el5 #1 SMP Sat Nov 10 18:24:52 EST 2007 i686 i686 i386 GNU/Linux
2. download
http://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-1.5.54.40-1.noarch.rpm
http://java.sun.com/j2se/1.5.0/download.jsp
Note :
click ‘Download JDK 5.0 Update <xx>
3. Install jdk
[root@test oracle]# chmod u+x jdk-1_5_0_16-linux-i586-rpm.bin
[root@test oracle]# ./jdk-1_5_0_16-linux-i586-rpm.bin
Do you agree to the above license terms? [yes or no]
yes
Unpacking…
Checksumming…
0
0
Extracting…
UnZipSFX 5.50 of 17 February 2002, by Info-ZIP (Zip-Bugs@lists.wku.edu).
inflating: jdk-1_5_0_16-linux-i586.rpm
Preparing… ########################################### [100%]
1:jdk ########################################### [100%]
Done.
4. Install sqldeveloper
[root@test oracle]# rpm -ivh sqldeveloper-1.5.54.40-1.noarch.rpm
Preparing… ########################################### [100%]
1:sqldeveloper ########################################### [100%]
[root@test oracle]# exit
5. test sqldeveloper
[oracle@test ~]$ sqldeveloper
6. test connection
