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
PRVG-2002 Saw error PRVG-2002 when verifying the cluster environment before installing grid infrastructure 19c on Linux 8.2. [grid@primary01 ~]$ cd $ORACLE_HOME [grid@primary01 grid]$ ./runcluvfy.sh stage… Read More »How to Resolve PRVG-2002 : Encountered error in copying file
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
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.
ORA-12528 Tried to connect a NOMOUNT database, but it failed with ORA-12528. C:\Users\ed>sqlplus sys/password@orcl as sysdba ... ERROR: ORA-12528: TNS:listener: all appropriate instances are blocking… Read More »How to Resolve ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »How to Resolve ORA-01109: database not open
ORA-12505 ORA-12505 means that the SID you provided in the connect identifier does not match any SID registered with the listener. Basically, SID means $ORACLE_SID,… Read More »How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
PRCR-1025 Tried to remove a database service from the cluster, but it failed with PRCR-1025. [oracle@primary01 ~]$ srvctl remove service -d orclcdb -s crm PRCR-1025… Read More »How to Resolve PRCR-1025 : Resource is still running