一、准备工作
1、关闭防火墙和SELINUX
[root@oracle-db]#systemctl stop firewalld [root@oracle-db]#vim /etc/selinux/config
#将SELINUX=active改为SELINUX=disabled,保存退出
2、修改系统标识
[root@oracle-db]# vim /etc/redhat-release
改为redhat-7,保存退出
3、创建用户组
1.[root@oracle-db]# groupadd oinstall 2.[root@oracle-db]# groupadd oracle 3.[root@oracle-db]# useradd -g oinstall -G oracle -m oracle 4.[root@oracle-db]# passwd oracle
4、创建Oracle安装目录、配置文件目录(授权等操作)
1.[root@oracle-db]# mkdir -p /data/oracle 2.[root@oracle-db]# mkdir -p /data/oraInventory 3.[root@oracle-db]# mkdir -p /data/database 4.[root@oracle-db]# cd /data 5.[root@oracle-db]# ls database oracle oraInventory 6.[root@oracle-db]# chown -R oracle:oinstall /data/oracle 7.[root@oracle-db]# chown -R oracle:oinstall /data/oraInventory 8.[root@oracle-db]# chown -R oracle:oinstall /data/database
5、安装Oracle所需资源包
yum install glibc* gcc* make* compat-db* libstdc* libXp* libXtst* compat-libstdc++* -y
yum install libXp.i686 libXp-devel.i686 libXt.i686 libXt-devel.i686 libXtst.i686 libXtst-devel.i686 make.x86_64 gcc.x86_64 libaio.x86_64 glibc-devel.i686 libgcc.i686 glibc-devel.x86_64 compat-libstdc++-33 -y
yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.i686 elfutilslibelf-devel gcc gcc-c++ glibc*.i686 glibc glibc-devel glibc-devel*.i686 ksh libgcc*.i686 libgcc libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.i686 libaio libaio*.i686 libaio-devel libaio-devel*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBCdevel*.i686 libXp
6、修改内核相关参数 1.
[root@oracle-db]# vim /etc/sysctl.conf
#添加以下内容
fs.aio-max-nr = 1048576 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
2.[root@oracle-db]# sysctl -p //使之生效
7、限制oracle用户提升性能
1.[root@oracledb]# vim /etc/security/limits.conf #添加以下内容: oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
8、配置Oracle环境变量
export ORACLE_BASE=/data/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 export ORACLE_SID=orcl export ORACLE_TERM=xterm export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export NLS_LANG=AMERICAN_AMERICA.UTF8 export LC_ALL=C
9、解压文件 uzip
10、开始图形安装 10-1、去除oracle支持
10-2、安装数据库
10-3、单例安装
10-4、选择语言(默认英文)
10-5、选择安装企业版
10-6、配置安装目录
10-7、配置Ora目录
10-8、选择选择group 组为之前创建好的oracle
10-9、检查兼容相关
10-10、选择 Ignore All
10-11、跳过警告检查
netca 配置监听 DBCA 配置数据库 Asdf-123 (密码)
自动启动配置文件 修改oratab vim /etc/oratab 找到: `orcl:/usr/oracle/product/11.2.0/db_1:N 修改为: orcl:/usr/oracle/product/11.2.0/db_1:Y 修改:将以下两个文件中的ORACLE_HOME_LISTNER=1$ vim /data/oracle/prodfouct/11.2.0/db_1/bin/dbstart vim /data/oracle/product/11.2.0/db_1/bin/dbshut 修改为ORACLE_HOME_LISTNER=$ORACLE_HOME “vim /etc/rc.d/rc.local” 在vim编辑器中,添加: su - oracle -lc "/data/oracle/product/11.2.0/db_1/bin/lsnrctl start" su - oracle -lc "/data/oracle/product/11.2.0/db_1/bin/bin/dbstart"
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
vim /data/oracle/product/11.2.0/db_1/network/admin/listener.ora SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME= orcl) (ORACLE_HOME=/data/oracle/product/11.2.0/db_1) (SID_NAME=orcl)))
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521)) ) )
vim /data/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.102.130)(PORT = 1521))) (CONNECT_DATA =(SID = orcl)))
sqlplus / as sysdba SQL> startup SQL> alter system register; SQL> quit lsntctl status `
注意:本文归作者所有,未经作者允许,不得转载