How to Resolve PRCD-1066 : Invalid start optionby Ed ChenJune 27, 2022June 29, 2022PRCD-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 PRCD-1066 : Invalid start option
How to Resolve PRKO-2002 : Invalid command line optionby Ed ChenJune 24, 2022June 27, 2022PRKO-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 PRKO-2002 : Invalid command line option
How to Resolve CRS-5702: Resource is already running on 'primary01'by Ed ChenFebruary 21, 2022January 11, 2022CRS-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 CRS-5702: Resource is already running on 'primary01'
How to Resolve PRKO-3032 : Invalid instance name(s)by Ed ChenJanuary 31, 2022March 30, 2022PRKO-3032 Tried to start one instance of a RAC database by SRVCTL utility, but it failed with PRKO-3032. [oracle@primary01 oracle]$ srvctl start instance -d orclcdb… Read More »How to Resolve PRKO-3032 : Invalid instance name(s)
How to Resolve PRCC-1016 : ORCLCDB was already stoppedby Ed ChenJanuary 14, 2022November 19, 2021PRCC-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 PRCC-1016 : ORCLCDB was already stopped
How to Resolve ORA-00600: internal error code, arguments: [kclcls_2]by Ed ChenNovember 8, 2021May 14, 20222 CommentsORA-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-00600: internal error code, arguments: [kclcls_2]
How to Resolve ORA-09925: Unable to create audit trail fileby Ed ChenAugust 20, 2021June 11, 2022ORA-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-09925: Unable to create audit trail file
How to Resolve ORA-29283: invalid file operationby Ed ChenJuly 14, 2021June 4, 2022ORA-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 ORA-29283: invalid file operation
How to Resolve PRCD-1120 : The resource for database could not be found.by Ed ChenJuly 10, 2021June 4, 20222 CommentsPRCD-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 »How to Resolve PRCD-1120 : The resource for database could not be found.
PDB Local Undo for Each RAC Instanceby Ed ChenJune 16, 2021November 9, 2021Usually, 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 »PDB Local Undo for Each RAC Instance