重装CRS-11.2.0.4挂载原磁盘组-linux7

1、删除所有节点的信息
#!/bin/bash
#Usage:Log on as the superuser('root') on node1,node2
#crsctl disable crs
ps -ef | grep d.bin | awk '{print $2}' | xargs kill -9
ps -ef |grep u01/app| awk '{print $2}' | xargs kill -9
cd /
echo ...................
cd /etc/oracle/
rm -rf scls_scr/ oprocd/ lastgasp/ o* setasmgid
echo ...................
sed -i '/ohas/d' etc/inittab
echo ...................
rm -f etc/init.d/init.cssd
rm -f etc/init.d/init.crs
rm -f etc/init.d/init.crsd
rm -f etc/init.d/init.evmd
rm -f etc/rc2.d/K96init.crs
rm -f etc/rc2.d/S96init.crs
rm -f etc/rc3.d/K96init.crs
rm -f etc/rc3.d/S96init.crs
rm -f etc/rc5.d/K96init.crs
rm -f etc/rc5.d/S96init.crs
rm -f etc/inittab.crs
echo ...................
rm -rf etc/init.d/ohasd
rm -rf etc/init.d/init.ohasd
rm -rf etc/oratab
rm -rf etc/oraInst.loc
echo ...................
rm -rf var/tmp/.oracle
rm -rf tmp/.oracle
rm -rf u01/app
echo ...................
cd /tmp
rm -rf CVU_11.2.0* logs dbca OraInstall*
echo ...................
rm /u01 -fr
mkdir -p u01/app/grid
mkdir -p u01/app/11.2.0/grid
mkdir -p u01/app/oracle
chown -R oracle:oinstall u01
chown -R grid:oinstall u01/app/grid
chown -R grid:oinstall u01/app/11.2.0
chmod -R 775 u01
echo ...................
systemctl  restart network
echo down


2、清除ocr和voting disk磁盘
dd if=/dev/zero of=/dev/asmdisk1 bs=1M count=100
dd if=/dev/zero of=/dev/asmdisk2 bs=1M count=100
dd if=/dev/zero of=/dev/asmdisk3 bs=1M count=100


--如果是oracleasm绑定的，还需要单独处理
oracleasm createdisk ocr1 dev/mapper/mpathocr1
oracleasm createdisk ocr2 dev/mapper/mpathocr2
oracleasm createdisk ocr3 dev/mapper/mpathocr3
oracleasm createdisk ocr4 dev/mapper/mpathocr4
oracleasm createdisk ocr5 dev/mapper/mpathocr5
oracleasm init
oracleasm scandisks
oracleasm listdisks


