oracle10gsetup建库,CentOS 下 Oracle 10g 安装 + 配置全过程图解

# 挂载CentOS系统安装光盘

dvdFile="//FileServerIp/Share/CentOS-5.5-x86_64-bin-DVD.iso"

dvdDir="/mnt/CentOS_Final"

mount -t iso9660 -o loop"${dvdFile}" "${dvdDir}"

# 将安装光盘添加到安装源

cat >> /etc/yum.repos.d/CentOS-Media.repo<<_yumsource>

[AutoInstaller]

name=CentOS-$releasever - Media

baseurl=file:///mnt/CentOS_Final/

gpgcheck=0

enabled=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

_yumSource

# 使用光盘作安装源，安装依赖库

yum -y --disablerepo=\*--enablerepo=AutoInstaller --nogpgcheck --skip-broken install compat-db* compat-gcc* libXp.so.6 libc-* libaio* openmotif glibc-devel* libgcc* gnome-lib* libXtst vnc-server xterm xorg-x11-twm gcc make binutils openmotif setarch compat-libstdc++ compat-libstdc++-devel

# 创建安装目录，解压安装包

mkdir -p /data/setupfiles/Oracle /data/oracle

cd/data/setupfiles/Oracle/

zcat /mnt/Oracle/10201_database_linux_x86_64.cpio.gz | cpio -idmv

# 添加用户，设定用户密码

/usr/sbin/groupadd oinstall

/usr/sbin/groupadd dba

/usr/sbin/useradd -m -g oinstall -G dba oracle -d /data/oracle/home

id oracle

passwd oracle

# 初始化安装目录

mkdir -p /data/oracle/app /data/oracle/data

chown -R oracle:oinstall /data/oracle/app /data/oracle/data

chmod -R 775 /data/oracle/app /data/oracle/data

# 设置oracle用户的环境变量

vim ~oracle/.bash_profile

LANG=UTF-8

ORACLE_SID=orcl

ORACLE_BASE=/data/oracle/app

ORACLE_HOME=/data/oracle/home

JAVA_HOME=$ORACLE_HOME/jdk

PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

LD_LIBRARY_PATH=$ORACLE_HOME/lib

exportLANG ORACLE_SID ORACLE_BASE ORACLE_HOME JAVA_HOME PATH LD_LIBRARY_PATH

# 配置VNC登录选项，Oracle安装需要使用界面

vim /etc/sysconfig/vncservers

VNCSERVERS="0:oracle"

VNCSERVERARGS[2]="-geometry 1280x1024 -nolisten tcp -nohttpd -localhost"

su - oracle

vncserver

logout

vncserver -kill :1

service vncserver start

# 由于Oracle未对CentOS作支持，改用RedHat标识

vim /etc/redhat-release

Red Hat Enterprise Linux AS release 3(higkoo)

# 修改内核参数

vim /etc/sysctl.conf

kernel.shmall=4294967296

kernel.shmmax=68719476736

kernel.shmmni=4096

kernel.sem=250 32000 100 128

fs.file-max=65536

net.ipv4.ip_local_port_range=1024 65000

sysctl -p

# 修改Oracle用户环境

vim /etc/security/limits.conf

oracle               soft    nproc   2047

oracle               hard    nproc   16384

oracle               soft    nofile 1024

oracle               hard    nofile 65536