Oracle on Solaris

UNIX Solaris
1

Hi friends,
i am given a new login id on a solaris system.And i have the basic .profile for that.Once i log in to that system how can i check if there is oracle installed on that solaris system ?
I would want to set the path and other variables if i find that oracle is installed on it.
Please help.
thanks in advance
sveera

2

try ps -ef | grep -i ora

Which will look for Oracle processes running on the machine. Also, you can check in /var/opt/oracle for a file called oratab (I think this is a typical location but I may be wrong - Im not a DBA :wink: )

3

Hi ,
Thanks for the quick reply. when i typed the command that you gave i got a long listing . when i try to check for the ORACLE_HOME PATH variable it says that it is not set ..then what do i do to use oracle from my login ....i know what variables to set but it says that variables are not set ...then how come other users are using it ? is it because it is not set in my login it is giving that the variable is not set ?
thanks
sveera

4

Look for a file in /usr/local/bin/ called oraenv. If it exists, you can run this shell and pass it your SID value. The script will set ORACLE_HOME and other variables. If the file doesnt exist, then contact your DBA or app support person to understand how they have setup the database. If you saw a bunch of Oracle processes running, then you know Oracle was installed and is running.

Example
. /usr/local/bin/oraenv testDB

5

Hi ,
Thanks a lot for the response. But i am not sure about the ORACLE SID.
Actually i havent worked on oracle though i have the knowledge of SQL and PLSQL .
Do i have to approach the client to know the SID or can i get it by just typing in some command?
actually i am working using telnet to the clients machine.
thanks
sveera

6

The ORACLE_SID is the schema ID (instance) of the database that you wish to connect to. You will need to ask somebody what SID you should connect to. Actually, find the oratab file. You should have permissions to view this file. When you find it, open it up. It will have a series of entries with the format like this:

database_sid:oracle_home_dir:Y|N

Choose which SID you want to connect to based upon entries in this file (still probably want to ask somebody if you are truly not sure of what DB you should be in).

7

Hi ,
Thanks a lot dear.
bye
veeras