Oracle backups fail with an error "0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details."

book

Article ID: 100019472

calendar_today

Updated On:

Description

Error Message

RMAN output in the job log shows the following error

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 10/01/2008 12:13:48
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
Recovery Manager complete.

Beremote debugs will show the following:


[90228] @@@@@@@MyCloseSocket called with sockfd = 740(0x2e4) retval = 0
[90228] BETCPConnection::CreateConnectionFromHostAndPort: Remote Host: "172.16.2.84": There were no addresses returned, belonging to family: IPv6
[90228] BETCPConnection::CreateConnectionFromHostAndPort: Could not create a connection to "172.16.2.84" because attempts with both IPv4 and IPv6 protocols failed
[90228] Could not create a BETCPConnection object from address: 172.16.2.84 error=An error occurred during a socket connect operation: Error Code: 10061, System Error Message: A connection has not been established because the system has actively refuse the connection.
[90228] NrdsAdvertiserThread: connect to target=172.16.2.84 port=6101 failed

Resolution

Verify if the name of the Oracle instance has a case mismatch in the oratab file (/etc/oratab) and the tnsnames.ora file. If there is a case mismatch, follow the steps below; 

1.  Change the instance name in the oratab file to match the case found in the tnsnames file.
2.  Restart the Remote for Linux Agent.
3.  Run the backup job.
 

Note: Ensure the Oracle SID name is specified in upper case letter rather than lower case letter.
 

 

Applies To

Oracle installed on Linux.

Issue/Introduction

When backing up the Oracle database the backup fail with an error "0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details."