Installation of Oracle 18c (18.3) RPM manually
Posted by Dirk Nachbar on Friday, October 19, 2018
Since last night the RPM version of Oracle 18c (18.3) is available, see my blog post http://dirknachbar.blogspot.com/2018/10/oracle-18c-rpm-for-linux-available.html
I was directly testing the manually way in installing the Oracle 18c (18.3) RPM version, not Unbreakable Linux Network (ULN).
As pre requirement you will need an up and running Linux Server, in my case an Oracle Enterprise Linux 7.4, and the Oracle 18c RPM and as well the Oracle 18c Preinstallation RPM.
Transfer the 2 above mentioned files to your target server as root user in any temporary directory, navigate in a shell to the temporary directory and execute as root following commands:
1. Install the Oracle 18c Preinstallation RPM
2. Install the Oracle 18c (18.3) RPM
As next we need to configure the Oracle 18c Database by executing the /etc/init.d/oracledb_ORCLDB-18c script as root user
In case you will receive following error message while executing the /etc/init.d/oracledb_ORCLDB-18c script, simply check your /etc/hosts file and add the IP, Fully Qualified Hostname and the Shortname of your server, re-execute the /etc/init.d/oracledb_ORCLCDB-18c script
And we are nearly done :-)
Switch in your shell to the oracle user:
You only need to change now the passwords of the Database Users, e.g. SYS, SYSTEM and so on.
It's really a quick and fast way to install and configure an Oracle 18c (18.3) release on your server, what I personally don't like, is the used OFA (Optimal/Oracle Flexible Architecture) layout provided within the RPM, everything goes under /opt ... :-(
I was directly testing the manually way in installing the Oracle 18c (18.3) RPM version, not Unbreakable Linux Network (ULN).
As pre requirement you will need an up and running Linux Server, in my case an Oracle Enterprise Linux 7.4, and the Oracle 18c RPM and as well the Oracle 18c Preinstallation RPM.
- The Oracle 18c RPM you will find under https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html
- The Oracle 18c Preinstallation RPM you will find here https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
Transfer the 2 above mentioned files to your target server as root user in any temporary directory, navigate in a shell to the temporary directory and execute as root following commands:
1. Install the Oracle 18c Preinstallation RPM
yum localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm Loaded plugins: langpacks, ulninfo Examining oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-18c-1.0-1.el7.x86_64 Marking oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.el7 will be installed --> Processing Dependency: glibc-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64 --> Processing Dependency: ksh for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64 --> Processing Dependency: libaio-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64 --> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64 --> Running transaction check ---> Package glibc-devel.x86_64 0:2.17-196.el7 will be installed --> Processing Dependency: glibc-headers = 2.17-196.el7 for package: glibc-devel-2.17-196.el7.x86_64 --> Processing Dependency: glibc-headers for package: glibc-devel-2.17-196.el7.x86_64 ---> 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 ---> Package libstdc++-devel.x86_64 0:4.8.5-16.el7 will be installed --> Running transaction check ---> Package glibc-headers.x86_64 0:2.17-196.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ==================================================================================================================================================================== Package Arch Version Repository Size ==================================================================================================================================================================== Installing: oracle-database-preinstall-18c x86_64 1.0-1.el7 /oracle-database-preinstall-18c-1.0-1.el7.x86_64 55 k Installing for dependencies: glibc-devel x86_64 2.17-196.el7 OL74 1.1 M glibc-headers x86_64 2.17-196.el7 OL74 675 k ksh x86_64 20120801-34.el7 OL74 883 k libaio-devel x86_64 0.3.109-13.el7 OL74 12 k libstdc++-devel x86_64 4.8.5-16.el7 OL74 1.5 M Transaction Summary ==================================================================================================================================================================== Install 1 Package (+5 Dependent packages) Total size: 4.1 M Total download size: 4.1 M Installed size: 14 M Is this ok [y/d/N]: y Downloading packages: warning: /var/OSimage/OL7.4_x86_64/Packages/glibc-devel-2.17-196.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Public key for glibc-devel-2.17-196.el7.x86_64.rpm is not installed -------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 52 MB/s | 4.1 MB 00:00:00 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY 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 Is this ok [y/N]: y Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : ksh-20120801-34.el7.x86_64 1/6 Installing : glibc-headers-2.17-196.el7.x86_64 2/6 Installing : glibc-devel-2.17-196.el7.x86_64 3/6 Installing : libaio-devel-0.3.109-13.el7.x86_64 4/6 Installing : libstdc++-devel-4.8.5-16.el7.x86_64 5/6 Installing : oracle-database-preinstall-18c-1.0-1.el7.x86_64 6/6 Verifying : oracle-database-preinstall-18c-1.0-1.el7.x86_64 1/6 Verifying : libstdc++-devel-4.8.5-16.el7.x86_64 2/6 Verifying : libaio-devel-0.3.109-13.el7.x86_64 3/6 Verifying : glibc-headers-2.17-196.el7.x86_64 4/6 Verifying : glibc-devel-2.17-196.el7.x86_64 5/6 Verifying : ksh-20120801-34.el7.x86_64 6/6 Installed: oracle-database-preinstall-18c.x86_64 0:1.0-1.el7 Dependency Installed: glibc-devel.x86_64 0:2.17-196.el7 glibc-headers.x86_64 0:2.17-196.el7 ksh.x86_64 0:20120801-34.el7 libaio-devel.x86_64 0:0.3.109-13.el7 libstdc++-devel.x86_64 0:4.8.5-16.el7 Complete!
2. Install the Oracle 18c (18.3) RPM
yum localinstall oracle-database-ee-18c-1.0-1.x86_64.rpm Loaded plugins: langpacks, ulninfo Examining oracle-database-ee-18c-1.0-1.x86_64.rpm: oracle-database-ee-18c-1.0-1.x86_64 Marking oracle-database-ee-18c-1.0-1.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package oracle-database-ee-18c.x86_64 0:1.0-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ==================================================================================================================================================================== Package Arch Version Repository Size ==================================================================================================================================================================== Installing: oracle-database-ee-18c x86_64 1.0-1 /oracle-database-ee-18c-1.0-1.x86_64 7.8 G Transaction Summary ==================================================================================================================================================================== Install 1 Package Total size: 7.8 G Installed size: 7.8 G Is this ok [y/d/N]: y Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : oracle-database-ee-18c-1.0-1.x86_64 1/1 [INFO] Executing post installation scripts... [INFO] Oracle home installed successfully and ready to be configured. To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-18c configure Verifying : oracle-database-ee-18c-1.0-1.x86_64 1/1 Installed: oracle-database-ee-18c.x86_64 0:1.0-1 Complete!
As next we need to configure the Oracle 18c Database by executing the /etc/init.d/oracledb_ORCLDB-18c script as root user
In case you will receive following error message while executing the /etc/init.d/oracledb_ORCLDB-18c script, simply check your /etc/hosts file and add the IP, Fully Qualified Hostname and the Shortname of your server, re-execute the /etc/init.d/oracledb_ORCLCDB-18c script
/etc/init.d/oracledb_ORCLCDB-18c configure Configuring Oracle Database ORCLCDB. [FATAL] [DBT-06103] The port (1,521) is already in use. ACTION: Specify a free port.
/etc/init.d/oracledb_ORCLCDB-18c configure Configuring Oracle Database ORCLCDB. Prepare for db operation 8% complete Copying database files 31% complete Creating and starting Oracle instance 32% complete 36% complete 40% complete 43% complete 46% complete Completing Database Creation 51% complete 54% complete Creating Pluggable Databases 58% complete 77% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/ORCLCDB. Database Information: Global Database Name:ORCLCDB System Identifier(SID):ORCLCDB Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details. Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
And we are nearly done :-)
Switch in your shell to the oracle user:
su - oracle
cd /opt/oracle
export ORACLE_BASE=`pwd`
cd product/18c/dbhome_1
export ORACLE_HOME=`pwd`
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=ORCLCDB
sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Fri Oct 19 13:54:58 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> col name format a30
SQL> select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ ONLY
3 ORCLPDB1 READ WRITE
You only need to change now the passwords of the Database Users, e.g. SYS, SYSTEM and so on.
It's really a quick and fast way to install and configure an Oracle 18c (18.3) release on your server, what I personally don't like, is the used OFA (Optimal/Oracle Flexible Architecture) layout provided within the RPM, everything goes under /opt ... :-(
Categories: Oracle 18c
