Check if Directory Exists by Shell Script
Test Command In some situations, we may need to detect the existence of a directory in shell or scripts. If so, there's a quick way… Read More »Check if Directory Exists by Shell Script
No such file or directory
How to Resolve ORA-27040: file create error, unable to create file
ORA-27040 Tried to add a data file to a tablespace, but it failed with ORA-01119 and ORA-27040. SQL> ALTER TABLESPACE EXAMPLE ADD DATAFILE '/u01/app/oracle/oradata/ORCLCDB/ORCLPDBX/example02.dbf' SIZE… Read More »How to Resolve ORA-27040: file create error, unable to create file
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-00308: cannot open archived log
ORA-00308 Found ORA-00308: cannot open archived log during performing a database point-in-time recovery (DBPITR) by RMAN. ORA-00308: cannot open archived log '/oradata/ORCL/ARCH/ORCL_1_294150.arc' ORA-27037: unable to… Read More »How to Resolve ORA-00308: cannot open archived log
How to Resolve ORA-01565: error in identifying file
In this post, I'll describe two error patterns for ORA-01565. Missing SPFILE Multitenant DB A. ORA-01565 for Missing SPFILE To create a plain-text parameter file,… Read More »How to Resolve ORA-01565: error in identifying file
How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
error while loading shared libraries After installing Oracle 10g RAC, we checked the configuration of the cluster database like this: [oracle@primary01 ~]$ srvctl config database… Read More »How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
What Makes Instance Shutdown Itself
What makes a running instance shutdown itself could be a very complicated topic to talk about, because we have to know what instance was thinking.… Read More »What Makes Instance Shutdown Itself
How to Resolve ORA-16571: Oracle Data Guard configuration file creation failure
ORA-16571 ORA-16571 means that DGMGRL tried to create or save broker files on the destination you designed, but somehow it failed in DGMGRL command line… Read More »How to Resolve ORA-16571: Oracle Data Guard configuration file creation failure
How to Resolve RMAN-06059: expected archived log not found
RMAN-06059 RMAN-06059 means that the archived logs you expect to use are missing from where they should be. In my case, when I tried to… Read More »How to Resolve RMAN-06059: expected archived log not found
How to Resolve ORA-00304: requested INSTANCE_NUMBER is busy
Srvctl Start Database ORA-00304 Saw some errors when I tried to startup a cluster database by srvctl. [oracle@primary01 ~]$ srvctl start database -d compdb PRCR-1079… Read More »How to Resolve ORA-00304: requested INSTANCE_NUMBER is busy