.profile和dbca_raw_config设置

HP_10g： export PS1=`hostname`$[$PWD] umask 022 export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2/db export ORACLE_SID=ballontt export PATH=/usr/bin:/etc/:/usr/sbin:/usr/ucb:/usr/local/bin:$ORACLE_HOME/bin:/usr/bin/X11

HP_10g： export PS1=`hostname`$'[$PWD]' umask 022 export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2/db export ORACLE_SID=ballontt export PATH=/usr/bin:/etc/:/usr/sbin:/usr/ucb:/usr/local/bin:$ORACLE_HOME/bin:/usr/bin/X11:/sbin:$PATH export ORACLE_TERM=xterm export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib/:$ORACLE_HOME/network/jlib
AIX_10g： PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. export PATH if [ -s "$MAIL" ] # This is at Shell startup. In normal then echo "$MAILMSG" # operation, the Shell checks fi # periodically. export TERM=vt100 alias ll='ls -l' set -o vi if [ "$LOGNAME" = "root" ] then export PS1='$LOGNAME'@"$(hostname)":'$PWD'"# " else export PS1='$LOGNAME'@"$(hostname)":'$PWD'"$ " fi export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORA_CRS_HOME=$ORACLE_BASE/crs export ORACLE_SID=ballontt export ORACLE_TERM=xterm export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib/:$ORACLE_HOME/network/jlib export PATH=$ORACLE_HOME/jdk/bin:$PATH:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/usr/ccs/bin:$ORACLE_HOME/OPatch umask 022 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export AIXTHREAD_SCOPE=S export TEMP=/tmp export TMP=/tmp export TMPDIR=/tmp export PATH=/oracle/ph:$PATH
AIX_11g： oracle用户： PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. #export PATH if [ -s "$MAIL" ] # This is at Shell startup. In normal then echo "$MAILMSG" # operation, the Shell checks fi # periodically. set -o vi export TMOUT=0 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORACLE_UNQNAME=ballontt export ORACLE_SID=ballontt1 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export OPATCH=$ORACLE_HOME/OPatch LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/share/lib CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/jdbc/lib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib PATH=$PATH:$ORACLE_HOME/bin:$OPATCH export CLASSPATH export LD_LIBRARY_PATH export PATH
grid用户： PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. #export PATH if [ -s "$MAIL" ] # This is at Shell startup. In normal then echo "$MAILMSG" # operation, the Shell checks fi # periodically. export TMOUT=0 set -o vi export ORACLE_SID=+ASM1 export ORACLE_BASE=/u01/app/grid export ORACLE_HOME=/u01/app/11.2.0/grid export OPATCH=$ORACLE_HOME/OPatch LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/share/lib CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/jdbc/lib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib PATH=$PATH:$ORACLE_HOME/bin:$OPATCH export LD_LIBRARY_PATH export CLASSPATH export PATH
dbca_raw_config设置： oracle@sbddb1:/oracle$ cat dbca_raw_config system=/dev/rsystem01_4g sysaux=/dev/rsysaux01_4g users=/dev/ruser01_1 temp=/dev/rtemp01_5g undotbs1=/dev/rundotbs1_10g undotbs2=/dev/rundotbs2_10g control1=/dev/rcontrol1_128m control2=/dev/rcontrol2_128m control3=/dev/rcontrol3_128m .profile中设置如下环境变量 export DBCA_RAW_CONFIG=/oracle/dbca_raw_config