Infrastructure at your Service

All Posts By

Oracle Team

Oracle Team

How to build a dummy resource plan

By | Database Administration & Monitoring | No Comments

Often switching off resource plan feature of Oracle database is desired. Unfortunately setting parameter RESOURCE_MANAGER_PLAN to empty string does not help, because it does not disable switching to another resource plan, e.g. with dbms_scheduler. Following procedure prevents this switching. 1. Creation of a dummy resource plan, e.g. TEST_PLAN: BEGIN DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA(); DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA(); DBMS_RESOURCE_MANAGER.CREATE_PLAN( plan =>’TEST_PLAN’, comment => ‘plan for TEST’, mgmt_mth => ‘EMPHASIS’, active_sess_pool_mth => ‘ACTIVE_SESS_POOL_ABSOLUTE’, parallel_degree_limit_mth => ‘PARALLEL_DEGREE_LIMIT_ABSOLUTE’); DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE( plan =>’TEST_PLAN’, group_or_subplan => ‘OTHER_GROUPS’, comment…

Read More
Oracle Team

ODA: The Patch version must be 12.2.1.4.0

By | Database Administration & Monitoring | 2 Comments

When trying to patch your virtualized ODA with patch 12.1.2.12.0 and immediately after that with 12.2.1.4.0, you might consider to load the patches like this: [[email protected] Oracle_Soft_Repo]# oakcli unpack -package /cloudfs/Oracle_Soft_Repo/p26433712_1212120_Linux-x86-64_1of2.zip Unpacking will take some time, Please wait… Successfully unpacked the files to repository. [[email protected] Oracle_Soft_Repo]# oakcli unpack -package /cloudfs/Oracle_Soft_Repo/p26433712_1212120_Linux-x86-64_2of2.zip Unpacking will take some time, Please wait… Successfully unpacked the files to repository. [[email protected] Oracle_Soft_Repo]# oakcli unpack -package /cloudfs/Oracle_Soft_Repo/p28216780_122140_Linux-x86-64_1of3.zip Unpacking will take some time, Please…

Read More
Oracle Team

Keine Angst vor Container Technologie (DOAG 2018)

By | Docker | No Comments

Seit 30 Jahren bin ich in der IT-Branche tätig, hatte immer wieder mit Oracle mit RDBMS Systemen zu tun. Nun, seit bald 4 Jahren als Berater bei dbi services habe ich sehr viel Berührung mit Oracle Datenbaken, daher auch mein Besuch der DOAG 2018. Mit grossem Interesse reiste ich zur DOAG nach Nürnberg und hatte mir vorgenommen zum Thema OpenShift und Container, diverse Sessions zu besuchen. Warum OpenShift? Nun seit einiger Zeit sehen wir Projekte(PoC) bei unseren…

Read More
Oracle Team

Patching a virtualized ODA to patch 12.2.1.4.0

By | Database Administration & Monitoring | 3 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
Oracle Team

Recovering from failed patch on virtualized ODA

By | Database Administration & Monitoring | 2 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
Oracle Team

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
Oracle Team

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
Oracle Team

How to migrate Grid Infrastructure from release 12c to release 18c

By | Application integration & Middleware, Database Administration & Monitoring, Database management, Oracle | No Comments

Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic as well as online allocation of compute resources where needed, when needed. Oracle Grid Infrastructure provides the necessary components to manage high availability (HA) for any business critical application. HA in consolidated environments is no…

Read More
Oracle Team

SQL Plan stability in 11G using stored outlines

By | Uncategorized | No Comments

Plan stability preserves execution plans in stored outlines. An outline is implemented as a set of optimizer hints that are associated with the SQL statement. If the use of the outline is enabled for the statement, then Oracle Database automatically considers the stored hints and tries to generate an execution plan in accordance with those hints (Oracle documentation). Oracle Database can create a public or private stored outline for one or all SQL statements. The…

Read More
Oracle Team

Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning.

By | Cloud, Database Administration & Monitoring, DevOps, Operation systems, Oracle | One Comment

Introduction : Oracle ASM Filter Driver (Oracle ASMFD) simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted. Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to Oracle ASM disks. In this blog I will…

Read More