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
<*> 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/
