Infrastructure at your Service

All posts by Michael Hein

Michael Hein



Michael Hein

Patching a virtualized ODA to patch 12.2.1.4.0

By | Database Administration & Monitoring | No Comments

This article describes patching a virtualized Oracle Database Appliance (ODA) containing only an ODA_BASE virtual machine. Do this patching first on test machines because it can not be guaranteed that all causes of failures of single VM ODAs are covered in this article. I got the experience that precheck for ODA patches does not detect some failure conditions which may lead to an unusuable ODA. Overview: Patch first to 12.1.2.12.0 After that patch to 12.2.1.4.0…

Read More
Michael Hein

Recovering from failed patch on virtualized ODA

By | Database Administration & Monitoring | No Comments

When a patch fails on a virtualized Oracle Database Appliance (ODA), this ODA is often unusuable because Linux and OAKD are patched to new release but Grid Infrastructure is still on old version. OAKD cannot be restarted in default mode because in this mode the active Grid Infrastructure version is checked, which will fail due to old version. Also Grid Infrastructure cannot be started due to the fact that OAKD controls access of shared hardware…

Read More
Michael Hein

How to fix OUI-10022 error on an ODA

By | Database Administration & Monitoring | No Comments

When manually upgrading Grid Infrastructure on an ODA according to MOS note 2379389.1 it has to be done as grid user. This can fail with OUI-10022 error which indicates that Oracle inventory is corrupt. But when trying an “opatch lsinventory” as oracle and as grid user these commands succeeded, so inventory seems to be ok. It turned out that the locks subdirectory of the oracle inventory was not writable for the grid user. After making…

Read More
Michael Hein

Getting in touch with shareplex

By | Database Administration & Monitoring | No Comments

Tuesday this week I had the opportunity to get in touch with shareplex, Quest’s replication solution. This product does not rely on Oracle licenses, so can also be used with Standard Edition. It is competitor of Oracle’s GoldenGate an used for asynchronous replication, too. An interesting feature is that not only committed transactions can be replicated, which is an advantage with big transactions. With this feature replication latencies within seconds can be realized. Also migrations…

Read More
Michael Hein

SCAN listener does not know about service

By | Database Administration & Monitoring | One Comment

When trying to connect to a database via SCAN listener in a RAC environment with sqlplus, an ORA-12514 error is thrown. Tnsping can resolve the connect string. Whereas connecting to the same database over node listener with sqlplus succeeds. One possible reason could be, that the parameter remote_listener of the database to be connected is not set to SCAN listener of RAC cluster. So try to set remote_listener to SCAN_LISTENER_HOST:SCAN_LISTENER_PORT like (e.g. host is scan_host,…

Read More
Michael Hein

Logical standby: No view for data guard status on session level

By | Database management, Oracle | No Comments

On logical standby you have to switch off data guard at least on session level to make modifications on objects which are maintained by data guard. This is done by command alter session disable guard; Dataguard can be reenabled for this session by issuing alter session enable guard; For executing these commands “alter database” privilege is at least needed, which is often not liked by IT security staff. Command “alter session disable guard” is also…

Read More
Michael Hein

How to shrink tables with on commit materialized views

By | Database Administration & Monitoring | No Comments

Usually it is not possible to shrink tables which are used by on commit materialized views. The result is an ORA-10652 “Object has on-commit materialized views” error, for which in action section nothing is suggested. There is a workaround for this error: Convert all materialized views which rely on your table to be shrinked from on-commit to on-demand views. Application must tolerate that the affected materialized views are not updated during shrinking space of the…

Read More
Michael Hein

utl_dbws causes ORA-29532 and bad_record_mac

By | Database Administration & Monitoring | No Comments

After installing OJVM patch set update APR-2017 on a 11.2.0.4 database with PSU APR-2017 installed, first call of utl_dbws package was successful, but after a while utl_dbws calls failed always with ORA-29532 and bad_record_mac. All Java objects remained valid. Also after trying procedures described in MOS document 2314363.1 utl_dbws worked first time, after that it always failed. We could observe that after a while after restarting database m000 process ran and tried to recompile Java…

Read More
Michael Hein

Disabling database trap with dataguard broker

By | Database Administration & Monitoring | No Comments

When connecting to dataguard broker and disabling database with ORACLE_SID set before connecting to broker, broker becomes inaccessible, which is shown below: Login to broker via database ila: oracle [ILA@p03] /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs : dgmgrl / DGMGRL for Linux: Version 11.2.0.4.0 – 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type “help” for information. Connected. DGMGRL> show configuration; Configuration – ila Protection Mode: MaxAvailability Databases: ILAP – Primary database ila – Physical…

Read More
Michael Hein

How to flashback databases in dataguard with broker

By | Database Administration & Monitoring | No Comments

Last week I had to do some tests with dataguard. To make restores easier restore points were required. Given is following configuration: show configuration; Configuration – ila Protection Mode: MaxAvailability Databases: ila – Primary database ilal – Logical standby database ILAP – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS How to set restore points here ? Two things to consider: Redo apply to a physical standby is incompatible with setting a restore point…

Read More