CentOS7安装Oracle11g

HUC-WFX 17小时前 ⋅ 28 阅读

一、准备工作 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 `