Infrastructure at your Service

All Posts By

Oracle Team

Oracle Team

Recover a corrupted datafile in your DataGuard environment 11G/12C.

By | Database Administration & Monitoring, Database management, Development & Performance, Oracle | No Comments

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to repair the Standby database, without to be necessary to restore entire database. Initial situation : DGMGRL> connect / Connected to “PROD_SITE2” Connected as SYSDG. DGMGRL> show configuration; Configuration – CONFIG1 Protection Mode: MaxPerformance Members: PROD_SITE2 -…

Read More
Oracle Team

Looping sssd_nss

By | Database Administration & Monitoring | No Comments

Often Linux systems are connected to LDAP via sssd. A high CPU consuming sssd can be seen in top, like below ( e.g. 89.4 % CPU usage): 9020 root 20 0 1296344 466780 333364 R 89.4 0.8 41:20.17 sssd_nss 27227 oracle 20 0 2371676 48320 29732 S 4.3 0.1 27:00.70 oracle One reason could be default configuration of /etc/nsswitch.conf: passwd: db sss files shadow: db sss files group: db sss files This configuration causes sssd_nss…

Read More
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

Foglight

By | Database Administration & Monitoring | No Comments

As many Oracle Database Administrators, I am a regular user of Oracle Enterprise Manager in order to monitor or administer my client’s databases. I am lucky because most of them have the diagnostic pack and the tuning pack :=). But we always have to be curious and discover new products. As described by my colleague Nicolas Penot, I installed Foglight: https://blog.dbi-services.com/foglight-monitoring-solution-for-databases-part-01/ https://blog.dbi-services.com/foglight-monitoring-solution-for-databases-part-02/ The installation was successful and very quick to realize, remember when you have…

Read More
Oracle Team

OEM 13c Repository view gc$metric_values_daily

By | Database Administration & Monitoring | One Comment

Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:     The report displays the details for each month and for each tablespace, but the GUI is sometimes painful: you have a nice report but many tablespaces and many numbers :=( At a client’s site, I had the following behavior: a production database had its data…

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