Oracle Database 19c Installation on OEL7.5/8.1
vmware 15 installed on host machine
Login as root user
root123
Wired Connect - Internet
Prerequisites - Installation using yum install.
# cd /etc/yum.repos.d/
wget http://yum.oracle.com/public-yum-ol7.repo
yum install oracle-database-preinstall-19c
Install Winscp - download
Finding ipaddress using ifconfig
eg: 192.168.21.100
From source to target , copy the db file LINUX.X64_193000_db_home.zip (drag and drop)
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
----------------------------
Configure hostname
vi /etc/hosts
#add entry
127.0.0.1 localhost.localdomain localhost
192.168.21.100 host1.chaitanyaoracledba.com host1
:wq!
vi /etc/hostname
#delete existing entry
host1.chaitanyaoracledba.com
:wq!
--------------------------------
set the oracle password
#passwd oracle
Enter the passwd : oracle123
confirm : oracle123
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=host1.chaitanyaoracledba.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.
$cd /u01/app/oracle/product/19.3.0/dbhome_1
$ cp LINUX.X64_193000_db_home.zip /u01/app/oracle/product/19.3.0/dbhome_1/
$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=host1.chaitanyaoracledba.com
$./runInstaller -ignorePrereq -waitforcompletion -silent -printtime -printmemory
-responseFile ${ORACLE_HOME}/install/response/db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=host1.chaitanyaoracledba.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
# Silent mode - Create Database using database configuration assistant - silent mode
dbca -silent -createDatabase
-templateName General_Purpose.dbc
-gdbname prod -sid prod -responseFile NO_VALUE
-characterSet AL32UTF8
-sysPassword sys123
-systemPassword sys123
-createAsContainerDatabase false
-numberOfPDBs 0
-pdbName pdbhr
-pdbAdminPassword PdbPassword1
-databaseType MULTIPURPOSE
-automaticMemoryManagement false
-totalMemory 870
-storageType FS
-datafileDestination "/oradata"
-redoLogFileSize 50
-emConfiguration NONE
-ignorePreReqs
Note : Info on oracle db19c installation it may be differ from your environment production,testing,development,and naming conventions,directories etc
THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME
