We're here to help!

Error Code:2044 File <XXX> sqlplus does not exist or is empty. Please check space and file permissions

Follow

 This issue is encountered occasionally when applying archive log, a timeout occurs and fails with an error.


Problem Details

Problem Statement

Log apply on standby fails with an error message and error code

Applicable Error Code

Error Code: 2044 
File (/usr/dbvisit/standby/tmp/33593.dbvisit.201904160305.sqlplus.dbv) does not exist
or is empty. Please check space and file permissions.

Affected Versions

v8 and v9

Affected Platforms

All

 

Description

When the standby database is being recovered by applying the archivelogs, there is basically set a hard limit for how long the apply of one archivelog can take. The default value is 125 seconds. This error occurs when the archive log apply takes longer than the default timeout value. 

Solution

Option 1: Increase the timeout for apply archive log by adding the following parameter to DDC file in the primary 

WAIT_FOR_FILE_SEC=250
Run the command from primary to copy the updated file to standby
./dbvctl -d <DDC> -c
Restart the daemon process for changes to take into effect
 
Option 2: Switch to RMAN for applying archived logs instead of sqlplus and thus there will be no need waiting for the sqlplus file. This can be done by changing the below parameter in the DDC file from N to Y
APPLY_ARCHIVE_RMAN=Y
Run the command from primary to copy the updated DDC to standby
./dbvctl -d <DDC> -c
Restart the daemon process for changes to take into effect
Have more questions? Submit a request

Comments