UNIX for Dummies Questions & Answers

hi

i would like to know the path of init.ora in AIX Server

i tried with find command but i could not find it.

can somebody help me with that.

Not sure this will help or not as I don't have a AIX server to try it on.

Normally, Oracle sets up it's oratab in a specific place - usually /var/opt/oracle/oratab. Inside that file is the 'home' of oracle. Run your find from that directory to find the init.ora

If you know where Oracle's home is (not the userid oracle but the product) then run your find from there. Usually has ../oracle/product/X.X.X/ where X.X.X is the version number.

thanks for ur reply

i tried for a search from ORACLE_HOME

the format of find that i use in solaris box is
find . -name '*init*' -print 2>/dev/null ---- for searching the init.ora files

when i tried the same command
find . -name '*init*' -print 2>/dev/null

i get a conjunction error for directing error to null file

hence i tried with find . -name '*init*' -print,

after few searches i am getting process table filled and unable to proceed further with the search.

can u plz help?

I dont have an AIX server either.

If you are looking for init.ora in your $OH, you should probably find it in this location in your database installation. (I am on RHEL 3.0)

$OH/dbs/init.ora
$OH/srvm/admin/init.ora

Hope it helps.

-vino

ya vino

it should be under ORACLE_HOME/dbs

this is what the notion that i had regarding the path of init.ora
to my surprise it wasnt there

thats why i had to make a search

and it wouldnt be as such in the name of init.ora

it would be as initSID.ora
where SID => $ORACLE_SID which we can get from tnsnames.ora

i could locate the file tnsnames.ora but not init*ora

any idea on how to do an effective search in AIX

i had mentioned the difficulty of searching in AIX in my previous post.

Thanks for ur reply

Also check your Oracle startup script - it could be using a different file so no init.ora would be found.

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 initdev.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.

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