Skip to Main Content

Database Software

ORA-12154: TNS:could not resolve the connect identifier specified

808686Mar 11 2012 — edited Aug 8 2012
Hi Experts,

I am trying to create a standby database using RMAN duplicate "active database" feature on 11.2 database and OS OEL 5.5
I am facing the below error while duplicating.
[oracle@uat ~]$ rman target sys/oracle@prim auxiliary sys/oracle@stby

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Mar 11 18:22:38 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: prim (DBID=192228048)
connected to auxiliary database: prim (not mounted)

RMAN> duplicate target database for standby from active database nofilenamecheck;

Starting Duplicate Db at 11-MAR-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=26 device type=DISK

contents of Memory Script:
{
backup as copy reuse
targetfile  '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwprim' auxiliary format 
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwstby'   ;
}
executing Memory Script

Starting backup at 11-MAR-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=46 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/11/2012 18:26:26
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/11/2012 18:26:26
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server

RMAN> 
I am able to tnsping successfully both the entries prim and stby from both the servers, also I am able to connect to the databases using the connection strings from each other server (primary database from standby server and standby database from primary server). Also, through RMAN I was able to connect to the primary database (target database) and auxilary database (standby database) but during the duplication process, it fails with the error ORA-12154: TNS:could not resolve the connect identifier specified

I have the below tns entries in the tnsnames.ora file on both primary and standby server. Please help me out.
STBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.132)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stby) (UR=A)
)
)

PRIM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prim)
)
)
This post has been answered by Shivananda Rao on Mar 12 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2012
Added on Mar 11 2012
47 comments
20,244 views