0、下载oracle 11g的2个安装包,上传到服务器,并解压2个包在一个目录下(我的目录是/upload)
1、安装依赖包,如需离线安装,需部署本地源
yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc- gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++-devel make sysstat unixodbc unixodbc-devel pdksh
2、添加oracle用户
groupadd dba
groupadd oinstall
groupadd asmdba
groupadd asmadmin
useradd -g oinstall -g dba,asmdba,asmadmin oracle
3、建立oracle安装目录
mkdir -p /u01
chmod 777 -r /u01
4、编辑环境变量
vi /etc/profile
#----------------------------------------------
tmp=/tmp; export tmp
tmpdir=$tmp; export tmpdir
display=192.168.1.159:0.0;export display
oracle_hostname=oracle2; export oracle_hostname
oracle_base=/u01/app/oracle; export oracle_base
oracle_home=$oracle_base/product/11.2.0/db_1; export oracle_home
oracle_sid=orcl; export oracle_sid
oracle_unqname=orcl; export oracle_unqname
oracle_term=xterm; export oracle_term
export path=$oracle_home/bin:$path
export ld_library_path=$oracle_home/lib:$ld_library_path
if [ $user = "oracle" ]; then
if [ $shell = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
#-----------------------------------------------
5、执行安装
./runinstaller -silent -responsefile /upload/db_install.rsp -ignoresysprereqs -ignoreprereq
6、安装提成成功后在root用户下执行以下2句
as a root user, execute the following script(s):
1. /u01/app/oinventory/orainstroot.sh
2. /u01/app/oracle/product/11.2.0/db_1/root.sh
cd /u01/app/oracle/product/1.20/db_1/bin
dbca -silent -clonetemplate -gdbname orcl -sid orcl -datafiledestination /u01/oradata -responsefile /upload/db_create.rsp
7、启动数据库
拷贝/u01/app/oracle/admin/orcl/pfile/init.ora.8122014171937 改名为initorcl.ora到/u01/app/oracle/product/11.2.0/db_1/dbs
lsnrctl start
sqlplus / as sysdba
sql>startup
8关闭防火墙
service iptables stop
chkconfig --level 35 iptables off