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:
Beremote shows:
[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

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.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)