oracle一键安装指南（linux）

文末有免登陆复制文本

1. 下载 LINUX.X64_193000_db_home.zip， 我们这里放到root根目录
3. 到root用户，创建oracle用户，密码设为oracle

4. useradd oracle
   passwd oracle

5. 在root用户，执行下面命令

6. groupadd oinstall
   groupadd dba
   groupadd oper
   usermod oracle -g oinstall -G dba,oper
   
   mkdir -p /home/oracle/oracle/product/19.3.0/db_1
   mkdir -p /home/oracle/oracle/ora_inventory
   
   # 解压安装包，注意安装包路径
   unzip -q LINUX.X64_193000_db_home.zip -d /home/oracle/oracle/product/19.3.0/db_1
   chown -R oracle:oinstall /home/oracle/oracle/
   
   
   echo "
   oracle soft nproc 2047
   oracle hard nproc 16384
   oracle soft nofile 1024
   oracle hard nofile 65536
   " >> /etc/security/limits.conf 
   
   echo "
   net.ipv4.icmp_echo_ignore_broadcasts=1
   net.ipv4.conf.all.rp_filter=1
   fs.file-max=655360
   fs.aio-max-nr=102400
   kernel.shmall=501024
   kernel.shmmax=1024024024
   kernel.shmmni=4096
   kernel.sem=250 32000 100 128
   net.ipv4.ip_local_port_range=9000 65535
   net.core.rmem_default=261024
   net.core.rmem_max=4121024
   net.core.wmem_default=261024
   net.core.wmem_max=4121024
   " >> /etc/sysctl.conf 
   
   sysctl -p
   
   systemctl stop firewalld.service 
   systemctl status firewalld.service 
   

7. 切换到oracle用户，执行下列命令

8. echo "
   export LANG=en_US.UTF-8
   export ORACLE_BASE=/home/oracle/oracle
   export ORACLE_HOME=/home/oracle/oracle/product/19.3.0/db_1
   export ORACLE_SID=oracledb
   export NLS_DATA_FORMAT=\"yyyy-mm-dd HH24:MI:SS\"
   export NLS_LANG=AMERICAN_AMERICA.UTF8
   export PATH=\$PATH:\$ORACLE_HOME/bin
   " >> ~/.bashrc 
   
   source ~/.bashrc
   
   
   cd $ORACLE_HOME/install/response
   cp db_install.rsp db_install.rsp.bak
   
   sed -i 's/oracle.install.option=/oracle.install.option=INSTALL_DB_SWONLY/' db_install.rsp
   sed -i 's/UNIX_GROUP_NAME=/UNIX_GROUP_NAME=oinstall/' db_install.rsp
   sed -i 's/INVENTORY_LOCATION=/INVENTORY_LOCATION=\/home\/oracle\/oracle\/ora_inventory/' db_install.rsp
   sed -i 's/ORACLE_BASE=/ORACLE_BASE=\/home\/oracle\/oracle/' db_install.rsp
   sed -i 's/oracle.install.db.InstallEdition=/oracle.install.db.InstallEdition=EE/' db_install.rsp
   sed -i 's/oracle.install.db.OSDBA_GROUP=/oracle.install.db.OSDBA_GROUP=dba/' db_install.rsp
   sed -i 's/oracle.install.db.OSOPER_GROUP=/oracle.install.db.OSOPER_GROUP=oper/' db_install.rsp
   sed -i 's/oracle.install.db.OSBACKUPDBA_GROUP=/oracle.install.db.OSBACKUPDBA_GROUP=dba/' db_install.rsp
   sed -i 's/oracle.install.db.OSDGDBA_GROUP=/oracle.install.db.OSDGDBA_GROUP=dba/' db_install.rsp
   sed -i 's/oracle.install.db.OSKMDBA_GROUP=/oracle.install.db.OSKMDBA_GROUP=dba/' db_install.rsp
   sed -i 's/oracle.install.db.OSRACDBA_GROUP=/oracle.install.db.OSRACDBA_GROUP=dba/' db_install.rsp
   sed -i 's/oracle.install.db.rootconfig.executeRootScript=/oracle.install.db.rootconfig.executeRootScript=false/' db_install.rsp
   
   
   cd $ORACLE_HOME
   ./runInstaller -silent -responseFile $ORACLE_HOME/install/response/db_install.rsp
   

9. 再切到root用户，执行

10. /home/oracle/oracle/ora_inventory/orainstRoot.sh 
    /home/oracle/oracle/product/19.3.0/db_1/root.sh
    

11. 再切换到oracle用户，执行

12. cd $ORACLE_HOME/assistants/netca
    netca /silent /responseFile /home/oracle/oracle/product/19.3.0/db_1/assistants/netca/netca.rsp
    
    cd $ORACLE_HOME/assistants/dbca/
    cp dbca.rsp dbca.rsp.bak
    
    sed -i 's/gdbName=/gdbName=oracledb/' dbca.rsp
    sed -i 's/sid=/sid=oracledb/' dbca.rsp
    sed -i 's/databaseConfigType=/databaseConfigType=SI/' dbca.rsp
    sed -i 's/templateName=/templateName=General_Purpose.dbc/' dbca.rsp
    sed -i 's/sysPassword=/sysPassword=oracle/' dbca.rsp
    sed -i 's/systemPassword=/systemPassword=oracle/' dbca.rsp
    sed -i 's/emConfiguration=/emConfiguration=DBEXPRESS/' dbca.rsp
    sed -i 's/dbsnmpPassword=/dbsnmpPassword=oracle/' dbca.rsp
    sed -i 's/characterSet=/characterSet=UTF8/' dbca.rsp
    
    dbca -silent -createDatabase -responseFile $ORACLE_HOME/assistants/dbca/dbca.rsp
    

 全部文本：

