cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Agent Error

Jorgen_Persson
Level 4
Hi

So I have a strange error that started to happen to my Oracle backup. The jobs are failing with following error.

Backup- Oracle-Win::\\acumed-appsvr1.acumed.local\VMFG
The Database script returned an error. Refer to the Database script output section in job logs for more details.

The applicable Rman error shows

Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. # ----------------------------------------------------------------- # RMAN command section # ----------------------------------------------------------------- RUN { ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE'; SEND 'BSA_SERVICE_HOST=192.168.42.20,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={6E4DBC22-9057-4FEB-8276-AC6BAF6D19FD},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\acumed-appsvr1.acumed.local\VMFG'; BACKUP INCREMENTAL LEVEL=0 FORMAT 'BE_U' DATABASE FORCE PLUS ARCHIVELOG FORCE; BACKUP CURRENT CONTROLFILE FORMAT 'BE_U'; RELEASE CHANNEL ch0; } RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-12154: TNS:could not resolve service name Recovery Manager complete.

I tried to reinstall the agent but no luck. Any ideas would be much appreciatedMessage was edited by:
Jorgen Persson
2 REPLIES 2

Jorgen_Persson
Level 4
deletedMessage was edited by:
Jorgen Persson

Sandy_Sandifer
Level 6
Hi Jergen,

Please try the following suggestions and let us know if this helps resolve the issue. it seems like there is just an issue with the TNS alias connection:
1. http://www.cryer.co.uk/brian/oracle/ORA12154.htm
2. http://www.is.mcgill.ca/minerva/Help/ora12154.htm
3. http://www.mydatabasesupport.com/oracle-faq/oracle-errors/ora-12154-tns-could-not-resolve-service-name.html

Thanks.