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."

Article:TECH64936  |  Created: 2009-01-13  |  Updated: 2012-01-26  |  Article URL http://www.symantec.com/docs/TECH64936
Article Type
Technical Solution


Environment

Issue



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



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

Environment



Oracle installed on Linux.


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.
 


Supplemental Materials

SourceError Code
Value0xe0000340
Description

The Database script returned an error. Refer to the Database script output section in job logs for more details.



Legacy ID



314003


Article URL http://www.symantec.com/docs/TECH64936


Terms of use for this information are found in Legal Notices