Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 3. PREPARING THE DATABASE ENVIRONMENT (3.01 Identify the Tools for…
Chapter 3. PREPARING THE DATABASE ENVIRONMENT
3.01 Identify the Tools for Administering an Oracle Database (115)
The Oracle Universal Installer (116)
The OUI Inventory
Set of files that exists outside any Oracle Home
LINUX: /etc/oraInst.loc
SOLARIS: /var/opt/oracle/oraInst.loc
WINDOWS: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc
When the OUI starts, it will look for this file. If it does not exist, OUI will create the file (registry key) and write to it the location of the new inventory.
Need permission to write the appropriate directory
If not it will generate the script to be run by the root user that will create the oraInst.loc
Store details of all the Oracle products installed on the machine
Exact version
The location
Details of patches
The Prerequisite Test
Running the OUI
Database Creation and Upgrade Tools
DBCA (Database Configuration Assistant) - Creating a database
Tools for Issuing Ad Hoc SQL: SQL*Plus and SQL Developer
SQL*Plus
Environment Variables
ORACLE_HOME
PATH
Include
bin
directory in the ORACLE_HOME
LD_LIBRARY_PATH
Include the
lib
directory in the ORACLE_HOME
SQL Developer
Need not to be installed with the OUI
Unzip the ZIP file and require JDK1.5
Oracle Enterprise Manager
Manage one database
Each instance will be accessible through Database Control on different port
Other Administration Tools
Oracle Net Manager, Oracle Net Configuration Assistant
Data Loading and Unloading Utilities
Backup Utilities
Plan an Oracle Database Installation (131)
Optimal Flexible Architecture
A
file system directory
structure that should make maintaining
multiple version
of
multiple
Oracle products
ORACLE_BASE
One directory on the server, beneath which all the Oracle software
Structure:
/pm/h/u
p
: string constant (such as u)
m
: numeric constant (such as 01)
h
: standard directory (such as app)
u
: OS account that will own all the Oracle software
Ex
: /u01/app/oracle
ORACLE_HOME
Each version of each product will then have its own ORACLE_HOME, beneath ORACLE_HOME
Structure:
$ORACLE_BASE/product/v/db_n
v
: release number of the product (such as 11.2.0)
db_n
: name derived by the installer based on which product it is (such as db), and an incrementing number for each installation (such as 1)
Ex
: /u01/app/oracle/product/11.2.0/db_1
Install the Oracle Software by Using the Oracle Universal Installer (OUI) (139)