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 

6 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