Skip to content

Oracle database 18c yum installation on Oracle linux 7.6

I have downloaded the oracle database 18c rpm package from oracle and have plan to install manually without ULN support.

Installing Oracle Database RPM Manually

 

[root@dbhost1 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.1.9.88 dbhost1.localdomain dbhost1

Download software :

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html

[root@dbhost1 ~]# yum -y install oracle-database-preinstall-18c
BDB2053 Freeing read locks for locker 0xbb: 12147/139929030764352
BDB2053 Freeing read locks for locker 0xbd: 12147/139929030764352
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
–> Running transaction check
—> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.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 ol7_latest 18 k

Transaction Summary
========================================================================================================================================================================
Install 1 Package

Total download size: 18 k
Installed size: 55 k
Downloading packages:
oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm | 18 kB 00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : oracle-database-preinstall-18c-1.0-1.el7.x86_64 1/1
Verifying : oracle-database-preinstall-18c-1.0-1.el7.x86_64 1/1

Installed:
oracle-database-preinstall-18c.x86_64 0:1.0-1.el7

Complete!

[root@dbhost1 install]# ls -ltr
total 6874960
drwxr-xr-x 7 oracle oinstall 117 Jan 26 2017 database
-rw-r–r– 1 root root 3586257564 Oct 24 2018 oracle-database-ee-18c-1.0-1.x86_64.rpm
-rwxrwxr-x. 1 oracle oinstall 3453696911 Jun 13 11:45 linuxx64_12201_database.zip

Install database software

[root@dbhost1 install]# yum -y 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
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!

Oracle Database software created at /opt/oracle/product/18c/dbhome_1

Creating and Configuring an Oracle Database

there is a location to find the details for creating the database,

/etc/init.d/oracledb_ORCLCDB-18c

you can manually edit the db creation configuration. I modified the database name is UATCDB, Pluggable database is UATPDB1
As a root user, create the database.

[root@dbhost1 ~]# /etc/init.d/oracledb_UATCDB-18c configure
Configuring Oracle Database UATCDB.
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/UATCDB.
Database Information:
Global Database Name:UATCDB
System Identifier(SID):UATCDB
Look at the log file “/opt/oracle/cfgtoollogs/dbca/UATCDB/UATCDB.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.

Verify database Creation as oracle user

[oracle@dbhost1 ~]$ export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1
[oracle@dbhost1 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@dbhost1 ~]$ export ORACLE_SID=UATDB
[oracle@dbhost1 ~]$ export ORACLE_SID=UATCDB
[oracle@dbhost1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 – Production on Sun Jun 30 16:03:19 2019
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> select name from v$database;

NAME
———
UATCDB

SQL> show user con_name
USER is “SYS”

CON_NAME
——————————
CDB$ROOT
SQL> select con_id, name from v$containers;

CON_ID
———-
NAME
——————————————————————————–
1
CDB$ROOT

2
PDB$SEED

3
UATPDB1

SQL>

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: