Create spfile

[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

[adewri]

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

how did u export pfile to spfile

[supower]

connect as sysdba and
CREATE SPFILE FROM PFILE='/u01/.........';

[Sameer]

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

Check if it is pointing to correct SPFILE

[salvareztur]

I have made.
create spfile='/oradmin/xxx/spfileDbd.ora' from pfile='/oradmin/xxx/inidDb.ora'

[adewri]

move the spfile to ORACLE_HOME/dbs if unix and $ORACLE_HOME/database if windows

[Sameer]

Originally posted by salvareztur
I have made.
create spfile='/oradmin/xxx/spfileDbd.ora' from pfile='/oradmin/xxx/inidDb.ora'

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 SPFILE

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

[abdulkhadeer]

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