Masih belum bisa.., Oracle yang saya pakai Oracle 10g pesan di alert lognya sebagai berikut :
Sat Sep 13 11:22:06 2008 Errors in file /opt/oracle/admin/abcd/udump/abcd_ora_18526.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" too small Error 604 happened during db open, shutting down database USER: terminating instance due to error 604 Instance terminated by USER, pid = 18526 ORA-1092 signalled during: alter database open resetlogs... mohon bantuannya utk analisis alert log diatas...Terima Kasih Banyak... ----- Pesan Asli ---- Dari: hendra chen <[EMAIL PROTECTED]> Kepada: [email protected] Terkirim: Sabtu, 13 September, 2008 11:38:41 Topik: Re: [indo-oracle] Error ORA-01092:Oracle Instance terminated ini solusi yang saya dapatkan dari metalink, semoga membantu 1. Correctly set ORA_NLS10 to point to the full path of $ORACLE_HOME/ nls/data/ 9idata directory. Example: echo $ORA_NLS10 /oracle/R12/ db/tech_st/ 10.2.0/nls/ data/9idata 2. Start database Best Regards, Hendra --- On Sat, 13/9/08, Bambang HP <bimawilis007@ yahoo.com> wrote: From: Bambang HP <bimawilis007@ yahoo.com> Subject: [indo-oracle] Error ORA-01092:Oracle Instance terminated To: indo-oracle@ yahoogroups. com Date: Saturday, 13 September, 2008, 11:33 AM Dear rekan-rakan Pada saat startup oracle muncul error: ORA-01092 : ORACLE instance terminated Disconnection Forced mohon bantuannya teman2 thanks banyak regards Bambang ____________ _________ _________ _________ _________ _________ _ Dapatkan alamat Email baru Anda! Dapatkan nama yang selalu Anda inginkan sebelum diambil orang lain! http://mail. promotions. yahoo.com/ newdomains/ id/ [Non-text portions of this message have been removed] Yahoo! Toolbar is now powered with Search Assist.Download it now! http://sg.toolbar. yahoo.com/ [Non-text portions of this message have been removed] ___________________________________________________________________________ Cari tahu ramalan bintang kamu - Yahoo! Indonesia Search. http://id.search.yahoo.com/search?p=%22ramalan+bintang%22&cs=bz&fr=fp-top [Non-text portions of this message have been removed]
