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