RAC

How to Resolve PRCT-1562 : The startup of instances for database are still in progress

by Ed Chen
October 31, 2022November 2, 2022

PRCT-1562 or PRCT-01562 Saw an error PRCT-1562 or PRCT-01562 when I tried to start a RAC database. [oracle@primary01 ~]$ srvctl start database -d orclcdb -o… Read More »

How to Resolve CRS-2501: Resource is disabled

by Ed Chen
August 10, 2022October 6, 2022

CRS-2501 CRS-2501 means that the resource you want to manipulate is in the disabled mode, you should make sure its status before enabling it. Let's… Read More »

How to Resolve PRCD-1066 : Invalid start option

by Ed Chen
June 27, 2022October 20, 2022

PRCD-1066 Tried to startup a RAC database with a start option by SRVCTL, or modify the default start option of a RAC database by SRVCTL,… Read More »

How to Resolve PRKO-2002 : Invalid command line option

by Ed Chen
June 24, 2022June 27, 2022

PRKO-2002 There could be many cases that throw PRKO-2002, this is only a case when we tried to open the database to READ ONLY. [oracle@primary01… Read More »

How to Resolve CRS-5702: Resource is already running on 'primary01'

by Ed Chen
February 21, 2022January 11, 2022

CRS-5702 Tried to startup a database in a cluster, we got CRS-5702. [oracle@primary01 ~]$ srvctl start database -d orclcdb PRCC-1014 : ORCLCDB was already running… Read More »

How to Resolve PRKO-3032 : Invalid instance name(s)

by Ed Chen
January 31, 2022November 11, 2022

PRKO-3032 or PRKO-03032 Tried to start one instance of a RAC database by SRVCTL utility, but it failed with PRKO-3032. [oracle@primary01 oracle]$ srvctl start instance… Read More »

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, 2021October 20, 2022
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-09925: Unable to create audit trail file

by Ed Chen
August 20, 2021June 11, 2022

ORA-09925 There're two error scenarios of ORA-09925 in this post: Single-instance Databases RAC Databases Let's see some cases. A. Single-instance Databases Tried to startup a… Read More »

How to Resolve ORA-29283: invalid file operation

by Ed Chen
July 14, 2021June 4, 2022

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 »