salam, sudah saya coba pak, berikut hasilnya : SQL> select name, database_role, open_mode from v$database; NAME DATABASE_ROLE OPEN_MODE --------- ---------------- ---------- CARD PRIMARY MOUNTED SQL> alter database open; alter database open * ERROR at line 1: ORA-00320: cannot read file header from log 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\CARD\REDO03.LOG'
masih tidak bisa juga pak. thank's Alif --- On Wed, 21/10/09, mohammad arief pradipto <[email protected]> wrote: From: mohammad arief pradipto <[email protected]> Subject: Re: [indo-oracle] ORA-01033: ORACLE initialization or shutdown in progress To: [email protected] Date: Wednesday, 21 October, 2009, 2:14 PM Kalau dapat error tsb, berarti keadaan database tidak dalam keadaan open, bisa jadi dia dalam keadaan nomount atau mount. Untuk mengeceknya ketikkan command berikut SQL> select name, database_role, open_mode from v$database; apabila betul nilai open_mode-nya bukan 'OPEN', maka buka database tsb SQL> alter database open; CMIIW regards, adipt 2009/10/21 Alif Sokhibi <alif_sokhibi@ yahoo.com> > > > salam, > > dear all Indo Oracle, > mohon bantuannya di karenakan akhir2 ini rumah saya selalu mati lampu, yang > akhirnya menyebabkan komputer harus hidup - mati - hidup -mati melulu... > nah setelah lampu menyala saya coba untuk connect ke Oracle kembali namun > ngga bisa masuk-masuk dan ada pesan errornya yaitu : > > ORA-01033: ORACLE initialization or shutdown in progress > > mohon solusinya para master oracle semuanya... > > thank's > > Alif > > New Email addresses available on Yahoo! > Get the Email name you've always wanted on the new @ymail and > @rocketmail. > Hurry before someone else does! > http://mail. promotions. yahoo.com/ newdomains/ aa/ > > [Non-text portions of this message have been removed] > > > -- adipt aa.ad...@gmail. com 021 68 535 141 http://adipt. blogspot. com/ [Non-text portions of this message have been removed] Get your preferred Email name! Now you can @ymail.com and @rocketmail.com. http://mail.promotions.yahoo.com/newdomains/aa/ [Non-text portions of this message have been removed]
