Solved

Oracle11gR2: Linux 5.3: how to set ORACLE_HOME?

Posted on 2011-03-22
4
778 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

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 77

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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 shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

627 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