Tablespace SYSMGMTDATA is FULL in Grid Infrastructure Management Repository (MGMTDB)
MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data. In Oracle 11g this information was stored in Berkley database (.bdb files), in $GRID_HOME/crf/db/hostname, but starting from Oracle database 12c it is configured as an Oracle Single Instance. In Oracle 12.1.0.1 the Grid Infrastructure Management ...
Oracle Cloud: Creating an Autonomous Transaction Processing (ATP) Database
To create the database, you sign up for Oracle Cloud Always Free at https://www.oracle.com/cloud/free/ You can sign up for a trial account which gives you $300 worth of credits valid for 30 days. First let's create the Compartment “LAB1”. A Compartment is a container to isolate resources unde Oracle Cloud ...
Managing CDB Fleet in Oracle Database 18c
Oracle Database 18c introduces the CDB fleet concept which is a collection of different CDBs that can be managed as one logical CDB. This feature is currently restricted to Enterprise Edition on Engineered Systems, like Exadata, and Enterprise Edition on Oracle Database Cloud Services. There are two possible roles in ...
Removing tracefiles with ADRCI
The ADRCI (Automatic Diagnostic Repository Command Interpreter) is a command-line tool that you use to manage Oracle Database diagnostic data. Below command will manually purge all tracefiles older than 10 days (14400 minutes) reducing occupation of filesystem "/u01": Syntax: purge [[-i {id | start_id end_id}] | [-age mins [-type {ALERT|INCIDENT|TRACE|CDUMP|HM}]]] ...
Oracle Database 20c New Features
New features of Oracle 20c: 1. Security - Force Upgraded Password File to be Case Sensitive - Connect to Multiple Databases with Different Certificates from a single client - Ability to Specify the Location of the CMU Wallet and dsi.ora File with a Database Property - Addition of USER_APPLICATION_ROLES Data ...
How to create user in Oracle Multitenant 12c without C## prefix
When I try to create a user without the c## prefix I get the ORA-65096 error: $ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat May 16 07:44:23 2020 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ...
