Redirect Restore of Oracle 21c database fails with an error " 0xe0000340 - The Database script returned an error"

book

Article ID: 100055158

calendar_today

Updated On:

Description

Error Message

 0xe0000340 - The Database script returned an error.

Cause

This issue is caused due to changes in the path for the TNSNAMES.ORA file in Oracle 21c

Resolution

To resolve this issue, the TNSNAMES.ORA path needs to be defined explicitly in the environment variables on the Oracle Server.

Set the following environment variables in the Oracle user profile. Below are the default paths for a Oracle21c setup.

ORACLE_HOME=C:\app\sysde\product\21c\dbhomeXE\

TNS_ADMIN=C:\app\sysde\product\21c\dbhomeXE\network\admin

 

Issue/Introduction

Redirect Restore of Oracle 21c database fails with an error " 0xe0000340 - The Database script returned an error."
Powered by Wolken Software