Tag Archives: oracle

Oracle connect to DB2 database


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Hari ini saya mencoba untuk mencoba membaca database DB2 dari database Oracle. Dengan fitur berikut kita dapat dengan mudah membaca data dari database lain walaupun kita hanya terhubung ke database Oracle. Berikut langkah-langkahnya 1. Buat sebuah DSN untuk DB2. Dari … Continue reading

Posted in DB2, Oracle Database | Tagged , , , , , , , , , , | Leave a comment

Oracle Enterprise 11gR2 Installation on Windows


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Untuk instalasi oracle 11gR2 sedikit berbeda dengan oracle database versi sebelumnya. Berikut langkah-langkahnya 1. Extract win32_11gR2_database_1of2.zip kemudian extract win32_11gR2_database_2of2.zip ke dalam /database/stage/components yang dibuat pada saat mengextract win32_11gR2_database_1of2.zip. Jika hal ini tidak dilakukan maka akan muncul error em.ear not found … Continue reading

Posted in Oracle Database | Tagged , , , , , , , , , | 1 Comment

Oracle Materialized View on prebuilt table


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Jika membuat materialized dari sebuah table CTAS dengan menggunakan prebuilt table, jika kita melakukan select dari table master, maka query rewrite terkadang tidak berjalan. Misalnya kita menggunakan table master employees dari schema sample Oracle. Kemudian kita membuat sebuah CTAS create … Continue reading

Posted in Oracle Database, Software, Tips n trick | Tagged , , , , , , , , , | Leave a comment

Oracle background process


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Untuk mendukung berjalannya database dengan benar, Oracle menjalankan service yang memiliki tugas masing-masing. Berikut merupakan service utama yang ada – dbwr (database writer) berguna untuk mencatat data yang ada di dalam buffer ke dalam disk. – lgwr (log writer) berguna … Continue reading

Posted in Oracle Database | Tagged , , , , , , , , , , | Leave a comment

Oracle Tablespace


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Oracle mempunyai definisi tablespace yang sama dengan DB2. Tablespace merupakan tempat dimana satu atau lebih database berada. Di Oracle terdapat 4 jenis tablespace 1. system tablespace Menyimpan informasi operasional dan menentukan atribute dari data yang disimpan seperti tipe data, besar … Continue reading

Posted in Oracle Database | Tagged , , , , , , , , , | Leave a comment

Oracle Enterprise 11g Uninstall on Windows


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Berikut merupakan cara untuk menguninstall Oracle. Pada contoh berikut digunakan Oracle 11g Enterprise 1. Jalankan Oracle Universal Installer 2. Klik Deinstall Products. Pilih komponen yang ingin diuninstall, klik remove. Jika sudah selesai klik close kemudian Next 3. Buka regedit, dan … Continue reading

Posted in Oracle Database | Tagged , , , , , , , , , | Leave a comment

Oracle Enterprise 11g Installation on Windows


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Berikut merupakan step by step untuk melakukan instalasi Oracle Enterprise 11g di Windows. Langkah yg dibutuhkan berbeda dengan Oracle Express 10g. Langkah ini pun akan berbeda dengan step by step untuk instalasi Oracle Enterprise 11g R2. Jangan lupa untuk mengecek … Continue reading

Posted in Oracle Database | Tagged , , , , , , , , , | Leave a comment

Oracle Express 10g Installation


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Berikut merupakan step by step untuk menginstall Oracle Express 10g. Versi gratis dari Oracle database yang dapat digunakan secara bebas. Jangan lupa untuk memperhatikan requirement yang dibutuhkan per masing-masing OS. Bisa langsung cek di site Oracle. 1. Klik setup 2. … Continue reading

Posted in Oracle Database | Tagged , , , , , | Leave a comment

Cognos Connect to Oracle


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

We now trying to connect Cognos with Oracle 1. Open Cognos Administration and configuration tab. At left panel, click data source connection 2. Click new data source button 3. Give source name. We can give additional information if needed. 4. … Continue reading

Posted in Cognos | Tagged , , , , , | Leave a comment

DB2 – Oracle Migration Parameter


Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1093

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1105

Warning: Illegal string offset 'status_txt' in /home/denysuta/public_html/wp-content/plugins/share-and-follow/share-and-follow.php on line 1132

Ada beberapa parameter yang sebaiknya diganti sebelum melakukan migrasi dari Oracle ke DB2. Parameter ini berguna untuk mempermudah atau mengotomatisasi proses migrasi. 1. DB2_COMPATIBILITY_VECTOR (registry) Isi nilai parameter ini dengan “ORA”. Ini merupakan level kompatibilitas tertinggi. Setelah mengubah parameter ini … Continue reading

Posted in DB2 | Tagged , , , , , , , | Leave a comment