by In this blog, I’ll go through oracle 18c installation on oracle Linux 7.4. Oracle 18c is not officially announced for on-premises database. But for study purpose, I thought to use Oracle 18c binaries from oracle edelivery which is available for Oracle Exadata. Other option is to try 18c on Oracle SQL live which I explained here.
My environment is all ready to go. I am using Oracle virtual box 5.2.2 with Oracle Linux 7.4, 4GB memory and extra disk for oracle binaries and data files.
|
1 2 3 4 5 6 7 8 |
[root@oracle18c ~]# cat /etc/oracle-release Oracle Linux Server release 7.4 [root@oracle18c ~]# hostname oracle18c [root@oracle18c ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.101 oracle18c oracle18c.localdomain |
Oracle recommends that when you install Oracle Linux 6 or Oracle Linux 7 and use Oracle Preinstallation RPM to configure your operating systems for Oracle Database and Oracle Grid Infrastructure installations. The Oracle Preinstallation RPM will automatically creates standard (not role-allocated) Oracle installation owner and groups, and sets up other kernel configuration settings as required for Oracle installations. 18c preinstall rpm is not available yet so used 12R2 as its compatible with 18c.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 |
[root@oracle18c sf_Share_VM]# yum install oracle-database-server-18c-preinstall No package oracle-database-server-18c-preinstall available. [root@oracle18c sf_Share_VM]# yum install -y oracle-database-server-12cR2-preinstall.x86_64 Loaded plugins: langpacks, ulninfo Resolving Dependencies --> Running transaction check ---> Package oracle-database-server-12cR2-preinstall.x86_64 0:1.0-3.el7 will be installed --> Processing Dependency: ksh for package: oracle-database-server-12cR2-preinstall-1.0-3.el7.x86_64 --> Processing Dependency: libaio-devel for package: oracle-database-server-12cR2-preinstall-1.0-3.el7.x86_64 --> Running transaction check ---> Package ksh.x86_64 0:20120801-34.el7 will be installed ---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved =============================================================================================================================== Package Arch Version Repository Size =============================================================================================================================== Installing: oracle-database-server-12cR2-preinstall x86_64 1.0-3.el7 ol7_latest 19 k Installing for dependencies: ksh x86_64 20120801-34.el7 ol7_latest 883 k libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k Transaction Summary =============================================================================================================================== Install 1 Package (+2 Dependent packages) Total download size: 914 k Installed size: 3.2 M Downloading packages: warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/libaio-devel-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Public key for libaio-devel-0.3.109-13.el7.x86_64.rpm is not installed (1/3): libaio-devel-0.3.109-13.el7.x86_64.rpm | 12 kB 00:00:00 (2/3): ksh-20120801-34.el7.x86_64.rpm | 883 kB 00:00:00 (3/3): oracle-database-server-12cR2-preinstall-1.0-3.el7.x86_64.rpm | 19 kB 00:00:00 ------------------------------------------------------------------------------------------------------------------------------- Total 1.7 MB/s | 914 kB 00:00:00 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Importing GPG key 0xEC551F03: Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>" Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03 Package : 7:oraclelinux-release-7.4-1.0.4.el7.x86_64 (@anaconda/7.4) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : ksh-20120801-34.el7.x86_64 1/3 Installing : libaio-devel-0.3.109-13.el7.x86_64 2/3 Installing : oracle-database-server-12cR2-preinstall-1.0-3.el7.x86_64 3/3 Verifying : libaio-devel-0.3.109-13.el7.x86_64 1/3 Verifying : oracle-database-server-12cR2-preinstall-1.0-3.el7.x86_64 2/3 Verifying : ksh-20120801-34.el7.x86_64 3/3 Installed: oracle-database-server-12cR2-preinstall.x86_64 0:1.0-3.el7 Dependency Installed: ksh.x86_64 0:20120801-34.el7 libaio-devel.x86_64 0:0.3.109-13.el7 Complete! ### Check the RPM log file to review the system configuration changes. cat /var/log/oracle-database-server-12cR2-preinstall/backup/Mar-01-2018-17-21-01/orakernel.lo</build@oss.oracle.com> |
I used the “VM Shared folder” to transfer the Oracle 18c software “V974953-01.zip” downloaded from edelivery. Copied from sharable drive to “/home/oracle” folder.
|
1 2 |
[root@oracle18c /]# ls /home/oracle/V974953-01.zip /home/oracle/V974953-01.zip |
Now create the required directories for Oracle binaries. Like GI 12.2, you now need to unzip the software on “ORACLE_HOME” location.
|
1 2 3 4 5 |
[root@oracle18c ~]# su - oracle [oracle@oracle18c ~]# mkdir -p /u01/app/oracle/product/18.0.0/db1 [oracle@oracle18c ~]# mkdir -p /u01/app/oraInventory [oracle@oracle18c ~]$ cd /u01/app/oracle/product/18.0.0/db1 [oracle@oracle18c db1]$ unzip /home/oracle/V974953-01.zip |
Now it’s ready to install it.
|
1 2 3 4 5 |
export ORACLE_HOME=/u01/app/oracle/product/18.0.0/db1 [oracle@oracle18c db1]$ pwd /u01/app/oracle/product/18.0.0/db1 [oracle@oracle18c db1]$ ./runInstaller Launching Oracle Database Setup Wizard.. |
Select “Set up software only”.
Single instance and click next.
Select “Enterprise Edition” and Next.
I kept the default location for oracle base. But it generated an error.
Looks like from 18c, we could not able to put the ORACLE_BASE under ORACLE_HOME location. So I put it some other location.
|
1 |
[oracle@oracle18c ~]# mkdir /u01/app/oracle_base |
I kept only one group DBA. You keep the recommended Oracle setup.
I ignored the swap and physical memory warnings. Setup is just for testing purpose.
Once complete, run the root scripts.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
[root@oracle18c 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@oracle18c db1]# /u01/app/oracle/product/18.0.0/db1/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/18.0.0/db1 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. Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] : n Oracle Trace File Analyzer (TFA - Non Daemon Mode) is available at : /u01/app/oracle/product/18.0.0/db1/suptools/tfa/release/tfa_home/bin/tfactl Note : 1. tfactl will use TFA Daemon Mode if TFA already running in Daemon Mode and user has access to TFA 2. tfactl will configure TFA Non Daemon Mode only if user has no access to TFA Daemon mode or TFA Daemon mode is not installed OR Oracle Trace File Analyzer (TFA - Daemon Mode) can be installed by running this script : /u01/app/oracle/product/18.0.0/db1/suptools/tfa/release/tfa_home/install/roottfa.sh |
Installation is now complete and click on close.
Add dummy database entry in oratab and test the sqlplus connection.
|
1 2 3 4 5 6 7 8 9 |
cat /etc/oratab AA:/u01/app/oracle/product/18.0.0/db1:N [oracle@oracle18c bin]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 Production on Thu Mar 1 22:42:02 2018 Version 18.1.0.0.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to an idle instance. SQL> exit Disconnected |
Thanks
Mandy
Leave a Reply