Oracle 19c grid response file . [grid@oragrid ~]$ cat grid.rsp|grep -v '#'|grep -v -e '^$' oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0 INVENTORY_LOCATION=/u01/app/oraInventory oracle.install.option=HA_CONFIG ORACLE_BASE=/u01/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.SCANClientDataFile= oracle.install.crs.config.gpnp.scanName= oracle.install.crs.config.gpnp.scanPort= oracle.install.crs.config.ClusterConfiguration=STANDALONE oracle.install.crs.config.configureAsExtendedCluster=false oracle.install.crs.config.memberClusterManifestFile= oracle.install.crs.config.clusterName= 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.config.gpnp.gnsClientDataFile= oracle.install.crs.config.gpnp.gnsSubDomain= oracle.install.crs.config.gpnp.gnsVIPAddress= oracle.install.crs.config.sites= oracle.install.crs.config.clusterNodes= oracle.install.crs.config.networkInterfaceList= oracle.install.crs.configureGIMR=false oracle.install.asm.configureGIMRDataDG=false oracle.install.crs.config.storageOption= oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations= oracle.install.crs.config.sharedFileSystemStorage.ocrLocations= oracle.install.crs.config.useIPMI=false oracle.install.crs.config.ipmi.bmcUsername= oracle.install.crs.config.ipmi.bmcPassword= oracle.install.asm.SYSASMPassword= oracle.install.asm.diskGroup.name=DATA oracle.install.asm.diskGroup.redundancy=EXTERNAL oracle.install.asm.diskGroup.AUSize=4 oracle.install.asm.diskGroup.FailureGroups= oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/oracleasm/disks/DATA1, oracle.install.asm.diskGroup.disks=/dev/oracleasm/disks/DATA1 oracle.install.asm.diskGroup.quorumFailureGroupNames= oracle.install.asm.diskGroup.diskDiscoveryString=/dev/oracleasm/disks/ oracle.install.asm.monitorPassword= oracle.install.asm.gimrDG.name= oracle.install.asm.gimrDG.redundancy= oracle.install.asm.gimrDG.AUSize=1 oracle.install.asm.gimrDG.FailureGroups= oracle.install.asm.gimrDG.disksWithFailureGroupNames= oracle.install.asm.gimrDG.disks= oracle.install.asm.gimrDG.quorumFailureGroupNames= oracle.install.asm.configureAFD=false oracle.install.crs.configureRHPS=false oracle.install.crs.config.ignoreDownNodes=false oracle.install.config.managementOption=NONE oracle.install.config.omsHost= oracle.install.config.omsPort=0 oracle.install.config.emAdminUser= oracle.install.config.emAdminPassword= oracle.install.crs.rootconfig.executeRootScript=false oracle.install.crs.rootconfig.configMethod= oracle.install.crs.rootconfig.sudoPath= oracle.install.crs.rootconfig.sudoUserName= oracle.install.crs.config.batchinfo= oracle.install.crs.app.applicationAddress= oracle.install.crs.deleteNode.nodes= ############### full file !!! [grid@oragrid ~]$ cat grid.rsp ############################################################################### ## Copyright(c) Oracle Corporation 1998,2019. All rights reserved. ## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file contains plain text passwords and ## ## should be secured to have read permission only by oracle user ## ## or db administrator who owns this installation. ## ## ## ############################################################################### ############################################################################### ## ## ## Instructions to fill this response file ## ## To register and configure 'Grid Infrastructure for Cluster' ## ## - Fill out sections A,B,C,D,E,F and G ## ## - Fill out section G if OCR and voting disk should be placed on ASM ## ## ## ## To register and configure 'Grid Infrastructure for Standalone server' ## ## - Fill out sections A,B and G ## ## ## ## To register software for 'Grid Infrastructure' ## ## - Fill out sections A,B and D ## ## - Provide the cluster nodes in section D when choosing CRS_SWONLY as ## ## installation option in section A ## ## ## ## To upgrade clusterware and/or Automatic storage management of earlier ## ## releases ## ## - Fill out sections A,B,C,D and H ## ## ## ## To add more nodes to the cluster ## ## - Fill out sections A and D ## ## - Provide the cluster nodes in section D when choosing CRS_ADDNODE as ## ## installation option in section A ## ## ## ############################################################################### #------------------------------------------------------------------------------ # Do not change the following system generated value. #------------------------------------------------------------------------------ oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0 ############################################################################### # # # SECTION A - BASIC # # # ############################################################################### #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/u01/app/oraInventory #------------------------------------------------------------------------------- # Specify the installation option. # Allowed values: CRS_CONFIG or HA_CONFIG or UPGRADE or CRS_SWONLY or HA_SWONLY # - CRS_CONFIG : To register home and configure Grid Infrastructure for cluster # - HA_CONFIG : To register home and configure Grid Infrastructure for stand alone server # - UPGRADE : To register home and upgrade clusterware software of earlier release # - CRS_SWONLY : To register Grid Infrastructure Software home (can be configured for cluster # or stand alone server later) # - HA_SWONLY : To register Grid Infrastructure Software home (can be configured for stand # alone server later. This is only supported on Windows.) # - CRS_ADDNODE : To add more nodes to the cluster # - CRS_DELETE_NODE : To delete nodes to the cluster #------------------------------------------------------------------------------- oracle.install.option=HA_CONFIG #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/u01/app/grid ################################################################################ # # # SECTION B - GROUPS # # # # The following three groups need to be assigned for all GI installations. # # OSDBA and OSOPER can be the same or different. OSASM must be different # # than the other two. # # The value to be specified for OSDBA, OSOPER and OSASM group is only for # # Unix based Operating System. # # These groups are not required for upgrades, as they will be determined # # from the Oracle home to upgrade. # # # ################################################################################ #------------------------------------------------------------------------------- # The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges. #------------------------------------------------------------------------------- oracle.install.asm.OSDBA=asmdba #------------------------------------------------------------------------------- # The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges. # The value to be specified for OSOPER group is optional. # Value should not be provided if configuring Client Cluster - i.e. storageOption=CLIENT_ASM_STORAGE. #------------------------------------------------------------------------------- oracle.install.asm.OSOPER=asmoper #------------------------------------------------------------------------------- # The OSASM_GROUP is the OS group which is to be granted SYSASM privileges. This # must be different than the previous two. #------------------------------------------------------------------------------- oracle.install.asm.OSASM=asmadmin ################################################################################ # # # SECTION C - SCAN # # # ################################################################################ #------------------------------------------------------------------------------- # Specify the type of SCAN configuration for the cluster # Allowed values : LOCAL_SCAN and SHARED_SCAN #------------------------------------------------------------------------------- oracle.install.crs.config.scanType=LOCAL_SCAN #------------------------------------------------------------------------------- # Applicable only if SHARED_SCAN is being configured for cluster # Specify the path to the SCAN client data file #------------------------------------------------------------------------------- oracle.install.crs.config.SCANClientDataFile= #------------------------------------------------------------------------------- # Specify a name for SCAN # Applicable if LOCAL_SCAN is being configured for the cluster # If you choose to configure the cluster with GNS with Auto assigned Node VIPs(DHCP),then the scanName should be specified in the format of 'SCAN name.Cluster name.GNS sub-domain' #------------------------------------------------------------------------------- oracle.install.crs.config.gpnp.scanName= #------------------------------------------------------------------------------- # Specify a unused port number for SCAN service #------------------------------------------------------------------------------- oracle.install.crs.config.gpnp.scanPort= ################################################################################ # # # SECTION D - CLUSTER & GNS # # # ################################################################################ #------------------------------------------------------------------------------- # Specify the required cluster configuration # Allowed values: STANDALONE, DOMAIN, MEMBERDB, MEMBERAPP #------------------------------------------------------------------------------- oracle.install.crs.config.ClusterConfiguration=STANDALONE #------------------------------------------------------------------------------- # Specify 'true' if you would like to configure the cluster as Extended, else # specify 'false' # # Applicable only for STANDALONE and DOMAIN cluster configuration #------------------------------------------------------------------------------- oracle.install.crs.config.configureAsExtendedCluster=false #------------------------------------------------------------------------------- # Specify the Member Cluster Manifest file # # Applicable only for MEMBERDB and MEMBERAPP cluster configuration #------------------------------------------------------------------------------- oracle.install.crs.config.memberClusterManifestFile= #------------------------------------------------------------------------------- # Specify a name for the Cluster you are creating. # # The maximum length allowed for clustername is 63 characters. The name can be # any combination of lower and uppercase alphabets (A - Z), (0 - 9) and hyphens (-). # # Applicable only for STANDALONE and DOMAIN cluster configuration #------------------------------------------------------------------------------- oracle.install.crs.config.clusterName= #------------------------------------------------------------------------------- # Applicable only for STANDALONE, DOMAIN, MEMBERDB cluster configuration. # Specify 'true' if you would like to configure Grid Naming Service(GNS), else # specify 'false' #------------------------------------------------------------------------------- oracle.install.crs.config.gpnp.configureGNS=false #------------------------------------------------------------------------------- # Applicable only for STANDALONE and DOMAIN cluster configuration if you choose to configure GNS. # Specify 'true' if you would like to assign SCAN name VIP and Node VIPs by DHCP # , else specify 'false' #------------------------------------------------------------------------------- oracle.install.crs.config.autoConfigureClusterNodeVIP=false #------------------------------------------------------------------------------- # Applicable only if you choose to configure GNS. # Specify the type of GNS configuration for cluster # Allowed values are: CREATE_NEW_GNS and USE_SHARED_GNS # Only USE_SHARED_GNS value is allowed for MEMBERDB cluster configuration. #------------------------------------------------------------------------------- oracle.install.crs.config.gpnp.gnsOption=CREATE_NEW_GNS #------------------------------------------------------------------------------- # Applicable only if SHARED_GNS is being configured for cluster # Specify the path to the GNS client data file #------------------------------------------------------------------------------- oracle.install.crs.config.gpnp.gnsClientDataFile= #------------------------------------------------------------------------------- # Applicable only for STANDALONE and DOMAIN cluster configuration if you choose to # configure GNS for this cluster oracle.install.crs.config.gpnp.gnsOption=CREATE_NEW_GNS # Specify the GNS subdomain and an unused virtual hostname for GNS service #------------------------------------------------------------------------------- oracle.install.crs.config.gpnp.gnsSubDomain= oracle.install.crs.config.gpnp.gnsVIPAddress= #------------------------------------------------------------------------------- # Specify the list of sites - only if configuring an Extended Cluster #------------------------------------------------------------------------------- oracle.install.crs.config.sites= #------------------------------------------------------------------------------- # Specify the list of nodes that have to be configured to be part of the cluster. # # The list should a comma-separated list of tuples. Each tuple should be a # colon-separated string that contains # - 1 field if you have chosen CRS_SWONLY as installation option, or # - 1 field if configuring an Application Cluster, or # - 3 fields if configuring a Flex Cluster # - 3 fields if adding more nodes to the configured cluster, or # - 4 fields if configuring an Extended Cluster # # The fields should be ordered as follows: # 1. The first field should be the public node name. # 2. The second field should be the virtual host name # (Should be specified as AUTO if you have chosen 'auto configure for VIP' # i.e. autoConfigureClusterNodeVIP=true) # 3. The third field indicates the site designation for the node. To be specified only if configuring an Extended Cluster. # Only the 1st field is applicable if you have chosen CRS_SWONLY as installation option # Only the 1st field is applicable if configuring an Application Cluster # # Examples # For registering GI for a cluster software: oracle.install.crs.config.clusterNodes=node1,node2 # For adding more nodes to the configured cluster: oracle.install.crs.config.clusterNodes=node1:node1-vip,node2:node2-vip # For configuring Application Cluster: oracle.install.crs.config.clusterNodes=node1,node2 # For configuring Flex Cluster: oracle.install.crs.config.clusterNodes=node1:node1-vip,node2:node2-vip # For configuring Extended Cluster: oracle.install.crs.config.clusterNodes=node1:node1-vip:site1,node2:node2-vip:site2 # You can specify a range of nodes in the tuple using colon separated fields of format # hostnameprefix:lowerbound-upperbound:hostnamesuffix:vipsuffix:role of node # #------------------------------------------------------------------------------- oracle.install.crs.config.clusterNodes= #------------------------------------------------------------------------------- # The value should be a comma separated strings where each string is as shown below # InterfaceName:SubnetAddress:InterfaceType # where InterfaceType can be either "1", "2", "3", "4", or "5" # InterfaceType stand for the following values # - 1 : PUBLIC # - 2 : PRIVATE # - 3 : DO NOT USE # - 4 : ASM # - 5 : ASM & PRIVATE # # For example: eth0:140.87.24.0:1,eth1:10.2.1.0:2,eth2:140.87.52.0:3 # #------------------------------------------------------------------------------- oracle.install.crs.config.networkInterfaceList= #------------------------------------------------------------------------------ # Specify 'true' if you would like to configure Grid Infrastructure Management # Repository (GIMR), else specify 'false'. # This option is only applicable when CRS_CONFIG is chosen as install option, # and STANDALONE is chosen as cluster configuration. #------------------------------------------------------------------------------ oracle.install.crs.configureGIMR=false #------------------------------------------------------------------------------ # Create a separate ASM DiskGroup to store GIMR data. # Specify 'true' if you would like to separate GIMR data with clusterware data, # else specify 'false' # Value should be 'true' for DOMAIN cluster configurations # Value can be true/false for STANDALONE cluster configurations. #------------------------------------------------------------------------------ oracle.install.asm.configureGIMRDataDG=false ################################################################################ # # # SECTION E - STORAGE # # # ################################################################################ #------------------------------------------------------------------------------- # Specify the type of storage to use for Oracle Cluster Registry(OCR) and Voting # Disks files. Only applicable for Standalone and MemberDB cluster. # - FLEX_ASM_STORAGE # - CLIENT_ASM_STORAGE # - FILE_SYSTEM_STORAGE # # Option FILE_SYSTEM_STORAGE is only for STANDALONE cluster configuration. #------------------------------------------------------------------------------- oracle.install.crs.config.storageOption= #------------------------------------------------------------------------------- # These properties are applicable only if FILE_SYSTEM_STORAGE is chosen for # storing OCR and voting disk # Specify the location(s) for OCR and voting disks # Three(3) or one(1) location(s) should be specified for OCR and voting disk, # separated by commas. # Example: # For Unix based Operating System: # oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=/oradbocfs/storage/vdsk1,/oradbocfs/storage/vdsk2,/oradbocfs/storage/vdsk3 # oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=/oradbocfs/storage/ocr1,/oradbocfs/storage/ocr2,/oradbocfs/storage/ocr3 # For Windows based Operating System OCR/VDSK on shared storage is not supported. #------------------------------------------------------------------------------- oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations= oracle.install.crs.config.sharedFileSystemStorage.ocrLocations= ################################################################################ # # # SECTION F - IPMI # # # ################################################################################ #------------------------------------------------------------------------------- # Specify 'true' if you would like to configure Intelligent Power Management interface # (IPMI), else specify 'false' #------------------------------------------------------------------------------- oracle.install.crs.config.useIPMI=false #------------------------------------------------------------------------------- # Applicable only if you choose to configure IPMI # i.e. oracle.install.crs.config.useIPMI=true # Specify the username and password for using IPMI service #------------------------------------------------------------------------------- oracle.install.crs.config.ipmi.bmcUsername= oracle.install.crs.config.ipmi.bmcPassword= ################################################################################ # # # SECTION G - ASM # # # ################################################################################ #------------------------------------------------------------------------------- # Password for SYS user of Oracle ASM #------------------------------------------------------------------------------- oracle.install.asm.SYSASMPassword= #------------------------------------------------------------------------------- # The ASM DiskGroup # # Example: oracle.install.asm.diskGroup.name=data # #------------------------------------------------------------------------------- oracle.install.asm.diskGroup.name=DATA #------------------------------------------------------------------------------- # Redundancy level to be used by ASM. # It can be one of the following # - NORMAL # - HIGH # - EXTERNAL # - FLEX# - EXTENDED (required if oracle.install.crs.config.ClusterConfiguration=EXTENDED) # Example: oracle.install.asm.diskGroup.redundancy=NORMAL # #------------------------------------------------------------------------------- oracle.install.asm.diskGroup.redundancy=EXTERNAL #------------------------------------------------------------------------------- # Allocation unit size to be used by ASM. # It can be one of the following values # - 1 # - 2 # - 4 # - 8 # - 16 # Example: oracle.install.asm.diskGroup.AUSize=4 # size unit is MB # #------------------------------------------------------------------------------- oracle.install.asm.diskGroup.AUSize=4 #------------------------------------------------------------------------------- # Failure Groups for the disk group # If configuring for Extended cluster specify as list of "failure group name:site" # tuples. # Else just specify as list of failure group names #------------------------------------------------------------------------------- oracle.install.asm.diskGroup.FailureGroups= #------------------------------------------------------------------------------- # List of disks and their failure groups to create a ASM DiskGroup # (Use this if each of the disks have an associated failure group) # Failure Groups are not required if oracle.install.asm.diskGroup.redundancy=EXTERNAL # Example: # For Unix based Operating System: # oracle.install.asm.diskGroup.disksWithFailureGroupNames=/oracle/asm/disk1,FGName,/oracle/asm/disk2,FGName # For Windows based Operating System: # oracle.install.asm.diskGroup.disksWithFailureGroupNames=\\.\ORCLDISKDATA0,FGName,\\.\ORCLDISKDATA1,FGName # #------------------------------------------------------------------------------- oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/oracleasm/disks/DATA1, #------------------------------------------------------------------------------- # List of disks to create a ASM DiskGroup # (Use this variable only if failure groups configuration is not required) # Example: # For Unix based Operating System: # oracle.install.asm.diskGroup.disks=/oracle/asm/disk1,/oracle/asm/disk2 # For Windows based Operating System: # oracle.install.asm.diskGroup.disks=\\.\ORCLDISKDATA0,\\.\ORCLDISKDATA1 # #------------------------------------------------------------------------------- oracle.install.asm.diskGroup.disks=/dev/oracleasm/disks/DATA1 #------------------------------------------------------------------------------- # List of failure groups to be marked as QUORUM. # Quorum failure groups contain only voting disk data, no user data is stored # Example: # oracle.install.asm.diskGroup.quorumFailureGroupNames=FGName1,FGName2 #------------------------------------------------------------------------------- oracle.install.asm.diskGroup.quorumFailureGroupNames= #------------------------------------------------------------------------------- # The disk discovery string to be used to discover the disks used create a ASM DiskGroup # # Example: # For Unix based Operating System: # oracle.install.asm.diskGroup.diskDiscoveryString=/oracle/asm/* # For Windows based Operating System: # oracle.install.asm.diskGroup.diskDiscoveryString=\\.\ORCLDISK* # #------------------------------------------------------------------------------- oracle.install.asm.diskGroup.diskDiscoveryString=/dev/oracleasm/disks/ #------------------------------------------------------------------------------- # Password for ASMSNMP account # ASMSNMP account is used by Oracle Enterprise Manager to monitor Oracle ASM instances #------------------------------------------------------------------------------- oracle.install.asm.monitorPassword= #------------------------------------------------------------------------------- # GIMR Storage data ASM DiskGroup # Applicable only when # oracle.install.asm.configureGIMRDataDG=true # Example: oracle.install.asm.GIMRDG.name=MGMT # #------------------------------------------------------------------------------- oracle.install.asm.gimrDG.name= #------------------------------------------------------------------------------- # Redundancy level to be used by ASM. # It can be one of the following # - NORMAL # - HIGH # - EXTERNAL # - FLEX# - EXTENDED (only if oracle.install.crs.config.ClusterConfiguration=EXTENDED) # Example: oracle.install.asm.gimrDG.redundancy=NORMAL # #------------------------------------------------------------------------------- oracle.install.asm.gimrDG.redundancy= #------------------------------------------------------------------------------- # Allocation unit size to be used by ASM. # It can be one of the following values # - 1 # - 2 # - 4 # - 8 # - 16 # Example: oracle.install.asm.gimrDG.AUSize=4 # size unit is MB # #------------------------------------------------------------------------------- oracle.install.asm.gimrDG.AUSize=1 #------------------------------------------------------------------------------- # Failure Groups for the GIMR storage data ASM disk group # If configuring for Extended cluster specify as list of "failure group name:site" # tuples. # Else just specify as list of failure group names #------------------------------------------------------------------------------- oracle.install.asm.gimrDG.FailureGroups= #------------------------------------------------------------------------------- # List of disks and their failure groups to create GIMR data ASM DiskGroup # (Use this if each of the disks have an associated failure group) # Failure Groups are not required if oracle.install.asm.gimrDG.redundancy=EXTERNAL # Example: # For Unix based Operating System: # oracle.install.asm.gimrDG.disksWithFailureGroupNames=/oracle/asm/disk1,FGName,/oracle/asm/disk2,FGName # For Windows based Operating System: # oracle.install.asm.gimrDG.disksWithFailureGroupNames=\\.\ORCLDISKDATA0,FGName,\\.\ORCLDISKDATA1,FGName # #------------------------------------------------------------------------------- oracle.install.asm.gimrDG.disksWithFailureGroupNames= #------------------------------------------------------------------------------- # List of disks to create GIMR data ASM DiskGroup # (Use this variable only if failure groups configuration is not required) # Example: # For Unix based Operating System: # oracle.install.asm.gimrDG.disks=/oracle/asm/disk1,/oracle/asm/disk2 # For Windows based Operating System: # oracle.install.asm.gimrDG.disks=\\.\ORCLDISKDATA0,\\.\ORCLDISKDATA1 # #------------------------------------------------------------------------------- oracle.install.asm.gimrDG.disks= #------------------------------------------------------------------------------- # List of failure groups to be marked as QUORUM. # Quorum failure groups contain only voting disk data, no user data is stored # Example: # oracle.install.asm.gimrDG.quorumFailureGroupNames=FGName1,FGName2 #------------------------------------------------------------------------------- oracle.install.asm.gimrDG.quorumFailureGroupNames= #------------------------------------------------------------------------------- # Configure AFD - ASM Filter Driver # Applicable only for FLEX_ASM_STORAGE option # Specify 'true' if you want to configure AFD, else specify 'false' #------------------------------------------------------------------------------- oracle.install.asm.configureAFD=false #------------------------------------------------------------------------------- # Configure RHPS - Rapid Home Provisioning Service # Applicable only for DOMAIN cluster configuration # Specify 'true' if you want to configure RHP service, else specify 'false' #------------------------------------------------------------------------------- oracle.install.crs.configureRHPS=false ################################################################################ # # # SECTION H - UPGRADE # # # ################################################################################ #------------------------------------------------------------------------------- # Specify whether to ignore down nodes during upgrade operation. # Value should be 'true' to ignore down nodes otherwise specify 'false' #------------------------------------------------------------------------------- oracle.install.crs.config.ignoreDownNodes=false ################################################################################ # # # MANAGEMENT OPTIONS # # # ################################################################################ #------------------------------------------------------------------------------- # Specify the management option to use for managing Oracle Grid Infrastructure # Options are: # 1. CLOUD_CONTROL - If you want to manage your Oracle Grid Infrastructure with Enterprise Manager Cloud Control. # 2. NONE -If you do not want to manage your Oracle Grid Infrastructure with Enterprise Manager Cloud Control. #------------------------------------------------------------------------------- oracle.install.config.managementOption=NONE #------------------------------------------------------------------------------- # Specify the OMS host to connect to Cloud Control. # Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.config.omsHost= #------------------------------------------------------------------------------- # Specify the OMS port to connect to Cloud Control. # Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.config.omsPort=0 #------------------------------------------------------------------------------- # Specify the EM Admin user name to use to connect to Cloud Control. # Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.config.emAdminUser= #------------------------------------------------------------------------------- # Specify the EM Admin password to use to connect to Cloud Control. # Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.config.emAdminPassword= ################################################################################ # # # Root script execution configuration # # # ################################################################################ #------------------------------------------------------------------------------------------------------- # Specify the root script execution mode. # # - true : To execute the root script automatically by using the appropriate configuration methods. # - false : To execute the root script manually. # # If this option is selected, password should be specified on the console. #------------------------------------------------------------------------------------------------------- oracle.install.crs.rootconfig.executeRootScript=false #-------------------------------------------------------------------------------------- # Specify the configuration method to be used for automatic root script execution. # # Following are the possible choices: # - ROOT # - SUDO #-------------------------------------------------------------------------------------- oracle.install.crs.rootconfig.configMethod= #-------------------------------------------------------------------------------------- # Specify the absolute path of the sudo program. # # Applicable only when SUDO configuration method was chosen. #-------------------------------------------------------------------------------------- oracle.install.crs.rootconfig.sudoPath= #-------------------------------------------------------------------------------------- # Specify the name of the user who is in the sudoers list. # Applicable only when SUDO configuration method was chosen. # Note:For Grid Infrastructure for Standalone server installations,the sudo user name must be the username of the user performing the installation. #-------------------------------------------------------------------------------------- oracle.install.crs.rootconfig.sudoUserName= #-------------------------------------------------------------------------------------- # Specify the nodes batch map. # # This should be a comma separated list of node:batch pairs. # During upgrade, you can sequence the automatic execution of root scripts # by pooling the nodes into batches. # A maximum of three batches can be specified. # Installer will execute the root scripts on all the nodes in one batch before # proceeding to next batch. # Root script execution on the local node must be in Batch 1. # # Examples: # 1. oracle.install.crs.config.batchinfo=Node1:1,Node2:2,Node3:2,Node4:3 # 2. oracle.install.crs.config.batchinfo=Node1:1,Node2:2,Node3:2,Node4:2 # 3. oracle.install.crs.config.batchinfo=Node1:1,Node2:1,Node3:2,Node4:3 # # Applicable only for UPGRADE install option. #-------------------------------------------------------------------------------------- oracle.install.crs.config.batchinfo= ################################################################################ # # # APPLICATION CLUSTER OPTIONS # # # ################################################################################ #------------------------------------------------------------------------------- # Specify the Virtual hostname to configure virtual access for your Application # The value to be specified for Virtual hostname is optional. #------------------------------------------------------------------------------- oracle.install.crs.app.applicationAddress= ################################################################################# # # # DELETE NODE OPTIONS # # # ################################################################################# #-------------------------------------------------------------------------------- # Specify the node names to delete nodes from cluster. # Delete node will be performed only for the remote nodes from the cluster. #-------------------------------------------------------------------------------- oracle.install.crs.deleteNode.nodes=[grid@oragrid ~]$
Thursday, 12 December 2024
Oracle 19c grid response file
Wednesday, 11 December 2024
Oracle Groups Role Separation (Oracle and Grid , groups and users
|
[root@oragrid rpm]# /u01/app/19.2.0/grid/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
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/19.2.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-10_03-50-46PM.log
2024/12/10 15:50:53 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node oragrid successfully pinned.
2024/12/10 15:51:02 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
oragrid 2024/12/10 15:51:48 /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr 724960844
2024/12/10 15:51:49 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
Monday, 9 December 2024
locate: can not stat () `/var/lib/mlocate/mlocate.db': No such file or directory
locate init.ohasd locate: can not stat () `/var/lib/mlocate/mlocate.db': No such file or directory [root@oraafd ~]# updatedb --- update the database !!! [root@oraafd ~]# ls -ltr /var/lib/mlocate total 8364 -rw-r----- 1 root slocate 8561430 Dec 9 09:17 mlocate.db --- [root@oraafd ~]# locate init.ohasd /etc/rc.d/init.d/init.ohasd /home/grid/36916690/36917416/files/crs/sbs/init.ohasd.sbs /home/grid/36916690/36917416/files/crs/sbs/init.ohasd.sles.sbs /u01/app/grid/19c/grid/crs/init/init.ohasd /u01/app/grid/19c/grid/crs/init/init.ohasd.sles /u01/app/grid/19c/grid/crs/sbs/init.ohasd.sbs /u01/app/grid/19c/grid/crs/sbs/init.ohasd.sles.sbs /u01/app/grid/19c/grid/crs/utl/init.ohasd /u01/app/grid/19c/grid/crs/utl/init.ohasd.sles
Saturday, 7 December 2024
CRS-2974: unable to act on resource 'ora.asm' on server
CRS-2974: unable to act on resource 'ora.asm' on server
[grid@srv1 ~]$ srvctl stop asm PRCR-1065 : Failed to stop resource ora.asm CRS-2974: unable to act on resource 'ora.asm' on server 'srv1' because that would require stopping or relocating resource 'ora.DATADISK.dg' but the appropriate force flag was not specified ps -ef | grep -E 'd\.bin|ohasd' root 1479 1 0 16:37 ? 00:00:00 /bin/sh /etc/init.d/init.ohasd run >/dev/null 2>&1 Password file: +OCRDISK/orapwasm Backup of Password file: ASM listener: LISTENER Spfile: +OCRDISK/ASM/ASMPARAMETERFILE/registry.253.1044813569 ASM diskgroup discovery string: /dev/oracleasm/disks/* [grid@srv1 ~]$ use -force to stop asm srvctl stop asm -force or srvctl stop asm -force -stopoption immediate[grid@srv1 ~]$ srvctl stop asm PRCR-1065 : Failed to stop resource ora.asm CRS-2974: unable to act on resource 'ora.asm' on server 'srv1' because that would require stopping or relocating resource 'ora.DATADISK.dg' but the appropriate force flag was not specified [grid@srv1 ~]$ srvctl stop asm -force [grid@srv1 ~]$ srvctl status asm ASM is not running. [grid@srv1 ~]$ srvctl start asm [grid@srv1 ~]$ [grid@srv1 ~]$ srvctl status asm ASM is running on srv1 [grid@srv1 ~]$
Wednesday, 4 December 2024
How to create Oracle Database Services via srvctl for PDB?
How to create Oracle Database Services via srvctl for PDB?
=====
tnsnames.ora
SQL> show parameter unique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string oradb
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
SQL>
/u01/app/oracle/product/19.0.0/db_1/network/admin
PRODB_SRVP=
(description=
(address_list=
(address = (protocol = TCP)(host = 192.168.1.120)(port = 1521))
)
(connect_data =
(service_name=PRODB_SRVP)
)
)
http://anuj-singh.blogspot.com/2012/03/srvctl-command-reference.html
SYNTAX ----
srvctl add service -d -s [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}][-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}][-z ] [-w ] [-t ] [-f]
srvctl config service -d [-s ] [-v]
srvctl start service -d [-s ""] [-o ]
srvctl stop service -d [-s ""] [-f]
srvctl status service -d [-s ""] [-f] [-v]
srvctl enable service -d -s ""
srvctl disable service -d -s ""
srvctl modify service -d -s [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z ] [-w ] [-t ]
srvctl remove service -d -s [-f]
srvctl add service -db -pdb -service
-preferred
-available
-stopoption IMMEDIATE
-notification true
-drain_timeout 300
[oracle@srv1 admin]$ srvctl add service -d oradb -s PRODB_SRVP -l primary -pdb PDB1 -m BASIC -e SELECT -w 1 -z 180 -q TRUE
[oracle@srv1 admin]$ srvctl start service -d oradb -s PRODB_SRVP
[oracle@srv1 admin]$ srvctl status service -d oradb -s PRODB_SRVP
Service PRODB_SRVP is running
====
Check the resource status !!!
for services ..
crsctl status resource -t|grep -i -b3 svc
srvctl config service -d oradb|grep -i 'service name'
=====
set linesize 100 pages 0
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
select
'SERVICE_ID ..........................................: '||SERVICE_ID ,
'NAME ................................................: '||NAME ,
'kill ................................................: '||NAME_HASH ,
'NAME_HASH ...........................................: '||NETWORK_NAME ,
'CREATION_DATE .......................................: '||CREATION_DATE ,
'CREATION_DATE_HASH ..................................: '||CREATION_DATE_HASH ,
'GOAL ................................................: '||GOAL ,
'DTP .................................................: '||DTP,
'AQ_HA_NOTIFICATION .................................: '||AQ_HA_NOTIFICATION ,
'CLB_GOAL ............................................: '||CLB_GOAL ,
'COMMIT_OUTCOME ......................................: '||COMMIT_OUTCOME ,
'RETENTION_TIME ......................................: '||RETENTION_TIME ,
'REPLAY_INITIATION_TIMEOUT ..........................: '||REPLAY_INITIATION_TIMEOUT ,
'SESSION_STATE_CONSISTENCY ...........................: '||SESSION_STATE_CONSISTENCY ,
'GLOBAL ..............................................: '||GLOBAL,
'PDB ................................................: '||PDB ,
'SQL_TRANSLATION_PROFILE .............................: '||SQL_TRANSLATION_PROFILE ,
'MAX_LAG_TIME.........................................: '||MAX_LAG_TIME,
'STOP_OPTION ........................................: '||STOP_OPTION ,
'FAILOVER_RESTORE ....................................: '||FAILOVER_RESTORE ,
'DRAIN_TIMEOUT .......................................: '||DRAIN_TIMEOUT ,
'TABLE_FAMILY_ID .....................................: '||TABLE_FAMILY_ID ,
'CON_ID ..............................................: '||CON_ID
from gv$services
;
[grid@srv1 ~]$ lsnrctl services|grep -i PRODB_SRVP
Service "PRODB_SRVP" has 1 instance(s).
[oracle@srv1 admin]$ sqlplus anuj/anuj123@PRODB_SRVP
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 4 16:53:31 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Wed Dec 04 2024 16:28:39 +04:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
Friday, 29 November 2024
How to install NTP ?
Failed to restart ntpd.service: Unit ntpd.service not found.
Oracle Linux: How to Start NTP Service With Slewing Enabled (Doc ID 2422934.1)
yum clean all && yum makecache
history
cat /etc/resolv.conf
# Generated by NetworkManager
#search lan
nameserver 127.0.0.1
search localdomain
nameserver 192.168.1.214
nameserver 9.9.9.9
yum install ntp
{
echo OPTIONS=\"-x -u ntp:ntp -p /var/run/ntpd.pid\"
} > /etc/sysconfig/ntpd
==
{ echo OPTIONS=\"-x -u ntp:ntp -p /var/run/ntpd.pid\"; } > /etc/sysconfig/ntpd
systemctl restart ntpd.service
cat /etc/sysconfig/ntpd
cat /etc/ntp.conf
server 0.rhel.pool.ntp.org iburst
server 1.rhel.pool.ntp.org iburst
server 2.rhel.pool.ntp.org iburst
server 3.rhel.pool.ntp.org iburst
[root@ora-rac1 ~]#
systemctl restart ntpd.service
[root@ora-rac1 ~]# ps -ef|grep -i ntpd
ntp 14258 1 0 08:06 ? 00:00:00 /usr/sbin/ntpd -u ntp:ntp -x -u ntp:ntp -p /var/run/ntpd.pid
root 14292 12045 0 08:07 pts/1 00:00:00 grep --color=auto -i ntpd
[root@ora-rac1 ~]# netstat -pl | grep ntp
udp 0 0 ora-rac1:ntp 0.0.0.0:* 14258/ntpd
udp 0 0 ora-rac1-priv.uk.co:ntp 0.0.0.0:* 14258/ntpd
udp 0 0 ora-rac1.uk.com:ntp 0.0.0.0:* 14258/ntpd
udp 0 0 localhost:ntp 0.0.0.0:* 14258/ntpd
udp 0 0 0.0.0.0:ntp 0.0.0.0:* 14258/ntpd
udp6 0 0 ora-rac1:ntp [::]:* 14258/ntpd
udp6 0 0 ora-rac1:ntp [::]:* 14258/ntpd
udp6 0 0 ora-rac1:ntp [::]:* 14258/ntpd
udp6 0 0 localhost:ntp [::]:* 14258/ntpd
udp6 0 0 ora-rac1:ntp [::]:* 14258/ntpd
udp6 0 0 [::]:ntp [::]:* 14258/ntpd
[root@ora-rac1 ~]# pstree -l -s -p -a 14258
systemd,1 --switched-root --system --deserialize 22
└─ntpd,14258 -u ntp:ntp -x -u ntp:ntp -p /var/run/ntpd.pid
[root@ora-rac1 ~]# ps -P 14258
PID PSR TTY STAT TIME COMMAND
14258 0 ? Ss 0:00 /usr/sbin/ntpd -u ntp:ntp -x -u ntp:ntp -p /var/run/ntpd.pid
[root@ora-rac1 ~]#
=========
yum install ntp -y
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
base | 3.6 kB 00:00:00
extras | 2.9 kB 00:00:00
updates | 2.9 kB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package ntp.x86_64 0:4.2.6p5-29.el7.centos.2 will be installed
--> Processing Dependency: libopts.so.25()(64bit) for package: ntp-4.2.6p5-29.el7.centos.2.x86_64
--> Running transaction check
---> Package autogen-libopts.x86_64 0:5.18-5.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
==============================================================================================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================================================================================
Installing:
ntp x86_64 4.2.6p5-29.el7.centos.2 base 549 k
Installing for dependencies:
autogen-libopts x86_64 5.18-5.el7 base 66 k
Transaction Summary
==============================================================================================================================================================================================================
Install 1 Package (+1 Dependent package)
Total download size: 615 k
Installed size: 1.5 M
Downloading packages:
No Presto metadata available for base
(1/2): autogen-libopts-5.18-5.el7.x86_64.rpm | 66 kB 00:00:00
(2/2): ntp-4.2.6p5-29.el7.centos.2.x86_64.rpm | 549 kB 00:00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 2.2 MB/s | 615 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
Installing : autogen-libopts-5.18-5.el7.x86_64 1/2
Installing : ntp-4.2.6p5-29.el7.centos.2.x86_64 2/2
warning: /etc/ntp.conf created as /etc/ntp.conf.rpmnew
warning: /etc/sysconfig/ntpd created as /etc/sysconfig/ntpd.rpmnew
Verifying : autogen-libopts-5.18-5.el7.x86_64 1/2
Verifying : ntp-4.2.6p5-29.el7.centos.2.x86_64 2/2
Installed:
ntp.x86_64 0:4.2.6p5-29.el7.centos.2
Dependency Installed:
autogen-libopts.x86_64 0:5.18-5.el7
Complete!
[root@ora-rac2 ~]#
Tuesday, 26 November 2024
Oracle Grid home and Grid base path
https://docs.oracle.com/en/database/oracle/////oracle-database/19/cwlin/about-creating-oracle-base-oracle-home-directories.html mkdir -p /u01/app/19.0.0/grid mkdir -p /u01/app/grid mkdir -p /u01/app/oracle chown -R grid:oinstall /u01 chown oracle:oinstall /u01/app/oracle chmod -R 775 /u01/
Subscribe to:
Posts (Atom)
