1.  C:\xampplite\apache\conf\extra

1. download pclzip.lib.php di http://www.phpconcept.net/pclzip/pclzip-downloads

2. untuk bakcup 1 create folder backup dan create file archive.zip

<?php

    // Include the PclZip library

    require_once(’pclzip.lib.php’);

 

    // Set the arhive filename

    $archive = new PclZip(’backup/archive.zip’);

 

    // Set the dir to archive

    $v_dir = dirname(getcwd()); // or dirname(__FILE__);

    $v_remove = $v_dir;

 

    // Create the archive

    $v_list = $archive->create($v_dir, PCLZIP_OPT_REMOVE_PATH, $v_remove);

    if ($v_list == 0) {

        die("Error : ".$archive->errorInfo(true));

    }

?>

sumber http://campstamba.com/2010/12/create-your-own-php-backup-solution-complete-tutorial-with-source-files/

<?php

echo "backup progress";

backup_tables(’localhost’,’root’,’’,’db_ci’);

//$host=’localhost’; $user=’root’; $pass=’’ ;$name=’db_ci’; $tables = ’*’;

/* backup the db OR just a table */

function backup_tables($host,$user,$pass,$name,$tables = ’*’)

{

    $link = mysql_connect($host,$user,$pass);

    mysql_select_db($name,$link);

    //get all of the tables

    if($tables == ’*’)

    {

        $tables = array();

        $result = mysql_query(’SHOW TABLES’);

        while($row = mysql_fetch_row($result))

        {

            $tables[] = $row[0];

        }

    }

    else

    {

        $tables = is_array($tables) ? $tables : explode(’,’,$tables);

    }

    //cycle through

    foreach($tables as $table)

    {

        $result = mysql_query(’SELECT * FROM ’.$table);

        $num_fields = mysql_num_fields($result);

        $return.= ’DROP TABLE ’.$table.’;’;

        $row2 = mysql_fetch_row(mysql_query(’SHOW CREATE TABLE ’.$table));

        $return.= "\n\n".$row2[1].";\n\n";

        for ($i = 0; $i < $num_fields; $i++)

        {

            while($row = mysql_fetch_row($result))

            {

                $return.= ’INSERT INTO ’.$table.’ VALUES(’;

                for($j=0; $j<$num_fields; $j++)

                {

                    $row[$j] = addslashes($row[$j]);

                    $row[$j] = ereg_replace("\n","\\n",$row[$j]);

                    if (isset($row[$j])) { $return.= ’"’.$row[$j].’"’ ; } else { $return.= ’""’; }

                    if ($j<($num_fields-1)) { $return.= ’,’; }

                }

                $return.= ");\n";

            }

        }

        $return.="\n\n\n";

    }

    $today = date("dmY");

    //save file

    //$handle = fopen(’db-backup-’.time().’-’.(md5(implode(’,’,$tables))).’.sql’,’w+’);

    $handle = fopen(’db-backup-’.$today.’.backup’,’w+’);

    fwrite($handle,$return);

    fclose($handle);

    echo "<META HTTP-EQUIV=’Refresh’

      CONTENT=’1; URL=db-backup-$today.backup’>";

}

?>

Setelah Cari2 Tempat Traning, googling, ke Forum Tanya2 member Kaskus, Ane Dapet Lokasi Tempat Traning Oracle Resmi, Daerah Jakarta yang lumayan Mahal atau Daerah Bandung yang lumayan Miring,



Ingin Traning Oracle, Jangan dulu sebelum lihat Perbandingan Harga Di Website di Bawah Ini:



Jakarta dan Sekitar

[spoiler=traning Oracle Di Jakarta]

1. Activindo System Informatika, PT.

Site Code: IO10

Wisma Nugra Santana

2nd Floor Suite 203

Jl Jendral Sudirman Kav 7-8

Jakarta 10220

Phone: 51000082



2. Asaba

Site Code: IO64

Ebenezer Building 3rd Floor

Jln Setiabudi Selatan No1

Jakarta 12920

Phone: 57904534

[spoiler=my dream]

[IMG]http://www.romeosoft.ro/images/ocp.jpg[/IMG]

[/spoiler]

3. Executrain Nusantarajaya, PT.

Site Code: IO4

Setiabudi 2 Building Suite 606

HR Rasuna Said Kav 62

Jakarta 12920

Phone: 5210793



4. Inixindo Persada Rekayasa, PT

Site Code: IOF

Permata Senayan Blok E2-E5

Jalan Tentara Pelajar

Simprug

Jakarta Selatan 12210

Phone: 57940868



5. Intellisys Tripratama, PT

Site Code: IO3

Komplek Roxy Mas Blok C3 No.38

Jl. K.H.Hasyim Ashari

Jakarta 10150

Phone: 6306028



6. Iverson Technology, PT.

Site Code: IO6

9th Floor Chase Plaza

Jl Jend Sudirman Kav 21

Jakarta 12920

Phone: 5208210



7. Jaringan Nusantara

Site Code: IO15

Wisma Kosgoro

8th Floor, Jalan Mh. Thamrin K

Jakarta

Phone: 39832414



8. Mitra Integrasi Informatika, PT.

Site Code: IO14

Wisma Metropolitan 1 Lt.9

Jl. Jend. Sudirman Kav. 29-31,

Jakarta 12920

Phone: 212511360



9. Multimatics Indonesia, PT

Site Code: IO29

Jl. Prof. Dr. Satrio No. 296

Karet - Kuningan

Jakarta Selatan 12940

Phone: 5260388



10. Nettrain Informatika, PT

Site Code: IO50

The East Building 16th Floor No 1

Jl. Lingkar Mega Kuningan

Kav E3.2 No. 1

Jakarta 12950

Phone: 57938538



11. Nettrain Infotama, PT

Site Code: IOL

Rasuna Office Park CO-01

Komplek Apartemen Taman Rasuna

Jl. H.R. Rasuna Said

Kuningan

Jakarta 12920

Phone: 83786390



12. Sarana Solusindo Informatik, PT

Site Code: IOB

Jl Sisingamangaraja No 14a

Kebayoran Baru

Jakarta Selatan 12110

Phone: 7258762



13. Sentra Karya Informatika, PT

Site Code: ION

Menara Thamrin - Atd Plaza

Jl.M.H.Thamrin Kav.3

Suite 504

Jakarta 10250

Phone: 39830016



Yang sudah gue dapet minta sama salesnya via ym, tapi semua lumayan mahal gan:

1. Oracle Indonesia

Sentral Senayan I, Lt. 9. Jl. Asia Afrika No. 8, Jakarta 10270

Contanct person:

Anna Cahyawati - 021 5723222 ext 1077, [email]anna.cahyawati@oracle.com[/email]

Yudi Adicawarman - 0215723222 ext 1022, [email]yudi.adicawarman@oracle.com[/email]

2. Mitra Integrasi Informatika (MII)

Wisma Metropolitan I lt. 9

Komp. Metropolitan

Jl. Jend. Sudirman Kav 29 - 31 Jakarta 12920

Tel. 021 2511360, Fax. 021 5705988

Contact Person:

Agung Sujatmiko ext. 2460 [email]agung.sujatmiko@metrodata.co.id[/email]

Reni Heryani ext. 2435 [email]reni.heryani@metrodata.co.id[/email]

Susilowati ext. 2437 [email]Susilowati@metrodata.co.id[/email]

3. Sisindokom

Graha Sisindokom

Jl. Panataran No. 2, Pegangsaan

Jakarta Pusat 10320

Tel. 021 31900711, Fax. 021 3140358

Contact Email: [email]inquiry@sisindokom.com[/email] , [email]ccare@sisindokom.com[/email]

4. Brainmatics

Menara Bidakara, Lantai 2, Suite 0205

Jl. Jend. Gatot Subroto Kav. 71-73, Jakarta 12870

Telp. +62-21-83793383; Fax. +62-21-83793384

5. Asaba

Jl. Setiabudi Selatan No.1

Jakarta 12920

Phone. :(+62-21) 5799 4700 Fax.: (+62-21) 5790 4551

E-Mail : information: [email]info@asaba.co.id[/email]

6. Inixindo

Permata Senayan Blok E2-E5

Jl. Tentara Pelajar No.5, Jakarta 12210

Phone : (021) 579 40868 Fax : (021) 579 40869





BELOGIX TRAINING SOLUTION IOK

GEDUNG LABORA 2ND FLOOR

LENGKONG KECIL 73

BANDUNG, 40261

62 22 422 1130



2 PT EXECUTRAIN NUSANTARAJAYA IO4

SETIABUDI 2 BUILDING SUITE 102

HR RASUNA SAID KAV 62

JAKARTA, 12920

62 21 521 0793



3 PT METRODATA EDUKASI INFORMATI IO9

WISMA METROPOLITAN I

6TH FLOOR

JI. JENDRAL SUDIRMAN KAV.29-31

JAKARTA, 12920

62215754897



4 PT SARANA SOLUSINDO INFORMATIK IOB

J1. SISINGAMANGARAJA NO. 14A

KEBAYORAN BARU

JAKARTA SELATIN

JAKARTA, 12110

62 21 720 1419



5 PT DATACRAFT INDONESIA IOM

MENARA IMPERIUM 10TH FLOOR

JL.HR.RASUNA SAID KAV.1

JAKARTA, 12980

62 21 835 6422



6 JAKARTA INSTITUTE OF TECH IOR

GAPURAMAS BUILDING 1ST FLOOR

JL.LETJEND S.

PARMAN KAV 91

JAKARTA, 11420

62 21 5695 6009



7 PT INIXINDO PERSADA REKAYASA IOF

8/F WISMA BISNIS

JALAN LETJEN S PARMAN KAV 12

JAKARTA BARAT, 11480

62 21 530 7253



8 PT SISINDOSAT LINTASBUANA IOH

JL. PANATARAN NO.2

PEGANGSAAN

JAKARTA PUSAT, 10320

62 21 3190 0717

[/spoiler]

Babak 2 Daerah Bandung dan sekitarnya

[spoiler=Traning Oracle di Bandung]

1. [url]http://belogix.com/training/schedule/[/url]

2. [url]http://www.informit.tc/calendar.htm#oracle_10g[/url]

3. [url]http://www.telkompdc.com/css/files/telkompdc_schedule_maret-july2010.pdf[/url]

[/spoiler]



Sebagai Perbandingan Daerah Jakarta Kebanyakan standart Dollar, Mahal, kecuali di Branmatic sekitar 3,9jt.

Tapi Di Bandung Harganya Bersaing. 5jt-an.

Bagi Agan yang Punya Info Lain selahkan Share Disini.

Dan Bagi Agan yang ada kelebihan Rijki Cendol, ANe Menerima dengan lapang dada. :iloveindonesia



share bermutu dari agan kaskus

[QUOTE=kodok_buncit;208460459]karena request agan2 saya share disini,



Alhamdulillah ane udah OCP (karena ini gaji kedongkrak juga),

kerja sebagai DBA pula



dulu ane tahun 2008 akhir ngambil training dan ujian OCA



pertama2 saya jelasin dulu aturan maennya



ada 3 tingkatan sertifikasi di oracle



yaitu : OCA, OCP dan OCM



untuk meraih OCA, agan2 harus menempuh 2 ujian





yaitu :



1z0-007 : introduction to SQL ($125)

1z0-042 : admin I ($125) (oracle 10G)

1z0-052 : admin I ($125) (oracle 11G)



untuk OCA, [B]tidak diwajibkan ikut training[/B] asal lulus dua ujian tersebut, anda berhak menyandang gelar OCA



setelah itu



untuk OCP,

syaratnya anda diharuskan training satu modul resmi (waktu itu saya ambil training 1z0-007 dan 1z0-042 di belogix)



dan lulus ujian



1z0-043 : admin II ($125) (oracle 10G)

1z0-053 : admin II ($125) (oracle 11G)



baru berhak OCP



jadi ringkasnya



OCA=lulus 1z0-007+1z0-042

OCP= lulus OCA+ikut training (salah satu aja) + 1z0-043



ane dulu sempet gagal gan pas 1z0-042 :(

rasanya kayak kecopetan duit 1.5 jeti (mana nyisihin dari gaji sendiri...hiks)

tapi ane ndak menyerah 2 bulan kemudian gua ujian alhamdulillah OCA lulus

(teriak2 kegirangan pas lulus di ruang test)



eh ndak disangka ane dapet beasiswa OCP gan (dikasih ama boss ane gan), ane dapet training di oracle indonesia (modul admin II) dan ujian OCP disana (alhamdulillah langsung lulus, masih terharu ampe sekarang, soalnya ane orang ndak punya gan dulu)



Saran ane ke kalian, sebelum lu training lu mending belajar sendiri dulu,

siapkan pertanyaan sebanyak2nya, dan jangan tergesa2 untuk ujian



ane training di belogix dan di oracle indonesia, rasanya sih sama2 aja, tergantung kalian tingkat pembelajarannya sampai mana



kalo pas di belogix saya ditraining sama Pak Bambang Sutedjo (baek gan orangnya dan ini bukunya [url]http://www.klik-oracle.web.id/?p=27[/url]) ngajarnya enak kok



kalo pas di oracle indonesia ane di train ama OCM namanya Pak Hanson Hutabarat, sama2 asik juga orangnya



cuma kalo di belogix, environment yang digunakan adalah windows

kalo di oracle indonesia pake Oracle Enterprise Linux



saran saya, belajar oracle itu harus di environment linux, lu bisa pake centos untuk simulasi di rumah, cari2 soal di internet ga masalah, tapi jangan diapalin, tapi di pahami ya gan, dengan doa dan usaha,

insya Allah agan2 lulus



gimana gan? cukup? atau perlu lebih spesifik lagi?[/QUOTE]

Bagi agan2 yang ingin belajar Oracle developer, berikut saya kasi link dari dosen its:

[CODE]http://lecturer.eepis-its.edu/~tessy/tutorial/[/CODE]



bagi agan yg punya yg lain share disini gan.



isiNya:

[DIR]    formdev/    09-Dec-2008 22:23      -

[DIR]    introtoSQL/    09-Dec-2008 22:23     -

[DIR]    java/    09-Dec-2008 22:23     -

[ ]    patch.zip    09-Dec-2008 22:23     6.0K

[DIR]    plsql/    09-Dec-2008 22:23     -

[DIR]    repdev/    09-Dec-2008 22:23     -

[ ]    skin.zip    09-Dec-2008 22:23     2.3M

[DIR]    sqlold/    09-Dec-2008 22:23     -

[DIR]    vb_oracle/



[CODE]http://www.4*shared.com/dir/341193/fc80a288/sharing.html[/CODE]



[CODE]http://www.4*shared.com/dir/9463070/c0a0e1cf/net_g_11i.html[/CODE



Developer Interaktif

[HTML]http://search.4*shared.com/q/1/Oracle_Forms_Developer_The_Complete_Video_Course[/HTML]



[CODE]Fundamental I



http://rapid*share.com/files/46014180/VTC.Course_-_Oracle.9i.Administration.Fundamentals.part1.rar

http://rapid*share.com/files/46014101/VTC.Course_-_Oracle.9i.Administration.Fundamentals.part3.rar

http://rapid*share.com/files/46014050/VTC.Course_-_Oracle.9i.Administration.Fundamentals.part4.rar

http://rapid*share.com/files/46014024/VTC.Course_-_Oracle.9i.Administration.Fundamentals.part2.rar



Fundamental II



http://rapid*share.com/files/46664910/___OSMEH_VRACA_NADU.part1.rar

http://rapid*share.com/files/46664904/___OSMEH_VRACA_NADU.part3.rar

http://rapid*share.com/files/46664900/___OSMEH_VRACA_NADU.part5.rar

http://rapid*share.com/files/46664898/___OSMEH_VRACA_NADU.part4.rar

http://rapid*share.com/files/46664896/___OSMEH_VRACA_NADU.part2.rar



Password default : shytex.com[/CODE]



admin1 workshop

[CODE]NETg Oracle Database 10g Administration Workshop (1 cd) oem

[IMG]http://www.software-schulungs-medien.de/img/c/articles/240/next-step-Oracle-Database-10g-Administration-Workshop-II-Curriculum.jpg[/IMG]

http://uploading.com/files/SXDF5HGU/knowledge_ORACLE_10G.part01.rar.html

http://uploading.com/files/VUVRRWUO/knowledge_ORACLE_10G.part02.rar.html

http://uploading.com/files/8U7CNY8S/knowledge_ORACLE_10G.part03.rar.html

http://uploading.com/files/RJ52VS9Q/knowledge_ORACLE_10G.part04.rar.html

http://uploading.com/files/08SLG5Q1/knowledge_ORACLE_10G.part05.rar.html

http://uploading.com/files/IUKHFLD0/knowledge_ORACLE_10G.part06.rar.html

http://uploading.com/files/U02TZNVS/knowledge_ORACLE_10G.part07.rar.html

http://uploading.com/files/6NG0FBNL/knowledge_ORACLE_10G.part08.rar.html

http://uploading.com/files/YQS2RHHX/knowledge_ORACLE_10G.part09.rar.html

http://uploading.com/files/GE34EYX7/knowledge_ORACLE_10G.part10.rar.html

http://uploading.com/files/OJAR1Y57/knowledge_ORACLE_10G.part11.rar.html



Mirror



http://hotfile.com/dl/7518074/ee7f426/knowledge_ORACLE_10G.part01.rar.html

http://hotfile.com/dl/7518086/de125f6/knowledge_ORACLE_10G.part02.rar.html

http://hotfile.com/dl/7518096/52b67cb/knowledge_ORACLE_10G.part03.rar.html

http://hotfile.com/dl/7518104/7ae41b4/knowledge_ORACLE_10G.part04.rar.html

http://hotfile.com/dl/7518107/24ae3db/knowledge_ORACLE_10G.part05.rar.html

http://hotfile.com/dl/7518119/64299cf/knowledge_ORACLE_10G.part06.rar.html

http://hotfile.com/dl/7518135/e199890/knowledge_ORACLE_10G.part07.rar.html

http://hotfile.com/dl/7518146/2129602/knowledge_ORACLE_10G.part08.rar.html

http://hotfile.com/dl/7518153/79a1f2b/knowledge_ORACLE_10G.part09.rar.html

http://hotfile.com/dl/7518160/beabc3a/knowledge_ORACLE_10G.part10.rar.html

http://hotfile.com/dl/7518164/928d4ba/knowledge_ORACLE_10G.part11.rar.html





Mirror



http://rapid*share.com/files/248165796/knowledge_ORACLE_10G.part01.rar

http://rapid*share.com/files/248165837/knowledge_ORACLE_10G.part02.rar

http://rapid*share.com/files/248165709/knowledge_ORACLE_10G.part03.rar

http://rapid*share.com/files/248165745/knowledge_ORACLE_10G.part04.rar

http://rapid*share.com/files/248165707/knowledge_ORACLE_10G.part05.rar

http://rapid*share.com/files/248165739/knowledge_ORACLE_10G.part06.rar

http://rapid*share.com/files/248165802/knowledge_ORACLE_10G.part07.rar

http://rapid*share.com/files/248165831/knowledge_ORACLE_10G.part08.rar

http://rapid*share.com/files/248165818/knowledge_ORACLE_10G.part09.rar

http://rapid*share.com/files/248165765/knowledge_ORACLE_10G.part10.rar

http://rapid*share.com/files/248165632/knowledge_ORACLE_10G.part11.rar

[/CODE]



update gan



[CODE]http://search.4*shared.com/q/1/OCA.Series-LiBiSO

[/CODE]

[CODE]

[IMG]http://i36.tinypic.com/2wnabyq.jpg[/IMG]

926 halaman | September 12, 2005 | PDF | 17 Mb



Bersiaplah untuk lulus OCA dan OCP Database Oracle 10g ujian sertifikasi dengan bantuan dari panduan ini Tekan Oracle. Dengan liputan yang lengkap dari semua material di Ujian # 1Z0-042 Oracle Database 10g: Administrasi I dan Ujian # 1Z0-043 Oracle Database 10g: Administrasi II, buku ini merangkumi segala sesuatu yang perlu anda ketahui untuk lulus ujian kedua. Di dalam, anda akan menemui troubleshooting ujian membantu, ratusan soal latihan, dan latihan di dunia nyata. Panduan ini berfungsi baik sebagai alat belajar dan rujukan di tempat kerja.

Dapatkan butiran lengkap tentang semua tujuan ujian, termasuk cara:



* Pasang Oracle Database 10g dan membuat database

* Gunakan SQL, SQL * Plus, iSQL * Plus, dan PL / SQL

akaun pengguna database * Membuat dan menguruskan

* Konfigurasi Rangkaian Oracle

* Menguruskan bersama pelayan

* Monitor, lagu, dan atasi masalah database

* Menangani database cadangan, memulihkan, dan pemulihan

* Gunakan Oracle Recovery Manager dan Oracle Flashback

* Tatarajah dan menguruskan keselamatan

* Gunakan Pengurusan Simpanan automatik dan Sumber Daya Manager

* Automatik tugas pentadbiran



Link (17 Mb)

http://rapid*share.com/files/141450020/0201.BY.Midochesser.rar



[/CODE]

update exam

[CODE]http://theindexof.net/exam%20oracle/[/CODE]

syntax for dumping oracle database 9.x

exp scott/tiger file=emp_"%date:~7,2%%date:~4,2%%date:~10,4%".dmp log=emp.log tables=emp rows=yes indexes=no

Sudah cukup lama rasanya saya tidak memberikan kontribusi dan berbagi informasi dengan komunitas tercinta ini. Hari ini saya akan mencoba berbagi sedikit pengalaman kepada teman-teman yang mungkin saja ada yang belum tahu. 



Secara umum, penggunaan .htaccess pada server hosting yang kita pergunakan bukanlah suatu masalah, paling "mentok" kita menghubungi server provider. Tapi bagaimana dengan localhost.....? sering error ya ..... ? nah bagi yang masih sering error, saya akan mencoba memberikan trik agar tidak error lagi. (Tapi sebagai catatan, secara global trik ini hanya teruji pada XAMPP.)

Setelah menemukan kode tersebut, anda harus menghapus # dari baris tersebut untuk mengaktifkan mod_rewrite, sehingga seperti terlihat di bawah ini:

Langkah terakhir adalah jangan lupa untuk menyimpan alias "save"perubahan ini dan tentu juga harus me-"restart" server XAMPP.



Dan setelah itu anda bisa menikmati hasilnya, salah satunya adalah dengan menggunakan "SEO setting" secara seutuhnya pada situs yang ada di localhost atau digunakan untuk intranet. Semoga sukses selalu.

sumber:

http://www.id-joomla.com/tip-dan-trik/496-mengaktifkan-htaccess-di-apache-xampp-pada-windows

clean url

buat file .htaccess

<IfModule mod_rewrite.c>



RewriteEngine On

RewriteRule (.*) index.php

RewriteBase /cleanurl/



</IfModule>

buat file php

<?php

    //$urlx=$_SERVER[’SERVER_NAME’].$_SERVER["REQUEST_URI"];

    $urlx=$_SERVER["REQUEST_URI"];

    $a= $_SERVER[’PHP_SELF’];

    echo $a;

    echo     $b= $_SERVER[’SERVER_ADDR’];

    echo "<br/>";

   

    $url = explode("/",$urlx);

    $p   = $url[2];

    $no  = $url[3];

    $id  = $url[4];

    //

     $url = "http://localhost/cleanurl/";



    //default

    if($p==’’){ $p=’home’; }

   

    echo "<a href=’".$url."’>home</a> | ";

    echo "<a href=’".$url."about’>About</a><br /><br />";

   

    echo "<a style=\"cursor:pointer\" onclick=\"location.href=’".$url."about’\" >link kedua</a><br>";

   

    echo "Artile<br />";

    echo "- <a href=’".$url."news/10/berita-pertama’>berita Pertama</a><br />";

    echo "- <a href=’".$url."news/11/berita-kedua’>berita Kedua</a><br /><br /><br />";

 

    if($p == ’home’)

    {

        echo "Halaman Awal";

    }

    elseif($p == ’about’)

    {

        echo "Halaman About";

    }

    elseif($p == ’news’)

    {

        //skenarionya pada bagian ini mengecek kedatabase apakah newsid 10 ini ada datanya didatbase

        if($no == "10")

        {

            echo"disini halaman berita pertama";

        }

        elseif($no == "11")

        {

            echo"disini halaman berita kedua";

        }

        else

        {

            echo"tidak ada berita itu";

        }

    }

    echo "<br>". $id;

?>

Manual Oracle Uninstall

A number of people have contacted me regarding problems uninstalling Oracle products. The two methods listed below should only be used as a last resort and will remove all Oracle software allowing a reinstall. If you make any mistakes they can be quite destructive so be careful.

• Windows


• UNIX

Windows

In the past I�ve had many problems uninstalling all Oracle products from Windows systems. Here�s my last resort method:

• Uninstall all Oracle components using the Oracle Universal Installer (OUI).


• Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entires for all Oracle products.


• Delete any references to Oracle services left behind in the following part of the registry:
  
  HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*
  
  It should be pretty obvious which ones relate to Oracle.


• Reboot your machine.


• Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.


• Delete the "C:\Program Files\Oracle" directory.


• Empty the contents of your "c:\temp" directory.


• Empty your recycle bin.

At this point your machine will be as clean of Oracle components as it can be without a complete OS reinstall.



Remember, manually editing your registry can be very destructive and force an OS reinstall so only do it as a last resort.

UNIX

Uninstalling all products from UNIX is a lot more consistent. If you do need to resort to a manual uninstall you should do something like:

• Uninstall all Oracle components using the Oracle Universal Installer (OUI).


• Stop any outstanding processes using the appropriate utilities:
  
  

  
  

  
  
  # oemctl stop oms user/password
  
  # agentctl stop
  
  # lsnrctl stop

  
  

  Alternatively you can kill them using the kill -9 pid command as the root user.


• Delete the files and directories below the $ORACLE_HOME:
  
  

  
  

  
  
  # cd $ORACLE_HOME
  
  # rm -Rf *

  
  



• With the exception of the product directory, delete directories below the $ORACLE_BASE.

  
  

  
  
  # cd $ORACLE_BASE
  
  # rm -Rf admin doc jre o*

  
  



• Delete the /etc/oratab file. If using 9iAS delete the /etc/emtab file also.

  
  

  
  
  # rm /etc/oratab /etc/emtab

  
  

Hope this helps. Regards Tim...

http://www.oracle-base.com/articles/misc/ManualOracleUninstall.php

The simplest way to remove Oracle is to run the Oracle installer:

Start > Programs > Oracle Installation Products > Universal Installer

1. On the first screen click on "Deinstall Products..."


2. Expand the tree view (just so that the second level is visible) and make sure you select everything that is selectable.


3. Click on "Remove..."


4. On the confirmation screen click "Yes"


5. When it has finished click "Close" and then "Exit" to quit the installer

Whilst the Oracle installer removes many components there are a number of things that it leaves behind. In order to completely remove all traces of Oracle the following additional steps will need to be taken:

1. Stop any Oracle services that have been left running. (Start > Settings > Control Panel > Services.)
   
   Services which I have found left behind are ’OracleOraHome90TNSListener’ and ’OracleServiceORACLE’. However there may be others depending on your installation. Look for any services with names starting with ’Oracle’.


2. Run regedit (Start > Run > Enter "regedit", click "Ok"), find and delete the following keys:
   
   
   
   HKEY_LOCAL_MACHINE

   \SOFTWARE

      \ORACLE



HKEY_LOCAL_MACHINE

   \SYSTEM

      \CurrentControlSet

         \Services

            \EventLog

               \Application

                  \Oracle.oracle
   
   
   
   Note: I have had it reported that some people also have registry entries saved under HKEY_CURRENT_USER\SOFTWARE\ORACLE, this registry entry may be created by some Oracle utilities. If it exists then delete it.


3. Delete the Oracle home directory:
   
       "C:\Oracle"
   
   This will also remove your database files (unless you located them elsewhere, in which case you will need to delete them separately).


4. Delete the Oracle program Files directory:
   
       "C:\Program Files\Oracle"


5. Delete the Oracle programs profile directory:
   
       "C:\Documents and Settings\All Users\Start Menu\Programs\Oracle - OraHome90"
   
   if you did not first run the Oracle installer to remove Oracle then there may be other Oracle profile group directories to remove.


6. Some of the Oracle services may be left behind by the uninstall. Open ‘services’ on the control panel, make a note of which Oracle services remain and see the notes ‘How to remove a service’ to remove them.


7. If you didn’t first run the Oracle Installer to remove Oracle then you may have some references to Oracle left in the path. To remove these: Start > Settings > Control Panel > System > Advanced > Environment Variables, look at both the use and system variable ’PATH’ and edit them to remove any references to Oracle.http://www.cryer.co.uk/brian/oracle/howto_uninstall_oracle9i.htm

listener oracle sering mati?

coba cek listener lognya..

and jalankan servicenya

cek juga listener oranya

System parameter file is C:\oracle\ora92\network\admin\listener.ora

Log messages written to C:\oracle\ora92\network\log\listener.log

jalankan service

C:\Documents and Settings\ME>lsnrctl start

PHP Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries

e.g:

C:\> SET NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

If you are using Microsoft Terminal Services then you can take a look on Note:342226.1 from Metalink

DOWNLOAD OCI.DLL

http://www.dll-files.com/dllindex/dll-files.shtml?oci

<table align="center" width="90%">

    <tr>

        <td align="left" valign="top"><br><strong><font color="#000033" size="3" face="Verdana">VESSEL SCHEDULE</font></strong></td>

    </tr>

</table>

<hr>



<form name="vessel" action="<?php $PHP_SELF; ?>" method="post">

<table align="left">

    <tr>

       

      <td><font color="#330000" size="2" face="Verdana">Vessel Name</font></td>

        <td>:<input type="text" name="ves"></td>

        <td><input type="submit" name="submit" value="Search"></td>

    </tr>

</table>

</form>

<?php

if($submit)

{

    $conn=ocilogon(’db_name’,’pass’,’sid’);

    $f5=’db_name’;

    $no=1;

    $non=0;

    $ves = strtoupper($ves);

    $que1 = "SELECT TO_CHAR(VV.BERTHING_DATE,’MM/DD/YYYY HH24:MI:SS’) AS BERTHING_DATE,

TO_CHAR(VV.DEPARTURE_DATE,’MM/DD/YYYY HH24:MI:SS’) AS DEPARTURE_DATE,

VM.VES_NAME

FROM $f5.vessel_voyage VV, $f5.vessel_master VM

WHERE VV.ves_code IN

  (SELECT ves_code FROM $f5.vessel_master WHERE ves_name LIKE UPPER (’%$ves%’) )

  AND VV.VES_CODE=VM.VES_CODE AND ROWNUM<=50

                ORDER BY berthing_date DESC";

    $sta2 = ociparse($conn,$que1);

    ociexecute($sta2);

    ?>

    <table align="center" cellspacing="1" bgcolor=’#d3ecff’ width="98%">

    <tr bgcolor="#000066">

           <td align="center" height="27"><font color=’yellow’ size=’2’ face=’verdana’>No.</font></td>       

        <td align="center"><font color=’yellow’ size=’2’ face=’verdana’>Ves. Code</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Ves. Id</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Voy. Out</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Voy. In</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Ves. Name</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana">Agent</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana, Arial, Helvetica, sans-serif">Berthing Date</font></td>

        <td align="center"><font color="yellow" size="2" face="Verdana, Arial, Helvetica, sans-serif">Departure Date</font></td>

    </tr>

    <?PHP

    while(@ocifetch($sta2))

    {

     if ($no%2 == 1) { $style = "row1"; }

              else { $style = "row2"; }

                echo "<tr class=’".$style."’>";

    ?>

        <td align="center" height="15"><?php echo$no;?></td>       



        <td align="center"><?php echo ociresult($sta2,"BERTHING_DATE")?></td>

        <td align="center"><?php echo ociresult($sta2,"DEPARTURE_DATE")?></td>

    </tr>

    <?

    $no++;

    $non++;

    }//END WHILE

}   

?>

</table>

 

1. copy isi folder instant client oracle atau oci.dll ke dalam folder F:\xampp\apache\bin

2. ubah isi file F:\xampp\php\php.ini dengan menghilangkan comment untuk baris yang berisi

extension=php_oracle.dll

extension=php_oci8.dll

contoh file: koneksi :

    $f5=’dbname’;   

$db="(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA = (SID = sidname))

  )";

if (!$conn) {

$m = oci_error();

echo $m["message"];

exit;

}

SQL: MINUS Query

The MINUS query returns all rows in the first query that are not returned in the second query.

Each SQL statement within the MINUS query must have the same number of fields in the result sets with similar data types.

The syntax for an MINUS query is:

select field1, field2, . field_n

from tables

MINUS

select field1, field2, . field_n

from tables;

Example #1

The following is an example of an MINUS query:

select supplier_id

from suppliers

MINUS

select supplier_id

from orders;

In this example, the SQL would return all supplier_id values that are in the suppliers table and not in the orders table. What this means is that if a supplier_id value existed in the suppliers table and also existed in the orders table, the supplier_id value would not appear in this result set.

Example #2 - With ORDER BY Clause

The following is an MINUS query that uses an ORDER BY clause:

select supplier_id, supplier_name

from suppliers

where supplier_id > 2000

MINUS

select company_id, company_name

from companies

where company_id > 1000

ORDER BY 2;

Since the column names are different between the two "select" statements, it is more advantageous to reference the columns in the ORDER BY clause by their position in the result set. In this example, we’ve sorted the results by supplier_name / company_name in ascending order, as denoted by the "ORDER BY 2".

The supplier_name / company_name fields are in position #2 in the result set.

 tips untuk register global





banyak kasus pemakai apache 2 pada kelabakan karena script nya mengalami error. Dengan pertimbangan security yang lebih baik, memang register global sebaiknya di set off.

Untuk coding yang memakai index follow, seperti phpnuke, postnuke, mambo, dan sebagian besar cms, tambahkan di paling atas pada file index.php, module.php, atau mod.php, pokoknya script yg manggil module :



extract($_GET);

extract($_POST);



jadi gak usah capek2 ganti semua variable, misalnya:

asal => $variabel

menjadi => $_GET[’variable’];



Tapi kalau coding nya berdiri sendiri, ya... tiap file php, atasnya harus ditambahin extract seperti yang di atas.



Untuk yang coding sendiri, ada baiknya jika set environment developing nya dengan:

register_global = off

safe_mode = on

so, coding kita bisa dipake dalam environment apapun...