All about oracle-database-preinstall-19c (Oracle Linux 8, 7)

How to download?

• OEL8 -https://yum.oracle.com/repo/OracleLinux/OL8/baseos/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm
• OEL7 -https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm
• OEL 7 (old) -https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

How to install?

rpm -qa oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm

What it will do?

• Create an oracle user
• Create groups
• Update kernel parameters

What will happen if existing oracle user and group exits?

• It will ignore oracle user creation
• It will add additional groups at the end of /etc/group
• It will replace existing kernel parameters with recommended values 

Send email with multiple attachment using powershell

# This script will take take input value and send email with attachments if matches names with input values
# Load SMO extension
[void][Reflection.Assembly]::LoadWithPartialName('Microsoft.VisualBasic')
$title = 'Email My Scripts'
$msg = 'Enter your INPUT :'
$INPUTVALUEvers = [Microsoft.VisualBasic.Interaction]::InputBox($msg, $title)
$INPUTVALUE = $INPUTVALUEvers -replace '\\','_'

###########Define Variables########
$fromaddress = "xyz@gmail.com"
$toaddress = "xyz@gmail.com"
$Subject = "My report $INPUTVALUEvers"
$body = "My reports"
$smtpserver = "my.com.au"

write-host $INPUTVALUE

[array]$attachments =Get-ChildItem -Path "\\My_path\My\*" -Include 

MyReport_$INPUTVALUE.html,Mylogon_$INPUTVALUE.txt

$Msg = @{
to = $toaddress
from = $fromaddress
Body = $body
subject = $Subject
smtpserver = $smtpserver
BodyAsHtml = $True
Attachments = $attachments.fullname
}
Send-MailMessage @Msg

Cloud backup - oracle - Dell - DDVE

Dell Data Domain Virtual Edition (DDVE): DB workload

Dell Cloud Snapshot Manager (CSM): App workload

Data Domain Management Center (DDMC): Manage multiple DDVE

Power Protect Management Center (PPDM): data protection, backup scheduling, deduplication, operational agility, self-service, and IT governance.

• app-optimized-compression   oracle1
• File per set should not be specified to avoid the performance bottleneck.