Saturday, April 18, 2009

Instal Toad Windows di linux

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


TOAD 8 run PCLINUXOS 2007

Nopember 15, 2008 in Linux, Oracle Tools, oracle | Tags: Linux, oracle, toad | No comments

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

toad_01

add ot PATH C:ORA;C:ORABIN. PATH value is under HKEY_LOCAL_MACHINE > System > CurrentControlSet > Control > SessionManager > Environment

toad_02

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

toad_03



No comments: