oracle19c安裝_cdb
一.安裝centos系統(此處 以centos7.9為例)
oracle 19.3.0.0
官方指導檔案
docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/index.html
二.配置本地yum源
http://blog.itpub.net/70004783/viewspace-2789438/
三、 資料庫安裝準備工作
Hostname |
dbserver |
版本 |
oracle19c |
Oracle_sid |
prod |
dbname |
prod |
home |
/home/oracle |
ORACLE_BASE |
/u01/app/oracle |
ORACLE_HOME |
/u01/app/oracle/product/19c/db_1 |
1、安裝需要的軟體列表,也可以
透過安裝資料庫軟體時的提示再安裝。
yum install -y bc yum install -y compat-libcap1* yum install -y compat-libcap* yum install -y binutils yum install -y compat-libstdc++-33 yum install -y elfutils-libelf yum install -y elfutils-libelf-devel yum install -y gcc yum install -y gcc-c++ yum install -y glibc-2.5 yum install -y glibc-common yum install -y glibc-devel yum install -y glibc-headers yum install -y ksh libaio yum install -y libaio-devel yum install -y libgcc yum install -y libstdc++ yum install -y libstdc++-devel yum install -y make yum install -y sysstat yum install -y unixODBC yum install -y unixODBC-devel yum install -y binutils* yum install -y compat-libstdc* yum install -y elfutils-libelf* yum install -y gcc* yum install -y glibc* yum install -y ksh* yum install -y libaio* yum install -y libgcc* yum install -y libstdc* yum install -y make* yum install -y sysstat* yum install -y libXp* yum install -y glibc-kernheaders yum install -y net-tools-*
2、修改主機名,更改hosts檔案
[root@localhost ~]# hostnamectl set-hostname dbserver
[root@dbserver ~]# vi /etc/hosts [root@dbserver ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 10.8.98.150 dbserver [root@dbserver ~]#
3、檢查作業系統版本
我此處用的centos7.9符合要求
4、檢查系統記憶體
我此處為8G,滿足。
5、檢查swap space
此處我係統為8G,swap也是8G,滿足。
6、檢查磁碟空間, 滿足。
7、 禁用SELINUX,關閉防火牆
[root@dbserver ~]# cat /etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three values: # targeted - Targeted processes are protected, # minimum - Modification of targeted policy. Only selected processes are protected. # mls - Multi Level Security protection. SELINUXTYPE=targeted
[root@dbserver ~]# systemctl stop firewalld [root@dbserver ~]# systemctl disable firewalld Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service. Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
8、修改LINUX的核心檔案
廠家推薦引數
所以配置如下
# vi /etc/sysctl.conf #ORACLE SETTING fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmmax = 7730941133 kernel.shmall = 1887437 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 net.ipv4.ip_forward = 0 #kernel.shmmax = 7730941133 (8*1024*1024*1024*90%=7,730,941,132.8) #(oracle推薦實體記憶體50%,實體記憶體大於SGA,小於實體記憶體,可選:50%-100%,我一般設定為90%實體記憶體) #kernel.shmall = 1887437 (實體記憶體8*1024*1024*1024*90%/4K=1887436.8)
最主要是以下2個引數的設定,可以參考 https://blog.csdn.net/cuichou8903/article/details/100395322
5.新增下列引數到/etc/security/limits.conf
[root@dbserver ~]# vi /etc/security/limits.conf 新增以下 #oracle setting add oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 oracle hard memlock 7549747 oracle soft memlock 7549747
oracle hard memlock 7549747 (8*1024*1024*90%=7,549,747.2)單位是kb
6、修改/etc/pam.d/login檔案
[root@dbserver ~]# vim /etc/pam.d/login 新增以下 #oracle setting add session required /lib/security/pam_limits.so session required pam_limits.so
7、環境變數中新增下列語句
[root@dbserver ~]# vim /etc/profile 新增以下 #oracle setting add if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi
[root@dbserver ~]# source /etc/profile
8、建立檔案目錄和相應的使用者
groupadd oinstall groupadd dba groupadd oper useradd -g oinstall -G dba,oper oracle mkdir -p /u01/app/oracle mkdir -p /u01/oraInventory chown -R oracle.oinstall /u01 chown -R oracle:oinstall /u01/app/oracle chmod -R 775 /u01/app/oracle mkdir -p /u01/app/oracle/product/19c/db_1 chown -R oracle:oinstall /u01/app/oracle/product/
修改oracle使用者密碼 [root@dbserver ~]# passwd oracle
9、配置ORACLE使用者的環境變數
[oracle@dbserver ~]$ vi .bash_profile 新增以下 #oracle setting add export EDITOR=vi export TMP=/tmp export TMPDIR=$TMP export ORACLE_SID=prod export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/19c/db_1 export INVENTORY_LOCATION=/u01/oraInventory export TNS_ADMIN=$ORACLE_HOME/network/admin export LD_LIBRARY_PATH=$ORACLE_HOME/lib export NLS_LANG="AMERICAN_AMERICA.AL32UTF8" export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS" export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:$PATH:$HOME/bin umask 022
[oracle@dbserver ~]$ source .bash_profile
10、 上傳oracle檔案到/home/oracle 目錄,注意許可權問題,都給oracle使用者許可權
19C需要將壓縮包裡的內容解壓到$ORACLE_HOME目錄下,我們為了方便直接將安裝包複製到$ORACLE_HOME目錄解壓即可。
[oracle@dbserver ~]$ cd $ORACLE_HOME [oracle@dbserver db_1]$ ls [oracle@dbserver db_1]$ pwd /u01/app/oracle/product/19c/db_1 [oracle@dbserver db_1]$ ll total 2987996 -rw-r--r--. 1 oracle oinstall 3059705302 Sep 1 16:59 LINUX.X64_193000_db_home.zip [oracle@dbserver db_1]$
解壓
[oracle@dbserver db_1]$ unzip LINUX.X64_193000_db_home.zip
重啟以下系統
11、root安裝vnc,oracle啟動vnc
切換到root安裝vnc,透過vnc安裝oracle [root@dbserver ~]# yum install *vnc* 切換到oracle 啟動vnc [oracle@dbserver ~]$ vncserver You will require a password to access your desktops. Password: Verify: Would you like to enter a view-only password (y/n)? n A view-only password is not used New 'dbserver:1 (oracle)' desktop is dbserver:1 Creating default startup script /home/oracle/.vnc/xstartup Creating default config /home/oracle/.vnc/config Starting applications specified in /home/oracle/.vnc/xstartup Log file is /home/oracle/.vnc/dbserver:1.log [oracle@dbserver ~]$
12、oracle使用者透過vnc客戶端連線圖形介面,進入相應目錄,準備開始安裝資料庫
四、僅安裝資料庫軟體
一步一步如下圖所示
然後netca建立監聽(略)
最後dbca建立資料庫 (略)
七、登陸資料庫檢視是否正常
SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/PROD/system01.dbf /u01/app/oracle/oradata/PROD/sysaux01.dbf /u01/app/oracle/oradata/PROD/undotbs01.dbf /u01/app/oracle/oradata/PROD/pdbseed/system01.dbf /u01/app/oracle/oradata/PROD/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/PROD/users01.dbf /u01/app/oracle/oradata/PROD/pdbseed/undotbs01.dbf /u01/app/oracle/oradata/PROD/pdb1/system01.dbf /u01/app/oracle/oradata/PROD/pdb1/sysaux01.dbf /u01/app/oracle/oradata/PROD/pdb1/undotbs01.dbf /u01/app/oracle/oradata/PROD/pdb1/users01.dbf 11 rows selected. SQL>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70004783/viewspace-2840360/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle19c安裝 單例項 系統centos7 非cdbOracle單例CentOS
- Windows 安裝Oracle19CWindowsOracle
- RochyLinux 8.6安裝Oracle19c ClientLinuxOracleclient
- ogg for oracle 19c 非cdb安裝配置Oracle
- 信創ARM_鯤鵬920安裝Oracle19c的過程Oracle
- 【配置安裝】Oracle靜默建庫for 12c&19c CDBOracle
- [重慶思莊每日技術分享]-安裝oracle19c時報錯DBT-50000Oracle
- 【CDB】怎樣轉換non-CDB to CDB
- 【Oracle19c】Oracle19c rman使用簡單測試Oracle
- 2.1 Overview of Containers in a CDB (CDB容器概述)ViewAI
- 【CDB】Oracle CDB/PDB常用管理命令Oracle
- 【Oracle19c】Oracle19c RAC 升級 ru:19.3-19.6Oracle
- oracle19c連pdbOracle
- Oracle 12c no-CDB轉換為CDBOracle
- ORACLE19C RAC+DGOracle
- Overview of Availability in a CDBViewAI
- 2.2.1.2 Namespaces in a CDBnamespace
- 1.3.2.2.2 通過Non-CDB(非CDB模式)建立PDB模式
- Oracle 12c 手動建立CDB和非CDBOracle
- 安裝npm 解除安裝npm 安裝apidocNPMAPI
- 1.3.2.1.2. 通過克隆或None-CDB方式建立CDBNone
- 1.3.2.2.2. 通過Non-CDB(非CDB模式)建立PDB模式
- oracle 12c non-cdb升級成cdb模式Oracle模式
- oracle19C技術架構Oracle架構
- 【DATAGUARD】Oracle19c Data Guard BrokerOracle
- BiocManager安裝,devtools安裝dev
- 1.3.1. 建立CDB
- 2.4.2 Connections to Containers in a CDBAI
- 2.4.1.2 Nonedefault Services in a CDBNone
- 2.4.1.1 Default Services in a CDB
- 2.4.1 Service Creation in a CDB
- 2.4 Overview of Services in a CDBView
- 2.2.4.4 Grants to PUBLIC in a CDB
- 2.2.3.1 Common Roles in a CDB
- 2.2.2.2 Local Users in a CDB
- 2.2.2.1 Common Users in a CDB
- 2.1 CDB容器概述
- JDK安裝和解除安裝JDK