Oracle Database Discussions

Hi Guru's



My DB Version: 10gR2
OS: Windows Server


I am trying to load text file using sql loader, previouly i am not getting thi sproblem but from morning i am geeting

TNS-12564: TNS:connection refused error

i enable listener tracing


where i am getting after every updation as:


31-AUG-2012 14:35:50:921] nsbaddfl: entry
[31-AUG-2012 14:35:50:921] nsbaddfl: normal exit
[31-AUG-2012 14:35:50:921] nsbfr: normal exit
[31-AUG-2012 14:35:50:921] nsdo: nsctxrnk=0
[31-AUG-2012 14:35:50:921] nsdo: normal exit
[31-AUG-2012 14:35:50:921] nsiocancel: entry
[31-AUG-2012 14:35:50:921] nsiofrrg: entry
[31-AUG-2012 14:35:50:921] nsiofrrg: exit
[31-AUG-2012 14:35:50:921] nsiocancel: exit
[31-AUG-2012 14:35:50:921] nsclose: closing transport
[31-AUG-2012 14:35:50:921] nttdisc: entry
[31-AUG-2012 14:35:50:921] nttdisc: Closed socket 396
[31-AUG-2012 14:35:50:921] nttdisc: exit
[31-AUG-2012 14:35:50:921] nsclose: global context check-out (from slot 6) complete
[31-AUG-2012 14:35:50:921] nsnadisc: entry
[31-AUG-2012 14:35:50:921] nsnadisc: no native services in use - returning
[31-AUG-2012 14:35:50:921] nsopenfree_nsntx: nlhthdel from mplx_ht_nsgbu, ctx=fbba48 nsntx=fd4888
[31-AUG-2012 14:35:50:921] nsiocancel: entry
[31-AUG-2012 14:35:50:921] nsiofrrg: entry
[31-AUG-2012 14:35:50:921] nsiofrrg: exit
[31-AUG-2012 14:35:50:921] nsiocancel: exit
[31-AUG-2012 14:35:50:921] nsmfr: entry
[31-AUG-2012 14:35:50:921] nsmfr: 1632 bytes at 0xfd4888
[31-AUG-2012 14:35:50:921] nsmfr: normal exit
[31-AUG-2012 14:35:50:921] nsmfr: entry
[31-AUG-2012 14:35:50:921] nsmfr: 536 bytes at 0xfbba48
[31-AUG-2012 14:35:50:921] nsmfr: normal exit
[31-AUG-2012 14:35:50:921] nsclose: normal exit
[31-AUG-2012 14:35:50:921] nsredirect: exit (0)
[31-AUG-2012 14:35:50:921] nsbeqaddr: connect handshake is complete
[31-AUG-2012 14:35:50:921] nsbeqaddr: normal exit
[31-AUG-2012 14:35:50:921] nsbequeath: normal exit
[31-AUG-2012 14:35:50:921] nsglhe: exit
[31-AUG-2012 14:35:50:921] nsevwait: entry
[31-AUG-2012 14:35:50:921] nsevwait: 5 registered connection(s)
[31-AUG-2012 14:35:50:921] nsevwait: 0 pre-posted event(s)
[31-AUG-2012 14:35:50:921] nsevwait: waiting for transport event (0 thru 5)...



So kindly suggest me what you think what is the problem

my sql net file details as :

SQLNET.log:

# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora

# Generated by Oracle configuration tools.



SQLNET.AUTHENTICATION_SERVICES= (NONE)



NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

trace_level_server=16

trace_file_server=server

trace_directory_server=F:\



Listener file Details are:

LISTENER:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = tsiindia)

(ORACLE_HOME = C:\oracle\product\10.1.0\db_1)

(SID_NAME = tsiindia)

)

)



LISTENER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = tsiindia)(PORT = 1521))

)



TRACE_FILE_LISTENER =F:\LISTENERTEST.trc

TRACE_DIRECTORY_LISTENER =F:\

LOGGING_LISTENER = on

TRACE_LEVEL_LISTENER =SUPPORT



sqlnet.log error getting during loading:


Fatal NI connect error 12500, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tsiindia.)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=tsiindia)(CID=(PROGRAM=C:\oracle\product\10.1.0\db_1\bin\SQLLDR.EXE)(HOST=TSIINDIA)(USER=vijay))))



VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.1.0.2.0 - Production

Time: 31-AUG-2012 14:28:07

Tracing not turned on.

Tns error struct:

ns main err code: 12564

TNS-12564: TNS:connection refused

ns secondary err code: 0

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0


Can any of you please suggest what the problem may be becoz after google i make changes in listener file as well as sqlnet .ora file