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???
07-20-2002, 07:46 PM
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)
07-21-2002, 03:04 AM
07-21-2002, 03:37 AM
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.
07-21-2002, 12:57 PM
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]
07-22-2002, 02:57 AM
create pfile from spfile at the location of the spfile file.