RMAN Commands fail with ORA-00904: “BS”.”GUID”: invalid identifier

Oracle Database Enterprise Edition 12.1.0.2: rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 2 08:33:58 2021 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: PDBCDB01 (DBID=2972180763) RMAN> RMAN command fails with error: RMAN> list backup summary; using target database ...

Oracle Database 21c for Linux platforms

Oracle Database 21c is now available for download for Linux platforms. Download here! This workshop offers several hands-on labs Oracle Database 21c contains more than 200 new innovations, including immutable blockchain tables, In-Database JavaScript, native JSON data type, AutoML for In-Database Machine Learning (ML), persistent memory store and sharding. More ...

MySQL Database Service – New HeatWave Innovations

Oracle announces MySQL Autopilot for MySQL HeatWave Service on OCI. MySQL is a perfect option now for datawarehousing. MySQL Autopilot delivers nine new machine learning-powered automation capabilities, further improving the performance and scalability of the MySQL Heatwave Service. HeatWave supports 64 node clusters and can process up to 32 TB ...
/ / Autopilot, DATABASE, HeatWave, MySQL

The Optimizer in Oracle Database 19c

The paper Optimizer in Oracle Database 19c introduces all of the new optimizer and statistics related features in Oracle Database 19c and provides simple, reproducible examples to make it easier to get acquainted with them, especially when migrating from previous versions. It also outlines how existing functionality has been enhanced ...
/ / DATABASE, Optimize, Oracle 19c

RMAN fails with RMAN-06900 RMAN-06901 ORA-04031

When trying to login with RMAN the following error occur: # rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Thu May 6 10:32:55 2021 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: PDEQ00 (DBID=2094282814) RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or ...
/ / ORA-04031, RMAN, RMAN-06900, RMAN-06901

Basic Administration of Oracle 12c Multitenant

Check if the database is CDB or non-CDB SQL> select cdb from v$database; CDB --- YES Connecting to Container $ export ORACLE_SID=pcdb01 $ sqlplus / as sysdba SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> show con_id CON_ID ------------------------------ 1 SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ...
/ / 12c, commands, multitenant, ORACLE, Oracle

OCP 12c, OCA, OCE, RHCSA and IBM Certified Database Administrator certifications.