ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
报错信息:
[oracle@rac1 admin]$ rman target sys/oracle@orcldg
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Mar 1 15:19:53 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
场景:
通过rman使单实例数据库迁移到rac,执行命令rman target sys/oracle@orcldg时报错(11.2.0.3.0版本)。
解决:
因使用tnsping orcldg是通的,但是rman target sys/oracle@orcldg报错,最后发现tnsnames.ora文件里的SERVICE_NAME = orcl是这样的值,改为SERVICE_NAME = orcldg即可解决;
原本以为是监听出了错,一直在RAC的静态监听纠结了好久,后来不经意间发现是在tnsnames.ora这个文件。