RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified

Oracle crontab job failed, But if run command line scripts working fine.

Executing Command : BACKUP AS COMPRESSED BACKUPSET

::::::::::::::
./src.log
::::::::::::::

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Feb 2 08:00:01 2015

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

connected to target database: PROD (DBID=2595689245)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified


Soluttion:

Add this TNS_ADMIN path in the "environment scripts" file. Then Try.

export TNS_ADMIN=/a02/oracle/PROD/db/11.2.0/network/admin/PROD1_server
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:/usr/bin:/bin:$TNS_ADMIN 

13 comments:

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Praveen Kumar said...

Valuable information thanks for sharing Oracle APPS DBA Online Training

Pega Online Training said...


Ya that's great to have blog like this it may clear the many thought from this
Pega Training

RAVI said...

Thanks for sharing this blog of real estate company Bangalore.

QATAR CLASSIFIEDS said...

I think this is old article i have doubt this is oracle real estate software Visit
or another if you can

Gifts n Cake said...

I think that's a brilliant idea _ Gifts and cakes with expensive quality

abdhul ece89 said...
This comment has been removed by the author.
abdhul ece89 said...

Very useful and informative article.. thanks for sharing your views and ideas about Oracle... i am also interesting to work in oracle apps development , can you suggest me some good Oracle Training in Chennai tutorials...

Mani Shanti Infracity Pvt Ltd said...

Nice post. For more have a look at Real Estate Property Management Services by best Real Estate Company in Gorakhpur. They have extended their services in Gorakhpur.

tapresume said...

Very good post but i guess system parameter is not aligned correctly. Also if you are looking for oracle jobs check https://www.tapresume.com/IN/searchjobs/oracle--jobs

Nicholas de said...

Nice blog has been shared by you. before i read this blog i didn't have any knowledge about this but now i got some knowledge so keep on sharing such kind of an interesting blogs.


Weblogic Server 12cR2 Training

Peter Johnson said...

I Just Love to read Your Articles Because they are very easy to understand.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Restaurant Equipment Parts Through Out US At Very Affordable Prices And Also We Offer Same Day Shipping In US.We Offer Only Genuine Products.Thanks For Posting.HAve a Nice Day!

Lathika Honey said...

This Blog Provides Very Useful and Important Information Digital Transformation Consulting Thanks for sharing.