Showing results for 
Search instead for 
Did you mean: 

Failed Oracle Restore ORA-27191 ORA-12154


We are unable to restore Oracle DB to another server.

Oracle Version

attached file is the detail of error messages.

TNS names has been defined in ORACLE_HOME\NETWORK\ADMIN, but at the end of the file it says " ORA-12154 "


(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))

The server itself can telnet to port 1521, so network conenction is not an issue.

did i miss something ?





2 Replies

Re: Failed Oracle Restore ORA-27191 ORA-12154


I see this error in the log file: 0xE0000340

Please have a look at this TN and see if it helps:

Please also have a look at this TN for redirected restore:

(The link for Oracle user access no longer exists - please see this URL: 

Another related TN:



Re: Failed Oracle Restore ORA-27191 ORA-12154

For the benefit of everyone;  here are some infos which are based from the attached log file (the latest restore attempt)

In this part everything is going correctly:
  CDbsbOra:Smiley TonguerocessMessage: 10> RESTORE CONTROLFILE FROM 'BE_c-3793180428-20190322-00'; 
  CDbsbOra:Smiley TonguerocessMessage: 13> alter database mount;
  CDbsbOra:Smiley TonguerocessMessage: Starting restore at 25-MAR-19

Then we get the RMAN error itself:
   RMAN-03002: failure of restore command at 03/25/2019 10:51:35
   ORA-27191: sbtinfo2 returned error

and then BE logs this error message telling us RMAN reported back an error:
   CDbsbOra::runRmanCmd: Error occured while trying to execute RMAN
   OCI_ERROR: ORA-12154: TNS:could not resolve the connect identifier specified


This points more to a general agent configuration issue on the new Oracle server
Have a look at: