Installation of Oracle Database 18cR1 & Oracle Grid Infrastructure 18cR1 on Oracle Linux 6.7(
Not an Exadata).
I’ve already covered a topic on 18c in my previous post which is on Upgrading Grid Infrastructure from 12cR2 to 18cR1. And the complete step-by-step guide on how you can download Oracle Grid Infrastructure 18c on your On-Premises system, though it is only available for Exadata machines. So from the same post you can get insight on how to download Oracle Database 18c on Non-Exadata machine.
In this post we’ll be Installing Oracle Database 18cR1 along with Oracle Grid Infrastructure 18cR1 on Oracle Enterprise Linux 6.7. And we’ll also be creating ASM Diskgroup and configuring ASM Instance and Database Instance in a Silent mode(Without GUI).
Here I’m assuming you already have downloaded and extracted both the setups (Grid and Database) in their respective home locations (i.e. ORACE_HOME/dbhome_1 for Database and ORACLE_HOME/gihome_1 for Grid. and you also have ASM Disk created /dev/oracleasm/disks/DATA.
- We’ll first install Grid Infrastructure and then we’ll go for RDBMS.
1. Modify Response file for grid as per your requirements
(e.g. /home/oracle/18c_grid_install.rsp).
You’ll get response file usually in $ORACLE_HOME/response, however in 18c version I did not find it at this location so you may use this sample response file.
2. Initialize installation for Grid Infrastructure in a silent mode.
Redirect to the Oracle Grid Infrastructure setup directory and execute following command.
[oracle@dbnode1 gihome_1]$ ./gridSetup.sh -silent -responseFile /home/oracle/18c_grid_install.rsp -ignorePrereqFailure -waitForCompletion 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-41810] Possible invalid choice for OSOPER Group. CAUSE: The group name you selected as the OSOPER for ASM group is commonly used for Oracle Database administrator privileges. ACTION: Oracle recommends that you designate asmoper as the OSOPER for ASM group, and that the group should not be the same group as an Oracle Database OSOPER group. [WARNING] [INS-32020] Installer has detected that the available disk space on the volume for the specified Oracle base location (/u02/app/grid) is less than the recommended value. ACTION: It is recommended that the volume for the Oracle base have at least 10 GB of available disk space. Choose a location that has sufficient available disk space or free up space on the existing volume. [WARNING] [INS-13014] Target environment does not meet some optional requirements. CAUSE: Some of the optional prerequisites are not met. See logs for details. /u02/app/oraInventory/logs/GridSetupActions2018-04-01_08-55-57AM/gridSetupActions2018-04-01_08-55-57AM.log ACTION: Identify the list of failed prerequisite checks from the log: /u02/app/oraInventory/logs/GridSetupActions2018-04-01_08-55-57AM/gridSetupActions2018-04-01_08-55-57AM.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: /u02/app/grid/product/18.0.0/gihome_1/install/response/grid_2018-04-01_08-55-57AM.rsp You can find the log of this install session at: /u02/app/oraInventory/logs/GridSetupActions2018-04-01_08-55-57AM/gridSetupActions2018-04-01_08-55-57AM.log As a root user, execute the following script(s): 1. /u02/app/grid/product/18.0.0/gihome_1/root.sh Execute /u02/app/grid/product/18.0.0/gihome_1/root.sh on the following nodes: [dbnode1] Successfully Setup Software with warning(s). As install user, execute the following command to complete the configuration. /u02/app/grid/product/18.0.0/gihome_1/gridSetup.sh -executeConfigTools -responseFile /home/oracle/18c_grid_install.rsp -silent
- -silent will tell setup to open without gui using a response file.
- -responseFile will give the path of the .rsp file to installer.
- -ignorePrereqFailure will tell setup not to perform prerequisites and ignore them.
- -waitForCompletion will not let terminal available in the session until installation finishes.
Execute these two scripts.
- As a root user, execute the following script(s):
[root@dbnode1 ~]$ /u02/app/grid/product/18.0.0/gihome_1/root.sh
O/P : >End Command output 2018-04-01 09:32:12: CLSRSC-327: Successfully configured Oracle Restart for a standalone server
- As install user, execute the following command to complete the configuration.
[oracle@dbnode1 ~] /u02/app/grid/product/18.0.0/gihome_1/gridSetup.sh -executeConfigTools -responseFile /home/oracle/18c_grid_install.rsp -silent
- Let’s now invoke SQL*PLUS
[oracle@dbnode1 ~]$ sqlplus / as sysasm SQL*Plus: Release 18.0.0.0.0 Production on Sun Apr 1 09:27:06 2018 Version 18.1.0.0.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to an idle instance.
We could connect to Idle Instance, hence Grid Infrastructure has now been successfully installed.
- Let’s try starting up the instance now,
SQL> startup ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service
Seems Cluster Synchronization Service is not running.
- Enable has.
[oracle@dbnode1 bin]$ crsctl enable has CRS-4622: Oracle High Availability Services autostart is enabled.
- Let’s start ora.cssd daemon.
[oracle@dbnode1 bin]$ crsctl start res ora.cssd -init CRS-2672: Attempting to start 'ora.cssd' on 'dbnode1' CRS-2672: Attempting to start 'ora.diskmon' on 'dbnode1' CRS-2676: Start of 'ora.diskmon' on 'dbnode1' succeeded CRS-2676: Start of 'ora.cssd' on 'dbnode1' succeeded
- Now again try starting up the instance, as it is not configure parameter file warning is expected.
SQL> startup ORA-00099: warning: no parameter file specified for ASM instance ORA-12754: Feature 'startup' is disabled due to missing capability 'Runtime Environment'.
We still have two warnings here ORA-00099 and ORA-12754. let’s fix them.
- ORA-12754 – This error occured because we’re trying to install 18c on Non-Exadata machine. Let’s solve this with little hack and check what happens next.
We just need to add one entry in parameter file, let’s do it.
- Edit Parameter file. i.e. init+ASM.ora (if you don’t find any, create one).
[oracle@dbnode1 ]$ vi /u02/app/grid/product/18.0.0/gihome_1/dbs/init+ASM.ora
- Add hidden parameter “_exadata_feature_on=true” in parameter file and then save and exit. also add asm_diskstring and asm_diskgroups.
_exadata_feature_on=true asm_diskstring='/dev/oracleasm/disks/*' asm_diskgroups=DATA
[ESC] > :wq > Enter (to save and exit)
- Let’s now try to startup the instance.
SQL> startup pfile='/u02/app/grid/product/18.0.0/gihome_1/dbs/init+ASM.ora'; ASM instance started Total System Global Area 1136934472 bytes Fixed Size 8666696 bytes Variable Size 1103101952 bytes ASM Cache 25165824 bytes ORA-15110: no diskgroups mounted
And here we go, instance started. we’ve got ORA-15110 because we need to configure asm, let’s configure it.
3. Configure ASM Instance.
Configure ASM Instance using asmca utility, but in silent mode(without GUI)
[oracle@dbnode1 dbs]$ asmca -silent -configureASM \ > -sysAsmPassword oradba786 \ > -asmsnmpPassword oradba786 \ > -diskstring '/dev/oracleasm/disks/*' \ > -diskGroupName DATA \ > -diskList '/dev/oracleasm/disks/DATA01' \ > -redundancy EXTERNAL [INFO] [DBT-30001] Disk groups created successfully. Check /u02/app/grid/cfgtoollogs/asmca/asmca-180401PM121856.log for details.
The INFO says Disk groups created successfully. Let’s again invoke SQL*PLUS,
[oracle@dbnode1 dbs]$ sqlplus / as sysasm SQL*Plus: Release 18.0.0.0.0 Production on Sun Apr 1 12:32:44 2018 Version 18.1.0.0.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.1.0.0.0
And here you go. asm instance is configured and up, let’s see something more.
SQL> select instance_name,status,version from v$instance; INSTANCE_NAME STATUS VERSION ---------------- ------------ ----------------- +ASM STARTED 18.0.0.0.0
Cheers! We’re done with Grid Infrastructure. We’ve installed Oracle Grid Infrastructure 18cR1 in silent mode.
4. Install Database.
Redirect to the Oracle Database setup directory and execute following command.
You’ll get response file usually in $ORACLE_HOME/response, however in 18c version I did not find it at this location so you may use this sample response file.
[oracle@dbnode1 dbhome_1]$ ./runInstaller -ignorePrereq -waitforcompletion -silent -responseFile /home/oracle/18c_db_install.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. /u02/app/oraInventory/logs/InstallActions2018-04-01_02-36-35PM/installActions2018-04-01_02-36-35PM.log ACTION: Identify the list of failed prerequisite checks from the log: /u02/app/oraInventory/logs/InstallActions2018-04-01_02-36-35PM/installActions2018-04-01_02-36-35PM.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: /u01/app/oracle/product/18.0.0/dbhome_1/install/response/db_2018-04-01_02-36-35PM.rsp You can find the log of this install session at: /u02/app/oraInventory/logs/InstallActions2018-04-01_02-36-35PM/installActions2018-04-01_02-36-35PM.log As a root user, execute the following script(s): 1. /u01/app/oracle/product/18.0.0/dbhome_1/root.sh Execute /u01/app/oracle/product/18.0.0/dbhome_1/root.sh on the following nodes: [dbnode1] Successfully Setup Software with warning(s). As a root user, execute the following script(s): 1. /u01/app/oracle/product/18.0.0/dbhome_1/root.sh
- -silent will tell setup to open without gui using a response file.
- -responseFile will give the path of the .rsp file to installer.
- -ignorePrereqFailure will tell setup not to perform prerequisites and ignore them.
- -waitForCompletion will not let terminal available in the session until installation finishes.
- Let’s run root script.
[root@dbnode1 ~] /u01/app/oracle/product/18.0.0/dbhome_1/root.sh Finished running generic part of root script. Now product-specific root actions will be performed.
We’re done installing Oracle Database 18cR1 as well, in silent mode.
- Let’s invoke SQL*PLUS and check.
[oracle@dbnode1 ~]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 Production on Sun Apr 1 15:10:44 2018 Version 18.1.0.0.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to an idle instance.
Cheers! We’ve installed Oracle Database 18cR1 along with Oracle Grid Infrastructure 18cR1 on Oracle Enterprise Linux 6.7
You can now go ahead and create your first database on Oracle Database 18c with ASM.
Peace 🙂