19c rac_grid_silent_responsefile

admin

grid install
[grid@zy1 ~]$ cat grid.rsp|grep -v ^#|grep -v ^$|grep -v =$

1. oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0
   
2. INVENTORY_LOCATION=/u01/app/oraInventory
   
3. oracle.install.option=CRS_CONFIG
   
4. ORACLE_BASE=/u01/app/grid
   
5. oracle.install.asm.OSDBA=asmdba
   
6. oracle.install.asm.OSOPER=asmoper
   
7. oracle.install.asm.OSASM=asmadmin
   
8. oracle.install.crs.config.scanType=LOCAL_SCAN
   
9. oracle.install.crs.config.gpnp.scanName=zy-scan
   
10. oracle.install.crs.config.gpnp.scanPort=1521
    
11. oracle.install.crs.config.ClusterConfiguration=STANDALONE
    
12. oracle.install.crs.config.configureAsExtendedCluster=false
    
13. oracle.install.crs.config.clusterName=zy-cluster
    
14. oracle.install.crs.config.gpnp.configureGNS=false
    
15. oracle.install.crs.config.autoConfigureClusterNodeVIP=false
    
16. oracle.install.crs.config.clusterNodes=zy1:zy1-vip,zy2:zy2-vip
    
17. oracle.install.crs.config.networkInterfaceList=enp0s3:192.168.56.0:1,enp0s8:10.10.10.0:2,enp0s9:10.10.10.0:4
    
18. oracle.install.crs.configureGIMR=false
    
19. oracle.install.asm.configureGIMRDataDG=false
    
20. oracle.install.crs.config.storageOption=FLEX_ASM_STORAGE
    
21. oracle.install.asm.SYSASMPassword=asm_Admin
    
22. oracle.install.asm.monitorPassword=asm_Admin
    
23. oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=                       
    
24. oracle.install.crs.config.useIPMI=false
    
25. oracle.install.asm.diskGroup.name=data1
    
26. oracle.install.asm.diskGroup.redundancy=EXTERNAL
    
27. oracle.install.asm.diskGroup.AUSize=4
    
28. oracle.install.asm.diskGroup.disks=/dev/asmdisks/asmdiskb
    
29. oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asmdisks/*
    
30. oracle.install.asm.gimrDG.AUSize=1
    
31. oracle.install.asm.configureAFD=false
    
32. oracle.install.crs.configureRHPS=false
    
33. oracle.install.crs.config.ignoreDownNodes=false                       
    
34. oracle.install.config.managementOption=NONE
    
35. oracle.install.config.omsPort=0
    
36. oracle.install.crs.rootconfig.executeRootScript=false

复制代码

1. [grid@raca_1 grid]$ ./gridSetup.sh -silent -responseFile /tmp/grid.rsp -ignorePrereqFailure
   
2. Launching Oracle Grid Infrastructure Setup Wizard...
   
3. 
   
4. [WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.
   
5.    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].
   
6.    ACTION: Provide a password that conforms to the Oracle recommended standards.
   
7. [WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.
   
8.    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].
   
9.    ACTION: Provide a password that conforms to the Oracle recommended standards.
   
10. [WARNING] [INS-40109] The specified Oracle Base location is not empty on this server.
    
11.    ACTION: Specify an empty location for Oracle Base.
    
12. [WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
    
13.    CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/GridSetupActions2023-07-18_11-11-34AM/gridSetupActions2023-07-18_11-11-34AM.log
    
14.    ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/GridSetupActions2023-07-18_11-11-34AM/gridSetupActions2023-07-18_11-11-34AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
    
15. The response file for this session can be found at:
    
16. /u01/app/19.0.0/grid/install/response/grid_2023-07-18_11-11-34AM.rsp
    
17. 
    
18. You can find the log of this install session at:
    
19. /u01/app/oraInventory/logs/GridSetupActions2023-07-18_11-11-34AM/gridSetupActions2023-07-18_11-11-34AM.log
    
20. 
    
21. As a root user, execute the following script(s):
    
22.         1. /u01/app/oraInventory/orainstRoot.sh
    
23.         2. /u01/app/19.0.0/grid/root.sh
    
24. 
    
25. Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
    
26. [raca_2]
    
27. Execute /u01/app/19.0.0/grid/root.sh on the following nodes:
    
28. [raca_1, raca_2]
    
29. 
    
30. Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes.
    
31. 
    
32. Successfully Setup Software with warning(s).
    
33. As install user, execute the following command to complete the configuration.
    
34.         /u01/app/19.0.0/grid/gridSetup.sh -executeConfigTools -responseFile /tmp/grid.rsp [-silent]
    

复制代码

database install
[oracle@zy1 response]$ cat db_2022-12-05_08-20-27PM.rsp|grep -v ^#|grep -v ^$|grep -v =$

1. oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
   
2. oracle.install.option=INSTALL_DB_SWONLY
   
3. UNIX_GROUP_NAME=oinstall
   
4. INVENTORY_LOCATION=/u01/app/oraInventory
   
5. ORACLE_BASE=/u01/app/oracle                  
   
6. oracle.install.db.InstallEdition=EE
   
7. oracle.install.db.OSDBA_GROUP=dba
   
8. oracle.install.db.OSOPER_GROUP=oper
   
9. oracle.install.db.OSBACKUPDBA_GROUP=backupdba
   
10. oracle.install.db.OSDGDBA_GROUP=dgdba
    
11. oracle.install.db.OSKMDBA_GROUP=kmdba
    
12. oracle.install.db.OSRACDBA_GROUP=racdba
    
13. oracle.install.db.rootconfig.executeRootScript=false
    
14. oracle.install.db.CLUSTER_NODES=zy1,zy2
    
15. oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
    
16. oracle.install.db.ConfigureAsContainerDB=false
    
17. oracle.install.db.config.starterdb.memoryOption=false
    
18. oracle.install.db.config.starterdb.installExampleSchemas=false
    
19. oracle.install.db.config.starterdb.managementOption=DEFAULT
    
20. oracle.install.db.config.starterdb.omsPort=0
    
21. oracle.install.db.config.starterdb.enableRecovery=false
    

复制代码

dbca create database
[oracle@zy1 ~]$ cat dbca.rsp |grep -v ^$|grep -v ^#|grep -v =$

1. responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
   
2. gdbName=ora19
   
3. sid=ora19
   
4. databaseConfigType=RAC
   
5. policyManaged=false
   
6. createServerPool=false
   
7. force=false
   
8. createAsContainerDatabase=true
   
9. numberOfPDBs=1
   
10. pdbName=pdb1
    
11. useLocalUndoForPDBs=true
    
12. nodelist=zy1,zy2
    
13. templateName=/u01/app/oracle/product/19.0.0/db_1/assistants/dbca/templates/General_Purpose.dbc
    
14. systemPassword=
    
15. emExpressPort=5500
    
16. runCVUChecks=FALSE
    
17. omsPort=0
    
18. dvConfiguration=false
    
19. olsConfiguration=false
    
20. datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/
    
21. datafileDestination=+DATA1/{DB_UNIQUE_NAME}/
    
22. recoveryAreaDestination=+DATA1
    
23. storageType=ASM
    
24. diskGroupName=+DATA1/{DB_UNIQUE_NAME}/
    
25. recoveryGroupName=+DATA1
    
26. characterSet=AL32UTF8
    
27. nationalCharacterSet=AL16UTF16
    
28. registerWithDirService=false
    
29. listeners=LISTENER
    
30. variables=ORACLE_BASE_HOME=/u01/app/oracle/product/19.0.0/db_1,DB_UNIQUE_NAME=ora19a,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=ora19,ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1,SID=ora19
    
31. initParams=ora191.undo_tablespace=UNDOTBS1,ora192.undo_tablespace=UNDOTBS2,sga_target=2394MB,db_block_size=8192BYTES,cluster_database=true,family:dw_helper.instance_mode=read-only,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=zyracXDB),diagnostic_dest={ORACLE_BASE},remote_login_passwordfile=exclusive,db_create_file_dest=+DATA1/{DB_UNIQUE_NAME}/,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,processes=320,pga_aggregate_target=798MB,ora191.thread=1,ora192.thread=2,nls_territory=AMERICA,local_listener=-oraagent-dummy-,db_recovery_file_dest_size=13332MB,open_cursors=600,log_archive_format=%t_%s_%r.arc,compatible=19.0.0,db_name=ora19,ora191.instance_number=1,ora192.instance_number=2,db_recovery_file_dest=+DATA1,audit_trail=db
    
32. sampleSchema=false
    
33. memoryPercentage=40
    
34. databaseType=MULTIPURPOSE
    
35. automaticMemoryManagement=false
    
36. totalMemory=0

复制代码

1. [oracle@raca1 ~]$ dbca -silent -createDatabase -ignorePrereqFailure -responsefile /tmp/dbca.rsp
   
2. Enter SYS user password:
   
3. 
   
4. Enter SYSTEM user password:
   
5. 
   
6. Enter PDBADMIN User Password:
   
7. 
   
8. [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   
9.    CAUSE:
   
10. 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].
    
11. b.The password entered is a keyword that Oracle does not recommend to be used as password
    
12.    ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
    
13. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
    
14.    CAUSE:
    
15. 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].
    
16. b.The password entered is a keyword that Oracle does not recommend to be used as password
    
17.    ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
    
18. [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
    
19.    CAUSE:
    
20. 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].
    
21. b.The password entered is a keyword that Oracle does not recommend to be used as password
    
22.    ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
    
23. Prepare for db operation
    
24. 7% complete
    
25. Copying database files
    
26. 27% complete
    
27. Creating and starting Oracle instance
    
28. 28% complete
    
29. 31% complete
    
30. 35% complete
    
31. 37% complete
    
32. 40% complete
    
33. Creating cluster database views
    
34. 41% complete
    
35. 53% complete
    
36. Completing Database Creation
    
37. 57% complete
    
38. 59% complete
    
39. 60% complete
    
40. Creating Pluggable Databases
    
41. 64% complete
    
42. 80% complete
    
43. Executing Post Configuration Actions
    
44. 100% complete
    
45. Database creation complete. For details check the logfiles at:
    
46. /u01/app/oracle/cfgtoollogs/dbca/raca.
    
47. Database Information:
    
48. Global Database Name:raca
    
49. System Identifier(SID) Prefix:raca1
    
50. Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/raca/raca.log" for further details.

复制代码

dbca remove database

1. dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName sys -sysDBAPassword oracle -sid orcl1

复制代码

1. mkdir -p /u01/app/19.0.0/grid
   
2. mkdir -p /u01/app/grid
   
3. mkdir -p /u01/app/oracle/product/19.0.0/db_1
   
4. chown -R grid:oinstall /u01
   
5. chown -R oracle:oinstall /u01/app/oracle
   
6. chmod -R 775 /u01
   
7. 
   
8. umask 022
   
9. export ORACLE_BASE=/u01/app/grid
   
10. export ORACLE_HOME=/u01/app/19.0.0/grid
    
11. export ORACLE_SID=+ASM1
    
12. export PATH=${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch:${PATH}
    
13. if [ -t 0 ]; then
    
14.    stty intr ^C
    
15. fi
    
16. 
    
17. umask 022
    
18. export ORACLE_BASE=/u01/app/oracle
    
19. export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1
    
20. export ORACLE_SID=rac1
    
21. export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
    
22. export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
    
23. export LD_LIBRARY_PATH=${ORACLE_HOME}/lib
    
24. export PATH=${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch:${PATH}
    
25. if [ -t 0 ]; then
    
26.    stty intr ^C
    
27. fi
    
28. 
    
29. 
    
30. ./sshUserSetup.sh -user oracle -hosts "raca1 raca2" -advanced -confirm -noPromptPassphrase
    
31. $ORACLE_HOME/runcluvfy.sh stage -pre crsinst -n raca1,raca2 -fixup -verbose
    
32. 
    
33. for h in raca1 raca1-priv  raca2 raca2-priv ;do
    
34. ssh -l oracle -o StrictHostKeyChecking=no $h date;
    
35. done
    
36. 
    
37. udevadm control --reload-rules
    
38. udevadm trigger
    
39. ls -l /dev/asmdisks/
    
40. 
    
41. for i in b; do
    
42. echo " KERNEL=="sd*", ACTION=="add|change", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d /dev/\$name", RESULT=="$(/lib/udev/scsi_id -g -u -d /dev/sd$i)", SYMLINK+="asmdisks/asmdisk$i", OWNER="grid", GROUP="asmadmin", MODE="0660""
    
43. done > /etc/udev/rules.d/99-oracle-asmdisks.rules

复制代码