siang juga .... sudah mas .. cuman masih aja tetep gak bisa di open , setiap mau di open pasti disconnect terus , apa mungkin temp tablespace pengaruh juga ..?? soalnya kalo saya lihat v$tablespace tdk ada tablespace TEMp nya juga di table v$tempfile kosong juga . kalo saya coba nambahin tablespace temp pasti keluar error database not open .
Nhs --- In [email protected], "betabetha ." <[EMAIL PROTECTED]> wrote: > > Siang, > > Coba tambahin undo_tablespace=UNDOTBS1, saya dulu juga pernah > mengalami error seperti ini dan setelah saya tambahin undo_tablespace > ternyata database saya bisa distartup sampai sekarang ^_^ > > > > On 3/31/06, nhomsan <[EMAIL PROTECTED]> wrote: > > pagi juga .. ini isi file init.ora-nya > > > > log_archive_dest_1='LOCATION=/u02/acccls/archive/' > > log_archive_format=%t_%s.arc_log > > log_archive_start=true > > db_block_size=8192 > > db_cache_size=524288000 > > db_file_multiblock_read_count=16 > > open_cursors=500 > > open_links=50 > > background_dump_dest=/u02/acccls/dump/bdump > > core_dump_dest=/u02/acccls/dump/cdump > > timed_statistics=TRUE > > user_dump_dest=/u02/acccls/dump/udump > > control_files= > > ("/u02/acccls/ctrlfile/control01.ctl", "/u02/acccls/ctrlfile/control0 > > 2.ctl", "/u02/acccls/ctrlfile/control03.ctl") > > compatible=9.2.0.0.0 > > hash_join_enabled=TRUE > > query_rewrite_enabled=FALSE > > star_transformation_enabled=FALSE > > java_pool_size=0 > > large_pool_size=524288000 > > shared_pool_size=524288000 > > processes=250 > > fast_start_mttr_target=300 > > remote_login_passwordfile=EXCLUSIVE > > pga_aggregate_target=524288000 > > sort_area_size=83886080 > > undo_management=AUTO > > undo_retention=10800 > > disk_asynch_io=true > > filesystemio_options=asynch > > max_enabled_roles = 100 > > star_transformation_enabled=temp_disable > > db_cache_advice = on > > job_queue_processes = 50 > > > > Nhs > > > > --- In [email protected], "betabetha ." <betabetha@> > > wrote: > > > > > > Pagi, > > > > > > Bisakah anda tampilkan init.ora anda? > > > > > > > > > > > > On 3/31/06, nhomsan <nhomsan@> wrote: > > > > dh , > > > > para oracle mania ... tolongin donkkk ... > > > > aku punya database production . sewaktu aku mau Up , ada pesen > > error > > > > ORA-01092: ORACLE instance terminated. Disconnection forced > > > > di alert lognya yang aku lihat spt ini : > > > > > > > > Errors in file /u02/acccls/dump/udump/acccls_ora_6809.trc: > > > > ORA-00704: bootstrap process failure > > > > ORA-00604: error occurred at recursive SQL level 1 > > > > ORA-08103: object no longer exists > > > > Fri Mar 31 07:47:59 2006 > > > > Error 704 happened during db open, shutting down database > > > > USER: terminating instance due to error 704 > > > > Fri Mar 31 07:47:59 2006 > > > > Errors in file /u02/acccls/dump/bdump/acccls_smon_6781.trc: > > > > ORA-00704: bootstrap process failure > > > > Fri Mar 31 07:47:59 2006 > > > > ARC0: Completed archiving log 3 thread 1 sequence 4 > > > > ARC0: Detected ARCH process failure > > > > ARC0: STARTING ARCH PROCESSES > > > > > > > > di file acccls_ora_6809.trc errornya spt ini : > > > > ..... > > > > ----- Recovery Hash Table Statistics --------- > > > > Hash table buckets = 32768 > > > > Longest hash chain = 0 > > > > Average hash chain = 0/0 = 0.0 > > > > Max compares per lookup = 0 > > > > Avg compares per lookup = 0/0 = 0.0 > > > > ---------------------------------------------- > > > > *** 2006-03-31 07:47:59.581 > > > > KCRA: start recovery claims for 0 data blocks > > > > *** 2006-03-31 07:47:59.581 > > > > KCRA: buffers claimed = 0/0, eliminated = 0 > > > > ----- Recovery Hash Table Statistics --------- > > > > Hash table buckets = 32768 > > > > Longest hash chain = 0 > > > > Average hash chain = 0/0 = 0.0 > > > > Max compares per lookup = 0 > > > > Avg compares per lookup = 0/0 = 0.0 > > > > ---------------------------------------------- > > > > ORA-00704: bootstrap process failure > > > > ORA-00604: error occurred at recursive SQL level 1 > > > > ORA-08103: object no longer exists > > > > > > > > gimana caranya agar database tsb bisa di Up yach ..?? apa > > > > ada cara untuk force Up atau ngetrace object apa yang hilang ..?? > > > > > > > > please .. tolong bantuannya .. soalnya penting ... > > > > > > > > Thank's > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > -----------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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > -----------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 > > > > > > > > > > > > > > > -- -----------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/
