DBA in the shadow

DBA in the shadow

DBA in the shadow

[OCI] Re-create the PDB$SEED
Today, let's talk about how to easily re-create the PDB$Seed when we don't have a backup. Below you can see the error: sys@> alter pluggable database PDB$SEED open read only; alter pluggable database
Sep 14, 20264 min read
[OCI] Clone PDB
If you prefer to read in Spanish Spanish version. Today, let's talk about the steps to clone a PDB using RMAN Active Duplicate or DDL commands betweent differents CDB$Root. DDL Let's use a script in
Jun 20, 20263 min read
DBA in the shadow
21 posts
Tutorials, scripts, and so on. Join me on my journey to optimize and learn.
[OCI] Check Jobs DBCli
If you prefer to read in Spanish Spanish version. Today, let's see a little script in order to see quickly monitor jobs running into Oracle Database Cloud. Below, you can see the output our sh: At t
Jun 10, 20263 min read
[26ai] JOIN_TO_ME
If you prefer to read in Spanish Spanish version. Today, let's talk about the new join syntax available in the last realease 26ai. It was introduced to simplify our joins avoiding common mistakes, wri
May 17, 20263 min read
[26ai] Cleanup of Obsolete PL/SQL Objects
If you prefer to read in Spanish Spanish version. Today, let's create an audit in order to clean up unused package/procedure/function in the database, with the porpuse of reducing the total amount of
Apr 19, 20262 min read
[26ai] Hybrid Read-Only Mode PDB
If you prefer to read in Spanish Spanish version. Today, let's talk about a new Hybrid Read-Only open-mode in 26ai. When we set up this mode, our PDB is read-only mode for local users and read-write f
Apr 9, 20263 min read
[26ai] ALERT_LOG_MAX_SIZE
If you prefer to read in Spanish Spanish version. Today, let's talk about a new parameter in 26ai in order to handle the size our alert log in a straightforward and efficient way. It's alert_log_max_s
Apr 3, 20262 min read
[26ai] ConnStr Tool
If you prefer to read in Spanish Spanish version. Today, let's talk about the new feature in 26ai: the ConnStr tool. The tool is a command-line utility that it works in order to display the connection
Mar 25, 20264 min read
[26ai] Install Oracle AI Database 26ai on Linux 9
If you prefer to read in Spanish Spanish version. Today, we're going to see how to set up Oracle 26ai on Linux 9. [root@~]# grep PRETTY /etc/os-release PRETTY_NAME="Oracle Linux Server 9.7" First of
Mar 14, 20262 min read