trying to find out where oracle is installed

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hi

I am logged into a remote linux machine, i want to find out where
the oracle software is installed..basically, i want to see the following
files...

oracle_home/rdbms/admin/sql.bsq
oracle_home/rdbms/admin/catalog.sql

i am taken to home directory...do i need to export something here?
how to know where oracle is installed?

2

which oracle

or

if ORACLE_HOME is defined
find $ORACLE_HOME -name sql.bsq
find $ORACLE_HOME -name catalog.sql
or
find $ORACLE_HOME \( -name catalog.sql -o -name sql.bsq \)

if ORACLE_HOME is not defined
find / \( -name catalog.sql -o -name sql.bsq \)

List of variable need to be in your .login or .profile etc
ORACLE_ACCOUNTNAME=oracle
ORACLE_HOME=/u02/app/oracle/product/10.2.0.1.0
ORACLE_SID=mymachinename

The other environnmental variable need to be updated
PATH should be appended with oracle bin
LD_LIBRARY_PATH should be appended with to oracle lib
:b:
RUV

3

find / -name $ORACLE_HOME/rdbms/admin/sql.bsq
find / -name $ORACLE_HOME/rdbms/admin/catalog.sql

Make sure $ORACLE_HOME is set

4

Do you try to find out which ORACLE_HOMEs exist?
The file /etc/oratab should tell you.