How to Resolve PRCD-1066 : Invalid start option
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 PRCD-1066 : Invalid start option
RAC
How to Resolve PRKO-2002 : Invalid command line option
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 PRKO-2002 : Invalid command line option
How to Resolve CRS-5702: Resource is already running on 'primary01'
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 CRS-5702: Resource is already running on 'primary01'
How to Resolve PRKO-3032 : Invalid instance name(s)
PRKO-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 stopped
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 PRCC-1016 : ORCLCDB was already stopped
How to Resolve ORA-00600: internal error code, arguments: [kclcls_2]
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-00600: internal error code, arguments: [kclcls_2]
How to Resolve ORA-09925: Unable to create audit trail file
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-09925: Unable to create audit trail file
How to Resolve ORA-29283: invalid file operation
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 ORA-29283: invalid file operation
How to Resolve PRCD-1120 : The resource for database could not be found.
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 »How to Resolve PRCD-1120 : The resource for database could not be found.
PDB Local Undo for Each RAC Instance
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 »PDB Local Undo for Each RAC Instance