阿里云安装Oracle
#!/bin/bash
#writed by kangjie 2018-05-9
#########################################
#如果没有交换分区swap,则创建 #
#检查 Swap 空间
swapon -s
#创建并允许 Swap 文件
dd if=/dev/zero of=/swapfile bs=1024 count=512k
#格式化并激活 Swap 文件
mkswap /swapfile
#激活 Swap
swapon /swapfile
#以上步骤做完,再次运行命令:
#
swapon -s
#你会发现返回的信息概要:
#Filename Type Size Used Priority
#/swapfile file 524284 0 -1
#如果要机器重启的时候自动挂载 Swap ,那么还需要修改 fstab 配置。用 vim 打开 /etc/fstab 文件,在其最后添加如下一行:
# /swapfile swap swap defaults 0 0
#最后,赋予 Swap 文件适当的权限:
# chown root:root /swapfile
# chmod 0600 /swapfile
#########################################
#########################################
#install depending packages #
#########################################
yum install -y gcc* gcc-* gcc-c++-* glibc-devel-* glibc-headers-* compat-libstdc* libstdc* elfutils-libelf-devel* libaio-devel* sysstat* unixODBC-* pdksh-*
########################################
#add groups,user and create dir #
########################################
/usr/sbin/groupadd -g 501 oinstall
/usr/sbin/groupadd -g 502 dba
useradd -u 1000 -g oinstall -G dba oracle
mkdir -p /data/oracle/product/11.2.0
mkdir /data/oracle/oradata
mkdir /data/oracle/inventory
mkdir /data/oracle/fast_recovery_area
chown -R oracle:oinstall /data/oracle
chmod -R 775 /data/oracle
##############################################
#modify sysctl.conf #
##############################################
cat >> /etc/sysctl.conf <<done
fs.file-max = 6815744
kernel.shmall = 2097152
#kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
done
sysctl -p
###############################################
#modify /etc/security/limits.conf #
###############################################
cat >> /etc/security/limits.conf << done
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
done
################################################
#modify /etc/pam.d/login #
################################################
echo "session required pam_limits.so">>/etc/pam.d/login
################################################
# setting user oracle env #
################################################
cat >> /home/oracle/.bash_profile <<done
ORACLE_BASE=/data/oracle
ORACLE_HOME=/data/oracle/product/11.2.0
ORACLE_SID=orcl
PATH=$PATH:/data/oracle/product/11.2.0/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
done
########################
vim /etc/hosts
192.168.206.135 CentOS
# 增加HOSTNAME到 /etc/hosts 文件中
192.168.206.135 iZ3unv****
#########################
unzip linux.x64_11gR2_database_1of2.zip && unzip linux.x64_11gR2_database_2of2.zip
cd database/response/
cp db_install.rsp db_install.rsp.bak
vim db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=CentOS
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/data/oracle/inventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/data/oracle/product/11.2.0
ORACLE_BASE=/data/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
DECLINE_SECURITY_UPDATES=true
##############33
#切换oracle用户 注意使用绝对路径
./runInstaller -silent -ignorePrereq -ignoreSysPrereqs -responseFile /home/pack/database/response/db_install.rsp
#切换root用户
/data/oracle/inventory/orainstRoot.sh
/data/oracle/product/11.2.0/root.sh
export DISPLAY=localhost:0.0
netca -silent -responseFile /home/pack/database/response/netca.rsp
netstat -tnulp | grep 1521
####################################
vim database/response/dbca.rsp
GDBNAME = "orcl"
SID = "orcl"
SYSPASSWORD = "oracle"
SYSTEMPASSWORD = "oracle"
SYSMANPASSWORD = "oracle"
DBSNMPPASSWORD = "oracle"
DATAFILEDESTINATION =/data/oracle/oradata
RECOVERYAREADESTINATION=/data/oracle/fast_recovery_area
CHARACTERSET = "ZHS16GBK"
TOTALMEMORY = "1638"
#建立新库,同时建立对应的实例
dbca -silent -responseFile /home/pack/database/response/dbca.rsp
########
create tablespace db_test datafile '/data/oracle/oradata/orcl/db_test.dbf' size 50m autoextend on;
select default_tablespace, temporary_tablespace, d.username from dba_users d
CREATE USER utest IDENTIFIED BY sd_123 DEFAULT TABLESPACE db_test TEMPORARY TABLESPACE temp;
GRANT CONNECT TO utest;
GRANT RESOURCE TO utest;
GRANT dba TO utest;
select * from dba_users;