3、安装grid 11.2.0.4
[root@hisdb01 software]# chown -R grid:oinstall software/
[grid@hisdb01 ~]$ cd software/
[grid@hisdb01 software]$ unzip p13390677_112040_Linux-x86-64_3of7.zip
在linux 7 上安装11.2.0.4会有个BUG，“Patch 19404309: BLR BACKPORT OF BUG 18658211 ON TOP OF 11.2.0.4.0 (BLR #3975140)”，需要下载补丁p19404309并上传p19404309_112040_Linux-x86-64.zip，后解压


[root@hisdb01 software]# cd bug/
[root@hisdb01 bug]# ll
total 170836
-rw-r--r--. 1 grid oinstall 174911877 Jan 20  2020 p18370031_112040_Linux-x86-64.zip
-rw-r--r--. 1 grid oinstall     19848 Jan 20  2020 p19404309_112040_Linux-x86-64.zip
[root@hisdb01 bug]# unzip p19404309_112040_Linux-x86-64.zip
[root@hisdb01 bug]# cp b19404309/grid/cvu_prereq.xml software/grid/stage/cvu/（安装软件包位置）
cp: overwrite ‘/software/grid/stage/cvu/cvu_prereq.xml’? y


find /software -name cvu*
rpm -ivh software/grid11204/grid/rpm/cvuqdisk-1.0.9-1.rpm
scp /software/grid11204/grid/rpm/cvuqdisk-1.0.9-1.rpm hisdb02:/software/


3.1 安装rpm包
在节点1 grid安装目录下的rpm目录下有cvuqdisk-1.0.9-1.rpm的安装包。
[root@hisdb01 bug]# cd software/grid/rpm/
[root@hisdb01 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm 
Preparing...                          ################################# [100%]
Using default group oinstall to install package
Updating / installing...
   1:cvuqdisk-1.0.9-1                 ################################# [100%]
拷贝cvuqdisk-1.0.9-1.rpm到节点2、3节点
[root@hisdb01 rpm]# scp cvuqdisk-1.0.9-1.rpm hisdb02:/tmp
[root@hisdb01 rpm]# scp cvuqdisk-1.0.9-1.rpm hisdb03:/tmp


节点2、3安装
[root@hisdb02 u01]# rpm -ivh tmp/cvuqdisk-1.0.9-1.rpm
[root@hisdb03 u01]# rpm -ivh tmp/cvuqdisk-1.0.9-1.rpm


3.2 检查安装条件是否满足
[root@hisdb01 rpm]# su - grid
[grid@hisdb01 ~]$ cd software/grid/
[grid@hisdb01 grid]$ ./runcluvfy.sh stage -pre crsinst -n hisdb01,hisdb02,hisdb03 -fixup -verbose
查看生成的报告，并进行相应的修改。在NTP、DNS、pdksh报错，可以忽略。


在所有节点运行
/tmp/CVU_11.2.0.4.0_grid/runfixup.sh


3.3 图形化安装GRID
[grid@hisdb01 ~]$ cd software/grid/
[grid@hisdb01 grid]$ ./runInstaller

3个节点root.sh运行前，分别打补丁p18370031：
上传p18370031_112040_Linux-x86-64.zip


chown grid:oinstall p18370031_112040_Linux-x86-64.zip


grid用户执行
[grid@hisdb01 bug]$ unzip p18370031_112040_Linux-x86-64.zip
[grid@hisdb01 bug]$ u01/app/11.2.0/grid/OPatch/opatch napply -oh u01/app/11.2.0/grid/ -local software/bug/18370031
输入 y,y
[grid@hisdb01 bug]$ u01/app/11.2.0/grid/OPatch/opatch lsinventory


[grid@hisdb01 bug]$ scp p18370031_112040_Linux-x86-64.zip hisdb02:/tmp 
[grid@hisdb01 bug]$ scp p18370031_112040_Linux-x86-64.zip hisdb03:/tmp
[grid@hisdb02 tmp]$ unzip p18370031_112040_Linux-x86-64.zip
[grid@hisdb02 tmp]$ u01/app/11.2.0/grid/OPatch/opatch napply -oh u01/app/11.2.0/grid/ -local tmp/18370031
输入 y,y
[grid@hisdb02 tmp]$ u01/app/11.2.0/grid/OPatch/opatch lsinventory


[grid@hisdb03 tmp]$ unzip p18370031_112040_Linux-x86-64.zip
[grid@hisdb03 tmp]$ u01/app/11.2.0/grid/OPatch/opatch napply -oh u01/app/11.2.0/grid/ -local tmp/18370031
输入 y,y
[grid@hisdb03 tmp]$ u01/app/11.2.0/grid/OPatch/opatch lsinventory


补丁成功后，节点1和2，3用root用户依次执行运行脚本：
/u01/app/oraInventory/orainstRoot.sh
/u01/app/11.2.0/grid/root.sh


[root@hisdb01 ~]# u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g 


The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  u01/app/11.2.0/grid


Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.


[root@hisdb02 ~]# u01/app/oraInventory/orainstRoot.sh
Changing 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@hisdb03 ~]# u01/app/oraInventory/orainstRoot.sh
Changing 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执行过程监控
[root@hisdb01 ~]# cd u01/app/11.2.0/grid/cfgtoollogs/crsconfig/
[root@hisdb01 crsconfig]# ls
rootcrs_hisdb01.log
[root@hisdb01 crsconfig]# tail -200f rootcrs_hisdb01.log


------核心日志--------
2022-09-15 18:17:00: Start of resource "ora.ctssd" Succeeded
2022-09-15 18:17:00: Configuring ASM via ASMCA
2022-09-15 18:17:00: Reuse Disk Group  is set to 0
2022-09-15 18:17:00: Executing as grid: u01/app/11.2.0/grid/bin/asmca -silent -diskGroupName SYSTEMDG -diskList '/dev/asmdisk1,/dev/asmdisk2,/dev/asmdisk3' -redundancy NORMAL -diskString '/dev/asm*' -configureLocalASM -au_size 4
2022-09-15 18:17:00: Running as user grid: u01/app/11.2.0/grid/bin/asmca -silent -diskGroupName SYSTEMDG -diskList '/dev/asmdisk1,/dev/asmdisk2,/dev/asmdisk3' -redundancy NORMAL -diskString '/dev/asm*' -configureLocalASM -au_size 4
2022-09-15 18:17:00:   Invoking "/u01/app/11.2.0/grid/bin/asmca -silent -diskGroupName SYSTEMDG -diskList '/dev/asmdisk1,/dev/asmdisk2,/dev/asmdisk3' -redundancy NORMAL -diskString '/dev/asm*' -configureLocalASM -au_size 4" as user "grid"
2022-09-15 18:17:00: Executing bin/su grid -c "/u01/app/11.2.0/grid/bin/asmca -silent -diskGroupName SYSTEMDG -diskList '/dev/asmdisk1,/dev/asmdisk2,/dev/asmdisk3' -redundancy NORMAL -diskString '/dev/asm*' -configureLocalASM -au_size 4"
2022-09-15 18:17:00: Executing cmd: /bin/su grid -c "/u01/app/11.2.0/grid/bin/asmca -silent -diskGroupName SYSTEMDG -diskList '/dev/asmdisk1,/dev/asmdisk2,/dev/asmdisk3' -redundancy NORMAL -diskString '/dev/asm*' -configureLocalASM -au_size 4"
--------------


[root@hisdb01 ~]# /u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g 


The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid


Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.




Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
  root wallet
  root wallet cert
  root cert export
  peer wallet
  profile reader wallet
  pa wallet
  peer wallet keys
  pa wallet keys
  peer cert request
  pa cert request
  peer cert
  pa cert
  peer root cert TP
  profile reader root cert TP
  pa root cert TP
  peer pa cert TP
  pa peer cert TP
  profile reader pa cert TP
  profile reader peer cert TP
  peer user cert
  pa user cert
Adding Clusterware entries to oracle-ohasd.service
CRS-2672: Attempting to start 'ora.mdnsd' on 'hisdb01'
CRS-2676: Start of 'ora.mdnsd' on 'hisdb01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'hisdb01'
CRS-2676: Start of 'ora.gpnpd' on 'hisdb01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'hisdb01'
CRS-2672: Attempting to start 'ora.gipcd' on 'hisdb01'
CRS-2676: Start of 'ora.cssdmonitor' on 'hisdb01' succeeded
CRS-2676: Start of 'ora.gipcd' on 'hisdb01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'hisdb01'
CRS-2672: Attempting to start 'ora.diskmon' on 'hisdb01'
CRS-2676: Start of 'ora.diskmon' on 'hisdb01' succeeded
CRS-2676: Start of 'ora.cssd' on 'hisdb01' succeeded


ASM created and started successfully.


Disk Group SYSTEMDG created successfully.


clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
Successful addition of voting disk 0c7ead0237314f2fbff053003098cf0d.
Successful addition of voting disk 37fbee628ac04f44bfb23d29eaab5f00.
Successful addition of voting disk 0b70911e26f44fa5bffd123cbf59f286.
Successfully replaced voting disk group with +SYSTEMDG.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   0c7ead0237314f2fbff053003098cf0d (/dev/asmdisk1) [SYSTEMDG]
 2. ONLINE   37fbee628ac04f44bfb23d29eaab5f00 (/dev/asmdisk2) [SYSTEMDG]
 3. ONLINE   0b70911e26f44fa5bffd123cbf59f286 (/dev/asmdisk3) [SYSTEMDG]
Located 3 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'hisdb01'
CRS-2676: Start of 'ora.asm' on 'hisdb01' succeeded
CRS-2672: Attempting to start 'ora.SYSTEMDG.dg' on 'hisdb01'
CRS-2676: Start of 'ora.SYSTEMDG.dg' on 'hisdb01' succeeded
Configure Oracle Grid Infrastructure for a Cluster ... succeeded


[root@hisdb02 ~]# /u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g 


The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid


Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.




Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
Adding Clusterware entries to oracle-ohasd.service
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node hisdb01, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
Configure Oracle Grid Infrastructure for a Cluster ... succeeded


[root@hisdb03 ~]# /u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g 


The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid


Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.




Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
Adding Clusterware entries to oracle-ohasd.service
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node hisdb01, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
Configure Oracle Grid Infrastructure for a Cluster ... succeeded


在所有节点执行完成root.sh后，点击确定

--进入该目录，可以看到上面的操作日志
[root@hisdb01 cfgtoollogs]# pwd
/u01/app/11.2.0/grid/cfgtoollogs

所有的root.sh都去调用了这个脚本，通过前台日志和后台日志均可以看出来，我们看看里面的关键信息：

4. 重新挂载其余asm磁盘（全部节点依次执行）
如果还需要进行磁盘的添加、删除操作，可以使用asmca
su - grid
sqlplus / as sysasm
SQL> col name for a30
SQL> select group_number,name,state,type from v$asm_diskgroup;


GROUP_NUMBER NAME          STATE       TYPE
------------ ------------------------------ ---------------------- ------------
     1 SYSTEMDG          MOUNTED       NORMAL
     0 DATA          DISMOUNTED
     0 FRA          DISMOUNTED


SQL> alter diskgroup data mount;


Diskgroup altered.


SQL> alter diskgroup fra mount;


Diskgroup altered.


在第一个节点挂载后就会注册到ocr，然后就可以用命令打开所有的磁盘组了
srvctl start diskgroup -g fra -n hisdb02
srvctl start diskgroup -g data -n hisdb02
srvctl start diskgroup -g fra -n hisdb03
srvctl start diskgroup -g data -n hisdb03




[grid@hisdb03 ~]$ more /tmp/1.txt 
+ASM1.asm_diskgroups='DATA','FRA'#Manual Mount
+ASM2.asm_diskgroups='DATA','FRA'#Manual Mount
+ASM3.asm_diskgroups='FRA','DATA'#Manual Mount
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE


5、安装数据库软件


在节点1中ROOT用户运行这个脚本，安装前建打上补丁p19404309


chown -R oracle:oinstall /software/
su - oracle
cd /software
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
cp /software/bug/b19404309/database/cvu_prereq.xml /software/database/stage/cvu/


用oracle用户执行安装：
cd /software/database/
./runInstaller

-----------------安装db报错--------------------------------------
安装database软件，在执行root.sh脚本的时候会报错：(这是em的一个bug),在节点一操作，其余节点还没复制安装代码过去；


Error in invoking target 'agent nmhs' of makefile '/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk'
解决方法一：
选择 继续，然后打上补丁：19692824 
解决方法二：
编辑文件 $ORACLE_HOME/sysman/lib/ins_emagent.mk
vi /u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk
找到 $(MK_EMAGENT_NMECTL) 这一行，在后面添加 -lnnz11 如下：
$(MK_EMAGENT_NMECTL) -lnnz11
然后点击retry 即可

[root@hisdb03 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing 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@hisdb01 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
Performing root user operation for Oracle 11g 


The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1


Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.


Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.


[root@hisdb02 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
[root@hisdb03 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh


6.db层面先处理，拉起业务


6.1 rdbms pfile处理(1\2\3节点分别用oracle用户执行)


ASMCMD [+data/ORCL] > ls -l
Type           Redund  Striped  Time             Sys  Name
                                                 Y    CONTROLFILE/
                                                 Y    DATAFILE/
                                                 Y    ONLINELOG/
                                                 Y    PARAMETERFILE/
                                                 Y    TEMPFILE/
                                                 N    snapcf_orcl1.f => +DATA/ORCL/CONTROLFILE/Backup.268.1111324603
                                                 N    spfileorcl.ora => +DATA/ORCL/PARAMETERFILE/spfile.267.1030194983




echo "SPFILE='+DATA/orcl/spfileorcl.ora'" >> /u01/app/oracle/product/11.2.0/db_1/dbs/initorcl1.ora
echo "SPFILE='+DATA/orcl/spfileorcl.ora'" >> /u01/app/oracle/product/11.2.0/db_1/dbs/initorcl2.ora
echo "SPFILE='+DATA/orcl/spfileorcl.ora'" >> /u01/app/oracle/product/11.2.0/db_1/dbs/initorcl3.ora


6.2 密码文件处理
[oracle@hisdb02 dbs]$ orapwd -h
Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n>


  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
    
  There must be no spaces around the equal-to (=) character.


[oracle@hisdb01 dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl1 password=oracle force=y
[oracle@hisdb02 dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl2 password=oracle force=y
[oracle@hisdb03 dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl3 password=oracle force=y


ll /u01/app/oracle/product/11.2.0/db_1/dbs/


6.3 注册数据库服务
[oracle@hisdb01 dbs]$ srvctl add database -h


Adds a database configuration to the Oracle Clusterware.


Usage: srvctl add database -d <db_unique_name> -o <oracle_home> [-c {RACONENODE | RAC | SINGLE} [-e <server_list>] [-i <inst_name>] [-w <timeout>]] [-m <domain_name>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-n <db_name>] [-y {AUTOMATIC | MANUAL | NORESTART}] [-g "<serverpool_list>"] [-x <node_name>] [-a "<diskgroup_list>"] [-j "<acfs_path_list>"]
    -d <db_unique_name>      Unique name for the database
    -o <oracle_home>         ORACLE_HOME path
    -c <type>                Type of database: RAC One Node, RAC, or Single Instance
    -e <server_list>         Candidate server list for RAC One Node database
    -i <inst_name>           Instance name prefix for administrator-managed RAC One Node database (default first 12 characters of <db_unique_name>)
    -w <timeout>             Online relocation timeout in minutes
    -x <node_name>           Node name. -x option is specified for single-instance databases
    -m <domain>              Domain for database. Must be set if database has DB_DOMAIN set.
    -p <spfile>              Server parameter file path
    -r <role>                Role of the database (primary, physical_standby, logical_standby, snapshot_standby)
    -s <start_options>       Startup options for the database. Examples of startup options are OPEN, MOUNT, or 'READ ONLY'.
    -t <stop_options>        Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.
    -n <db_name>             Database name (DB_NAME), if different from the unique name given by the -d option
    -y <dbpolicy>            Management policy for the database (AUTOMATIC, MANUAL, or NORESTART)
    -g "<serverpool_list>"   Comma separated list of database server pool names
    -a "<diskgroup_list>"    Comma separated list of disk groups
    -j "<acfs_path_list>"    Comma separated list of ACFS paths where database's dependency will be set
    -h                       Print usage


[oracle@hisdb01 dbs]$ srvctl add database -d orcl -o /u01/app/oracle/product/11.2.0/db_1 -p +DATA/orcl/spfileorcl.ora -n orcl -a "FRA,DATA"


6.4 注册数据库实例
[oracle@hisdb01 dbs]$ srvctl add instance -d orcl -i orcl1 -n hisdb01
[oracle@hisdb01 dbs]$ srvctl add instance -d orcl -i orcl2 -n hisdb02
[oracle@hisdb01 dbs]$ srvctl add instance -d orcl -i orcl3 -n hisdb03


[oracle@hisdb01 dbs]$ srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/orcl/spfileorcl.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2,orcl3
Disk Groups: FRA,DATA
Mount point paths: 
Services: 
Type: RAC
Database is administrator managed


6.5 起停数据库测试
[oracle@hisdb01 dbs]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 15 23:19:50 2022


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> startup
ORACLE instance started.


Total System Global Area 2505338880 bytes
Fixed Size        2255832 bytes
Variable Size     1124074536 bytes
Database Buffers   1358954496 bytes
Redo Buffers       20054016 bytes
Database mounted.
Database opened.


[root@hisdb01 dbs]# srvctl stop database -d orcl
[root@hisdb01 dbs]# srvctl start database -d orcl


[root@hisdb01 dbs]# crsctl stat res ora.orcl.db -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.orcl.db
      1        ONLINE  ONLINE       hisdb01                  Open                
      2        ONLINE  ONLINE       hisdb02                  Open                
      3        ONLINE  ONLINE       hisdb03                  Open


6.6 如果以前还有补丁，则需要关注，要更新补丁至少大于等于以前的环境；