Data Modeling Early Adopter 2 for reverse engineering Desember 5, 2008
Posted by setijoagus in Oracle Tools, oracle.Tags: Data Modeling Early Adopter, oracle 11g, Reverse Engineering
add a comment
Data Modeling Early Adopter 2 for reverse engineering
info from :
1. email oracle
Download Oracle SQL Developer Data Modeling Early Adopter 2
Following a successful first early adopter release of Oracle SQL Developer Data Modeling, we have rolled in a lot of changes and updates into an Early Adopter 2 release. Visit the Oracle SQL Developer Data Modeling homepage on OTN to download the product and test the updated release. Download.
2. my friend : Rudi K.
i try install Oracle SQL Developer Data Modeling Early Adopter 2 for reverse engineering
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
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
Swingbench Oracle Single Node September 26, 2008
Posted by setijoagus in Oracle Tools, oracle.Tags: oracle, performance, swingbench
add a comment
1. Swingbench adalah free load generator yang ditulis dengan Java oleh Dominic Giles yang bekerja di Oracle UK.
SH – Sales History application based on the Oracle-supplied SH schema. A read-only benchmark.
CC and SOE – OLTP-type applications
Stress Test – basic INSERT/UPDATE/DELETE/SELECT test.
2. File dapat di download di http://www.dominicgiles.com/downloads.html
3. Dapatkan swingbench yang terakhir, misalnya : swingbench230376.zip
4. Extract Swingbench
[oracle@test ~]$ pwd
/home/oracle
[oracle@test ~]$ unzip /u01/backup/swingbench230376.zip
5. download juga java, saya menggunakan jre-6u5-linux-i586-rpm.bin
[oracle@test ~]$ su – root
[root@test ~]# chmod a+x jre-6u5-linux-i586-rpm.bin
[root@test ~]# ./jre-6u5-linux-i586-rpm.bin
[root@test ~]# rpm -ivh jre-6u5-linux-i586.rpm
6. edit environtment Swingbench
[oracle@test ~]$ pwd
/home/oracle
[oracle@test ~]$ cd swingbench
[oracle@test swingbench]$ pwd
/home/oracle/swingbench
[oracle@test swingbench]$ vi swingbench.env
7. Environtment Swingbench, yang perlu diedit adalah (sesuaikan dengan mesin anda)
export JAVAHOME=/usr/java/jre1.6.0_05
export SWINGHOME=/home/oracle/swingbench
8. Menyiapkan test, pada kasus ini saya ingin melakukan test order entry, dimana pembuatan tablespace, schema dan user telah disiapkan oleh swingbench.
[oracle@test swingbench]$ cd bin/
[oracle@test bin]$ pwd
/home/oracle/swingbench/bin
[oracle@test bin]$ ./oewizard
9. Hasil setelah klik button finisih.
10. Untuk mengaktifkan grafik CPU dan disk IO, jalankan perintah seperti di bawah ini :
[oracle@test bin]$ pwd
/home/oracle/swingbench/bin
[oracle@test bin]$ ./cpumonitor
11. Langkah berikutnya adalah menjalankan swingbench untuk mengukur performance dari database kita, dengan mensimulasikan jika ada sejumlah user yang menjalankan order entry secara bersamaan.
[oracle@test bin]$ pwd
/home/oracle/swingbench/bin
[oracle@test bin]$ ./swingbench sample/oeconfig.xml
12. Yang perlu diperhatikan pada saat menjalankan swingbench adalah user, password dan connect string sudah benar.
13. Saatnya, kita mulai pertualangan untuk melakukan performance tuning, semisal “Number of Users” diisi 5.
klik tombol start
14. Semakin Besar TPM, TPS dan semakin kecil RTM (Response Time milliseconds) berarti semakin baik.
Script to delete archivelogs periodically September 20, 2008
Posted by setijoagus in Linux, Oracle Tools, oracle.Tags: archive log, Crontab, Linux, oracle
2 comments
Archive oracle harus dipantau, kalau nggak bisa habis kapasitas tempat penyimpanannya, sehingga menyebabkan
transaksi tidak dapat berjalan lagi sampai dengan ada tersedia tempat / space untuk melanjutkan transaksi.
Tetapi sebaliknya seorang dba kadang – kadang lupa (he…he..he…).
(Sebaiknya script ini digabungkan dengan RMAN atau sistem backup lainnya exp, expdp)
a. membuat script dengan ide dari –> http://www.dbazine.com/oracle/or-articles/liu2
b. penyesuaian script clean_arch.ksh, logika script ini, setelah mengisikan letak folder
archive di ARCH (mungkin folder anda berbeda), apakah sudah mencapai 85 % penggunakan
partisi dimana folder archive disimpan, jika ya cari file archive dan hapus archive
yang berusia 8 hari.
[oracle@iscdd script]$ vi clean_arch.ksh
ARCH=/home/oracle/archive
dfhasil=”`df -h $ARCH | awk ‘{ print $5 }’ | sed ’s/%//g’`”
hasil=”`echo $dfhasil | awk ‘{ print $2 }’`”
echo $hasil
if test $hasil -ge 85
then
echo “`date` `hostname` Archive Folder : $hasil %”
find /home/oracle/archive/ -type f -mtime +8 -exec ls {} ;
fi
c. membuat schedulle untuk membersihkan archive, tiap hari senin
Minute 0-59
Hour 0-23
Day of month 1-31
Month 1 – 12
Day of Week 0 – 6, with 0 = Sunday
[oracle@iscdd script]$ crontab -e
0 6 * * 1 /home/oracle/script/clean_arch.ksh
Send Status Database Oracle With E-mail September 20, 2008
Posted by setijoagus in Linux, Oracle Tools, oracle.Tags: Crontab, Email, Instance, Linux, oracle, sendEmail
4 comments
Liburan panjang kantor – kantor tutup, tetapi karena berbagai pertimbangan menyebabkan Administrator Server / DBA tidak boleh mematikan server. Selain piket dengan datang secara fisik ke kantor, alternatif lainnya adalah mengirim status server lewat e-mail dan tentunya dapat dikembangkan dengan menggunakan sms phone.
Saya menggunakan SendEmail, karena pertimbangan
a. lightweight
b. command line SMTP email client
c. free program
d. simple to use
e. feature rich
1. download file
http://caspian.dotconf.net/menu/Software/SendEmail/sendEmail-v1.55.tar.gz
2. Extract the package
[root@iscdd ]# tar xvzf sendEmail-v1.55.tar.gz -C /usr/local/src/
3. Copy the sendEmail script to /usr/local/bin
[root@iscdd ]# cp /usr/local/src/sendEmail-v1.55/sendEmail /usr/local/bin
4. Make sure executable
[root@iscdd ]# chmod +x /usr/local/bin/sendEmail
5. Run it
[root@iscdd ]# su – oracle
[oracle@iscdd ~]$ df -h /u01 | sendEmail -f rukr@ubslinux.com -u sisa harddisk -s 172.20.140.31:25 -t seag@ubslinux.com
Keterangan :
hasil perintah linux df -h /u01 akan dikirim
-f (from) rukr@ubslinux.com
-u (subject) sisa harddisk
-s (mail server ) 172.20.140.31:25
-t (alamat email yang dituju) seag@ubslinux.com
6. status database oracle
a. membuat script berdasarkan dari –> http://www.dbazine.com/oracle/or-articles/liu2
b. penyesuaian script ckinstance.ksh, inti dari script ini memeriksa apakah proses oracle
di linux masih jalan, yaitu dengan mengunakan perintah
[oracle@iscdd script]$ ps -ef | grep pmon
oracle 30611 1 0 May14 ? 00:02:24 ora_pmon_iscdd
oracle 26369 26206 0 08:24 pts/2 00:00:00 grep pmon
[oracle@iscdd script]$ vi ckinstance.ksh
###################################################################
## ckinstance.ksh ##
###################################################################
ORATAB=/etc/oratab
db=`egrep -i “:Y|:N” $ORATAB | cut -d”:” -f1 | grep -v “#” | grep -v “*”`
pslist=”`ps -ef | grep pmon`”
for i in $db ; do
echo “$pslist” | grep “ora_pmon_$i” > /dev/null > hasil
if (( $hasil )); then
hasil=” `date` `hostname` : Oracle Instance – $i: Down”
else
hasil=” `date` `hostname` : Oracle Instance – $i: Up”
fi
echo “$hasil” | /usr/local/bin/sendEmail -f root@ubslinux.com -u server ppc -s 172.20.140.31:25 -t seag@ubslinux.com
done
rm hasil -f
[oracle@iscdd script]$ chmod 777 ckinstance.ksh
[oracle@iscdd script]$ ./ckinstance.ksh
c. hasil email
Thu Sep 18 09:38:32 WIT 2008 iscdd : Oracle Instance – iscdd: Up
d. membuat schedulle dengan crontab, dimana script akan dijalankan setiap 20 menit
Minute 0-59
Hour 0-23
Day of month 1-31
Month 1 – 12
Day of Week 0 – 6, with 0 = Sunday
[oracle@iscdd script]$ crontab -e
0,20,40 * * * * /home/oracle/script/ckinstance.ksh
