RAC

How to Resolve PRCC-1016 : ORCLCDB was already stopped

by Ed Chen
January 14, 2022November 19, 2021

PRCC-1016 Found an error PRCC-1016 when I tried to stop a RAC database. By the way, it's a Container Database (CDB). [oracle@primary01 ~]$ srvctl stop… Read More »

How to Resolve ORA-00600: internal error code, arguments: [kclcls_2]

by Ed Chen
November 8, 2021November 10, 2021
2 Comments

ORA-00600 kclcls_2 A developer reported an Oracle famous error ORA-00600 like the following: java.sql.SQLException: ORA-00600: internal error code, arguments: [kclcls_2], [45], [285680] ORA-00600 is an… Read More »

How to Resolve ORA-17629: Cannot connect to the remote database server

by Ed Chen
September 1, 2021October 20, 2021

ORA-17629 ORA-17627 ORA-12514 When we tried to clone a remote PDB via a DB link, we got ORA-17629 ORA-17627 and ORA-12514 in error stack like… Read More »

How to Resolve ORA-09925: Unable to create audit trail file

by Ed Chen
August 20, 2021October 29, 2021

ORA-09925 There're two error scenarios of ORA-09925 in this post, one is for single-instance databases, the other is for RAC databases. Single-instance Databases Tried to… Read More »

How to Resolve ORA-29283: invalid file operation

by Ed Chen
July 14, 2021October 24, 2021

ORA-29283 Someone tried to use UTL_FILE.FOPEN in a stored procedure to operate a file, but it sometimes failed with ORA-29283. ORA-29283: invalid file operation: nonexistent… Read More »

How to Resolve PRCD-1120 : The resource for database could not be found.

by Ed Chen
July 10, 2021August 2, 2021

PRCD-1120 PRCD-1120 means that the database you want to operate with is not found in the cluster. Mostly, you misspelled the resource name of database.… Read More »

PDB Local Undo for Each RAC Instance

by Ed Chen
June 16, 2021November 9, 2021

Usually, we have separate undo tablespace for each instance in a RAC database. For example, UNDOTBS1 is for the first instance and UNDOTBS2 is for… Read More »

How to Resolve ORA-01109: database not open

by Ed Chen
June 5, 2021January 21, 2022

ORA-01109 ORA-01109 is pretty normal when your database is idle, stop or close. Mostly it's previously shutdown manually by someone, or the database shutdown itself… Read More »

How to Change Both DB_NAME and DB_UNIQUE_NAME of a RAC Database

by Ed Chen
February 6, 2021January 11, 2021

We plan to do the following items in order to change both DB_NAME and DB_UNIQUE_NAME of a RAC database. Database Level: Change DB_NAME of a… Read More »

How to Change DB_UNIQUE_NAME of a RAC Database

by Ed Chen
February 3, 2021October 3, 2021

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