centos 6.5下安装oracle 11gR2与Oracle自动启动的配置

wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle --no-check-certificate

yum install oracle-rdbms-server-11gR2-preinstall

vi /etc/sysconfig/networkNETWORKING=yesHOSTNAME=oracle.buzheng.org

vi /etc/hosts192.168.1.15 oracle.buzheng.org oracle

[root@oracle ~]# passwd oracle更改用户 oracle 的密码 。新的 密码：重新输入新的 密码：passwd： 所有的身份验证令牌已经成功更新。

[root@oracle ~]# vi /etc/security/limits.d/90-nproc.conf# Default limit for number of user's processes to prevent# accidental fork bombs.# See rhbz #432903 for reasoning.*   soft nproc  1024root  soft nproc  unlimited*   -  nproc  16384

[root@oracle ~]# vi /etc/selinux/config# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:#  enforcing - SELinux security policy is enforced.#  permissive - SELinux prints warnings instead of enforcing.#  disabled - No SELinux policy is loaded.SELINUX=permissive# SELINUXTYPE= can take one of these two values:#  targeted - Targeted processes are protected,#  mls - Multi Level Security protection.SELINUXTYPE=targeted

[root@oracle]# reboot

[root@oracle]# mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1[root@oracle]# chown -R oracle:oinstall /u01[root@oracle]# chmod -R 775 /u01

[root@oracle]# xhost + # 要在主机上运行，不能是远程 shell

[root@oracle]# su oracle[oracle@oracle]# vi .bash_profile# Oracle SettingsTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIRORACLE_HOSTNAME=oracle.buzheng.org; export ORACLE_HOSTNAMEORACLE_UNQNAME=orcl; export ORACLE_UNQNAMEORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOMEORACLE_SID=orcl; export ORACLE_SIDPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH export PATH

linux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zip

unzip linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_2of2.zipcd database./runInstaller

export LANG=en_US./runInstaller

[root@oracle ~]# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.

[root@oracle ~]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh Running Oracle 11g root.sh script...The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1Enter the full pathname of the local bin directory: [/usr/local/bin]:  Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.

ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initDB11G.ora'

SID_LIST_LISTENER =  (SID_LIST=  (SID_DESC =  (SID_NAME = orcl)  (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) ) )

iptables -I INPUT 4 -m state --state NEW -p tcp --dport 1521 -j ACCEPTservice iptables saveservice iptables reload

[root@oracle ~]# vi /etc/oratab## This file is used by ORACLE utilities. It is created by root.sh# and updated by the Database Configuration Assistant when creating# a database.# A colon, ':', is used as the field terminator. A new line terminates# the entry. Lines beginning with a pound sign, '#', are comments.## Entries are of the form:#  $ORACLE_SID:$ORACLE_HOME:<N|Y>:## The first and second fields are the system identifier and home# directory of the database respectively. The third filed indicates# to the dbstart utility that the database should , "Y", or should not,# "N", be brought up at system boot time.## Multiple entries with the same $ORACLE_SID are not allowed.##orcl:/u01/app/oracle/product/11.2.0/dbhome_1:Y

#!/bin/sh# chkconfig: 345 61 61# description: Oracle 11g R2 AutoRun Servimces# /etc/init.d/oracle## Run-level Startup script for the Oracle Instance, Listener, and# Web InterfaceORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1"ORA_OWNR="oracle"# if the executables do not exist -- display errorif [ ! -f "$ORACLE_HOME/bin/dbstart" ]thenecho "Oracle startup: cannot start"exit 1fi# parameter: start, stop, restartcase "$1" instart)# Oracle listener and instance startupsu $ORA_OWNR -s /bin/bash $ORACLE_HOME/bin/dbstart $ORACLE_HOMEecho "Oracle Start Succesful!OK.";;stop)# Oracle listener and instance shutdownsu $ORA_OWNR -s /bin/bash $ORACLE_HOME/bin/dbshut $ORACLE_HOMEecho "Oracle Stop Succesful!OK.";;restart)$0 stop$0 start;;*)echo $"Usage: `basename $0` {start|stop|restart}"exit 1esacexit 0

# chmod 750 /etc/init.d/oracle# ln -s /etc/init.d/oracle /etc/rc1.d/K61oracle# ln -s /etc/init.d/oracle /etc/rc3.d/S61oracle

service oracle startservice oracle stopservice oracle restart

# chkconfig --add oracle# chkconfig --level 345 oracle on