How to create a Backup Report in EM Cloud Control 13c
This blog describes how to create a backup report in Enterprise Manager 13c.
Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.
This blog describes how to create a backup report in Enterprise Manager 13c.
Oracle Data Redaction: What It Is and How to use it. A quick example usage case.
Configure Oracle Database Server and it’s Database with OKV using RESTfull API
Oracle Key Vault 21.7 introduce the SSH key support, a new type of endpoint(SSH server) and a new wallet type (SSH Wallet).
Oracle Key Vault 21.7 introduce the SSH key support, a new type of endpoint(SSH server) and a new wallet type (SSH Wallet).
How to configure, from scratch, the TDE on the database, how to upload the wallet keys in the OKV and how to configure the database to use these keys.
[ORA-20001] How can LC_* localisation environment variables can break Oracle datapatch
In this blog I want to introduce some of the new features of the Oracle 23c developer edition. It will be only a selection of some of the main features. It is not the intention to give you a thorough picture of all the features in this blog. I have tested some of the essential ones (in my opinion) on…
The Oracle 23c new feature Lock Free Reservations allows to break with the traditional locking mechanism. Now multiple concurrent sessions can update the same row without be blocked !!! Let’s see how it works. In the traditional locking mechanism, when a first session modifies a row, oracle will hold 2 locks : If a second session tries to update the…
SQL is a wonderful language and very easy to use. For example you can call a PL/SQL function into a SELECT or WHERE clause and the result of the PL/SQL function is returned into the SQL expression. But when we call a PL/SQL function inside a SQL statement there is a context switch between the SQL Engine and the PL/SQL…
This blog comes to complete the excellent blog written by my colleague Gregory Steulet on the same topic. SQL FIREWALL is a new security layer integrated into Oracle Database 23c. First, we create a admin user for which we grant it a new admin privilege “sql_firewall_admin”: We enable the SQL FIREWALL: We create a capture process on the user LFE:…
Sysadmins are traditionally more operators than developers, they code mainly scripts for automation reasons (shell scripts, Ansible, Terraform, aso). In addition, they can find themselves in situations where they need to analyse code or even decompile programs. Some sysadmins lack good programming methodology, that was my motivation to dig deeper into this subject. Are there simple rules to follow? As…