How to Resolve ORA-17629 Oracle Error Message
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-17629 Oracle Error Message
RAC
How to Resolve ORA-09925 Oracle Error Message
ORA-09925: Unable to create audit trail file There're two error scenarios of ORA-09925 in this post, one is for single-instance databases, the other is for… Read More »How to Resolve ORA-09925 Oracle Error Message
How to Resolve ORA-29283 Oracle Error Message
ORA-29283: invalid file operation: nonexistent file or path [29434] Someone tried to use UTL_FILE.FOPEN in a stored procedure to operate a file, but it sometimes… Read More »How to Resolve ORA-29283 Oracle Error Message
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.
Local Undo of PDB 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 »Local Undo of PDB for Each RAC Instance
How to Resolve ORA-01109: database not open
ORA-01109 ORA-01109 is pretty normal when your database is close, mostly it's previously shutdown manually by someone, or the database shutdown itself by accident, you… Read More »How to Resolve ORA-01109: database not open
How to Change Both DB_NAME and DB_UNIQUE_NAME of a RAC Database
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 Both DB_NAME and DB_UNIQUE_NAME of a RAC Database
How to Change DB_UNIQUE_NAME of a RAC Database
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 »How to Change DB_UNIQUE_NAME of a RAC Database
How to Change DB_NAME of a RAC Database
In previous post, we have talked about how to change DBID of a RAC database. In this post, we will talk about how to change… Read More »How to Change DB_NAME of a RAC Database
How to Change DBID of a RAC Database
In previous post, we have talked about how to change both DB_NAME and DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about… Read More »How to Change DBID of a RAC Database