Solved

Oracle11gR2: Linux 5.3: how to set ORACLE_HOME?

Posted on 2011-03-22
4
773 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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
levels for reporting 5 63
Need help with Oracle syntax 4 56
execute immediate plsql block 5 33
oracle 11g 23 47
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

919 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now