Terimakasih Pak Bowo atas sharingnya, Oooh.. ternyata itu toh fungsinya parameter COMPATIBLE :-)
Kalau saya export Full db dari 8.1.6 (NT/W2K) ke 10G Standard Edition One (RH Linux 4) Kira-kira tahapan apa yang harus diperhatikan? Apakah semua object dari 8.1.6 akan bisa "jalan" di 10G? Ditunggu pencerahannya lagi, Salam, Bambang ----- Original Message ----- From: Yulius Wibowo To: [email protected] Sent: Tuesday, February 21, 2006 1:11 PM Subject: [indo-oracle] Re: Migrate/Update 8.1.6 -> 10g or 8.1.6 -> 8.1.5 Downgrade tetap bisa dilakukan selama nilai parameter COMPATIBLE-nya sesuai. Misal, di database 8.1.6, settingan parameter COMPATIBLE=8.1.0 atau COMPATIBLE=8.1.5 Maka seluruh database files (datafiles, controlfiles, redolog files, ...) masih bisa dipakai di software oracle 8.1.5. Tip: Upgrade dgn menggunakan DBUA (Upgrade Assistant) Direct upgrade ke 10G: 9.2.0, 9.0.1, 8.1.7, 8.0.6 In-Direct upgrade ke 10G: 8.1.6, 8.1.5, 8.0.5, 8.0.4, 8.0.3, 7.3.4 (harus diupgrade dulu ke versi yg support utk direct upgrade) CMIIW, Bowo --- In [email protected], "Anang Rahmadyan" <[EMAIL PROTECTED]> wrote: > > Stahu saya ndak bisa. karena down grade. jadi caranya : > 1. Dari Oracle versi 8.1.5 buat tns ke Oracle 8.1.6. > 2. Dari 8.1.5 Export data Oracle 8.1.6. c:/>Exp System/[EMAIL PROTECTED] owner=user_8.1.6 file=c:\oracle_8_1_6.DMP > 3. Setelah itu buat structure data yang sama dengan 8.1.6 di 8.1.5 (Username,Tablespace data,index) dan import file dmp tadi. > Mungkin pak Julius punya solusi yang lebih baik.! mohon hubungi juga beliau > > ----- Original Message ----- > From: Bambang Subekti > To: [email protected] > Sent: 20 February 2006 0:03 > Subject: Re: [indo-oracle] Migrate/Update 8.1.6 -> 10g or 8.1.6 - > 8.1.5 > > > Terimakasih Pak Anang atas replynya, > Saya maksudkan copy file (datafiles, controlfiles, redologfiles,init.ora) disini adalah dari Oracle 8.1.6 (NT) ke 8.1.5 (Windows 2000) [oraclenya downgrade] bukan ke Linux, setelah itu baru dari 8.1.5 (W2K) saya export dan import ke Oracle 10g (Linux). > Saya ngak tahu apa perbedaanya 8.1.6 dan 8.1.5. Apakah kalau saya copy (datafiles, controlfiles, redologfiles,init.ora) akan jalan di Oracle 8.1.5 ? Kalo cara export import apa bisa juga? Karena ini Oraclenya downgrade walaupun OSnya masih Windows juga. > > Ada yang bisa kasih pencerahan. > ----- Original Message ----- > From: Anang Rahmadyan > To: [email protected] > Sent: Monday, January 24, 2005 1:04 PM > Subject: Re: [indo-oracle] Migrate/Update 8.1.6 -> 10g or 8.1.6 -> 8.1.5 > > > Pak Bambang... > setahu saya kayaknya gak bisa copy file, karena format file dari Windows Nt dan linux tidak sama. Saya pernah mengalami hal demikian, tapi kasusnya mungkin agak beda. Yakni dari Oracle 7.3.4 Win Nt migrasi ke Oracle 8.1.7 ke Linux. > Nah waktu itu karena saya pikir datanya gak terlalu besar (Kurang Lebig 4GB - DMP), maka saya ambil alternatif untuk Export/Import. Yakni dengan jalan : > 1. Saya buat Tns Name Dari Linux Ke Winnt untuk mengakses Oracle Versi 7.3.4. > 2. Dengan menggunakan Linux saya export data base (DMP) sehingga saya daper backup dmp versi linux. > 3. Saya buat struktur yang sama dengan di Winnt, (Tablespace Name). > 4. Buat User dengan privilage yang sama. (Lebih dari satu user). > 5. Kemudian saya import. > Sejauh ini berhasil. > ----- Original Message ----- > From: Bambang Subekti > To: [email protected] > Sent: 16 February 2006 17:42 > Subject: [indo-oracle] Migrate/Update 8.1.6 -> 10g or 8.1.6 - > 8.1.5 > > > Hallo para Oracle Mania, > > Saya ada pertanyaan mengenai migration/update database. > > Source DB : Oracle 8.1.6 > Flatform : Windows NT - Compaq > > Target DB : Oracle 10G Standard Edition One > Flatform : Redhat Linux 3.0 - Primergy Fujitsu Siemen > > Ada berapa cara untuk memindahkan Database dara Source DB ke Target DB? > Yang saya tahu bisa pake Database Upgrade Assistant, Export Import atau manual (SQL script). > Mana yang paling mudah dan direkomendasikan? Ada yang dokumentasinya selain dari Oracle Documentation? > > Kalau seandainya saya mau pake Temporary Database (8.1.5) sebagai Target DB yang nantinya dari Temporary ini saya mau migrate datanya ke 10g. Apakah bisa dilakukan copy datafiles (bukan pake export/import) dari Source DB ke Temporary DB ? > > Source DB : Oracle 8.1.6 > Flatform : Windows NT - Compaq > > Target DB : Oracle 8.1.5 (Temporary DB) > Flatform : Windows NT/2000 - Intel Base PC > > 8.1.6 => 8.1.5 => bisa copy datafiles saja ? > > Final Target DB : Oracle 10G Standard Edition One > Flatform : Redhat Linux 3.0 - Primergy Fujitsu Siemen > > Saya pake 8.1.5 sebagai Temporary DB karena tidak punya media (CD) utk yg 8.1.6. > Atau ada yang mau minjemin/copy CD nya? > Atau kalau mau download dimana? > > Terimakasih, > Bambang S > > [Non-text portions of this message have been removed] > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > SPONSORED LINKS Membership database software Database mortgage software Pda database software > Database management software Oracle database administration Oracle database management > > > --------------------------------------------------------------- --------------- > YAHOO! GROUPS LINKS > > a.. Visit your group "indo-oracle" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------------------------------------- --------------- > > > > > --------------------------------------------------------------- --------------- > > > =================================================== > > This Mail Scanned By Messaging Security Suite > > ================= Provided by IT Hardware ================= > > > [Non-text portions of this message have been removed] > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > SPONSORED LINKS Membership database software Database mortgage software Pda database software > Database management software Oracle database administration Oracle database management > > > ----------------------------------------------------------------- ------------- > YAHOO! GROUPS LINKS > > a.. Visit your group "indo-oracle" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > ----------------------------------------------------------------- ------------- > > > > [Non-text portions of this message have been removed] > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > ------------------------------------------------------------------- ----------- > YAHOO! GROUPS LINKS > > a.. Visit your group "indo-oracle" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > ------------------------------------------------------------------- ----------- > > > > > ------------------------------------------------------------------- ----------- > > > =================================================== > > This Mail Scanned By Messaging Security Suite > > ================= Provided by IT Hardware ================= > > > [Non-text portions of this message have been removed] > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com SPONSORED LINKS Membership database software Database mortgage software Pda database software Database management software Oracle database administration Oracle database management ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "indo-oracle" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
