1.安装前准备
版本: oracle12c-12.1.0.2
下载链接:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=ocomen
Oracle 12C数据库文件:
linuxamd64_12102_database_1of2.zip
linuxamd64_12102_database_2of2.zip
#通过xftp,xshell,winscp上传到一个目录中
#因为只需将包解压到一个目录,后续删除两个压缩包,建议上传到 /tmp目录
#修改主机名和hosts文件
2.root用户配置
#检查所需的软件包
rpm -q binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel
#添加组和用户
groupadd oinstall #添加组oinstall
groupadd dba #添加组dba
useradd -g oinstall -G dba oracle 添加oracle用户附加组dba
echo “oracle”| passwd –stdin oracle 设置oracle用户的密码
3.修改内核参数
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 1717986918
kernel.shmmax = 2147483648 (不确定根据报错更改,RHEL7.2应该是4xxxxx)
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 = 1048586
#参数报错根据提示修改即可
sysctl-p 生效
sysctl -a
4.修改limits文件
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
5.修改pam.d/login
session required /lib/security/pam_limits.so
session required pam_limits.so
6.oracle用户配置
#设置环境变量
vi .bash_profile
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=oracle12c
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
echo "PATH=\$PATH:$HOME/bin:\$ORACLE_HOME/bin:\$ORACLE_HOME/lib:\$ORACLE_HOME/lib64" >>.bash_profile
echo -e "LD_LIBRARY_PATH=\$ORACLE_HOME/bin:/usr/bin" >>.bash_profile
echo -e "export ORACLE_HOME=\$ORACLE_BASE/product/12c" >>.bash_profile
#再次进入文件添加if语句
IF语句
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
source ~/.bash_profile 立即生效
7. 安装Oracle
rpm -q binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel
#重启计算机,以oracle用户登录,相关语言设置选择英语
进入database 执行./runInstaller
lsnrctl start 启动监听程序
sqlplus / as sysdba 连接数据库