jueves, 12 de junio de 2008

ORACLE Database 10g Variables de Ambiente


OFA OPTIMAL FLEXIBLE ARQUITECTURE

What is OFA The OFA standard is a series of recommendations for naming files and folders when installing and implementing an Oracle database. The official OFA advice can be found in the manuals at docs.oracle.com (for 9i - Administering Oracle, for 10g - Installing Oracle)

Ejemplo 1

vi .profile

# Oracle Settings
umask 022
TMP=/tmp;
export TMPTMPDIR=$TMP;
export TMPDIR
ORACLE_BASE=/u01/app/oracle;
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0;
export ORACLE_HOME
#ORACLE_SID=
export ORACLE_SID
ORACLE_TERM=xterm;
export ORACLE_TERM
PATH=/usr/sbin:$PATH:/export/home/oracle;
export PATH=$ORACLE_HOME/bin:$PATH;
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export CLASSPATH


vi .profile


Ejemplo 2

HOME=/export/home/oracle
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/lib:/lib:/usr/lib
LOGNAME=oracleMAIL=/var/mail/oracle
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0
ORACLE_SID=BDDWSGRD
ORACLE_TERM=xtermPATH=/u01/app/oracle/product/10.2.0/bin:/usr/sbin:/usr/bin::/export/home/oracle
SHELL=/bin/sh
TERM=vt100
TMP=/tmp
TMPDIR=/tmp
TZ=America/Bogota