sqlnet.log shows incorrect host!
953576Aug 19 2012 — edited Aug 19 2012Hi,
I am unable to explain this, or fix it. I have a 11gr2 DB (Arabic charset) installed on win7 pro. I am using a Delphi application to connect to it on the same machine, but I am getting error 12543 followed by 00513. Upon further investigation, I noticed that host showing in the sqlnet.log is incorrect. I have no idea why it's showing 192.168.1.107 where it should be localhost.
****************
sqlnet.log
****************
Fatal NI connect error 12543, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.107)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=smart)(CID=(PROGRAM=D:\Smart\Accounts.exe)(HOST=LAPTOP1)(USER=Duraid))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 19-ÇÛÓØÓ -2012 19:51:02
Tracing not turned on.
Tns error struct:
ns main err code: 12543
TNS-12543: TNS: áÇ íãßä ÇáæÕæá Åáì ÇáãÖíÝ ÇáãØáæÈ
ns secondary err code: 12560
nt main err code: 513
TNS-00513: áã íÊã ÇáÊãßä ãä ÇáæÕæá Çáì ÇáãÖíÝ ÇáãØáæÈ
nt secondary err code: 51
nt OS err code: 0
****************
sqlnet.ora
****************
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
****************
listener.ora
****************
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\oracle
****************
tnsnames.ora
****************
SMART =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = smart)
)
)
Please note that I can log is using sqlplus.
Does anyone know why sqlnet.log is showing a different host compared to other files? How can I fix this? How can I trace that?
Thanks.