[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
DBA in the shadow
Tutorials, scripts, and so on. Join me on my journey to optimize and learn.
Latest articles
[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
[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
[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
[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
[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
[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
[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
[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
