You have certainly also received this error once in you Oracle DBA career: “ORA-01665: control file is not a standby control file” while trying to create a standby database with RMAN through a full database backup. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the “Restore Failover”. In order…
Once a replication environment is set up, it’s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation. This posting should help you with this task. In the example below, tables from schema G001 will be added to an existing replication setup from the database PROD1 to REP1. CFG_ADV_COND CFG_NARRATIVE_TEMPLATE…
Database Vault solution allows to create rules that manage access to database. Among these rules there is what is called in Database Vault “Rule Sets”. These logic components are written as PL/SQL functions to return Boolean results.
If rule expressions do not match the user context, the access is refused and a specific message can be configured in order to
…
For a few day we had a quick request at a customer which was to replace a voting disk in an ASM disk group. The current ASM disk group (redundancy normal) had 3 disks : two located in one data center and one disk in another data center. The goal was to replace one voting disk (from the most used
…
Data can be corrupted in different ways, for example an I/O issue when reading data from the storage or a memory issue when updating data. The db_block_checking parameter allows to change the behavior of an Oracle database concerning block checking.
This posting will present this parameter and some tests to measure its impact on the database.
This post presents the configuration of the tmpfs filesystem size on SLES 11 in order to use the Oracle 11.2 Automatic Memory Management feature (AMM) through the Oracle instance parameter memory_target.
Oracle Application Express – APEX 4.1 Introduces many new features such as :
Improved error handling and user-defined exception processing
Application Express now supports the use of ROWID for updates, inserts and deletes as an alternative to specifying primary keys
Developers can now easily add the capability for end-users to load spreadsheet data into existing tables within an application
The
…
Le marché du Database Activity Monitoring (DAM) devenant de plus en plus important avec des produits tels que Imperva, Guardium ou Sentrigo, je me suis intéressé au produit Oracle Database Firewall, qu’Oracle présente comme un substitut aux différents acteurs du marché des DAMs.
Oracle has introduced three new caching features in its Oracle 11g release:
In this posting, I will present the query result cache feature.
Ayant rencontré récemment des problèmes de blocs corrompus sur des bases Oracle en version Oracle 10g et Oracle 11g, des différences notables sont apparues notamment au niveau de la vue v$database_block_corruption. Je vous livre dans ce post le résultat de mes tests.
A few days ago I downloaded the Cloud Control 12c binaries for Linux x86_64 from the Oracle Technet.
My friend, Hervé Schweitzer, configured an OEL 5.7 VM for test purpose and I was quite eager to install this new software. I checked the O.S settings, the required parameters, aso …, everything was fine. My OMS repository database (11.2.0.3) was ready.
…
My colleague Hervé Schweitzer reported a very interesting issue to me. It is about the usage of Grid Control 11g while monitoring the available space on an Oracle database – in our case a 10.2.0.3 target database. This post continues my last post about the free space management in a tablespace in relation to the recycle bin management.
