Administration

How to Change DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 20, 2021January 20, 2021

In previous post, we have talked about how to change DB_NAME of a single-instance database. In this post, we will talk about how to change… Read More »

How to Change DB_NAME of a Single-Instance Database

by Ed Chen
January 16, 2021January 20, 2021

In previous post, we have talked about how to change DBID of a single-instance database. In this post, we will talk about how to change… Read More »

How to Change DBID of a Single-Instance Database

by Ed Chen
January 13, 2021January 20, 2021

For a duplicate database, you may want to change its Database Identifier (DBID) only in order to distinguish this one from another. Here we use… Read More »

How to Resolve NID-00120: Database should be mounted exclusively

by Ed Chen
January 6, 2021January 9, 2021

NID-00120 I was trying to change database name (DB_NAME) of a 19c RAC database by DBNEWID utility (nid), but it failed with NID-00120: Database should… Read More »

How to Find DBID

by Ed Chen
December 30, 2020December 22, 2020

In some situations, you may have to know DBID of the database to let backup catalog know the subsequent steps are for specific database in… Read More »

How to Connect a PDB Directly by OS Authentication

by Ed Chen
December 23, 2020December 28, 2020

OS Authentication We usually connect to the database by / AS SYSDBA without providing any password for maintenance works, such as startup, shutdown and backup.… Read More »

How to Query TEXT in ALL_VIEWS

by Ed Chen
November 28, 2020January 10, 2021

ALL_VIEWS Dictionary view ALL_SOURCE contains only several object types like PROCEDURE, PACKAGE BODY, FUNCTION, TYPE except VIEW. If you want to search the content of… Read More »

Complete Initialization Parameters List in DBCA 19c

by Ed Chen
October 31, 2020October 19, 2020

The complete list is shown during creating a 19c RAC database by DBCA.

How to Kill All Sessions Instantly

by Ed Chen
July 29, 2020July 22, 2020

Kill All Sessions I have talked about many topics about identifying and killing sessions in my blog, including: How to Kill Session in Logon Trigger… Read More »

How to Resolve ORA-01000: maximum open cursors exceeded

by Ed Chen
January 15, 2020January 17, 2020

ORA-01000 Saw an error ORA-01000: maximum open cursors exceeded when executing a lot of statements. It seemed that the number of open cursors has reached… Read More »