-
Spfile vs init.ora
I just installed a new database (9I). Of course I know that SPfile is the first the database is looking after.
But How do I change the parameters, so they will take the init.ora and don`t use the spfile.
I meant, it was enough renaming the spSID.ora - but than my database won`t start
-
-
I know there is some way to include this line somewhere, so the database automatically use the init.ora file
-
1. generate your init.ora file from spfile
2. rm $ORACLE_HOME/dbs/spfileyoursid.ora
3. mv init.ora $ORACLE_HOME/dbs/inityoursid.ora
Jeff Hunter
-
And the advantages of using an spfile over an init.ora file are?
OCP 8i, 9i DBA
Brisbane Australia
-
not having to remember to update the init.ora after a system parameter change. Only one I can think of, oh dataguard needs it as well
-
Originally posted by davey23uk
not having to remember to update the init.ora after a system parameter change. Only one I can think of, oh dataguard needs it as well
Yep, that's all I can think of too. That's why I don't use them.
OCP 8i, 9i DBA
Brisbane Australia
-
Originally posted by davey23uk
not having to remember to update the init.ora after a system parameter change. Only one I can think of, oh dataguard needs it as well
rman can back it up
I'm stmontgo and I approve of this message
-
Originally posted by stmontgo
rman can back it up
What's the use??
I know there is some way to include this line somewhere, so the database automatically use the init.ora file
Keep your init.ora anywhere you want to.
In $ORACLE_HOME/dbs/inityoursid.ora type:
IFILE=your-init-file-name-with-path
Last edited by simply_dba; 01-28-2005 at 12:11 AM.
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
-
Originally posted by simply_dba
What's the use??
Keep your init.ora anywhere you want to.
In $ORACLE_HOME/dbs/spfileyoursid.ora type:
IFILE=your-init-file-name-with-path
ahhh, so u can like restore it?
I'm stmontgo and I approve of this message
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
|