Solved

What is the difference between the Oracle Base Directory and the Oracle Home Directory?

Posted on 2012-03-25
5
1,003 Views
Last Modified: 2012-03-25
I'm an applications developer. My specialty is developing applications based on the Microsoft Office platform, but I can navigate in Visual Studio too. I am trying to ramp up for a project that is going to be using Microsoft Access 2010 for a front end linked to an Oracle database, which I've not worked with before.
I am trying to install Oracle on a computer running on Windows 7 Ultimate 64 bit and I'm feeling like a kid who just wants to kick the ball around but has to build a soccer stadium before he can even start.
Anyway, I've installed Oracle Enterprise 11g on the computer. I know that life would probably be much simpler with Oracle Express, but Express, unfortunately, only runs on Windows 32 bit, hence the full edition. I also loaded all the sample databases (at least I'm pretty sure I did).
I've loaded the Java JDK 1.6 version. I believe that piece is OK.
At this point the piece I think I really need is ODAC, so I can set up ODBC, then create a DSN to create a connection from Access to Oracle.
SO here I am trying to load ODAC and wondering what I'm supposed to do with this window that the Oracle Universal Installer has presented me. Here's a snapshot of the window.
OUIOThe window text:

Install Location
Specify a base location for storing all Oracle software and configuration-related files. This location is the Oracle Base directory. Create one Oracle Base Directory for each operating system user. By default, software and configuration files are installed by version and database name in the Oracle Base directory.

Oracle Base: C:\app\Todd

Software location
Specify a base location for storing Oracle software files separate from database configuration files in the Oracle Base directory. This software directory is the Oracle Home directory. Change the defaults below either to specify an alternative location, or to an existing Oracle Home.

Name: OraCLient11g_home1
Path: C:\app\Todd\product\11.2.0\client_1

So the Oracle Base, Name and Path do exist (my user name is Todd). They are the defaults that were created when I installed Oracle.
I don't know what to make of the prompt for the Software Location. In fact, I would put forth the supposition that if you really understand what this prompt is getting at, you're probably already an expert in the software and don't need that prompt to begin with. Does this mean I'm supposed to create a different folder and put the path to that new folder in the textbox for 'path'? What if I just want to use the pre-existing sample databases that were loaded in the initial install. I believe they're in Oracle11g_home1. Am I supposed to first create a copy of them somewhere else, then install this ODAC software in there? It's not making a whole lot of sense to me, but I guess that's just my ignorance showing.
I know I'm asking a whole lot of questions here, but, then, I'm not sure what's the correct first question to ask.
I'll try this:
What is the difference between the Oracle Base Directory and the Oracle Home Directory?
0
Comment
Question by:shambalad
  • 3
  • 2
5 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 37764080
You can see from the examples you have above.  Oracle Home is a sub-directory under Oracle Base.

Oracle Base holds everything for Oracle except the data files (although it "could")
Typically this will be divided between the Oracle binaries (which are in the home) and the diagnostics (trace, dump and listener/alert log files)

If you have multiple homes (for instance 10g and 11g installs) both will be under the same oracle base
0
 
LVL 7

Author Comment

by:shambalad
ID: 37764118
If I'm reading your response correctly, the entries that were loaded by the installation software to that prompt screen are OK.
But if I click 'Next', I get a warning message (see below).



Message text:
OUI-10030. You have specified a non-empty directory to install this product. It is recommended to specify either an empty or a non-existent directory. You may, however, choose to ignore this message if the directory contains Operating System generated files or subdirectories like lost+found.
Do you want to proceed with installation in this Oracle Home?


I have a feeling I probably should want to proceed with installation in a different Oracle Home. But is that really so. Where should I install this software?

I'll admit I'm actually asking a new question here. So I'm going to close this question out; give you credit for the answer and copy this over to a new forum question.
Thanks,
Todd
Oui-Warning-msg.jpg
0
 
LVL 7

Author Comment

by:shambalad
ID: 37764123
I was trying to embed that image. I don't care for this new web brower interface that Experts-Exchange has implemented at all. I don't think it's an improvement.
Anyway, here's the image:
x
0
 
LVL 7

Author Closing Comment

by:shambalad
ID: 37764127
I'm going to open a new question to continue this line of inquiry.
Thanks,
Todd
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 37764206
I'm going to guess you've tried the install more than once and that's why you're getting the error that the directory isn't empty.

Either that, or you pre-created the directory and when Oracle tried to create it for you it saw it already there and is warning you.

Only you can decide if it's safe or not.  If the home directory is empty or has nothing in it important you can ignore the error.  if the directory has something in it important then you might want to pick something else
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
levels for reporting 5 51
Need help on Index -Oracle -Challenging question 5 44
Pl/SQL Query 31 62
EXECUTE IMMEDIATE 5 36
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

747 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

13 Experts available now in Live!

Get 1:1 Help Now