Solved

Oracle11gR2: Linux 5.3: how to set ORACLE_HOME?

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

751 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