課程介紹

DBA數據庫管理必備認證：ORACLE OCP 19C

教材下載

ORACLE OCP 19C 官方電子教材

ORACLE OCP 12C官方電子教材

1.安裝前環境配置 基本信息 OS DB hostname DB name IP Redhat7.6 Oracle 19C Oracle19C weisi 192.168.2.100 配置/etc/hosts [root@ocp /]#echo '192.168.2.100 Oracle19C' >> /etc/hosts 關閉防火墻和Selinux systemctl stop firewalld.servicesystemctl disable firewalld.servicesed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/sysconfig/selinux 配置系統參數 echo kernel.shmmni=4096 >> /etc/sysctl.confecho kernel.sem=250 32000 100 128 >> /etc/sysctl.confecho fs.file-max=6815744 >> /etc/sysctl.confecho fs.aio-max-nr=1048576 >> /etc/sysctl.confecho net.ipv4.ip_local_port_range=9000 65500 >> /etc/sysctl.confecho net.core.rmem_default=262144 >> /etc/sysctl.confecho net.core.rmem_max=4194304 >> /etc/sysctl.confecho net.core.wmem_default=262144 >> /etc/sysctl.confecho net.core.wmem_max=1048576 >> /etc/sysctl.confecho kernel.shmmax=2023478784 >> /etc/sysctl.confecho kernel.shmall=52780232 >> /etc/sysctl.confecho 'session required /lib64/security/pam_limits.so' >>/etc/pam.d/loginecho 'session required pam_limits.so' >>/etc/pam.d/loginecho 'oracle soft nproc 2047' >> /etc/security/limits.confecho 'oracle hard nproc 16384' >> /etc/security/limits.confecho 'oracle soft nofile 1024' >> /etc/security/limits.confecho 'oracle hard nofile 65536' >> /etc/security/limits.confecho 'oracle soft stack 10240' >> /etc/security/limits.confecho?'oracle??hard??stack???32768'???>>?/etc/security/limits.conf [root@ocp /]#sysctl -p 創建用戶oracle用戶和組 groupadd oinstall groupadd dba groupadd oper useradd -g oinstall -G dba,oper oracleecho "1qaz2wsx." | passwd --stdin oracle 創建安裝目錄 mkdir -p /u01/appmkdir -p /u01/app/oraclemkdir -p /u01/app/oracle/product/19.3/dbhome_1chown -R oracle:oinstall /u01/appchmod -R 775 /u01/app 配置本地yum [root@ocp /]# cd /etc/yum.repos.d[root@ocp /]#rm -f /etc/yum.repos.d/*.repoecho [Local] >>Local.repoecho name=Local Yum >>Local.repoecho baseurl=file:///tmp/redhat7iso >>Local.repoecho gpgcheck=0 >>Local.repoecho enabled=1 >>Local.repoecho gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release >>Local.repo[root@ocp /]#yum clean all[root@ocp /]#yum list 配置oracle 用戶環境變量 [root@ocp?yum.repos.d]#?su?–?oracle echo umask 022 >>/home/oracle/.bash_profileecho ORACLE_BASE=/u01/app/oracle >>/home/oracle/.bash_profile echo 'ORACLE_HOME=/u01/app/oracle/product/19.3/dbhome_1' >>/home/oracle/.bash_profileecho ORACLE_SID=weisi >>/home/oracle/.bash_profileecho 'PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin' >>/home/oracle/.bash_profileecho 'export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID' >>/home/oracle/.bash_profile[oracle@ocp ~]$ source /home/oracle/.bash_profile 2.安裝數據庫軟件 [oracle@OracleTraining ~]$ mkdir /u01/app/soft數據庫軟件已經上傳到/u01/app/soft 并解壓到當前目錄[oracle@Oracle19C ~]$ su – root[root@Oracle19C ~]# chown oracle:oinstall /u01/app/soft/LINUX.X64_193000_db_home.zip[oracle@Oracle19C ~]$ su – oracle[oracle@ocp ~]$ cd /u01/app/soft[oracle@ocp]$ unzip LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.3/dbhome_1[oracle@ocp]$cd /u01/app/oracle/product/19.3/dbhome_1[oracle@ocp database]$export DISPLAY=192.168.1.20:0.0[oracle@ocp database]$export[oracle@ocp database]$./runInstaller root用戶，使用yum 工具安裝缺少的包[root@ocp Packages]# cd /tmp/redhat7iso/Packagesyum -y install compat-libcap1-1*yum -y install compat-libstdc++yum -y install libstdc++-devel.x86_64yum -y install gcc-c++*yum -y install kshyum -y install libaio-devel將compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm 上傳到/tmp 目錄cd /tmprpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm 3.創建數據庫 [oracle@ocp ~]$export DISPLAY=192.168.1.2:0.0[oracle@ocp ~]$ dbca 4.基礎命令 登入數據庫: sqlplus / as sysdba 查看當前數據庫show con_name ? ? ?? 查看PDB信息 col pdb_name format a20 col status format a20select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs; 或者 show pdbs 查看當前環境 SELECT?SYS_CONTEXT('USERENV','CON_NAME')?FROM?dual; 容器切換 alter session set container=weisipdb;?alter?session?set?container=CDB$ROOT; 關閉數據庫 Shutdown immediate; 啟動數據庫 startup 5.完全卸載oracle rm -f /etc/oratabrm -f /etc/oraInst.locrm -rf $ORACLE_BASErm -rf /u01/app/oraInventory end 歡迎關注微信公眾號【廈門微思網絡】。www.xmws.cn專業IT認證培訓19周年 主要課程：思科、華為、紅帽、ORACLE、VMware、CISP、PMP等認證培訓及考證

《新程序員》：云原生和全面數字化實踐50位技術專家共同創作，文字、視頻、音頻交互閱讀

總結

以上是生活随笔為你收集整理的收藏 | 超详细的Oracle19c安装步骤的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。