Может кто-нибудь подскажет в чем-дело?
В один прекрасный день пропал connect к базе на собственном компе
при этом connect к другим базам на других компьютерах в сети есть!
У меня стоит Windows XP Pro, Oracle 9i Server.
tnsping тоже не проходит:

>tnsping smartsaf

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-BAL-2005 14:18:44

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
c:\progra~1\oracle\ora92\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SI
PC)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SmartSaf)))
TNS-12535: TNS:operation timed out

В trace log:

***********************************************************************
Fatal NI connect error 12535, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SIPC)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SmartSaf)(CID=(PROGRAM=C:\Program Files\Oracle\ora92\bin\sqlplusw.exe)(HOST=SIPC)(USER=SergejusI))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 15-BAL-2005 13:29:44
Tracing to file: /tmp/tmp/\cli_4364_1.trc
Tns error struct:
nr err code: 0
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0


Что случилось, что делать?

В дополнение еще log tnsping:

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-BAL-2005 14:18:44

Copyright (c) 1997 Oracle Corporation. All rights reserved.


--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is /tmp/tmp\tnsping.trc
New trace level is 16
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source c:\progra~1\oracle\ora92\network\admin\sqlnet.ora
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TNSPING.TRACE_LEVEL = 16
TRACE_LEVEL_CLIENT = 16
TRACE_DIRECTORY_CLIENT = /tmp/tmp
TNSPING.TRACE_DIRECTORY = /tmp/tmp
TRACE_UNIQUE_CLIENT = yes
TRACE_FILE_CLIENT = cli.trc
LOG_FILE_CLIENT = sqlnet.log
LOG_DIRECTORY_CLIENT = /tmp/tmp
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nnfun2awanm: entry
nnfgiinit: entry
nnftboot: entry
nnftboot: exit
nnfoboot: entry
nnfoboot: exit
nnfoboot: entry
nnfoboot: exit
nnfhboot: entry
nnfhboot: exit
nnflcls: entry
nnflcls: exit
nncpcin_maybe_init: first request sent to name server will have ID 0
nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is [root]
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrsp: Parmeter names.directory_path not found, setting path to compiled in default
nnfgspd: entry
nnfgspd: setting element DCE
nnfgspd: setting element CDS
nnfgspd: setting element TNSNAMES
nnfgspd: setting element ONAMES
nnfgspd: setting element ONRS
nnfgspd: setting element HOSTNAME
nnfgspd: setting element LDAP
nnfgspd: Path set
nnfgspd: exit
nnfgrne: Going though read path adapters
nnfgrne: Switching to DCE adapter
nnfgrne: Original name: smartsaf
nnfgrne: Name did not qualify, skipping to next adapter
nnfgrne: Switching to CDS adapter
nnfgrne: Original name: smartsaf
nnfgrne: Name did not qualify, skipping to next adapter
nnfgrne: Switching to TNSNAMES adapter
nnfgrne: Original name: smartsaf
nnftinit: entry
nnftinit: Tnsnames refresh interval is 0
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_local_addrfile: entry
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_local_addrfile: exit
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_system_addrfile: entry
nnftmlf_make_system_addrfile: system names file is c:\progra~1\oracle\ora92\network\admin\tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftinit: exit
nnftqnm: entry
nnfcagmd: entry
nnfcagmd: Attempting to find metadata for type a.smd
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nnfttran: entry
--- c:\progra~1\oracle\ora92\network\admin\tnsnames.ora TABLE HAS THE FOLLOWING CONTENTS ---
JXFS2.OFFICE.5CI.LT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dance)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = jxfs2)))
INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SIPC)(PORT = 1521))) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService)))
JXFS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dance)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = jxfs)))
SMARTSAF = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SIPC)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SmartSaf)))
JXFS2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dance)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = cebit)))
EXTPROC_CONNECTION_DATA.OFFICE.5CI.LT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO)))
SMARTSAF.OFFICE.5CI.LT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sipc)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = smartsaf)))
--- END c:\progra~1\oracle\ora92\network\admin\tnsnames.ora TABLE ---
nnfttran: exit
nnfttran: entry
nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SIPC)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SmartSaf))) for name smartsaf
nnfcraa: entry
nnfgrne: Name successfully queried
nnfgrne: Obtaining answer records for smartsaf
nnftans: entry
nnfcran: entry
nnfcran: 64 rrs requested, 1 remaining, 1 total
nnfcran: exit
nnfgrne: exit
nlolgserv: entry
nnfggav: entry
nnfggav: exit
nnfgfrm: entry
nnfgfrm: exit
nlolgserv: exit
nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nnfun2awanm: Getting the path of sqlnet.ora
nnfun2awanm: Getting the adapter name
nnfun2awanm: exit
nscall: entry
nsmal: entry
nsmal: 164 bytes at 0xb6fd00
nsmal: normal exit
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsc2addr: entry
nttbnd2addr: entry
nttgetport: entry
nttgetport: port resolved to 1521
nttgetport: exit
nttbnd2addr: looking up IP addr for host: SIPC
nttbnd2addr: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 492 bytes at 0xbb85f0
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 2348 bytes at 0xbb87e8
nsmal: normal exit
nsopenmplx: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: tcp.validnode_checking not turned on
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: creating a socket.
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 1828.
ntt2err: entry
ntt2err: soc 1828 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nsbfr: entry
nsbfr: normal exit
nsbfr: entry
nsbfr: normal exit
nsmfr: entry
nsmfr: 2348 bytes at 0xbb87e8
nsmfr: normal exit
nsmfr: entry
nsmfr: 492 bytes at 0xbb85f0
nsmfr: normal exit
nsopen: error exit
nscall: error exit
nscall: entry
nscall: connecting...
nsclose: entry
nsclose: normal exit
nladget: entry
nladget: exit
nsmfr: entry
nsmfr: 164 bytes at 0xb6fd00
nsmfr: normal exit
nladtrm: entry
nladtrm: exit
nscall: error exit

Нет, пакетного фильтра не ставил.
С других компов при коннекте ко мне та же ошибка,
хотя раньше все работали.

Я посмотрел tnsping trace log к другому серверу в сетке (к которому есть коннект):
все похоже, а разница начинается при открытии socket'a
У меня :

trying to connect to socket 1828.
ntt2err: entry
ntt2err: soc 1828 error
А к другому:
nttcni: trying to connect to socket 1824.
nttcni: connected on ipaddr 192.168.92.84
nttcni: exit
nttcon: NT layer TCP/IP connection has been established.

То есть у меня идет неудачная попытка открытия socket'a и с другим номером
Где-то здесь загводка, похоже

Я так понимаю, возвращает ошибку:

ntt2err: soc 1828 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport

Ничего не изменилось.

Да, вообщем-то

Да, порт 1521 открыт. И через него коннект с другими серверами в сетке идет.
Пытался и отключать firewall, все то же.

Вот:
# LISTENER.ORA Network Configuration File: c:\progra~1\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =(CONNECT_TIMEOUT=30)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SIPC)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\progra~1\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = SmartSaf)
(ORACLE_HOME = c:\progra~1\oracle\ora92)
(SID_NAME = SmartSaf)
)
)

и вот:

# TNSNAMES.ORA Network Configuration File: c:\progra~1\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

SMARTSAF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SIPC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SmartSaf)
)
)

JXFS2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dance)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cebit)
)
)



EXTPROC_CONNECTION_DATA.xxx.yyy.zzz =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Это антивирусная программа, да? То, таковой нет.

Снес всю антивирусную защиту и заработало!!!
Администраторы сети централизованно устанавливали везде свой антивирусный ... и после этого и начались проблемы