Database

Multitenancy: is a Proxy PDB part of the 3 free PDBs at 19c

As most of us know, Oracle Database 19c now supports up to 3 pluggable databases (PDBs) per container database (CDB) without requiring additional multitenant license—applicable for both Standard Edition (SE2) and Enterprise Edition (EE). This documentation clearly states: “For all offerings, if you are not licensed for Oracle Multitenant, then you may have up to

By |2022-04-30T20:32:31+02:00April 29th, 2020|Database|0 Comments

Enterprise Manager warnings : Diskgroup requires rebalance on ASM targets

The following is from a former colleague, worth mentioning. The ASM targets in OEM-GC give the next active warnings: Metric: Disk Group Percent Imbalance Message: Disk Group SYSTEMDG requires rebalance because the space usage imbalance between disks is high. Metric: Disk Size Imbalance (%) Message: Disk Group SYSTEMDG has failure groups with disks of different

By |2023-04-23T11:41:13+02:00October 5th, 2019|grid control, RAC|0 Comments

Should a standby database be considered in the cloud?

To answer this question for your company, the criticalness of your application and database must be clear. In a High Availability Environment, a standby-database can be part of the technical solution to ensure minimum downtime for your database. But when moving to a public or private cloud (IaaS, PaaS), the providers ensure a certain high availability,

By |2022-06-10T09:24:35+02:00September 3rd, 2019|Database, Standby, Uncategorized|0 Comments

Oracle disaster recovery without licensing the DR site

Recently I got a question of a customer regarding a failover configuration. They wanted to install a second server acting as a failover server, switched off until the primary experiences an outage, and they don’t want to pay licenses for it. By bringing the failover-server to life and restore the backup,  business continues on this

By |2022-06-10T09:26:24+02:00May 12th, 2019|Database, licensing|0 Comments

expdp, ora-1555, Query Duration = 0

During a migration of a database, a remote export/import procedure (through database-link) fails intermittently. Some tables are skipped during export, with the familiair ‘ORA-0155’ error. Snapshot too old. Procedure hasn’t changed. What’s going on, besides the obvious reasons for an ORA-0155. Database version changed from 10.2.0.4 to 11.2.0.4.

By |2022-06-10T09:28:57+02:00March 2nd, 2019|Database|0 Comments

What kind of Oracle Linux support on Oracle hardware is included

When you buy an Oracle Database Appliance – any type – or just a X-server (e.g. X7-2), you get free support for OracleVM, Oracle Solaris and Oracle Linux. But Oracle Linux has different flavours , like basic, premier and premier limited. What kind of support do you get when buying hardware from Oracle? Can Ksplice be

By |2022-06-18T13:34:57+02:00September 15th, 2018|Database, licensing, Uncategorized|0 Comments

Recent Tweets Jobaclenl