In NetBackup you could do that by setting multiple retention per media. So that 1 tape cartridge could be shared by several backup policy. I believe you can do the something on Backup Exec.
Have you check your user and password for those TNSname ?Have you specified correct user, password, and TNSname string in your Oracle backup script or template?BBelang