.profile和dbca_raw_config设置

最新推荐文章于 2021-09-20 22:16:40 发布

原创最新推荐文章于 2021-09-20 22:16:40 发布 · 785 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#.profile #dbca_raw_config #裸设备 #数据文件 #AIX

oracle配置专栏收录该内容

5 篇文章

订阅专栏

本文介绍了在AIX操作系统环境下配置Oracle 10g及11g数据库的具体步骤，包括环境变量设置、路径定义、库文件路径配置等关键信息，并提供了用于快速创建数据库的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:/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'"$ "

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

ballontt
2014/03/26

---The End---

微博： weibo.com/ballontt

如需转载，请标明出处和链接，谢谢！

.profile和dbca_raw_config设置

ballontt 2014/03/26

ballontt
2014/03/26