Chapter 3 Preparing the Database Environment

Identifying the Tools for Administering an Oracle Database
The Oracle Universal Installer, OUI
The OUI inventory
The Prerequisite Tests: oraparam.ini also specify location of the products.xml
Product requirement: refhost.xml

Database Creation and Upgrade Tools
DBCA
DBUA

Tools for Issuing Ad hoc SQL
SQL Plus
SQL Developer (Need not be installed with OUI, self-contained product, require JRE)

Oracle Enterprise Manager
Database Control installed in Oracle Home consist of Java process monitoring a port for incoming http requests.

Other Administration Tools
Oracle Net Manager, Oracle Net Configuration Assistant
Import, Export, Datapump (impdp, expdp), SQL Loader

Backup Utilities
Recovery Manager, RMAN
Oracle Secure Backup: backing up entire environment

Plan an Oracle Database Installation
1. Choice of Operating System
2. Hardware and Operating System Resources

Optimal Flexible Architecture
ORACLE_BASE: e.g.: D:\app\Administrator
ORACLE_HOME: e.g.: D:\app\Administrator\product\11.1.0\db_1
Database (datafiles): e.g.: D:\app\Administrator\oradata\dbname
control01.ctl,control02.ctl,redo01.log,redo02.log,system01.dbf,system02.dbf

Environment Variables:
ORACLE_BASE
ORACLE_HOME
ORACLE_SID
PATH
LB_LIBRARY_PATH (Linux, Unix)
DISPLAY (Linux, Unix)


Install the Oracle Software by Using the OUI
runInstaller.sh -ignoreSysPrereqs
runInstaller.sh -record -destinationFile responsefilename
runInstaller.sh -silent -reponsefile responsefilename