I have created a db in oracle 9i, when a export pfile to spfile and then I startup database don´t recognize control files.
Anybody knows something
I only can start database using pfile.
Thanks everybody
Printable View
I have created a db in oracle 9i, when a export pfile to spfile and then I startup database don´t recognize control files.
Anybody knows something
I only can start database using pfile.
Thanks everybody
how did u export pfile to spfile :confused:Quote:
Originally posted by salvareztur
I have created a db in oracle 9i, when a export pfile to spfile and then I startup database don´t recognize control files.
Anybody knows something
I only can start database using pfile.
Thanks everybody
connect as sysdba and
CREATE SPFILE FROM PFILE='/u01/.........';
Check if it is pointing to correct SPFILEQuote:
Originally posted by salvareztur
I have created a db in oracle 9i, when a export pfile to spfile and then I startup database don´t recognize control files.
Anybody knows something
I only can start database using pfile.
Thanks everybody
I have made.
create spfile='/oradmin/xxx/spfileDbd.ora' from pfile='/oradmin/xxx/inidDb.ora'
move the spfile to ORACLE_HOME/dbs if unix and $ORACLE_HOME/database if windows
When you create a non-default spfile, you need to specify the SPFILE name in the PFILE, i.e init.ora, The parameter name to be specified in init.ora is SPFILEQuote:
Originally posted by salvareztur
I have made.
create spfile='/oradmin/xxx/spfileDbd.ora' from pfile='/oradmin/xxx/inidDb.ora'
SPFILE = 'current SPFILE name', in your case, it would be
SPFILE = /oradmin/xxx/spfileDbd.ora
Now....
1. Specify this parameter in your PFILE as
SPFILE = /oradmin/xxx/spfileDbd.ora
2. Create the SPFILE as
CREATE SPFILE='/oradmin/xxx/spfileDbd.ora' FROM PFILE='/oradmin/xxx/inidDb.ora'
3. Shutdown the database
4. and now try to start the database...
For more info refer to initialisation parameter SPFILE or non-default SPFILE specification...
HTH
Sameer
hello
you can create a pfile from spfile . it like this
create pfile ='file path name '
from spfile ='filepath name '
and then try to make to changes ot it and and teh again tyr to creat a spfilefrom the pfile :D