DevOps, CI/CD and Automation

Hi All,

I have Problem with Connection used TCP/IP..

This is log connection from file sqlnet.log :

***********************************************************************
Fatal NI connect error 12571, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=donlee)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)(CID=(PROGRAM=C:\Program Files\Quest Software\TOAD\TOAD.exe)(HOST=DONLEE)(USER=dodon))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
Time: 25-APR-05 10:58:25
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12571
TNS-12571: TNS:packet writer failure
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

And this is from TNSNAMES.ORA :
PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = donlee)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PROD)
)
)


and this from LISTENER.ORA:
# C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = donlee)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PROD)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = PROD)
)
)

..................................

Please help me about this.

Many Thanks
Dodon
Leading8