Try one of these to locate your init.ora file:
Note: The Oracle instance configuration file is generally referred to as "init.ora". The file that you are really looking for will have the database SID added to "init" as in init
dev.ora. The init.ora files found in $ORACLE_HOME/dbs are typically symbolic links to where they really are located. They do not have to exist there and apparently don't in your case.
- If you have a DBA, consult him. He must know where the init.ora for your database is located.
- Make sure your environment is correctly set by running /usr/local/bin/oraenv.
- Look for an environment variable called ORACLE_BASE. This points to where the Oracle directory structures start. If this is set you can probably find your init.ora in a directory similar to "$ORACLE_BASE/admin/<yoursid>/pfile
- Go backwars from $ORACLE_HOME. cd $ORACLE_HOME cd ../../admin<yoursid>
You certainly should be able find your init.ora at this point.
For what it's worth, I would caution you on modifying the init.ora file. Unless you know what you are doing, you can adversly impact your database.
Thomas