Database Administration & Monitoring, Hardware & Storage, Operating systems, Oracle How to configure additional network card on an ODA X8 family 25.05.2020 by Marc Wagner During a past project, we were using ODA X8-2M with one additional network card. As per my knowledge, on an appliance, additional cards are used to extend connectivity to additional network. Customer was really enforcing to have network redundancy between(…)
Database Administration & Monitoring, Oracle dbvisit dbvctl process is terminating abnormally with Error Code: 2044 29.11.2019 by Marc Wagner When applying archive logs on the standby, dbvctl process can terminate abnormally with Error Code: 2044. This can happen in case there are several archive logs with huge size to be applied.
Database Administration & Monitoring, Oracle ODA hang/crash due to software raid-check 29.11.2019 by Marc Wagner Oracle Database Appliance (ODA) is by default configured with software raid for Operating System and Oracle Database software file system (2 internal SSD disks). 2 raid devices are configured : md0 and md1.ODA are configured to run raid-check every Sunday(…)
Database Administration & Monitoring, Oracle Adding a dbvisit standby database on the ODA in a non-OMF environment 23.10.2019 by Marc Wagner 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,(…)
Database Administration & Monitoring, Oracle Having multiple standby databases and cascading with dbvisit 23.10.2019 by Marc Wagner 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.
Database Administration & Monitoring, Oracle Connecting to ODA derby database 23.10.2019 by Marc Wagner 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(…)
Database Administration & Monitoring, Oracle Migrating Oracle database from windows to ODA 01.10.2019 by Marc Wagner 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).
Database Administration & Monitoring, Oracle Moving oracle database to new home on ODA 13.09.2019 by Marc Wagner 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(…)
Control-M How workload policies is making your life easy 26.02.2019 by Marc Wagner 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(…)
Database Administration & Monitoring, Oracle RMAN catalog upgrade, why, when and how 23.08.2018 by Marc Wagner One of our customer has been initially creating a RMAN catalog on an Oracle database release 12.1.0.2.0 and was now intending to register new Oracle 12.2.0.1.0 databases. Registering the databases will be failing with errors : PL/SQL package RCAT.DBMS_RCVCAT version 12.01.00.02(…)