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.



Recovery Manager: Release - 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


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 


Sridevi Koduru said...

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.


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