Optimal Flexible Architecture
Directory structure
Three sets of directories
* One for Oracle binary files
* One for control files, redo log files, other admin files
* One for data files
Naming scheme
Mount points: /pm
* p: literal; m: variable
Examples
* /u01 /u02 /u03
* /ora01 /ora02 /ora03
Oracle install directory: /pm/h/u/product/v
* h: purpose; u: user; v: version
Examples
* /u02/db/oracle/product/10.1.0
* /u01/app/oracle/product/9.0.4
Admin directory: /pm/h/admin/d/a
* d: sid; a: subdirectory (adhoc, arch, adump, bdump, cdump, create, exp, logbook, pfile, udump
Examples
* /u02/db/admin/orcl/create
File naming convention
Root directory: /pm/q/d
* q: literal, d: db name or sid
Examples
* /u03/oradata/ocp10g
Files
* Control files: controlnn.ctl (control01.ctl)
* Redo log files: redonn.log (redo01.log)
* Data files: tablespacenn.dbf (system01.dbf, undo01.dbf)
Install
Create User and Group
Unix/Linux
* User: oracle
* Groups: oinstall, dba
groupadd -g 500 oinstall groupadd -g 501 dba useradd -u 500 -g oinstall -G dba -d /home/oracle oracle -s /bin/bash
Windows
* User: any user belong to Admin group
* Group: ORA_DBA
Set Environment Variables
* ORACLE_BASE (/opt/oracle)
* ORACLE_HOME ($ORACLE_BASE/product/10.1.0)
* ORACLE_SID (ORCL)
* NLS_LANG (American_America.US7ASCII)
* DISPLAY (db1.my.com:1.0)
Oracle Universal Installer
Command
* Unix:
– runInstaller
– runInstaller -parameterFile /home/oracle/oraparam.ini
* Windows: setup.exe
Features
* Dependency checking (to disable: runInstaller -ignoreSysPrereqs)
* Multiple Oracle home support
* National language/globalization support
* Web based installation (??)
* Unattended installation
runInstaller -responsefile respfile [-silent] [-nowelcome]
* Uninstall
* Support for user defined packages
Install
* Specify database file storage option:
– Local file system
– Automatic storage management (ASM)
– Raw devices
Post install
# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/opt/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.1.0/orcl; export ORACLE_HOME ORACLE_SID=ORCL; export ORACLE_SID PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL ulimit -u 16384 -n 65536