RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not

[MAJED_SHARIF]

We are facing problem on our client Ibrahim Fiber Limited.
Currently our client is running
1)NetBackup Master Server/Media Server 6.0MP1 (Windows Server 2003 Standard)
2)NetBackup client 6.0MP1 on RedHat Linux 3.0
3)NetBackup Oracle Agent MP1 for Linux
When we try to start backup of Oracle Agent we get following error message

INF - Begin progress logging for process: (6713)
INF - Starting Oracle Recovery Manager.
INF - Using: /home/oracle/opt/d01/oracle/proddb/9.2.0/bin/rman
INF - Connection info: target / rcvcat 'rman/*****@testcat1'
INF - Start of Recovery Manager input.
INF - # -----------------------------------------------------------------
INF - # RMAN command section
INF - # -----------------------------------------------------------------
INF - RUN {
INF - # Backup Archived Logs
INF - sql 'alter system archive log current';
INF - ALLOCATE CHANNEL ch00
INF - TYPE 'SBT_TAPE';
INF - BACKUP
INF - FORMAT 'arch-s%s-p%p-t%t'
INF - ARCHIVELOG
INF - ALL;
INF - RELEASE CHANNEL ch00;
INF - # Control file backup
INF - ALLOCATE CHANNEL ch00
INF - TYPE 'SBT_TAPE';
INF - SEND 'NB_ORA_CLIENT=testdbs.ifl.net,NB_ORA_SERV=hobkupsrv,NB_ORA_POLICY=oratestfull';
INF - BACKUP
INF - FORMAT 'arch-s%s-p%p-t%t'
INF - CURRENT CONTROLFILE;
INF - RELEASE CHANNEL ch00;
INF - }
INF - End of Recovery Manager input.
INF - Start of Recovery Manager output.
INF - Recovery Manager: Release 9.2.0.6.0 - Production
INF - connected to target database: PROD (DBID=4224663781)
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: =========================================================
INF - RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve service name
INF - Recovery Manager complete.
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager.

We created Oracle Backup Template with the option of Oracle Recovery Catalog which is available in Oracle Backup
Template wizard Without that option we are able to backup oracle database.
Kindly assist us to resolve the issue. Your early response is highly appreciated.

[Andreas_Almroth]

Hi,

This has very little to do with NetBackup, as it is a an Oracle problem.

From the client where you have your Oracle database which is being backed up, can you tnsping testcat1? Can you connect with sqplus rman/@testcat1?

Most likely you can't connect. You will have to create a working entry on the client for the TNS name, so that you can connect with rman or sqplus. Once that is done, you have a better chance...

If you have never connected from the client, have you registered your database in the recovery catalog?

Regards,
Andreas

[MAJED_SHARIF]

Yes i have tested all these things all things are fine on oracle side. i can connect to rman from sqlplus. i belive this is some where else in NetBackup side. My Oracle testing are checked by Oracle experts by Oracle Support. they are saying that the oracle is working fine and might be NetBackup is unable to set the required environment.

[Ilya_Voronin]

Please show entire backup script without comments (grep -v ^# backup.sh).

[Andreas_Almroth]

Please show us all the scripts involved. Do you execute the RMAN script as the Oracle user? That is, do you use su - oracle -c ... call somewhere in the script chain? If not, your environment is obviously not set up, and running Oracle backups as root doesn't really work well.

If you have based your script on the sample script provided with NetBackup you will find it calls su -

Regards,
Andreas