Oracle官方安装经典文档
1.检查系统包是否已经安装。rpm -q grep binutils-2.* elfutils-libelf-0.* glibc-2.* glibc-common-2.* libaio-0.* libgcc-4.* libstdc+-4.* make-3.* compat-libstdc+-33 elfutils-libelf-devel-0.* glibc-devel-2.* gcc-4.* gcc-c+-4.* libaio-devel-0.* libstdc+-devel-4.* unixODBC-2.* unixODBC-devel-2.* sysstat-7.*2.如缺少相应的补丁包,可以到系统安装盘安装相关的补丁包cd /media/Enterprise Linux dvd 20090127/Server/rpm -Uvh grep binutils-2.*rpm -Uvh elfutils-libelf-0.*rpm -Uvh glibc-2.*rpm -Uvh glibc-common-2.*rpm -Uvh libaio-0.*rpm -Uvh libgcc-4.*rpm -Uvh libstdc+-4.*rpm -Uvh make-3.*rpm -Uvh compat-libstdc+-33rpm -Uvh elfutils-libelf-devel-0.*rpm -Uvh glibc-devel-2.*rpm -Uvh gcc-4.*rpm -Uvh gcc-c+-4.*rpm -Uvh libaio-devel-0.*rpm -Uvh libstdc+-devel-4.*rpm -Uvh unixODBC-2.*rpm -Uvh unixODBC-devel-2.*rpm -Uvh sysstat-7.*3.添加oracle组和用户(Oracle Enterprise Linux默认把oracle的用户创建完了,这一步骤可以省略)# groupadd oinstall -g 501# groupadd dba -g 502# groupadd oper -g 503# useradd oracle -u 500 -g oinstall -G dba,oper# passwd oracle输入密码:oracle4.修改参数文件 sysctl.conf# cat >> /etc/sysctl.conf << EOFkernel.sem=1055 32000 100 128kernel.shmmax=2147483648kernel.shmall = 2097152net.ipv4.tcp_sack = 0net.ipv4.tcp_timestamps = 0net.ipv4.conf.default.rp_filter = 0net.core.optmem_max = 65535net.core.rmem_default = 4194304net.core.wmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_max = 262144fs.file-max = 6553600net.ipv4.ip_local_port_range = 1024 65000EOF5.以下命令加载sysctl.conf文件中的内容,检查参数值是否正确设定。# /sbin/sysctl -p6.修改参数文件limits.conf# cat >> /etc/security/limits.conf << EOF* soft nproc 2047* hard nproc 16384* soft nofile 1024* hard nofile 65536EOF7.修改参数文件login# cat >> /etc/pam.d/login << EOFsession required /lib/security/pam_limits.sosession required pam_limits.soEOF8.修改参数文件config# vi /etc/selinux/config注销其他的,仅留下面的内容SELINUX=disabledSELINUXTYPE=disabled9.创建安装目录# mkdir -p /oracle/u01/app/oracle/product/1101/db# mkdir -p /oracle/u02/oradata# chown -R oracle:oinstall /oracle# chmod -R 775 /oracle10.确认系统版本号rootRHEL53 /# cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.3 (Carthage)Kernel r on an mrootRHEL53 /# cat /etc/redhat-releaseRed Hat Enterprise Linux Server release 5.3 (Tikanga)11.修改oracle的环境变量.bash_profile# su - oracle$ vi /.bash_profile# Oracle Settings#export ORA_NLS10=$ORACLE_HOME/nls/dataexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_BASE=/oracle/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/1101/dbexport ORACLE_SID=ora11gexport ORACLE_TERM=xtermexport PATH=$PATH:$ORACLE_HOME/bin:/sbin:/usr/sbinexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNELif $USER = "oracle" ; then if $SHELL = "/bin/ksh" ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022fi# Shell setting.#umask 022set -o vi# stty erase Hexport PS1="$ORACLE_SIDhostname $PWD$ "export SQLPATH=/home/oracle/sql# auto add env parameter $PROMPT_COMMAND when use non-Linux tty login by ssh.if "$SSH_CONNECTION" != ; then export HOSTIP=echo $SSH_CONNECTION |awk print $3 |awk -F: if ($1 = "") print $4; else print $1 export PROMPT_COMMAND=echo -ne "0330;$USER$HOSTIP:$HOSTNAME%.*:$PWD/#$HOME/ 007"fi# Oracle Alias#alias base=cd $ORACLE_BASEalias home=cd $ORACLE_HOMEalias alert=tail -200f $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace/alert_$ORACLE_SID.logalias tnsnames=vi $ORACLE_HOME/network/admin/tnsnames.ora12.访问控制列表调整# xhost +13.上传并解压相关安装介质$ unzip linux_11gR1_database_1013.zip14.图形化界面安装数据库软件11g版本# su - oracle$ cd database$ ./runInstaller.sh选择高级安装Advanced Installation选择Custom安装选定perform. type configurationCustom Database执行两个脚本# cd /oracle/u01/app/oraInventory/# ./orainstRoot.sh# cd /oracle/u01/app/oracle/product/1101/db/# ./root.sh15.netca配置监听器及本地命名模式# su - oracle$ netca16.DBCA创建数据库# su - oracle$ dbca1).welcome界面,点击“Next”2).选择Create a Database,点击“Next”3).选择Custom Database,点击“Next”4).Global Database Name输入ora