#手动切到root用户
su - root

useradd oracle
passwd oracle

groupadd oinstall
groupadd dba
groupadd oper
usermod oracle -g oinstall -G dba,oper

mkdir -p /home/oracle/oracle/product/19.3.0/db_1
mkdir -p /home/oracle/oracle/ora_inventory
unzip -q LINUX.X64_193000_db_home.zip -d /home/oracle/oracle/product/19.3.0/db_1
chown -R oracle:oinstall /home/oracle/oracle/

echo "
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
" >> /etc/security/limits.conf 

echo "
net.ipv4.icmp_echo_ignore_broadcasts=1
net.ipv4.conf.all.rp_filter=1
fs.file-max=655360
fs.aio-max-nr=102400
kernel.shmall=501024
kernel.shmmax=1024024024
kernel.shmmni=4096
kernel.sem=250 32000 100 128
net.ipv4.ip_local_port_range=9000 65535
net.core.rmem_default=261024
net.core.rmem_max=4121024
net.core.wmem_default=261024
net.core.wmem_max=4121024
" >> /etc/sysctl.conf 

sysctl -p

systemctl stop firewalld.service 
systemctl status firewalld.service 

#手动切到oracle用户
su - oracle

echo "
export LANG=en_US.UTF-8
export ORACLE_BASE=/home/oracle/oracle
export ORACLE_HOME=/home/oracle/oracle/product/19.3.0/db_1
export ORACLE_SID=oracledb
export NLS_DATA_FORMAT=\"yyyy-mm-dd HH24:MI:SS\"
export NLS_LANG=AMERICAN_AMERICA.UTF8
export PATH=\$PATH:\$ORACLE_HOME/bin
" >> ~/.bashrc 

source ~/.bashrc

cd $ORACLE_HOME/install/response
cp db_install.rsp db_install.rsp.bak

sed -i 's/oracle.install.option=/oracle.install.option=INSTALL_DB_SWONLY/' db_install.rsp
sed -i 's/UNIX_GROUP_NAME=/UNIX_GROUP_NAME=oinstall/' db_install.rsp
sed -i 's/INVENTORY_LOCATION=/INVENTORY_LOCATION=\/home\/oracle\/oracle\/ora_inventory/' db_install.rsp
sed -i 's/ORACLE_BASE=/ORACLE_BASE=\/home\/oracle\/oracle/' db_install.rsp
sed -i 's/oracle.install.db.InstallEdition=/oracle.install.db.InstallEdition=EE/' db_install.rsp
sed -i 's/oracle.install.db.OSDBA_GROUP=/oracle.install.db.OSDBA_GROUP=dba/' db_install.rsp
sed -i 's/oracle.install.db.OSOPER_GROUP=/oracle.install.db.OSOPER_GROUP=oper/' db_install.rsp
sed -i 's/oracle.install.db.OSBACKUPDBA_GROUP=/oracle.install.db.OSBACKUPDBA_GROUP=dba/' db_install.rsp
sed -i 's/oracle.install.db.OSDGDBA_GROUP=/oracle.install.db.OSDGDBA_GROUP=dba/' db_install.rsp
sed -i 's/oracle.install.db.OSKMDBA_GROUP=/oracle.install.db.OSKMDBA_GROUP=dba/' db_install.rsp
sed -i 's/oracle.install.db.OSRACDBA_GROUP=/oracle.install.db.OSRACDBA_GROUP=dba/' db_install.rsp
sed -i 's/oracle.install.db.rootconfig.executeRootScript=/oracle.install.db.rootconfig.executeRootScript=false/' db_install.rsp

cd $ORACLE_HOME
./runInstaller -silent -responseFile $ORACLE_HOME/install/response/db_install.rsp

#手动回退到root
su - root

/home/oracle/oracle/ora_inventory/orainstRoot.sh 
/home/oracle/oracle/product/19.3.0/db_1/root.sh

#手动切换到oracle
su - oracle 
cd $ORACLE_HOME/assistants/netca
netca /silent /responseFile /home/oracle/oracle/product/19.3.0/db_1/assistants/netca/netca.rsp

cd $ORACLE_HOME/assistants/dbca/
cp dbca.rsp dbca.rsp.bak

sed -i 's/gdbName=/gdbName=oracledb/' dbca.rsp
sed -i 's/sid=/sid=oracledb/' dbca.rsp
sed -i 's/databaseConfigType=/databaseConfigType=SI/' dbca.rsp
sed -i 's/templateName=/templateName=General_Purpose.dbc/' dbca.rsp
sed -i 's/sysPassword=/sysPassword=oracle/' dbca.rsp
sed -i 's/systemPassword=/systemPassword=oracle/' dbca.rsp
sed -i 's/emConfiguration=/emConfiguration=DBEXPRESS/' dbca.rsp
sed -i 's/dbsnmpPassword=/dbsnmpPassword=oracle/' dbca.rsp
sed -i 's/characterSet=/characterSet=UTF8/' dbca.rsp
dbca -silent -createDatabase -responseFile $ORACLE_HOME/assistants/dbca/dbca.rsp