Kalau nilai parameter SPFILE = blank/NULL, artinya, database instance yg sedang berjalan sekarang, TIDAK menggunakan spfile, tetapi menggunakan pfile (init<SID>.ora).
Jadi ketika anda menjalankan perintah SQL> create pfile from spfile; anda akan mendapatkan error message ... Karena, memang tidak ada/menggunakan spfile. Tapi sebaliknya, kalau anda ingin membuat spfile dari pfile yg ada, SQL> create spfile from pfile; SQL> startup force SQL> show parameter spfile SQL> create pfile from spfile; it's OK CMIIW, Bowo --- In [email protected], "oracle_yunike" <[EMAIL PROTECTED]> wrote: > > > 1. select name, value from v$parameter where name = 'spfile'; > > name value > spfile > > 2. show parameter spfile > > name type value > spfile string > > > Trus mesti gimana lagi pak ujang. Server AIX, oracle 9.2.0.4 > > Thanks > > > -----Original Message----- > From: [email protected] [mailto:indo- [EMAIL PROTECTED] > On Behalf Of Ujang Jaenudin > Sent: Tuesday, April 04, 2006 12:53 PM > To: [email protected] > Subject: Re: [indo-oracle] ORA-27037 > > yunike,select name, value from v$parameter where name = 'spfile'; > ataushow parameter spfile hasilnya gimana? > > regards > > --ujang > ----- Original Message ----- > From: "oracle_yunike" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, April 04, 2006 11:56 AM > Subject: [indo-oracle] ORA-27037 > > > > > > Hi all, > > > > Ketika saya menjalankan > > > > SQL> create pfile from spfile > > > > Muncul error sbb: > > > > Error at line 1: > > ORA-27037: Unable to obtain file status > > IBM AIX RISC System/6000 Error: 2: No such file or directory > > Additional information: 3 > > > > > > Penyebabnya apa yah. > > Thanks > > > Send instant messages to your online friends > http://asia.messenger.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 > -- -----------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/
