Tnslistener falling _ Someone has seen this ??

Doug · Wed, 12 Dec 2007 9:52 am

I installed Oracle 9.2.0.1 on my notebook, after formatting the same.
As usual I created a standard DateewareHouse bank.
I always had this bank tip on the pc and never gave a problem, but now, when I connect with user sys, or what else, after a few second the listener service falls ???? I already looked on google and I did not find anything ...

Someone hate help me ???

ATT
PS - My S.O is Win XP Professional.

Doug · Wed, 12 Dec 2007 11:29 am

Listener Log

Select all

 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 16:22:43 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=2648 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
11-DEZ-2007 16:22:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Douglas))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
11-DEZ-2007 16:24:49 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Douglas))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * reload * 0 
11-DEZ-2007 16:25:28 * (CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION=RO)) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * PLSExtProc * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 16:47:27 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=1988 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
11-DEZ-2007 16:48:57 * service_register * testes * 0 
11-DEZ-2007 16:49:04 * service_update * testes * 0 
11-DEZ-2007 16:49:13 * service_update * testes * 0 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 16:49:16 * service_update * testes * 0 
11-DEZ-2007 16:49:40 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1052)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 16:50:46 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=2832 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
11-DEZ-2007 16:51:30 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1098)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 16:53:02 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=4036 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
11-DEZ-2007 16:53:50 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1158)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 16:55:26 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=3376 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 16:56:08 * service_register * testes * 0 
11-DEZ-2007 16:57:02 * service_update * testes * 0 
11-DEZ-2007 16:57:34 * service_update * testes * 0 
11-DEZ-2007 16:58:44 * service_update * testes * 0 
11-DEZ-2007 16:59:17 * service_update * testes * 0 
11-DEZ-2007 16:59:50 * service_update * testes * 0 
11-DEZ-2007 17:00:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\Arquivos de programas\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1180)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:01:42 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=1548 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:02:30 * service_register * testes * 0 
11-DEZ-2007 17:02:36 * service_update * testes * 0 
11-DEZ-2007 17:03:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1190)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:03:51 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=3968 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:04:40 * service_register * testes * 0 
11-DEZ-2007 17:06:03 * service_update * testes * 0 
Não há mais atendimento em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
Não há mais atendimento em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
11-DEZ-2007 17:06:09 * service_died * testes * 12537 
11-DEZ-2007 17:06:17 * service_register * testes * 0 
11-DEZ-2007 17:06:23 * service_update * testes * 0 
11-DEZ-2007 17:06:29 * service_update * testes * 0 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:06:32 * service_update * testes * 0 
11-DEZ-2007 17:06:37 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1197)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:07:16 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=3456 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:07:49 * service_register * testes * 0 
11-DEZ-2007 17:08:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\Arquivos de programas\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1207)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:08:59 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=3384 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:09:31 * service_register * testes * 0 
11-DEZ-2007 17:09:31 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\Arquivos de programas\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1214)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:10:26 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=2936 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:10:38 * service_register * testes * 0 
Não há mais atendimento em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
Não há mais atendimento em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
11-DEZ-2007 17:11:00 * service_died * testes * 12547 
TNS-12547: TNS:contato perdido 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:12:19 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=320 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:23:29 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=320 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:27:51 * service_register * testes * 0 
11-DEZ-2007 17:29:12 * service_update * testes * 0 
11-DEZ-2007 17:29:21 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1040)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:30:05 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=3928 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
11-DEZ-2007 17:30:16 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\Arquivos de programas\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1045)) * establish * testes * 0 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:30:51 * service_register * testes * 0 
11-DEZ-2007 17:31:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplusw.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1049)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:32:32 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=880 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
11-DEZ-2007 17:33:11 * service_register * testes * 0 
11-DEZ-2007 17:34:11 * service_update * testes * 0 
11-DEZ-2007 17:34:44 * service_update * testes * 0 
11-DEZ-2007 17:35:53 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\Arquivos de programas\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1054)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 17:38:10 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=3512 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
11-DEZ-2007 17:38:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testes)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=SERVER)(USER=Douglas))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1061)) * establish * testes * 0 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-DEZ-2007 19:43:10 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=320 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 12-DEZ-2007 11:51:25 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=756 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
 
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 12-DEZ-2007 12:26:36 
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved. 
 
O arquivo de parâmetros do sistema é C:\oracle\ora92\network\admin\listener.ora 
Mensagem de log gravada para C:\oracle\ora92\network\log\listener.log 
Informações de rastreamento gravadas para C:\oracle\ora92\network\trace\listener.trc 
O nível de rastreamento atualmente é 0 
 
Iniciado com pid=220 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 
Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

elidias7 · Thu, 13 Dec 2007 8:35 am

When the Listener service exits the air, no error message is displayed on the screen?
Anything you ever checked Alert, to see if there's something different about him?

Hugs,

gilbertoca · Thu, 13 Dec 2007 11:23 am

Listener log does not show any problem.
How is the configuration of the sqlnet.ora file?
When you connect and this interrupts happens, do you really check if the listener has fallen through the command-line utility?

Gilberto

carlaestevao80 · Thu, 13 Dec 2007 2:08 pm

I have a BD tests in 10g, where if it is passing exactly the same.
n is qualquer registration in the alert.log file and in listener.log lies something of the q gender was presented earlier.

Can anyone help?

Thanks

Doug · Thu, 13 Dec 2007 4:12 pm

Anigos, since I did not find anything on the internet about it, I ended up formatting my note, and I still did not reinstall Oracle ...

in relation to SQLNet.ora, a person gave me the tip of Change the NTS to None

Select all

SQLNET.AUTHENTICATION_SERVICES= (NTS)

But it did not work. Maybe the friend who has the same problem can try this solution ......

gilbertoca · Thu, 13 Dec 2007 4:52 pm

That's why I asked you to set it up in the previous post!
See this comments I did about when I passed by similar situation: http://www.jroller.com/gilbertoca/entry ... om_o_banco

Gilberto

Doug · Fri, 14 Dec 2007 9:32 am

Hehe .. very good ... hopes we can help the friend up there that is co the same problem.

ABS

tiagofenix · Fri, 06 Nov 2009 1:26 pm

Well, I had a problem similar to a web application. I discovered that the Oracle database required an Impersonate to be able to create the connection with Oracle Server.

If you have a Web application, this is easily contoured with a

Select all

 <identity impersonate="true"/>

on Web.config or Configuring IIS.

I hope to have contributed ...

Fri, 06 Nov 2009 1:31 pm

In Java applications you need to place a file named Orion-Web.xml and in it points the datasource prevalently configured in the App Server and that will be used by Application

Tnslistener falling _ Someone has seen this ??

Who is online