Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.
Recently at a customer we needed to power-cycle a database system because we wanted to be sure that a cluster resource fails over to a remaining node as expected. The issue was that we did not have access to the data center where the system is running nor did we have access to the console. What to do? Actually it…
What to do if you get the above error when you try to install Oracle SE2 (did not test if the same issue is there with EE, but probably it is) in silent mode?: ./runInstaller oracle.install.option=INSTALL_DB_SWONLY ORACLE_BASE=/u01/app/oracle/ ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_2_4/ UNIX_GROUP_NAME=oinstall oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=dba oracle.install.db.BACKUPDBA_GROUP=dba oracle.install.db.DGDBA_GROUP=dba oracle.install.db.KMDBA_GROUP=dba FROM_LOCATION=../stage/products.xml INVENTORY_LOCATION=/u01/app/oracle/oraInventory/ SELECTED_LANGUAGES=en oracle.install.db.InstallEdition=SE2 DECLINE_SECURITY_UPDATES=true -silent -ignoreSysPrereqs -ignorePrereq -waitForCompletion You already checked my oracle support and…
This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp Using GoldenGate event actions to suspend replication for end of day reporting One question…
The last post in this series outlined on how to do an initial load of the target database using the “expdp/impdp” method: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp In…
The last post in this series outlined on how to do an initial load of the target database using the “file to replicat” method: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat In this post I’ll show how to do…
The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release.The second post explained how to create a sample replication with Oracle GoldenGate: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate In this post I’ll look how to do an initial load using…
The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release: Installing and patching Oracle GoldenGate 12c to the latest release In this post I’ll look in how to prepare the databases and how to setup GoldenGate for a first sample replication between two Oracle 12.1.0.2 databases. My test setup is as…
As more and more customers ask for expertise in Oracle GoldenGate this blog post is the first in a series and outlines how to install Oracle GoldenGate 12c and how to patch it to the latest release on Oracle Linux 7.1 x64. The installation sources (as always) can be downloaded from otn.oracle.com. For the latest patchset you’ll need access to…
Before PostgreSQL 9.5 (which is in alpha2 currently) you could grant access to individual columns of a table to users or roles. A little test script to demonstrate this: (postgres@[local]:5432) [postgres] > select version(); version ————————————————————————————————————– PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit (1 row) create table t ( id int primary key,…
How many applications do you know that need to define a validity of a row? And how many of these do that by adding two columns: valid_from and valid_to or similar column names? Well, in PostgreSQL (you already suspect it 🙂 ) there is much more elegant way to do that. PostgreSQL knows the concept of range types. Several of…
As you might know PostgreSQL 9.5 is currently in alpha 2. One of the new features will be the possibility to import foreign schemas. Having this it is no longer required to create all the foreign tables which saves a lot of work. Setting up oracle_fdw was done in exactly the same way as in the previous post. Make sure…
For integrating data from other systems PostgreSQL has the concept of foreign data wrappers. Many of these exist for different types of systems. In this post I’ll look into how you may connect PostgreSQL to Oracle. The home of the foreign data wrapper for Oracle (as most of the PostgreSQL stuff) is on github. If you do not want to…
