No such file or directory

How to Resolve ORA-31640: unable to open dump file

by Ed Chen
July 25, 2023July 26, 2023

ORA-31640 Tried to import data into the database from a dump file, but it failed with ORA-31640. Linux [oracle@test ~]$ impdp system/password@orcl full=yes directory=BACKUP2 dumpfile=full.dmp… Read More »

Check if Directory Exists by Shell Script

by Ed Chen
December 14, 2022March 12, 2023

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 »

How to Resolve ORA-27040: file create error, unable to create file

by Ed Chen
May 18, 2022June 26, 2023

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-09925: Unable to create audit trail file

by Ed Chen
August 20, 2021June 12, 2023

ORA-09925 There're two error scenarios of ORA-09925 in this post: Single-instance Databases RAC Databases Let's see some cases. Single-instance Databases Tried to startup a test… Read More »

How to Resolve ORA-00308: cannot open archived log

by Ed Chen
August 13, 2021June 26, 2023

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-01565: error in identifying file

by Ed Chen
January 9, 2021December 9, 2022

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 SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

by Ed Chen
February 8, 2020August 10, 2021

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 »

What Makes Instance Shutdown Itself

by Ed Chen
November 6, 2019November 22, 2022

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 »

How to Resolve ORA-16571: Oracle Data Guard configuration file creation failure

by Ed Chen
August 9, 2019December 10, 2022

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 RMAN-06059: expected archived log not found

by Ed Chen
July 11, 2019December 10, 2022

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 »

JavaScript is not enabled. Please enable it and reload the page.