level 9
云淡风清198974
楼主
[RMAN报错]RMAN-04006:检查tnsname.ora文件格式
环境:
oraclce database 11.2.0.4
源端为两个节点组成的集群,目标端为另一集群的主节点,并已关闭该集群次节点的实例。
使用sys用户rman传输报错:
$ rman target sys/oracle@aalias auxiliary sys/oracle@Balias
connected to target database: XKDMS (DBID=926903478)RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00554: initialization of internal recovery manager package failedRMAN-04006: error from auxiliary database: ORA-12154: TNS:could not resolve the connect identifier specified
经过排查,发现是源端的tnsnames.ora文件中,少些了一个')'符号,填补后重新执行rman命令,传输成功。
2025年05月06日 09点05分
1
环境:
oraclce database 11.2.0.4
源端为两个节点组成的集群,目标端为另一集群的主节点,并已关闭该集群次节点的实例。
使用sys用户rman传输报错:
$ rman target sys/oracle@aalias auxiliary sys/oracle@Balias
connected to target database: XKDMS (DBID=926903478)RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00554: initialization of internal recovery manager package failedRMAN-04006: error from auxiliary database: ORA-12154: TNS:could not resolve the connect identifier specified
经过排查,发现是源端的tnsnames.ora文件中,少些了一个')'符号,填补后重新执行rman命令,传输成功。