Infrastructure at your Service

All Posts By

Daniel Westermann

Daniel Westermann

SQL Monitoring in PostgreSQL (1) – the logging system

By | Database Administration & Monitoring | No Comments

When developing an application as well as when the application is in production there is the need to identify long running queries. In Oracle one tool you might use for that is the SQL Monitor. In this post I’ll look into what PostgreSQL provides in this area. PostgreSQL has a very strong logging system. This system can be used to log many, many server messages as well as information about sql queries. To enable to…

Read More
Daniel Westermann

Upgrading PostgreSQL to a new major release

By | Database Administration & Monitoring | No Comments

The last post looked into how to upgrade PostgreSQL to a new minor version. In this post I’ll look into how to upgrade PostgreSQL to a new major version. This is not as simple as just installing the binaries and start the instance from there. For major upgrades there are two possibilities: dump the old version and restore into the new version by using pg_dump and pg_restore use pg_upgrade I’ll only look into pg_upgrade for…

Read More
Daniel Westermann

Patching PostgreSQL to a new minor release

By | Database Administration & Monitoring | 3 Comments

If you are used to patch Oracle databases you probably know how to use opatch to apply PSUs. How does PostgreSQL handle this? Do we need to patch the existing binaries to apply security fixes? The answer is: No. Lets say you want to patch PostgreSQL from version 9.4.1 to version 9.4.5. What do you need to do? For this little demo I’ll create a new database and a sample table in my 9.4.1 instance:…

Read More
Daniel Westermann

Migrating the Oracle 12cR1 sample schemas to PostgreSQL Plus Advanced Server 9.4

By | Database Administration & Monitoring | No Comments

This post takes a look on how to migrate the Oracle 12cR1 sample schemas to PPAS 9.4 (PostgreSQL Plus Advanced Server 9.4). I’ll not dig into how to install PPAS as this was described in detail some time ago. Just follow this post if you need a setup guide. If you wonder why I am doing this there are two reasons: to see if it works, to have fun and to learn PostgreSQL and PPAS…

Read More
Daniel Westermann

Upgrading the Grid Infrastructure from 12.1.0.1 to 12.1.0.2 on the command line

By | Database Administration & Monitoring | 2 Comments

A lot of people use the graphical way to upgrade Oracle software from one version to another. While there is nothing to say against that the same can be done without any graphical tools. This post outlines the steps to do so. Currently my cluster is running Grid Infrastructure 12.1.0.1 without any PSU applied. The node names are racp1vm1 and racp2vm2: [[email protected] ~]$ /u01/app/12.1.0/grid_1_0/bin/crsctl query crs softwareversion Oracle Clusterware version on node [racp1vm2] is [12.1.0.1.0]…

Read More
Daniel Westermann

The scripts of my DOAG 2015 session: Automated GI/RAC staging with Cobbler and VirtualBox

By | Database Administration & Monitoring | 2 Comments

I promised to upload the scripts of my session to our blog. So, here they are: create_12102_gi_rac_project.sh: This one creates the 12.1.0.2 GI/RAC project on the cobbler server finish_ora_12102_gi_rac_project.sh: This one does the configuration of the GI/RAC on the last node ora12102_gi_rac.ks: The 12.1.0.2 GI/RAC kickstart file pg940.ks: Template kickstart file for PostgreSQL 9.4 create_940_postgres_project.sh: Template project file for PostgreSQL 9.4 for creating the project on the cobbler server remove_projects.sh: A sample to delete the…

Read More
Daniel Westermann

Linux Magic System Request Key Hacks

By | Database Administration & Monitoring | No Comments

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 is quite easy to force a system to reboot without syncing the disks or unmounting…

Read More
Daniel Westermann

SEVERE:OUI-10020:The target area /u01/app/oracle/oraInventory/ is being used as a source by another session

By | Database Administration & Monitoring | No Comments

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 verified that…

Read More
Daniel Westermann

If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?

By | Database Administration & Monitoring | No Comments

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 that pops up when stopping the replication by using an event marker is: What happens…

Read More
Daniel Westermann

Using GoldenGate event actions to suspend replication for end of day reporting

By | Database Administration & Monitoring | 3 Comments

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 this post I’ll look into how to use event actions to suspend GoldenGate replication for…

Read More