Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlnet.log shows incorrect host!

953576Aug 19 2012 — edited Aug 19 2012
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2012
Added on Aug 19 2012
5 comments
469 views