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 ." <[EMAIL PROTECTED]>
> wrote:
> >
> > Pagi,
> >
> > Bisakah anda tampilkan init.ora anda?
> >
> >
> >
> > On 3/31/06, nhomsan <[EMAIL PROTECTED]> 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/
