RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of servic
I was running an RMAN duplicate command for a backup-based duplication to the database PROVSTDB. It had just shutdown the server when the error occurred. Here is the specific command:
DUPLICATE DATABASE TO 'Provstdb'
BACKUP LOCATION '\DB_BACKUP'
NOFILENAMECHECK
SPFILE
PARAMETER_VALUE_CONVERT 'G:\oracle\oradata\provstdb\CONTROL01.CTL', 'E:\Oracle\oradata\ProvSTDB\CONTROL01.CTL'
SET DB_CREATE_FILE_DEST 'E:\Oracle\oradata\ProvSTDB\';
Here also is the tnsnames.ora:
GIHUB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HSCSPROV2T.hscs.virginia.edu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ProvSTDB.hscs.virginia.edu)
)
)
PROVSTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HSCSPROV2T.hscs.virginia.edu)(PORT = 1521))