Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle11gR2: Linux 5.3: how to set ORACLE_HOME?

Posted on 2011-03-22
4
Medium Priority
?
785 Views
Last Modified: 2012-05-11
Hello experts,

what do I set ORACLE_HOME to?

below is my install directory

I had it set to ORACLE_HOME=/oracle

but, I don't think that's the right path...

In advance, thank you for your help...

regards,
[oracle@oracle oracle]$ ls
apex         dbs                      inventory  nls              owm            sqlplus
app          dc_ocm                   j2ee       oc4j             perl           srvm
assistants   deinstall                javavm     ocm.rsp          plsql          sysman
bin          demo                     jdbc       odbc             precomp        timingframework
ccr          diagnostics              jdev       olap             racg           tmp
cdata        dv                       jdk        ons              rdbms          ucp
cfgtoollogs  emcli                    jlib       OPatch           relnotes       uix
clone        EMStagePatches_confserv  ldap       opmn             root.sh        utl
config       has                      lib        oracle_confserv  root.sh.old    wwg
crs          hs                       log        oracore          root.sh.old.1  xdk
csmig        ide                      md         oraInst.loc      scheduler
css          install                  mesg       ord              slax
ctx          install.platform         mgw        oui              sqldeveloper
cv           instantclient            network    owb              sqlj

Open in new window

0
Comment
Question by:epifanio67
  • 2
  • 2
4 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 35194970
What makes you think that isn't right?

Did you run root.sh after the install?  If so, see if there is a /etc/oratab file.  If so, if should show the correct home.

It should have also been correct in the oracle usrs profile an not needed changing.
0
 

Author Comment

by:epifanio67
ID: 35194993
thank you expert...

well, I have ORACLE_HOME set to the base directory where the application is installed. In other words:
ORACLE_HOME=/oracle

is this correct?

I searched the web and ORACLE_HOME seemed to be set to .../product/11.xx/db....

below is what I get when cat /etc/oratab... I don't see ORACLE_HOME there...

thanks for all of your help
[oracle@oracle oracle]$ cat /etc/oratab
#



# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
confserv:/oracle:N

Open in new window

0
 
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 2000 total points
ID: 35195016
Again, why do you not think it is correct?  Is something not working or throwing an error?

In the oratab file, for the conserv instance ORACLE_HOME is /oracle.

The comments talk about the file layout.
0
 

Author Closing Comment

by:epifanio67
ID: 35195112
got it.. thx for your help..
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question