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

Problem

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

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] 10/16/08 14:10:02 @@@@@@@MyCloseSocket called with sockfd = 740(0x2e4) retval = 0
[90228] 10/16/08 14:10:02 BETCPConnection::CreateConnectionFromHostAndPort: Remote Host: "172.16.2.84": There were no addresses returned, belonging to family: IPv6
[90228] 10/16/08 14:10:02 BETCPConnection::CreateConnectionFromHostAndPort: Could not create a connection to "172.16.2.84" because attempts with both IPv4 and IPv6 protocols failed
[90228] 10/16/08 14:10:02 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] 10/16/08 14:10:02 NrdsAdvertiserThread: connect to target=172.16.2.84 port=6101 failed

Solution

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.