"Unable to validate Oracle database credentials error"
Environment: Backup Exec 11d Media server running on W2003 R2 SP2
Remote oracle server running on W2003 SP2 running 4 databases (one on oracle 10, 3 on oracle 9)
Note: complete Oracle newbie.
I'm trying to setup the remote backup agent. I start the BE Remote Agent Utility then select the Oracle tab and click the New button. I select one of the Oracle 9 dbs in the Local instance name drop down field and then fill in the name and password of an oracle user with the appropriate rights to backup\restore the db. I add the name of the media server in the job settings page. When I click OK the unable to validate error appears.
Also in the \Symantec\Backup Exec\RAWS\sqlnet.log file I get the following:
Fatal NI connect error 12557, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORA92A)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORA92A)(CID=(PROGRAM=C:\Program Files\Symantec\Backup Exec\RAWS\vxmon.exe)(HOST=LEO)(USER=hhall))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Time: 23-OCT-2007 14:58:20
Tracing not turned on.
Tns error struct:
ns main err code: 12557
TNS-12557: TNS:protocol adapter not loadable
ns secondary err code: 12560
nt main err code: 527
TNS-00527: Protocol Adapter not loadable
nt secondary err code: 0
nt OS err code: 0
Any suggestions?
Can anyone ponit me at a step by stpe guide to setting up oracle db backups in my windows based environment?
Thanks
Andrew