Hi para Pakar, saya mau tanya, saya punya report yang menggunakan graphic, report tsb saya buat dengan menggunakan Developer 6i, database 9i.
Report tersebut berhasil saya jalankan di database 9i dengan OS Windows tetapi tidak berhasil dijalankan di database oracle 9i dengan OS HPUX dengan error OG-01603 : Unable to create PL/SQL Development Environment context. Mohon pencerahan dari para pakar. Thanks, A Tony Indarto P "Bringing Dreams to Life" Manulife Indonesia is part of Manulife Financial - Proud Worldwide Sponsor of the Beijing 2008 Olympic Games Abi <[EMAIL PROTECTED]> Sent by: [email protected] 03/11/2008 10:07 Please respond to [email protected] To [email protected] cc Subject Re: [indo-oracle] restore database dari 9i ke 10g dengan datafile... Pak Dharma, Ketika bapak sudah restore datafile-create controlfile (Kondisi database dalam keadaan mount), mungkin bisa dicoba cara berikut pak: - database harus diopen upgrade : SQL> Alter database open resetlogs upgrade; - Install and upgrade database components SQL>@?/rdbms/admin/catuprgd.sql - Check Status upgrade SQL>@?/rdbms/admin/utlu102s.sql - Shutdown SQL>shutdown immediate - startup normal SQL>startup - compile invalid objects SQL>@?/rdbms/admin/utlrp.sql Selamat mencoba pak... regards, Fahmi 2008/11/2 Dharma Setiadi <[EMAIL PROTECTED]> > Dear All..... > > Saya lagi mencoba untuk restore dan startup database. Saat ini saya > memiliki datafile2 lengkap dengan system.dbf. Saya coba create new > controlfile dan berhasil... > > SQL> @/data003/oradata/orcl/elltst_from_ellprd.sql > ORACLE instance started. > > Total System Global Area 1207959552 bytes > Fixed Size 2072424 bytes > Variable Size 318767256 bytes > Database Buffers 872415232 bytes > Redo Buffers 14704640 bytes > > Control file created. > > Kemudian muncul masalah pada saat startup. > > SQL> startup > ORACLE instance started. > > Total System Global Area 1207959552 bytes > Fixed Size 2072424 bytes > Variable Size 318767256 bytes > Database Buffers 872415232 bytes > Redo Buffers 14704640 bytes > Database mounted. > ORA-01589: must use RESETLOGS or NORESETLOGS option for database open > > saya baca2 ternyata perlu direset Log-nya. Sudah saya lakukan dan berhasil. > > SQL> Recover database using backup controlfile; > ORA-00279: change 2576389724 generated at 11/02/2008 15:37:00 needed for > thread > 1 > ORA-00289: suggestion : > > /usr/oracle/product/10.2.0/flash_recovery_area/ELLGPP2/archivelog/2008_11_02/o1_ > mf_1_1_%u_.arc > ORA-00280: change 2576389724 for thread 1 is in sequence #1 > > Specify log: {<RET>=suggested | filename | AUTO | CANCEL} > > /usr/oracle/product/10.2.0/flash_recovery_area/ELLGPP2/archivelog/2008_11_02/log3b_ellprd.log > Log applied. > Media recovery complete. > > Kemudian saya recovery, muncul pesan dibawah.. > > SQL> Alter database open resetlogs; > Alter database open resetlogs > * > ERROR at line 1: > ORA-01092: ORACLE instance terminated. Disconnection forced > > Masalahnya Oracle instance terminated. kemudian saya liat alert log, sebgai > berikut: > > ARCH: Connecting to console port... > *** 2008-11-02 15:54:33.214 > Prior to RESETLOGS processing... > ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE start > Database is not in archivelog mode > ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE complete > *** 2008-11-02 15:54:33.264 > Thread 1: Sequence reset to 1. > ORA-00704: bootstrap process failure > ORA-39700: database must be opened with UPGRADE option > > So, masalahnya kemudian, dibilang kalau database harus jalan dengan UPGRADE > option. Muncul pesan : > > SQL> startup upgrade > ORACLE instance started. > > Total System Global Area 1207959552 bytes > Fixed Size 2072424 bytes > Variable Size 318767256 bytes > Database Buffers 872415232 bytes > Redo Buffers 14704640 bytes > Database mounted. > ORA-01113: file 1 needs media recovery > ORA-01110: data file 1: > '/data003/oradata/ellgpp2/dbs/data101/system_ellprd.dbf' > > Pesan diatas muncul karena recovery belum dilakukan. Tapi pada saat saya > coba recovery log, akan muncul pesan bahwa startup harus ugrade option... > Adapun database yang direstore dari 9i ke 10G... > Apakah memang tidak bisa restore database dengan copy datafile ke beda > versi oracle..?? atau mungkin ada yang salah dengan cara yang saya > lakukan... > Mohon dengan sangat masukkannya... > Salam, > Dharma Setiadi > > . > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
