Skip to content

Oracle Database 19c install & hammerdb & links

Prerequisites

Edit host file /etc/hosts -> ip_address fully-qualified machine-name machine-name

dnf install oracle-database-preinstall-19c or yum

#make directories for dw & data

mkdir -p /u01/app/oracle/product/19/db_1 or mkdir -p /opt/u01/app/oracle/product/19/db_1

mkdir -p /u02 or mkdir -p /opt/u02

#change owner

chown -R oracle:oinstall /u01 or /opt/u01 # if oinstall doesn’t exist tehn ->/usr/sbin/groupadd oinstall

chown -R oracle:oinstall /u02 or /opt/u02

chmod -R 775 /u01 or chmod -R 775 /u01

chmod -R 775 /u02 or chmod -R 775 /u02

#edit /home/oracle/bash_profile

#ORACLE_BASE /u01/app/oracl

#ORACLE_HOME $ORACLE_BASE/product/19/db_1

#ORACLE_SID orcl

#ORACLE_UNQNAME orcl

Link: https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-8

Download software :

https://edelivery.oracle.com/linux

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

#copy software

cp V982063-01.zip /opt/u01/app/oracle/product/19/db_1 or cp V982063-01.zip 01/app/oracle/product/19/db_1

#unzip

unzip V982063-01.zip

#install

export CV_ASSUME_DISTID=OL7

./runInstaller

This image has an empty alt attribute; its file name is image-19-1024x798.png

Oracle Enterprise Manager Database Express URL: https://hostname.si:5500/em

#Create hammerdb pluggable database

create pluggable database pdbhammerdb admin user adminh identified by pwd roles=(CONNECT) file_name_convert = (‘/opt/u02/ORCL/pdbseed’,’/opt/u02/ORCL/pdbhammerdb’);

#open

alter pluggable database pdbhammerdb open;

Hammerdb

Links: https://www.hammerdb.com/blog/uncategorized/hammerdb-best-practice-for-oracle-performance-and-scalability/

How to tune and Benchamrk Oracle Database with HammerDB and AWR

https://youtu.be/d_eba2j5IGI

Oracle

Link: https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-8

https://edelivery.oracle.com/linux

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

Links

https://connor-mcdonald.com/archives/

Oracle University podcast

https://oracleuniversitypodcast.libsyn.com

Leave a Reply

Your email address will not be published. Required fields are marked *