minersoracleblog.wordpress.com
GoldenGate 12 – Classic, Coordinated and Integrated Replicat | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/03/07/goldengate-12-classic-coordinated-and-integrated-replicat
Rick Miners' Oracle Blog. GoldenGate 12 – Classic, Coordinated and Integrated Replicat. This entry was posted on March 7, 2014, in GoldenGate. I New Replicat Modes Availalble in GolgenGate 12.1. The new Coordinated and Integrated Replicats can help you achieve transactions being applied in parallel on the target database without having to manually split out tables into multiple replicats. Let’s take a look at the difference in the replicat modes. Constructs logical change records (LCR) that represent sou...
minersoracleblog.wordpress.com
Using dstat for monitoring CPU, Memory, Disk, etc | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/10/15/using-dstat-for-monitoring-cpu-memory-disk-etc
Rick Miners' Oracle Blog. Using dstat for monitoring CPU, Memory, Disk, etc. This entry was posted on October 15, 2014, in Linux. Dstat is a good tool for replacing vmstat, netstat, iostat, and ifstat. It it a very lightweight tool that can consolidate and correlate data that you would normally have to capture in different terminals. I’ve used dstat before in the past to monitor backup throughput over interfaces. Of course, this is possible if the backups are going to disk. CPU, Load, Disk I/O and Memory.
minersoracleblog.wordpress.com
GoldenGate Initial-Load Direct Load | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2013/05/24/goldengate-initial-load-direct-load
Rick Miners' Oracle Blog. GoldenGate Initial-Load Direct Load. This entry was posted on May 24, 2013, in GoldenGate. And tagged OGG Initial Load. This article will demostrate how to perform a OGG Initial Load using the Direct Load technique. Other Initial Load techniques and their advantages and disadvantages can be found here. OGG is installed on source and target systems. OGG : 11.2.1.0.1. Database : 11.2.0.3. Linux : OEL 6 ( 64 bit ). 1 Configure the initial-load processes. GGSCI start extract csoea.
minersoracleblog.wordpress.com
Oracle GoldenGate Initial Load Techniques | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2013/05/23/oracle-goldengate-initial-load-techniques
Rick Miners' Oracle Blog. Oracle GoldenGate Initial Load Techniques. This entry was posted on May 23, 2013, in GoldenGate. And tagged OGG Initial Load. In order to start using OGG replication, the source and target databases must be in sync. This means that the source data must be copied over to the target and remain in sync while changes are occurring in the source database. So, why is a native tool recommended? General Steps for Performing an Initial-Load. 1 The continuous standard extract for replicat...
minersoracleblog.wordpress.com
Changing Timezone Settings on Oracle Database Servers | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/09/19/changing-timezone-settings-on-oracle-database-servers
Rick Miners' Oracle Blog. Changing Timezone Settings on Oracle Database Servers. This entry was posted on September 19, 2014, in Oracle. These settings shown were valid for DB 11.2.0.2 and above on Redhat/Oracle Linux 6. Look at /etc/localtime to see the timezone setting for the server. The. Setting should be set to an entry in the /usr/share/zoneinfo directory/subdirectory. Ls -lhF /etc/localtime lrwxrwxrwx 1 root root 35 May 9 17:54 /etc/localtime - /usr/share/zoneinfo/America/Chicago. Incorrect SYSDAT...
minersoracleblog.wordpress.com
Mapping problem with compressed update record – Key column missing from update | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2013/12/20/mapping-problem-with-compressed-update-record-key-column-missing-from-update
Rick Miners' Oracle Blog. Mapping problem with compressed update record – Key column missing from update. This entry was posted on December 20, 2013, in GoldenGate. Here’s an example of an update statement failing on the target database on a table without a primary or unique key. Since there are no keys defined on the table, the replicat will consider all the columns as key columns. Doing some research on My Oracle Support turned up the following two notes that were used to come up with a solution. Here&...
minersoracleblog.wordpress.com
GNU screen Command | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/07/29/gnu-screen-command
Rick Miners' Oracle Blog. This entry was posted on July 29, 2014, in Linux. The screen utility can be used to start a session that will be persistent if the terminal is lost, plus it also provides the ability to login from another computer simply by attaching to the screen session name. Here are some essential commands to know:. Start new session with a name and a log file. Screen -S name -L. Attach to a running session. Screen -d -R name. Leave a Reply Cancel reply. Enter your comment here. Oracle Golde...
minersoracleblog.wordpress.com
Oracle GoldenGate : DB2 to Oracle | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/08/25/oracle-goldengate-db2-to-oracle
Rick Miners' Oracle Blog. Oracle GoldenGate : DB2 to Oracle. This entry was posted on August 25, 2014, in GoldenGate. This article will demonstrate heterogeneous replication using OGG from DB2 to Oracle. OGG is installed on source and target systems. DB2 on Mainfram Z/OS. Oracle Database : 11.2.0.3. 3 Configuration on Source. Server ( DB2 ). Place all parameter files in the $GG HOME/dirprm directory. Extract for Initial Load. C Source Table Definitions. When done, copy the output file (dirdef/db2t source...
minersoracleblog.wordpress.com
Root Filesystem Full – No Space Left on Device due to open files | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2013/06/04/root-filesystem-full-no-space-left-on-device-due-to-open-files
Rick Miners' Oracle Blog. Root Filesystem Full – No Space Left on Device due to open files. This entry was posted on June 4, 2013, in Linux. Here’s the status of the root file system which was causing the “No Space Left on Device” error message. Df -h . Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGExaDb-LVDbSys1 30G 30G 0 100% /. Du -sh * 7.7M bin 67M boot 3.5M dev 8.5M etc 1.2G home 440M lib 28M lib64 16K lost found 4.0K media 1.2G mnt 6.8G opt 1.1G root 41M s...Next was to look at open file...