| Listener always stop [message #64201] |
Sun, 02 January 2005 16:37  |
Fahami
Messages: 22
Registered: December 2004
|
Junior Member |
|
|
Hi everybody,
I got a major problem here. Why my Listener always stop when somebody accessing database? Each time a user log in to database, the TNSLNSR.EXE error will come out and the listener is down. This require listener to restart before can proceed.
This is my listener.ora
# LISTENER.ORA Network Configuration File: C:oracleora92networkadminlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Twinhead)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = demo)
(ORACLE_HOME = C:oracleora92)
(SID_NAME = demo)
)
(SID_DESC =
(GLOBAL_DBNAME = OEMREP)
(ORACLE_HOME = C:oracleora92)
(SID_NAME = OEMREP)
)
)
Thanks & Regards.
|
|
|
|
|
|
| Re: Listener always stop [message #64203 is a reply to message #64202] |
Sun, 02 January 2005 21:23  |
Fahami
Messages: 22
Registered: December 2004
|
Junior Member |
|
|
Hi,
I opened and checked my listener.log file at it's folder. No single error is recorded.
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 03-JAN-2005 10:11:01
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is C:oracleora92networkadminlistener.ora
Log messages written to C:oracleora92networkloglistener.log
Trace information written to C:oracleora92networktracelistener.trc
Trace level is currently 0
Started with pid=3024
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Twinhead)(PORT=1521)))
TIMESTAMP * CONNECT DATA [[* PROTOCOL INFO]] * EVENT [[* SID]] * RETURN CODE
03-JAN-2005 10:11:03 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Admin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Twinhead)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Twinhead)(PORT=2100))(Presentation=FTP)(Session=RAW))
03-JAN-2005 10:11:08 * service_register * demo * 0
03-JAN-2005 10:11:08 * service_register * OEMREP * 0
03-JAN-2005 10:11:41 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=demo)(CID=(PROGRAM=C:Program FilesLVSLV LIMS 5.3lvl.exe)(HOST=TWINHEAD)(USER=Admin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.1.1.28)(PORT=2023)) * establish * demo * 0
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 03-JAN-2005 10:12:07
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is C:oracleora92networkadminlistener.ora
Log messages written to C:oracleora92networkloglistener.log
Trace information written to C:oracleora92networktracelistener.trc
Trace level is currently 0
Started with pid=292
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Twinhead)(PORT=1521)))
TIMESTAMP * CONNECT DATA [[* PROTOCOL INFO]] * EVENT [[* SID]] * RETURN CODE
03-JAN-2005 10:12:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Admin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0
03-JAN-2005 10:12:15 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=demo)(CID=(PROGRAM=C:Program FilesLVSLV LIMS 5.3lvl.exe)(HOST=TWINHEAD)(USER=Admin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.1.1.28)(PORT=2052)) * establish * demo * 0
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 03-JAN-2005 10:12:29
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is C:oracleora92networkadminlistener.ora
Log messages written to C:oracleora92networkloglistener.log
Trace information written to C:oracleora92networktracelistener.trc
Trace level is currently 0
Started with pid=2240
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Twinhead)(PORT=1521)))
TIMESTAMP * CONNECT DATA [[* PROTOCOL INFO]] * EVENT [[* SID]] * RETURN CODE
03-JAN-2005 10:12:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Admin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Twinhead)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Twinhead)(PORT=2100))(Presentation=FTP)(Session=RAW))
03-JAN-2005 10:12:51 * service_register * demo * 0
03-JAN-2005 10:12:51 * service_register * OEMREP * 0
03-JAN-2005 11:12:53 * service_update * demo * 0
|
|
|
|
| Re: Listener always stop [message #64207 is a reply to message #64203] |
Sun, 02 January 2005 23:15 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
If you open a command-prompt you can issue the command 'lsnrctl trace <<z>sid_name> <<z>user|admin|support>' (so, 1 of user/admin/support). This will create a (large!) trace-file, which might lead you to your error.
My knowledge about listener-problems ends about here, so good luck.
hth
|
|
|
|
| Re: Listener always stop [message #109512 is a reply to message #64207] |
Fri, 25 February 2005 03:12 |
kamalc
Messages: 3
Registered: February 2005
|
Junior Member |
|
|
Does your server have a STATIC IP ? If not, provide a static IP Address for the same. If it's holding a DYNAMIC IP, it sometimes, might clash with an existing IP in the network and the Listener may go down frequently.
Thanx Kamal
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
