Dear Readers, In this article, we will understand the step by step Migration from Oracle to SQL Server. To complete this configuration we need to follow below steps. I am using MSSQL Server 2012 and Oracle 12c R1 for this activity. You can use any… Read More
There is no excerpt because this is a protected post.
Invoke Linux GUI On windows using Xming software Today we will understand how to invoke Linux GUI on windows using Xming software. To complete this configuration we need to follow the below steps and I will also share the issue and its resolution which I… Read More
Hi Readers, Below article will help you on Shell Script to get EMAIL alerts for ABENDED Processes in Oracle GoldenGate. Script :
[oracle@AWS1 ~]# cat GG_Abend.sh
# Output GG information to log file
echo 'INFO ALL' | /u01/app/oracle/product/ogg_src/ggsci > $logfile
# Check for ABEND errors #
if [ `cat $logfile | grep ABENDED | grep -v grep | wc -l` -eq 0 ]
echo "No ABENDED process."
echo "GoldenGate Process ABENDED on $ORACLE_HOST_NAME for database $ORACLE_SID"
cat $logfile | mailx -s "GoldenGate Process ABENDED on $ORACLE_HOST_NAME for database $ORACLE_SID" $DBA_EMAIL
#cat $logfile | mailx -s "TEST MAIL on $ORACLE_HOST_NAME for database $ORACLE_SID" $DBA_EMAIL
Keep Script in Crontab :
[root@AWS! ~]# crontab -l
5 * * * * /oracle/home/GG_Abend.sh > /dev/null 2>&1
The above script will execute for every 5 minutes Now check Output file in… Read More
Dear Readers, In this article we will focus on new feature that has been introduced in Oracle 18C that is “Private Temporary Table”. Private temporary tables are temporary database objects that are dropped at the end of end of a session or transaction depending on… Read More
Dear Readers, In this article we will focus one of the most remarkable feature that has been introduced in Oracle 18C that is “now you can cancel SQL statement without killing session”. Prior 18C, DBA’s had to kill a DB sessions to get rid of… Read More
This article focuses on Oracle 18C new feature: Schema Only Account. This allows schemas can be created without a password from Oracle Database 18C. BACKGROUND: Schema is a collection of objects, while DB user is an account to connect to instance. Till Oracle 12C, Oracle… Read More
Dear Readers, In this article we will focusing on new initialization parameters that have been introduced in Oracle 18c. Below is the list of such parameters along with its significance: ADG_ACCOUNT_INFO_TRACKING This parameter has been introduced to control failed login attempts by users on Active… Read More
Installation of Oracle database 18c(188.8.131.52.0) On Linux In this article we will see steps to Install Oracle database 18c(184.108.40.206.0) on Linux x86-64 Environment. Follow below steps Click below link to install Linux x86-64 Oracle 18c software binaries for Linux x86-64 Create vm and install linux operating system… Read More
In this article, we will see Installation of Oracle Database 18c(220.127.116.11.0) On Windows. Click on below link to download 18c software binaries for windows platform Software binaries for oracle 18c Once you downloaded the file unzip and double click on setup.exe application file. Step 1 :… Read More