Feb 3 路 4 min read 路 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...
Join discussion
Apr 6, 2025 路 5 min read 路 Esta gu铆a paso a paso est谩 dise帽ada para que puedas validar de manera segura y efectiva el estado de tu entorno Data Guard, especialmente tras reinicios, parcheos o eventos de failover. Incluye comandos clave, interpretaci贸n de resultados, y acci贸n c...
Join discussion
Jan 29, 2025 路 3 min read 路 Oracle is a company that offers a variety of business oriented products and services, including Oracle Database, a relational database management system (RDBMS). Oracle database is a core component of many corporate IT environments, supporting busin...
Join discussionMay 4, 2024 路 1 min read 路 Export as DDL: via dbms_metadata Oracle 19c. SE CREATE TABLE "TEST" ("TEST" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 43277 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE , "MA...
Join discussionFeb 6, 2024 路 1 min read 路 Check Status and Parameters. Shutdown and startup mount (!Caution). [oracle@orcl ~]$ sqlplus / as sysdba SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. ...
Join discussion
Feb 5, 2024 路 1 min read 路 Get and Set ADR_BASE location. [oracle@orcl ~]$ adrci ADRCI: Release 19.0.0.0.0 - Production on Tue Aug 8 15:08:45 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show bas...
Join discussion
Feb 5, 2024 路 1 min read 路 Purge Alerts older than 1 month (44640 minutes). adrci> purge -age 44640 -type ALERT Purge Trace Files older than 1 month (44640 minutes). adrci> purge -age 44640 -type TRACE Purge Incidents older than 1 month (44640 minutes). adrci> purge -ag...
Join discussion