暂无图片
暂无图片
7
暂无图片
暂无图片
暂无图片
首页 / 静默安装19c GI standalone database

静默安装19c GI standalone database

原创 yuqi.zhou 云和恩墨技术服务团队 2021-09-09
1640

前言：本文只记录了一些关键步骤，很多安装前的配置没有记录，供大家参考。

一、创建用户、目录、解压软件等

groupadd  -g 54421  oinstall
groupadd  -g 54422  dba
groupadd  -g 54423  oper
groupadd  -g 54427  asmdba
groupadd  -g 54428  asmoper
groupadd  -g 54429  asmadmin

useradd -u 54321 -g oinstall -G oinstall,dba,oper,asmdba,asmadmin,asmoper oracle
useradd -u 54322 -g oinstall -G oinstall,dba,oper,asmadmin,asmdba,asmoper grid

mkdir -p /oracle/app/19c/grid
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/oracle
mkdir -p /oracle/app/oracle/product/19c/dbhome_1
chown -R grid:oinstall /oracle
chmod -R 775 /oracle
chown -R oracle:oinstall /oracle/app/oracle

grid:
cd /oracle/software/
unzip -d /oracle/app/19c/grid/  LINUX.X64_193000_grid_home.zip

oracle:
cd /oracle/software/
unzip -d /oracle/app/oracle/product/19c/dbhome_1 LINUX.X64_193000_db_home.zip

二、安装GI

1. 准备响应文件

[grid@cmlc-quasiactdb ~]$ cat grid.rsp 
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0
INVENTORY_LOCATION=/oracle/app/oraInventory
oracle.install.option=HA_CONFIG
ORACLE_BASE=/oracle/app/grid
oracle.install.asm.OSDBA=asmdba
oracle.install.asm.OSOPER=asmoper
oracle.install.asm.OSASM=asmadmin
oracle.install.crs.config.scanType=LOCAL_SCAN
oracle.install.crs.config.ClusterConfiguration=STANDALONE
oracle.install.crs.config.configureAsExtendedCluster=false
oracle.install.crs.config.gpnp.configureGNS=false
oracle.install.crs.config.autoConfigureClusterNodeVIP=false
oracle.install.crs.config.gpnp.gnsOption=CREATE_NEW_GNS
oracle.install.crs.configureGIMR=false
oracle.install.asm.configureGIMRDataDG=false             
oracle.install.crs.config.useIPMI=false
oracle.install.asm.SYSASMPassword=j55xrp6t!
oracle.install.asm.diskGroup.name=DATA
oracle.install.asm.diskGroup.redundancy=EXTERNAL
oracle.install.asm.diskGroup.AUSize=4
oracle.install.asm.diskGroup.disks=/dev/asm-quasiact_adg1_data001,/dev/asm-quasiact_adg1_data002
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*
oracle.install.asm.monitorPassword=j55xrp6t!
oracle.install.asm.configureAFD=false
oracle.install.crs.configureRHPS=false
oracle.install.crs.config.ignoreDownNodes=false               
oracle.install.config.managementOption=NONE
oracle.install.config.omsPort=0
oracle.install.crs.rootconfig.executeRootScript=false

2. 执行静默安装

[grid@cmlc-quasiactdb ~]$ $ORACLE_HOME/gridSetup.sh -silent -responseFile /home/grid/grid.rsp
Launching Oracle Grid Infrastructure Setup Wizard...

[WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.
   CAUSE: 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].
   ACTION: Provide a password that conforms to the Oracle recommended standards.
[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.
   CAUSE: 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].
   ACTION: Provide a password that conforms to the Oracle recommended standards.
[WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. gridSetupActions2021-09-07_07-39-24PM.log
   ACTION: Identify the list of failed prerequisite checks from the log: gridSetupActions2021-09-07_07-39-24PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
 /oracle/app/19c/grid/install/response/grid_2021-09-07_07-39-24PM.rsp

You can find the log of this install session at:
 /tmp/GridSetupActions2021-09-07_07-39-24PM/gridSetupActions2021-09-07_07-39-24PM.log

As a root user, execute the following script(s):
        1. /oracle/app/oraInventory/orainstRoot.sh
        2. /oracle/app/19c/grid/root.sh

Execute /oracle/app/19c/grid/root.sh on the following nodes: 
[cmlc-quasiactdb]



Successfully Setup Software with warning(s).
As install user, execute the following command to complete the configuration.
        /oracle/app/19c/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/grid.rsp [-silent]


Moved the install session logs to:
 /oracle/app/oraInventory/logs/GridSetupActions2021-09-07_07-39-24PM

2. 执行root.sh脚本

[root@cmlc-quasiactdb ~]# /oracle/app/oraInventory/orainstRoot.sh
Changing permissions of /oracle/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /oracle/app/oraInventory to oinstall.
The execution of the script is complete.
[root@cmlc-quasiactdb ~]# /oracle/app/19c/grid/root.sh
Check /oracle/app/19c/grid/install/root_cmlc-quasiactdb_2021-09-07_19-47-14-808255897.log for the output of root script

3. 查看资源状态

[grid@cmlc-quasiactdb ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      cmlc-quasiactdb          STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE                               STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.driver.afd
      1        ONLINE  ONLINE       cmlc-quasiactdb          STABLE
ora.evmd
      1        ONLINE  ONLINE       cmlc-quasiactdb          STABLE
--------------------------------------------------------------------------------

4. 配置

[grid@cmlc-quasiactdb ~]$ /oracle/app/19c/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/grid.rsp -silent
Launching Oracle Grid Infrastructure Setup Wizard...

You can find the logs of this session at:
/oracle/app/oraInventory/logs/GridSetupActions2021-09-07_08-44-57PM

You can find the log of this install session at:
 /oracle/app/oraInventory/logs/UpdateNodeList2021-09-07_08-44-57PM.log
Successfully Configured Software.

这一步会创建磁盘组、监听、asm资源。

5. 再次查看资源状态

[grid@cmlc-quasiactdb ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       cmlc-quasiactdb          STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       cmlc-quasiactdb          STABLE
ora.asm
               ONLINE  ONLINE       cmlc-quasiactdb          Started,STABLE
ora.ons
               OFFLINE OFFLINE      cmlc-quasiactdb          STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       cmlc-quasiactdb          STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.driver.afd
      1        ONLINE  ONLINE       cmlc-quasiactdb          STABLE
ora.evmd
      1        ONLINE  ONLINE       cmlc-quasiactdb          STABLE
--------------------------------------------------------------------------------

三、处理磁盘组

1. 创建FRA磁盘组

SQL> create diskgroup FRA EXTERNAL redundancy disk '/dev/asm-quasiact_adg1_fra001' attribute 'compatible.rdbms'='19.0','compatible.asm'='19.0';

Diskgroup created.

2. 增加磁盘到DATA磁盘组

SQL> alter diskgroup DATA add disk 
  2  '/dev/asm-quasiact_adg1_data003',
  3  '/dev/asm-quasiact_adg1_data004',
  4  '/dev/asm-quasiact_adg1_data005',
  5  '/dev/asm-quasiact_adg1_data006',
  6  '/dev/asm-quasiact_adg1_data007',
  7  '/dev/asm-quasiact_adg1_data008',
  8  '/dev/asm-quasiact_adg1_data009',
  9  '/dev/asm-quasiact_adg1_data010'
 10  rebalance power 2;

Diskgroup altered.

四、安装数据库软件

  1. 准备响应文件
[oracle@cmlc-quasiactdb ~]$ cat db.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=/oracle/app/oraInventory
ORACLE_BASE=/oracle/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_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
oracle.install.db.rootconfig.executeRootScript=false
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.memoryOption=false
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.managementOption=DEFAULT
oracle.install.db.config.starterdb.enableRecovery=false
  1. 安装
[oracle@cmlc-quasiactdb ~]$ $ORACLE_HOME/runInstaller -silent -noconfig -responseFile /home/oracle/db.rsp
Launching Oracle Database Setup Wizard...

[WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. /oracle/app/oraInventory/logs/InstallActions2021-09-07_09-05-01PM/installActions2021-09-07_09-05-01PM.log
   ACTION: Identify the list of failed prerequisite checks from the log: /oracle/app/oraInventory/logs/InstallActions2021-09-07_09-05-01PM/installActions2021-09-07_09-05-01PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
 /oracle/app/oracle/product/19c/dbhome_1/install/response/db_2021-09-07_09-05-01PM.rsp

You can find the log of this install session at:
 /oracle/app/oraInventory/logs/InstallActions2021-09-07_09-05-01PM/installActions2021-09-07_09-05-01PM.log

As a root user, execute the following script(s):
        1. /oracle/app/oracle/product/19c/dbhome_1/root.sh

Execute /oracle/app/oracle/product/19c/dbhome_1/root.sh on the following nodes: 
[cmlc-quasiactdb]


Successfully Setup Software with warning(s).
[oracle@cmlc-quasiactdb ~]$ sqlplus -v

SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

五、创建数据库

1. 准备响应文件

[oracle@cmlc-quasiactdb ~]$ cat dbca.rsp 
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0
gdbName=actdb
sid=actdb
databaseConfigType=SI
createAsContainerDatabase=false
templateName=/oracle/app/oracle/product/19c/dbhome_1/assistants/dbca/templates/General_Purpose.dbc
sysPassword=oracle
systemPassword=oracle
datafileDestination=+DATA
recoveryAreaDestination=+FRA
characterSet=ZHS16GBK
nationalCharacterSet=AL16UTF16
memoryPercentage=50
databaseType=MULTIPURPOSE
automaticMemoryManagement=false

2. 建库

[oracle@cmlc-quasiactdb ~]$ dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp
[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.
Prepare for db operation
10% complete
Registering database with Oracle Restart
14% complete
Copying database files
43% complete
Creating and starting Oracle instance
45% complete
49% complete
53% complete
56% complete
62% complete
Completing Database Creation
68% complete
70% complete
71% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /oracle/app/oracle/cfgtoollogs/dbca/actdb.
Database Information:
Global Database Name:actdb
System Identifier(SID):actdb
Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/actdb/actdb.log" for further details.

至此，数据库创建完毕。

standalone安装部署静默安装
最后修改时间：2025-07-16 13:04:34
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

文章被以下合辑收录

Oracle技术专栏（共17篇）
Oracle案例、学习笔记等

评论