-
Create spfile
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/.........';
-
Re: Create spfile
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
-
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
Amar
"There is a difference between knowing the path and walking the path."
-
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
-
hello
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
abdulkhadeer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|