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???
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)
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.
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.
[Edited by ashley75 on 07-21-2002 at 01:12 PM]
create pfile from spfile at the location of the spfile file.