TNS-12560: TNS:protocol adapter error
509836Apr 29 2006 — edited Mar 1 2007Hi Experts,
Im new to Oracle, basically im installing Oracle 9i on SAP, O/S 2003 server enterprise. But i faced as stated on the subject above. Attached herewith my splnet.log
***-------------------------------------------------------------------------------------------------------------------
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(SDU=32768)(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=sapides47)(PORT=1527))(CONNECT_DATA=(SID=IDE)(GLOBAL_NAME=IDE.WORLD)(CID=(PROGRAM=E:\usr\sap\IDE\SYS\exe\run\R3load.exe)(HOST=SAPIDES47)(USER=ideadm))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.2.0 - Production
Time: 27-APR-2016 11:42:09
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 538
TNS-00538: Message 538 not found; product=NETWORK; facility=TNS
nt secondary err code: 65
nt OS err code: 0
***-------------------------------------------------------------------------------------------------------------------
I did checked to make sure the services for TNSListener and Oracle<SID> are started before proceed with the installation.
Would like your valuable opinion on how to solve the problem above.
Thanks in advance.