You can start by ps -ef | grep pmon that will show all the pmon processes running, so that will show you the names of all the instances running. From there, you can look for the filenames associated with the instance, or the listeners to find the oracle_homes, ora whatever. On 7/12/07, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
I got one AIX server where I want to check as what are the Oracle installed in it. Is there I can get this information from any Log. There is not oratab in /etc or /var/opt/oracle. Is it possible with OraInst.loc. Anyway I am even not sure that OraInst.loc was ever removed for any new installation as this is Dev Server which is not good practice. I can check the Version details once I know where is the ORACLE_HOME using inspdver[ Oracle 7 or 8] or unix.rgs[8i or 9i]etc. The challenge is to find out various Oracle Installed on the Server. TIA Sanjay ------------------------------ Looking for a deal? Find great prices on flights and hotels<http://us.rd.yahoo.com/evt=47094/*http://farechase.yahoo.com/;_ylc=X3oDMTFicDJoNDllBF9TAzk3NDA3NTg5BHBvcwMxMwRzZWMDZ3JvdXBzBHNsawNlbWFpbC1uY20->with Yahoo! FareChase.
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'