1.1关闭防火墙 systemctl stop firewalld systemctl disable firewalld 1.2禁用NetworkManager服务 systemctl stop NetworkManager systemctl disable NetworkManager 1.3禁用SELINUX setenforce 0 sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/’ /etc/selinux/config (备注: 关闭selinux 查看selinux状态:getenforce 或者sestatus -v 临时关闭:[root@oracledb ~] setenforce 0 永久关闭:[root@oracledb ~] vim /etc/selinux/config 设置SELINUX=disabled) 1.4 配置HOSTS解析 vi /etc/hosts
1.5安装jdk cd /usr/local mkdir java cd java tar -zxvf jdk-8u261-linux-x64.tar.gz
vi /etc/profile 添加如下内容:
source /etc/profile java -version
1.6创建用户以及组 groupadd oper groupadd dba groupadd asmdba groupadd backupdba groupadd dgdba groupadd kmdba groupadd racdba groupadd oinstall useradd oracle passwd oracle usermod -g oinstall -G oper,dba,asmdba,backupdba,dgdba,kmdba,racdba oracle 1.7创建安装目录并赋权 mkdir -p /home/u01/app/oracle/product/19.3.0/dbhome_1/ mkdir -p /home/u01/app /oraInventory chmod +755 -R /home/u01/app / chown -R oracle:oinstall /home/u01/ 1.8配置环境变量 su – oracle vi .bash_profile export ORACLE_SID=orcl export ORACLE_BASE=/u19/app/oracle export ORACLE_HOME= O R A C L E B A S E / p r o d u c t / 19.3.0 / d b h o m e 1 e x p o r t P A T H = ORACLE_BASE/product/19.3.0/dbhome_1 export PATH= ORACLEBASE/product/19.3.0/dbhome1exportPATH=PATH: O R A C L E H O M E / b i n e x p o r t L D L I B R A R Y P A T H = ORACLE_HOME/bin export LD_LIBRARY_PATH= ORACLEHOME/binexportLDLIBRARYPATH=LD_LIBRARY_PATH: O R A C L E H O M E / l i b e x p o r t C L A S S P A T H = ORACLE_HOME/lib export CLASSPATH= ORACLEHOME/libexportCLASSPATH=ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export LANG=zh_CN.UTF-8 export NLS_LANG=‘AMERICAN_AMERICA.AL32UTF8’ #解决sqlplus 上下键,删除键乱码问题。需要安装rlwrap,依赖包readlines,libtermcap-devel alias sqlplus=‘rlwrap sqlplus’ alias rman=‘rlwrap rman’ alias lsnrctl=‘rlwrap lsnrctl’ 使用配置生效: source .bash_profile 1.9配置LIMITS限制参数 vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 1.10修改系统内核参数sysctl.conf文件 vi /etc/sysctl.conf net.ipv4.ip_forward = 0 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmax = 68719476736 kernel.shmall = 4294967296 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.file-max= 6815744 fs.aio-max-nr = 1048576 启用新的配置文件信息 sysctl -p
二、安装需要的rpm包2.1查询是否安装如下依赖包: rpm -q bc binutils cpp compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel gcc gcc-c++ glibc glibc-devel ksh kmod kmod-libs libaio libaio-devel libgcc libstdc++ libstdc+±devel make sysstat unixODBC 2.2无网环境需要用rpm安装: rpm -ivh (安装缺少的rpm包) rpm -Uvh(升级需要升级的包) rpm -Uvh *.rpm --nodeps –force(强力安装)
备注: compat-libstdc++安装后即使安装后显示未安装也没关系
三、安装软件3.1解压数据库软件 su – oracle unzip -q LINUX.X64_193000_db_home.zip -d $ORACLE_HOME 3.2生成响应文件 O R A C L E H O M E / i n s t a l l . r s p 备 注 : 应 答 文 件 的 参 考 位 置 在 ORACLE_HOME/install.rsp 备注:应答文件的参考位置在 ORACLEHOME/install.rsp备注:应答文件的参考位置在ORACLE_HOME/install/response/下 vim $ORACLE_HOME/install.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/home/u01/app/oraInventory ORACLE_BASE=/home/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba oracle.install.db.rootconfig.executeRootScript=false oracle.install.db.rootconfig.configMethod=ROOT 3.3静默安装 sh $ORACLE_HOME/runInstaller -silent -noconfig -force -ignorePrereq -responseFile $ORACLE_HOME/install.rsp 提示如下内容则表示成功: Successfully Setup Software with warning(s). 3.4执行脚本 su - root sh /u19/app/oraInventory/orainstRoot.sh sh /u19/app/oracle/product/19.3.0/dbhome_1/root.sh
四、创建实例4.1 .配置响应文件 O R A C L E H O M E / d b c a . r s p 备 注 : 配 置 项 可 参 考 ORACLE_HOME/dbca.rsp 备注:配置项可参考 ORACLEHOME/dbca.rsp备注:配置项可参考ORACLE_HOME/assistants/dbca/dbca.rsp) responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0 gdbName=orcl sid=orcl sysPassword=Egis_2016 oracleHomeUserPassword=Egis_2016 emExpressPort=5500 totalMemory=4096 4.2配置实例 $ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile $ORACLE_HOME/dbca.rsp
五、创建监听4.1 .配置响应文件 O R A C L E H O M E / n e t c a . r s p 备 注 : 配 置 项 可 参 考 ORACLE_HOME/netca.rsp 备注:配置项可参考 ORACLEHOME/netca.rsp备注:配置项可参考ORACLE_HOME/assistants/netca/netca.rsp)
[GENERAL] RESPONSEFILE_VERSION=“19.3” CREATE_TYPE=“CUSTOM” [oracle.net.ca] INSTALLED_COMPONENTS={“server”,“net8”,“javavm”} INSTALL_TYPE="“typical”" LISTENER_NUMBER=1 LISTENER_NAMES={“LISTENER”} LISTENER_PROTOCOLS={“TCP;1521”} LISTENER_START="“LISTENER”" NAMING_METHODS={“TNSNAMES”,“ONAMES”,“HOSTNAME”} NSN_NUMBER=1 NSN_NAMES={“EXTPROC_CONNECTION_DATA”} NSN_SERVICE={“PLSExtProc”} NSN_PROTOCOLS={“TCP;HOSTNAME;1521”}
4.2配置监听 $ORACLE_HOME/bin/netca -silent -responsefile $ORACLE_HOME/netca.rsp