Kalau state terakhir adalah MOUNTED, berarti tidak ada masalah dengan control file-nya.
Kemungkinan kenapa database tidak dapat OPEN adalah, karena datafile/logfile ada yang rusak/hilang. Coba dilihat isi alert.log file, biasanya informasi/detail error message nya ada di dalam alert.log file tsb. Andaikata tidak ada error, coba secara manual open databasenya: (asumsi: state terakhir MOUNTED) SQL> ALTER DATABASE OPEN; SQL> SELECT status FROM V$INSTANCE; Berdasarkan pengalaman saya, apabila databasenya HARUS di OPEN secara manual spt diatas, maka yg harus dilakukan adalah, create ulang service Oracle-nya, menggunakan ORADIM. (asumsi: ORACLE_SID=ORCL) C:\> oradim -delete -sid ORCL C:\> oradim -new -sid ORCL -startmode auto -intpwd oracle Note: NOMOUNT : Membaca parameter file, allocate memory for SGA MOUNT : Membaca controlfile, determine location of database files OPEN : Membuka Datafile, Logfile, Open akses from user, ... CMIIW, Bowo --- In [email protected], "Henri Alia Putra" <[EMAIL PROTECTED]> wrote: > > dear imansyah > > pengalaman saya sih, kalau ada masalah dalm create control file, coba jalan kan step by step > jangan langsug load scriptnya > > jadi ketauan errornya pas jalanin apa.. > > wassalam > > Henri Alia Putra > Information Technology - Performance Available and Security > PT. Federal International Finance > Jl, Gaya Motor Raya No 8 > Gedung AMDI B. > Jakarta Utara > Phone : 021-65300708 ext 249 > Fax : 021-65300709 > > > ________________________________ > > From: [email protected] on behalf of imansyah mochamad > Sent: Fri 1/13/2006 10:49 AM > To: [email protected] > Subject: [indo-oracle] Oracle9i (ORA-01041 / ORA-03113 ) > > > dear all, > > saya ada masalah di Oracle9i ORA-01041 / ORA-03113, > OS window 2000, database bisa di-mounted, tidak bisa > di open, > kemungkinan control filenya rusak,database tidak di > archaive, no backup lagi :(, saya sudah buat > controlfilenya, recover data filenya still no open, > untuk di linux saya baca > http://www.idevelopment.info/data/Oracle/DBA_tips/Linux/LINUX_4.shtml > > > pertanyaan saya, > 1.bagaimana bisa diopen lagi > 2.adakah command ipcs dan ipcrm di window ? (untuk > maintain memory) > > Thanks All > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > > > > -- > -----------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 > > > > > SPONSORED LINKS > Membership database software <http://groups.yahoo.com/gads? t=ms&k=Membership+database+software&w1=Membership+database+software&w 2=Database+mortgage+software&w3=Pda+database+software&w4=Database+man agement+software&w5=Oracle+database+administration&w6=Oracle+database +management&c=6&s=195&.sig=eDDh4hKVCztlkTEeYzirSg> Database mortgage software <http://groups.yahoo.com/gads? t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2= Database+mortgage+software&w3=Pda+database+software&w4=Database+manag ement+software&w5=Oracle+database+administration&w6=Oracle+database+m anagement&c=6&s=195&.sig=hXxg74XuhXSzegVx-t1xkA> Pda database software <http://groups.yahoo.com/gads? t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Datab ase+mortgage+software&w3=Pda+database+software&w4=Database+management +software&w5=Oracle+database+administration&w6=Oracle+database+manage ment&c=6&s=195&.sig=roR_Z1cY1-GOzqzt3GgyUw> > Database management software <http://groups.yahoo.com/gads? t=ms&k=Database+management+software&w1=Membership+database+software&w 2=Database+mortgage+software&w3=Pda+database+software&w4=Database+man agement+software&w5=Oracle+database+administration&w6=Oracle+database +management&c=6&s=195&.sig=qVd58SCSnEG4iKPrZDnKTA> Oracle database administration <http://groups.yahoo.com/gads? t=ms&k=Oracle+database+administration&w1=Membership+database+software &w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+m anagement+software&w5=Oracle+database+administration&w6=Oracle+databa se+management&c=6&s=195&.sig=HnkpKGBwHtP2yh9OvVaS3Q> Oracle database management <http://groups.yahoo.com/gads? t=ms&k=Oracle+database+management&w1=Membership+database+software&w2= Database+mortgage+software&w3=Pda+database+software&w4=Database+manag ement+software&w5=Oracle+database+administration&w6=Oracle+database+m anagement&c=6&s=195&.sig=8YpXzkCJ2hlCDM-NY94dXQ> > > ________________________________ > > YAHOO! GROUPS LINKS > > > > * Visit your group "indo-oracle <http://groups.yahoo.com/group/indo-oracle> " on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] <mailto:indo-oracle- [EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . > > > ________________________________ > > > > > [Non-text portions of this message have been removed] > -- -----------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/
