Infrastructure at your Service

All Posts By

Marc Wagner

Marc Wagner

Adding a dbvisit standby database on the ODA in a non-OMF environment

By | Database Administration & Monitoring | No Comments

I have recently been working on a customer project where I had been challenged adding a dbvisit standby database on an ODA X7-2M, named ODA03. The existing customer environment was composed of Oracle Standard 12.2 version database. The primary database, myDB, is running on server named srv02 and using a non-OMF configuration. On the ODA side we are working with OMF configuration. The dbvisit version available at that time was version 8. You need to…

Read More
Marc Wagner

Having multiple standby databases and cascading with dbvisit

By | Database Administration & Monitoring | No Comments

Dbvisit standy is a disaster recovery solution that you will be able to use with Oracle standard edition. I have been working on a customer project where I had to setup a system having one primary and two standby databases. One of the standby database had to run with a gap of 24 hours. Knowing that flashback possibilities are very limited on standard edition, this would give customer the ability to extract and restore some…

Read More
Marc Wagner

Connecting to ODA derby database

By | Database Administration & Monitoring | No Comments

ODA light (ODA X7-2S, X7-2M, X8-2S, X8-2M) come with an internal derby database to manage ODA metadata. From time to time, there is a need to check or update some information within it, as for example when facing database deletion issue. I would like to strongly advise that updating manually the ODA repository should only be done after getting Oracle support guidance and agreement to do so. Neither the author (that’s me 🙂 ) nor…

Read More
Marc Wagner

Migrating Oracle database from windows to ODA

By | Database Administration & Monitoring | 2 Comments

Nowadays I have been working on an interesting customer project where I had to migrate windows oracle standard databases to ODA. The ODAs are X7-2M Models, running version 18.5. This version is coming with Red Hat Enterprise Linx 6.10 (Santiago). Both windows databases and target ODA databases are running PSU 11.2.0.4.190115. But this would definitively also be working for oracle 12c and oracle 18c databases. The databases are licensed with Standard Edition, so migrating through…

Read More
Marc Wagner

Moving oracle database to new home on ODA

By | Database Administration & Monitoring | No Comments

Moving database to new ORACLE_HOME is a common dba task. Performing this task on an ODA will need an additional step knowing ODA Lite is using an internal Derby database for the metadata. ODA HA will not be a problem here, knowing we do not have any Derby database. Through this blog I would like to give you some guidance and work around to move database to a new home (of same major release). In…

Read More
Marc Wagner

How workload policies is making your life easy

By | Database Administration & Monitoring | No Comments

Working as a control-M administrator, we are often requested to hold jobs or stop jobs during a period of time. Holding jobs and updating the job configuration might not be the most efficient way to do this. Workload policies is making your life really easier, giving you the possibility to configure such modification in advance and to let the system act independently whether the NDP (New Day Processing) is in the middle of the period…

Read More
Marc Wagner

Walking through the Zürich ZOUG Event – September the 18th

By | Database Administration & Monitoring | No Comments

What a nice and an interesting new experience… My first ZOUG Event… Interesting opportunities to meet some great persons and hear to some great sessions. I had the chance to participate to Markus Michalewicz sessions. Markus is Senior Director, Database HA and Scalability Product Management by Oracle, and was the special guest to this event.

Read More