Where is my init.ora

[ashley75]

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

[Shestakov]

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)

[pando]

$ORACLE_BASE/admin/$ORACLE_SID/scripts/init.ora

[TimHall]

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

[ashley75]

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]

[soniaarora]

Try
create pfile from spfile at the location of the spfile file.

[TimHall]

Read this:

http://www.oracle-base.com/Articles/...Parameters.asp

Cheers