Protected: Oracle DBA Training Status
There is no excerpt because this is a protected post.
oracle
Oracle 18C New Initialization Parameters
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
Oracle GoldenGate Articles
Oracle GoldenGate Articles Dear Readers, Please check below articles to get good knowledge on Oracle GoldenGate AWS Cloud. SNO DESCRIPTION ARTICLE LINK 1 Shell Script to get EMAIL alerts for Lagging between GoldenGate Processes https://www.ktexperts.com/shell-script-to-get-email-alerts-for-lagging-between-goldengate-processes/ 2 Shell Script to get EMAIL alerts for STOPPED Processes… Read More
Protected: Automating drop partitions for set of Partition tables(Retention based on Selected Dates)
There is no excerpt because this is a protected post.
Protected: Shell script to EXPDP / SCP and IMPDP
There is no excerpt because this is a protected post.
Performing an Initial load with Oracle GoldenGate 12c
Dear Readers, In this article we will see Performing an Initial load with Oracle GoldenGate 12c. We care for your speed. Below is an easy way to Performing an Initial load with Oracle GoldenGate 12c. What is GoldenGate Initial Load ? Loads the data directly from source… Read More
Oracle to MySQL Heterogeneous Unidirectional Replication
Oracle to MySQL Heterogeneous Unidirectional Replication Hello Readers, In this article we will see how to make Heterogeneous Unidirectional Replication between Oracle and MySQL. Source : Oracle DB(12.1.0) Target : MySQL(5.7) Download Goldengate Binaries Download GoldenGate binaries from Oracle.com using below link(Oracle) https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Make sure that you… Read More
GoldenGate: MySQL to Oracle Heterogeneous Unidirectional Replication
MySQL to Oracle Heterogeneous GoldenGate Unidirectional Replication In this article we will see MySQL to Oracle GoldenGate Unidirectional Replication. Prerequisites for Replication: 1.Create two VM’s on your machine 2.Install MySQL on Source Sever. 3.Install Oracle Software and Create database on target. 4.Make sure two Vm’s are… Read More
Online Segment Shrink
Online Segment Shrink A segment is a logical storage structure that contains data structure (segment type) of database objects. A segment is a set (unordered) of extents. A segment and all its extents are stored in one tablespace. From Oracle Database 10g, we can use the segment shrinking capability to reclaim unused… Read More
Oracle Security Audit: SQL92_SECURITY
SQL92_SECURITY Oracle Security Audit: Q: How to improve security level for DML transactions?. Ans: By setting the SQL92_SECURITY parameter we can improve the security level for DML transactions. The configuration option SQL92_SECURITY specifies whether table-level SELECT privileges are required to execute an update or… Read More
