TNS-12557: TNS:protocol adapter not loadable

[Database Administrator]

Oracle Error : TNS-12557: TNS protocol adapter not loadable

Cause: On some platforms (such as OS/2) protocol adapters are loaded at run-time. If the shared library (or DLL) for the protocol adapter is missing or one of its supporting libraries is missing then this error is returned.

Action: For further details, turn on tracing and reexecute the operation. The trace file will include the name of the shared library (or DLL) that could not be loaded.

[administrator]

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=oracl e)(ARGV0=oracleORA92A)(ARGS='(DESCRIPTION=(LOCAL=Y ES)(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

[MRMZMuaz]

Hi, This post of mine is very knowledgable and may enhance the information of the viewers , however I would like some specific information for myself. If someone can help me then please send me a private message. Best Regards,