---
title: "#19c articles | Hashnode"
description: "Explore 17 articles tagged #19c on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/19c"
---

Tag

# #19c

17 posts · 0 followers

[Michael](https://hashnode.com/@mmuehlbeyer) · [Feb 3](https://hashnode.com/posts/patch-your-database-with-autoupgrade/6981b0a9e859e66623a8cae0)

### [Patch your database with autoupgrade](https://mmuehlbeyer.hashnode.dev/patch-your-database-with-autoupgrade?utm_source=hashnode&utm_medium=feed)

With the help of autoupgrade you could easily patch you're current database to the latest available patch by using a 2-step approach Let's dive directly into it Assume we have installed Oracle database 19c no patches, base version 19.19 (as we're run...

4 min read · [mmuehlbeyer.hashnode.dev](https://mmuehlbeyer.hashnode.dev/patch-your-database-with-autoupgrade?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Sep 28, 2025](https://hashnode.com/posts/ogg-lentitud-de-replicat/68d959f1ca1fd63fd36d3d27)

### [\[OGG\] Lentitud de replicat](https://dbaenlasombra.com/ogg-lentitud-de-replicat?utm_source=hashnode&utm_medium=feed)

El artículo también se encuentra publicado en Ingles English version. Hoy vamos a ver un caso sencillo de un proceso de replicat en OGG que corre demasiado lento. La situación del OGG cuando me pidieron ayuda era la siguiente: GGSCI 1> info all Prog...

4 min read · [dbaenlasombra.com](https://dbaenlasombra.com/ogg-lentitud-de-replicat?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Sep 28, 2025](https://hashnode.com/posts/ogg-replicat-is-running-too-slowly/68d9594852fe01b173fd4bd9)

### [\[OGG\] Replicat is running too slowly](https://dbaintheshadow.com/ogg-replicat-is-running-too-slowly?utm_source=hashnode&utm_medium=feed)

If you prefer to read in Spanish Spanish version. Today, let’s look at a case where the Replicat process is running too slowly. The situation with OGG when they notified me was as follows: GGSCI 1> info all Program Status Group Lag at...

4 min read · [dbaintheshadow.com](https://dbaintheshadow.com/ogg-replicat-is-running-too-slowly?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Jul 3, 2025](https://hashnode.com/posts/oci-monitorizacion-dataguard/6866718eab300b1a4b5e805e)

### [\[OCI\] Monitorización Dataguard](https://dbaenlasombra.com/oci-monitorizacion-dataguard?utm_source=hashnode&utm_medium=feed)

Os paso un script sencillo para supervisar nuestro Oracle Data Guard, cuya función es enviarnos una alerta si se detectan errores o advertencias. En caso que nuestro script haya detectado problemas, nos enviará un correo con la siguiente información:...

2 min read · [dbaenlasombra.com](https://dbaenlasombra.com/oci-monitorizacion-dataguard?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Mar 2, 2025](https://hashnode.com/posts/oci-ogg-auto-start-ogg-en-linux/67c49d611964ef4b4489ab4c)

### [\[OCI-OGG\] Auto start Ogg en Linux](https://dbaenlasombra.com/oci-ogg-auto-start-ogg-en-linux?utm_source=hashnode&utm_medium=feed)

Vamos a definir un servicio para nuestro golden gate arranque en linux de manera automática cuando el sistema se reinicia. Para ello necesitamos definir lo siguiente: Ficheros de parámetros para golden gate. Sh para gestionar el arranque/parada del...

3 min read · [dbaenlasombra.com](https://dbaenlasombra.com/oci-ogg-auto-start-ogg-en-linux?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Aug 23, 2024](https://hashnode.com/posts/mantenimiento-de-datafiles/66c8afb7665c1a8271b11d8c)

### [Mantenimiento de datafiles](https://dbaenlasombra.com/mantenimiento-de-datafiles?utm_source=hashnode&utm_medium=feed)

Adjunto un pequeño script que tengo configurado vía crontab, para tener controlado cuando los tablespaces llegan a cierto umbral que se pasa por parámetro. Lo que se hace es redimensionar el datafile añadiendo 5Gb y me notifica vía email si ha habido...

2 min read · [dbaenlasombra.com](https://dbaenlasombra.com/mantenimiento-de-datafiles?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Jul 29, 2024](https://hashnode.com/posts/rman-08137-warning-archived-log-not-deleted-needed-for-standby-or-upstream-capture-process/66a7bad50f07fa611422f3c7)

### [RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process](https://dbaenlasombra.com/rman-08137-warning-archived-log-not-deleted-needed-for-standby-or-upstream-capture-process?utm_source=hashnode&utm_medium=feed)

A la hora de revisar porque RMAN no era capaz de eliminar los archive logs dándonos el siguiente error: RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process archived log file name=+RECO/XXXXXX/ARCHIVELOG/2024\_...

2 min read · [dbaenlasombra.com](https://dbaenlasombra.com/rman-08137-warning-archived-log-not-deleted-needed-for-standby-or-upstream-capture-process?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Apr 30, 2024](https://hashnode.com/posts/wallet-key-needed-pdb-needs-to-import-keys-from-source/6630fde2180585ab012fe4b8)

### [Wallet Key Needed - PDB needs to import keys from source](https://dbaenlasombra.com/wallet-key-needed-pdb-needs-to-import-keys-from-source?utm_source=hashnode&utm_medium=feed)

A la hora de abrir una PDB, nos encontramos que la PDB estaba abierta pero en modo RESTRICTED=YES SQL> show pdbs CON\_ID CON\_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- ...

2 min read · [dbaenlasombra.com](https://dbaenlasombra.com/wallet-key-needed-pdb-needs-to-import-keys-from-source?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Apr 15, 2024](https://hashnode.com/posts/ogg-02045-db-does-not-have-streamspoolsize-initialization/661d0d72c5594d78dd19e001)

### [OGG-02045 DB does not have streams\_pool\_size initialization](https://dbaenlasombra.com/ogg-02045-db-does-not-have-streamspoolsize-initialization?utm_source=hashnode&utm_medium=feed)

Revisando el log de golden gate, vimos el siguiente error: 2024-02-29T23:44:02.152+0000 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, xxxxx.prm: Database does not have streams\_pool\_size initialization parameter configured. Analizamos ...

1 min read · [dbaenlasombra.com](https://dbaenlasombra.com/ogg-02045-db-does-not-have-streamspoolsize-initialization?utm_source=hashnode&utm_medium=feed)

[David Sanz](https://hashnode.com/@sanzmaci) · [Jan 29, 2024](https://hashnode.com/posts/release-mismatch-19000230718-18-in-database-classesbin-vs-19000231017-18-in-executable/65b76d2c07f89ed9aa18c3d9)

### [Release mismatch, 19.0.0.0.230718 1.8 in database (classes.bin) vs 19.0.0.0.231017 1.8 in executable](https://dbaenlasombra.com/release-mismatch-19000230718-18-in-database-classesbin-vs-19000231017-18-in-executable?utm_source=hashnode&utm_medium=feed)

Vamos a tratar de solucionar el siguiente error que teníamos presente en el alert log. \_\_(3):joxcsys: release mismatch, 19.0.0.0.230718 1.8 in database (classes.bin) vs 19.0.0.0.231017 1.8 in executable pid 35577 cid 3 2024-01-29T09:27:44.180287+01:0...

2 min read · [dbaenlasombra.com](https://dbaenlasombra.com/release-mismatch-19000230718-18-in-database-classesbin-vs-19000231017-18-in-executable?utm_source=hashnode&utm_medium=feed)
