首先在edelivery中下载Oracle Linux 8.0 然后就默认安装系统 环境准备工具目前不支持OL8，所以需要手动安装，首先设置内核参数，在/etc/sysctl.conf追加 [root@localhost ~]# cat /etc/sysctl.conf |grep -v
首先在edelivery中下载Oracle Linux 8.0
然后就默认安装系统
环境准备工具目前不支持OL8，所以需要手动安装，首先设置内核参数，在/etc/sysctl.conf追加
[root@localhost ~]# cat /etc/sysctl.conf |grep -v ^#|grep -v ^$fs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104kernel.panic_on_oops = 1net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.conf.all.rp_filter = 2net.ipv4.conf.default.rp_filter = 2fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500[root@localhost ~]#
sysctl -p使参数生效
然后/etc/security/limits.d/oracle-database-preinstall-19c.conf中添加
[root@localhost limits.d]# cat /etc/security/limits.d/oracle-database-preinstall-19c.conforacle soft nofile 1024oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768oracle hard memlock 134217728oracle soft memlock 134217728[root@localhost limits.d]#
安装依赖软件
dnf install -y bc binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libXrender-devel libX11 libXau libXi libXtst libgcc librdmacm-devel libstdc++ libstdc++-devel libxcb make net-tools nfs-utils Python3 python3-configshell python3-rtslib python3-six targetcli smartmontools sysstat unixODBC libnsl libnsl.i686 libnsl2 libnsl2.i686
创建用户组和用户
[root@localhost limits.d]# groupadd -g 1001 oinstall[root@localhost limits.d]# groupadd -g 1002 dba[root@localhost limits.d]# groupadd -g 1003 oper[root@localhost limits.d]# useradd -u 1001 -g oinstall -G dba,oper oracle[root@localhost limits.d]# passwd oracleChanging password for user oracle.New password: BAD PASSWORD: The password is shorter than 8 charactersRetype new password: passwd: all authentication tokens updated successfully.[root@localhost limits.d]#
创建目录
[root@localhost ~]# mkdir -p /u01/app/oraInventory[root@localhost ~]# mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1[root@localhost ~]# chown -R oracle: /u01/app/oraInventory[root@localhost ~]# chown -R oracle: /u01/app/oracle[root@localhost ~]# su - oracle[oracle@localhost db]$ unzip -q /stage/db/V982063-01.zip -d /u01/app/oracle/product/19.3.0/dbhome_1/[oracle@localhost db]$
开始安装，注意版本兼容问题要先设置环境变量export CV_ASSUME_DISTID=RHEL7.6
[oracle@localhost ~]$ export CV_ASSUME_DISTID=RHEL7.6[oracle@localhost ~]$ /u01/app/oracle/product/19.3.0/dbhome_1/runInstaller -ignorePrereq -waitforcompletion -silent > -responseFile /u01/app/oracle/product/19.3.0/dbhome_1/install/response/db_install.rsp > oracle.install.option=INSTALL_DB_SWONLY > .ORACLE_HOSTNAME=OL8.0_19C > UNIX_GROUP_NAME=oinstall > INVENTORY_LOCATION=/u01/app/oraInventory > SELECTED_LANGUAGES=en,en_GB > ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 > ORACLE_BASE=/u01/app/oracle > oracle.install.db.InstallEdition=EE > oracle.install.db.OSDBA_GROUP=dba > oracle.install.db.OSBACKUPDBA_GROUP=dba > oracle.install.db.OSDGDBA_GROUP=dba > oracle.install.db.OSKMDBA_GROUP=dba > oracle.install.db.OSRACDBA_GROUP=dba > SECURITY_UPDATES_VIA_MYORACLESUPPORT=false > DECLINE_SECURITY_UPDATES=trueLaunching Oracle Database Setup Wizard... The response file for this session can be found at: /u01/app/oracle/product/19.3.0/dbhome_1/install/response/db_2019-08-17_12-41-50PM.rsp You can find the log of this install session at: /tmp/InstallActions2019-08-17_12-41-50PM/installActions2019-08-17_12-41-50PM.log As a root user, execute the following script(s): 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/oracle/product/19.3.0/dbhome_1/root.sh Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: [localhost]Execute /u01/app/oracle/product/19.3.0/dbhome_1/root.sh on the following nodes: [localhost] Successfully Setup Software.Moved the install session logs to: /u01/app/oraInventory/logs/InstallActions2019-08-17_12-41-50PM[oracle@localhost ~]$ su - rootPassword: [root@localhost ~]# /u01/app/oraInventory/orainstRoot.shChanging permissions of /u01/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.[root@localhost ~]# /u01/app/oracle/product/19.3.0/dbhome_1/root.shCheck /u01/app/oracle/product/19.3.0/dbhome_1/install/root_localhost.localdomain_2019-08-17_12-44-20-885851348.log for the output of root script[root@localhost ~]#
代码是
/u01/app/oracle/product/19.3.0/dbhome_1/runInstaller -ignorePrereq -waitforcompletion -silent -responseFile /u01/app/oracle/product/19.3.0/dbhome_1/install/response/db_install.rsp oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=OL8.0_19C UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en,en_GB ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSBACKUPDBA_GROUP=dba oracle.install.db.OSDGDBA_GROUP=dba oracle.install.db.OSKMDBA_GROUP=dba oracle.install.db.OSRACDBA_GROUP=dba SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true
静默安装数据库,df -h先看看内存够不够,不够就调整参数大小或者mount -o remount,size=4G /dev/shm
[root@localhost ~]# mount -o remount,size=4G /dev/shm[root@localhost ~]# su - oracle[oracle@localhost ~]$ /u01/app/oracle/product/19.3.0/dbhome_1/bin/dbca -silent -createDatabase > -templateName General_Purpose.dbc > -gdbname cdb1 -sid cdb1 -responseFile NO_VALUE > -characterSet AL32UTF8 > -sysPassword oracle > -systemPassword oracle > -createAsContainerDatabase true > -numberOfPDBs 1 > -pdbName pdb1 > -pdbAdminPassword oracle > -databaseType MULTIPURPOSE > -automaticMemoryManagement false > -totalMemory 2000 > -storageType FS > -datafileDestination "/u01/app/oracle/oradata" > -redoLogFileSize 50 > -emConfiguration NONE > -ignorePreReqs[WARNING] [DBT-11209] Current available memory is less than the required available memory (2,000MB) for creating the database. CAUSE: Following nodes do not have required available memory : Node:localhost Available memory:1.8429GB (1932452.0KB) [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.Prepare for db operation8% completeCopying database files31% completeCreating and starting Oracle instance32% complete36% complete40% complete43% complete46% completeCompleting Database Creation51% complete53% complete54% completeCreating Pluggable Databases58% complete77% completeExecuting Post Configuration Actions100% completeDatabase creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/cdb1.Database Information:Global Database Name:cdb1System Identifier(SID):cdb1Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb1/cdb1.log" for further details.[oracle@localhost ~]$
代码是
/u01/app/oracle/product/19.3.0/dbhome_1/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname cdb1 -sid cdb1 -responseFile NO_VALUE -characterSet AL32UTF8 -sysPassword oracle -systemPassword oracle -createAsContainerDatabase true -numberOfPDBs 1 -pdbName pdb1 -pdbAdminPassword oracle -databaseType MULTIPURPOSE -automaticMemoryManagement false -totalMemory 2000 -storageType FS -datafileDestination "/u01/app/oracle/oradata" -redoLogFileSize 50 -emConfiguration NONE -ignorePreReqs
修改/etc/oratab中默认的N为Y,以便让数据库随系统的启动一起启动
[oracle@localhost ~]$ cat /etc/oratab |grep -v ^#|grep -v ^$cdb1:/u01/app/oracle/product/19.3.0/dbhome_1:Y[oracle@localhost ~]$
查看一下
[oracle@localhost ~]$ export ORACLE_SID=cdb1[oracle@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1[oracle@localhost ~]$ export ORACLE_BASE=/u01/app/oracle/[oracle@localhost ~]$ export PATH=$PATH:$ORACLE_HOME/bin[oracle@localhost ~]$ [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 17 14:20:38 2019Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0 SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NOSQL> alter system set db_create_file_dest='/u01/app/oracle/oradata'; System altered. SQL> alter pluggable database pdb1 save state; Pluggable database altered. SQL> exit;Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0[oracle@localhost ~]$
更多Oracle相关信息见Oracle 专题页面 https://www.558idc.com/topicnews.aspx?tid=12
