We are unable to restore Oracle DB to another server.
Oracle Version 188.8.131.52.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 "
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))
(SID = COMMS)
The server itself can telnet to port 1521, so network conenction is not an issue.
did i miss something ?
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:
(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
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:rocessMessage: 10> RESTORE CONTROLFILE FROM 'BE_c-3793180428-20190322-00';
CDbsbOra:rocessMessage: 13> alter database mount;
CDbsbOra:rocessMessage: 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: