OS:Oracle Linux 6.6 64bit
DB:11.2.0.4
为服务器创建LVM,分别存放Oracle_HOME, Data, FRA
安装RPM
在Oracle Linux 6中,只需要一条命令即可安装所有Oracle需要的RPM包
接下来,
IP地址,DNS,主机名,/etc/hosts
组和用户
创建必需的目录
oracle用户环境变量
vi /etc/pam.d/login
增加一行
vi /etc/profile
配置用户资源限制
依次运行
runInstaller
netca
dbca
DB:11.2.0.4
为服务器创建LVM,分别存放Oracle_HOME, Data, FRA
点击(此处)折叠或打开
-
pvcreate /dev/sdb
-
pvcreate /dev/sdc
-
-
vgcreate vg00 /dev/sdb /dev/sdc
-
-
lvcreate -L 30G -n orahome vg00
-
lvcreate -L 40G -n oradata vg00
- lvcreate -L 50G -n fra vg00
-
- mke2fs -t ext4 /dev/vg00/orahome
- mke2fs -t ext4 /dev/vg00/oradata
-
mke2fs -t ext4 /dev/vg00/fra
在Oracle Linux 6中,只需要一条命令即可安装所有Oracle需要的RPM包
点击(此处)折叠或打开
- yum -y install oracle-rdbms-server-11gR2-preinstall
IP地址,DNS,主机名,/etc/hosts
组和用户
点击(此处)折叠或打开
-
#只需要创建oper组
-
groupadd oper
-
- usermod -g oinstall -G dba,oper oracle
- passwd oracle
点击(此处)折叠或打开
-
mkdir -p /u01/app/oracle
-
chown -R oracle:oinstall /u01 /oradata /fra
- chmod -R 775 /u01 /oradata /fra
点击(此处)折叠或打开
-
# Oracle env settings
-
export TMP=/tmp
-
export TMPDIR=$TMP
-
export ORACLE_BASE=/u01/app/oracle
-
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
-
export ORACLE_SID=red
-
export ORACLE_PATH=/u01/app/oracle/common/oracle/sql
-
export ORACLE_TERM=xterm
-
export TNS_ADMIN=$ORACLE_HOME/network/admin
-
export PATH=$ORACLE_HOME/bin:${JAVA_HOME}/bin:/u01/app/common/oracle/bin:$PATH:/usr/local/sbin:/usr/local/bin
-
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:$ORACLE_HOME/ctx/lib:/lib:/usr/lib:/usr/local/lib
-
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
-
export SQLPATH=~/admin/sql:$ORACLE_HOME/sqlplus/admin
-
export LANG="en_US.UTF-8"
-
export NLS_LANG='american_america.zhs16gbk'
- export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
增加一行
点击(此处)折叠或打开
- session required /lib64/security/pam_limits.so
点击(此处)折叠或打开
-
if [ $USER = "oracle" ]; then
-
if [ $SHELL = "/bin/ksh" ]; then
-
ulimit -p 16384
-
ulimit -n 65536
-
else
-
ulimit -u 16384 -n 65536
-
fi
- fi
点击(此处)折叠或打开
-
# Oracle-Validated setting for nofile soft limit is 131072
-
oracle soft nofile 131072
-
-
# Oracle-Validated setting for nofile hard limit is 131072
-
oracle hard nofile 131072
-
-
# Oracle-Validated setting for nproc soft limit is 131072
- oracle soft nproc 131072
-
-
# Oracle-Validated setting for nproc hard limit is 131072
-
oracle hard nproc 131072
-
-
# Oracle-Validated setting for core soft limit is unlimited
- oracle soft core unlimited
-
-
# Oracle-Validated setting for core hard limit is unlimited
-
oracle hard core unlimited
-
-
# Oracle-Validated setting for memlock soft limit is 50000000
-
oracle soft memlock 50000000
-
-
# Oracle-Validated setting for memlock hard limit is 50000000
- oracle hard memlock 50000000
依次运行
runInstaller
netca
dbca
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22621861/viewspace-1691932/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22621861/viewspace-1691932/
本文详细介绍了在 Oracle Linux 6.6 64位系统上搭建 LVM 存储架构,并安装配置 Oracle 11g R2 数据库的过程。包括创建 LVM 卷组、安装必要的 RPM 包、设置 Oracle 用户环境变量及权限等关键步骤。

被折叠的 条评论
为什么被折叠?



