-
Hi all,
I am running Oracle 9.2 on Linux redhat 7.3
I created the database using DBCA and after the database creation was completed, I was loooking for the init.ora but I couldn't find it at all except there was an init.ora.8787082323.
I tried to make the new init.ora by using this command:
CREATE PFILE=/home/oracle/admin/db_name/pfile/initDB_name.ora from spfile=/home/oracle/product/9.2.0/dbs/spfileDB_NAME.ora
but it tell me invalid file name
could someone tell me where is my init.ora and how to fix this problem???
Thanks
-
Check:
$HOME/admin/$SID/pfile
Where : $HOME --> home directory for owner of database (oracle by default)
Filename have to be: init$SID.ora
Where $SID => $ORACLE_SID (ur environment parameter)
-
$ORACLE_BASE/admin/$ORACLE_SID/scripts/init.ora
-
It's possible you don't have one if you're using a SPFILE. If you were using an init.ora file the first place Oracle looks is the $ORACLE_HOME/dbs directory. The file it finds here is usually:
- A symbolic link to the $ORACLE_HOME/admin/$SID/pfile directory
- A file containing an IFILE reference to this directory.
- A SPFILE reference.
If you find the file in the DBS directory it will tell you where your file is if you have one.
Cheers
-
Tim and Shestakov and Pando
Thanks your advise. I did look into $ORACLE_HOME/admin/DB_NAME/pfile/ before I posted the message in here. As I mentioned earlier, ini.ora is no where to be found except there is a file init.ora.80890943.
I am aware of the spfile locate in $ORACLE_HOME/dbs/spfileDB_NAME.ora and I have the file.
The question is how do I change the parameter for my database if I only have the spfile instead of pfile. and I think I can create the new pfile too right??? How come Oracle returns with INVALID FILE name.
Please advise
[Edited by ashley75 on 07-21-2002 at 01:12 PM]
-
Try
create pfile from spfile at the location of the spfile file.
-
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
|