Di init.ora, kok parameter UNDO_TABLESPACE tidak
kelihatan ya? padahal parameter UNDO_MANAGEMENT di set
ke AUTO..

Ada kemungkinan datafile UNDO tidak ada/corrupt?
Soalnya undo mgkn dibutuhkan utk proses recovery pada
saat open.

Coba check UNDO datafile, misalkan UNDO_TABLESPACE
bernilai UNDOTBS1 (Sebelumnya, STARTUP MOUNT dulu
databasenya):

  select name from v$datafile where ts# = 
   (select ts# from v$tablespace where name =
'UNDOTBS1');

Coba check apakah datafile tersebut available?

regards,
tomi

--- nhomsan <[EMAIL PROTECTED]> wrote:

> udah ... malah saya matiin powernya tapi masih
> begitu juga errornya ..
> 
> 
> Nhs
> 
> --- In [email protected], Tomi Wijanto
> <[EMAIL PROTECTED]> wrote:
> >
> > Udah pernah coba di-restart servernya?
> > Mungkin ada proses lama yg nyangkut, sehingga
> proses
> > startup gagal
> > 
> > regards,
> > tomi
> > 
> > --- nhomsan <[EMAIL PROTECTED]> wrote:
> > 
> > > 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
> > 
> > 

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


Kirim email ke