Highlighted

Failed Oracle Restore ORA-27191 ORA-12154


Hello,

We are unable to restore Oracle DB to another server.

Oracle Version 11.2.0.2.0

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 "

tnsnames.ora:

COMMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))
)
(CONNECT_DATA =
(SID = COMMS)
)
)

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

did i miss something ?

 

Thanks,

MR

 

2 Replies

Re: Failed Oracle Restore ORA-27191 ORA-12154

@achel91 

I see this error in the log file: 0xE0000340

Please have a look at this TN and see if it helps: https://www.veritas.com/support/en_US/article.100024618.html

Please also have a look at this TN for redirected restore: 
https://www.veritas.com/support/en_US/article.100018450.html

(The link for Oracle user access no longer exists - please see this URL: https://www.veritas.com/support/en_US/article.100001916.html#Oracle_Agent) 

Another related TN: https://www.veritas.com/content/support/en_US/article.100019620.html

 

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:
https://www.veritas.com/content/support/en_US/article.100019620.html