offline backup scheduled failed

[Former Member]

Hi friends,

In server1 in that two instances are running:

instance name :1. spbadm (online and offline backup)

: 2.spxadm (online and offline backup)

The schedules are calling using "spbadm" user, in that all schedules are running successfully.

only "spxadm-offline-sunday sche-backup" - (offline backup) schedule failed , below i have attached the TSM log reports for reference.

""""""

BR0055I Start of database backup: bdyoerwt.aff 2008-08-10 16.00.03

BR0280I BRBACKUP time stamp: 2008-08-10 16.00.03

BR0301E SQL error -12557 at location BrDbConnect-2

ORA-12557: TNS:protocol adapter not loadable

BR0310E Connect to database instance SPX failed

BR0280I BRBACKUP time stamp: 2008-08-10 16.00.03

BR0301E SQL error -12557 at location BrDbConnect-2

ORA-12557: TNS:protocol adapter not loadable

BR0310E Connect to database instance SPX failed

BR0056I End of database backup: bdyoerwt.aff 2008-08-10 16.00.03

BR0280I BRBACKUP time stamp: 2008-08-10 16.00.03

BR0054I BRBACKUP terminated with errors

"""""""""""

Could you plz help me to fix the issue.

With regards

Kyle.....

[Former Member]

Hi Solai,

Let me know what is your R3trans -d says in the system spxadm,and also the database release you are working on.

Thanks,

Satyabrat

[JPReyes]

This could be cause for a lot of different reasons...

The first one that cross my mind is enviromental variables, so check your variables and make sure you can do a tnsping, the second one could be missing libraries, also check your tns settings.

regards

Juan