19C Database Installation on OEL7.5/8.
1 with vmware 15
-----------------------------------
Login as root
root123
Wired Connect - Internet
Prerequisites - Installation using yum install tool
---------------------------------------------
# cd /etc/yum.repos.d/
wget http://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64
yum install oracle-database-preinstall-19c
create user,groups,rpms,kernel params - installed
----------------------------------------------------------------
Changing Owner ship and Permissions
----------------------------------
Where default we have root user,Need to provide ownership to user oracle on
Oracle binaries
To manage Oracle Installed binaries, will create OS groups and user.
Oracle recommends three groups.
dba - Full Administrative privileges
oinstall - Will have privileges on inventory files.
oper - optional - operational - limited privileges
After Installing Pre-requisites, These user and groups are created by it self.
Verify using ID
#id oracle
If not exists, Need to create Manually.
----------------------------------------------------------------
Create Directories:
mkdir -p /u01/app/oraInventory
mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
-----------------------------------------------------------------
Permissions on File systems
---------------------------
#chown -R oracle:oinstall /u01
chown -R oracle:oinstall /softwares
chown -R oracle:oinstall /oradata
chown -R oracle:oinstall /orabackup
chown -R oracle:oinstall /archives
Note: -R ? includes all subfiles and folders
Will Provide read,write,execute permissions on file systems
chmod -R 775 /u01
chmod -R 775 /softwares
chmod -R 775 /oradata
chmod -R 775 /orabackup
chmod -R 775 /archives
set the oracle password
#passwd oracle
Enter the passwd : oracle123
confirm : oracle123
----------------------------
Install Winscp - download
-------------------------
ifconfig
Finding ipaddress using ifconfig
eg: 192.168.43.214
login with oracle
From source to target , copy the db file LINUX.X64_193000_db_home.zip (drag and
drop) /softwares
Configure hostname
--------------------
vi /etc/hosts
#add entry
127.0.0.1 localhost.localdomain localhost
192.168.1.19 lab5.uniracglobal.com lab5
:wq!
vi /etc/hostname
#delete existing entry
lab1.uniracglobal.com
:wq!
--------------------------------
Login to Oracle user
#su - oracle
----------------------------------------------
Configuing .bash_profile - Environment Variables
------------------------------------------------
is a hidden file for every user default profile
Will declare variables to locate the oracle binaries
So
$vi .bash_profile
#Append few parameters following
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=prod; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
ORACLE_HOSTNAME=lab1.uniracglobal.com; export ORACLE_HOSTNAME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export
CLASSPATH
Now ... save the file
esc :wq!
then execute
$. .bash_profile
# Silent mode.
Now unzip the file in ORACLE HOME location
Using Winscp Tool
Connect to Oracle user finding ipaddress from linux
then drag and drop the file to location /u01/app/oracle/product/19.3.0/dbhome_1/
-------------------------------------
Now install...
---------------------------------
$cd /u01/app/oracle/product/19.3.0/dbhome_1/
$unzip LINUX.X64_193000_db_home.zip
$ls
Will see runInstaller file to install the db software
$export ORACLE_HOSTNAME=lab5.uniracglobal.com
$./runInstaller -ignorePrereq -waitforcompletion -silent -printtime -
printmemory \
-responseFile ${ORACLE_HOME}/install/response/db_install.rsp \
oracle.install.option=INSTALL_DB_SWONLY \
ORACLE_HOSTNAME=lab5.uniracglobal.com \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en,en_GB \
ORACLE_HOME=${ORACLE_HOME} \
ORACLE_BASE=${ORACLE_BASE} \
oracle.install.db.InstallEdition=EE \
oracle.install.db.OSDBA_GROUP=dba \
oracle.install.db.OSBACKUPDBA_GROUP=dba \
oracle.install.db.OSDGDBA_GROUP=dba \
oracle.install.db.OSKMDBA_GROUP=dba \
oracle.install.db.OSRACDBA_GROUP=dba \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true
Run the root scripts when prompted.
As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/19.3.0/dbhome_1/root.sh
For CDB and PDB - Enables Multitenant Feature.
$dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname prod -sid prod -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword MyNewPass4! \
-systemPassword MyNewPass4! \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName ptmpdb \
-pdbAdminPassword MyNewPass4! \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement true \
-totalMemory 780 \
-storageType FS \
-datafileDestination "/oradata" \
-redoLogFileSize 100 \
-emConfiguration NONE \
-ignorePreReqs
