Posting from my Email :D

-


Comments

Post a Comment

Popular posts from this blog

SAP SWPM Software Provision Manager SL Toolset 1.0 SP22 Startup Options

-
This is just a rough note on the options and properties we can set upon running apinst when installing a SAP system. Version: [root@host SWPM]# ./sapinst -v [==============================] - extracting...  done! INFO       2018-04-19 11:54:56.315 (mainThread) [sixxcreate.cpp:346] ******************************************************************************** Initial log directory: /root/.sapinst/falconheavy.vantage-intl.com/12345 ******************************************************************************** SAPinst build information: -------------------------- Version:         749.0.47 Build:           1832063 Compile time:    Mar 27 2018 - 13:22:27 Make type:       optU Codeline:        749_REL Platform:        linuxx86_64 Kernel build:    749, patch 426, changelist 1830485 SAP JRE build:   SAP...
Read more

Quick Dirty Script for Checking Oracle Data Gurad Gap and Emailing it

-
 Situation: primary DB: prd_CCC standby DB: prd_WWW file 1: gap-check.bat @echo off cls echo. echo. echo This script checks for Archive Logs at prd_ccc and Applied Logs at prd_www echo. echo Querying prd_ccc (Primary) echo select max(sequence#) "Primary" from v$archived_log where archived='YES';|sqlplus -s / as sysdba echo Querying prd_www (Standby) echo select max(sequence#) "Standby" from v$archived_log where applied='YES';|sqlplus -s / as sysdba echo. DGMGRL / "show configuration" date /t && time /t && hostname && whoami file 2: emailer.ps1 $Username      = "username" $EmailPassword = "password" $today = Get-Date $Username = $Username $EmailTo = "adam@jasabyte.com"  $EmailFrom = "server@jasabyte.com" $Body = Get-Content .\status.log -Raw $Subject = "PRIMARY/STANDBY DB GAP - $today" $SMTPServer = "mail.smtp2go.com"  $SMTPMessage = New-Object System.Net.Mai...
Read more