Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| SUN Solaris The Solaris Operating System, usually known simply as Solaris, is a free Unix-based operating system introduced by Sun Microsystems . |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| solaris-oracle | rags_s11 | SUN Solaris | 3 | 06-20-2008 01:25 AM |
| Oracle Installation on Solaris | panchpan | SUN Solaris | 5 | 10-23-2007 04:16 AM |
| Oracle on Solaris | amon | Shell Programming and Scripting | 1 | 04-26-2006 09:55 AM |
| oracle on solaris | sveera | UNIX for Advanced & Expert Users | 2 | 06-03-2005 11:50 AM |
| Oracle on solaris. | niasdad | UNIX Desktop for Dummies Questions & Answers | 2 | 11-06-2002 12:40 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
04-18-2005
|
||||
|
||||
Oracle on Solaris
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 |
|
04-18-2005
|
|||||
|
|||||
|
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  ) |
|
04-18-2005
|
||||
|
||||
|
oracle
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 |
|
04-18-2005
|
|||||
|
|||||
|
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 |
|
04-18-2005
|
||||
|
||||
|
Oracle
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 |
|
04-18-2005
|
|||||
|
|||||
|
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:
Code:
database_sid:oracle_home_dir:Y|N |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
