ORA-12514: TNS:listener could not resolve SERVICE_NAME
DBA2011Nov 5 2009 — edited Nov 5 2009trying to duplicate db on remote server, getting message, just wondering how i can make it work wcmp is on remote server, if i add this in listener.ora it says no db of this name running
oracle:tulpcorpadb03$ rman TARGET sys/******@wcmp AUXILIARY /
Recovery Manager: Release 9.2.0.8.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. 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 could not resolve SERVICE_NAME given in connect descriptor
oracle:tulpcorpadb03$ tnsping wcmp
TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 05-NOV-2009 11:21:44
Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = PWR_DB01-HA)(PORT = 1522)
)) (CONNECT_DATA = (SERVICE_NAME = wcmp)))
OK (10 msec)
oracle:tulpcorpadb03$ sqlplus 'sys/******@wcmp as sysdba;
>
oracle:tulpcorpadb03$ sqlplus 'sys/******@wcmp as sysdba';
SQL*Plus: Release 9.2.0.8.0 - Production on Thu Nov 5 11:23:06 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor