Sunday 28 July 2013

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

RMAN DUPLICATE FAILED WITH BELOW ERROR
=====================================

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 16 02:57:58 2013

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

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12154: TNS:could not resolve the connect identifier specified

RMAN>
connected to recovery catalog database
RMAN>
connected to auxiliary database (not started)

Note: Comment ebstest_LOCAL paramater in tnsnames.ora file and try it again.

Solution:

oratest@ctsst $ diff tnsnames.ora tnsnames.ora_bkp
24c24
< #ebstest_LOCAL =
---
> ebstest_LOCAL =
46,57d45
< ebsoltp =
< (DESCRIPTION=
< (ADDRESS=(PROTOCOL=tcp)(HOST=ebsoltp.user.com)(PORT=1535))
< (CONNECT_DATA=
< (SID=ebsoltp)
< )
< )
< catalog=
< (DESCRIPTION =
< (ADDRESS_LIST =
< (ADDRESS = (COMMUNITY = TCP) (PROTOCOL=TCP) (Host =catalog.user.com) (Port = 1525)))
< (CONNECT_DATA = (SID = catalog)))
59d46
<
oratest@ctsst $



oratest@ctsst $ rman

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 16 03:03:57 2013

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

RMAN> connect target sys/tim3Pa55@ebsoltp

connected to target database: EBSOLTP (DBID=2581404741)

RMAN> connect catalog catalog/catalog007@catalog

connected to recovery catalog database

RMAN> connect auxiliary /

connected to auxiliary database: EBSTEST (not mounted)


After doing above steps issue got resolved.Happy learning !!!!!!!!!!!!!!!

3 comments:

  1. Great and useful blog. Creating content regularly is very tough. Your points are motivated me to move on. That is a really neatly written article.
    Oracle Fusion HCM Technical Online Training

    ReplyDelete
  2. Hi,
    This is very useful article.Thanks for sharing such a nice article.
    oracle fusion SCM online training



    ReplyDelete
  3. Very efficiently written information. It will be beneficial to anybody who utilizes it, including me. Keep up the good work. For sure i will check out more posts. This site seems to get a good amount of visitors. Legal Entity Identifier Number

    ReplyDelete