Re: Help with Oralce 7.3.3 Listener Trace options on NT

I did that, but it didn't stop the trace. I think there must be a occrupted program, it seemed like a program went into an infinite loop when writing into the log file. The trace log file grew to 40mb in just 5 minutes after I started the listener.

I had to uninstall the oracle db and reinstalled it.

Thank you for your input,

Ada Zhao

In article <7jqh2d$5bi$1_at_taliesin.netcom.net.uk>,   "Alex" <alex.hudghton_at_capgemini.co.uk> wrote:
> TRACE_LEVEL_LISTENER = OFF in listener.ora
>
> Alex
>
> Ada Zhao wrote in message <7jpc2n$u5t$1_at_nnrp1.deja.com>...
> >I installed a software called SQL-station from Platium technology,
and
> >I thought the installation program changed my Oracle listener
setting.
> >The listener runs at 100% all the time ever after I installed the
sql-
> >station. I tried to turn off every "trace" option that I could find
in
> >the Oracle settings( all the *.ora files), but no luck. One thing I
> >noticed is that listener keeps on writing to a file called
> >\orant\network\admin\trace\listener.trc.
> >
> >Anyone has ideas or suggestion on how to turn the listener trace off
?
> >
> >The following is the part of the trace log for the listener.
> >
> >TNSLSNR for 32-bit Windows: Version 2.3.3.0.0 - Production on 10-JUN-
99
> >13:55:16
> >
> >
> >Copyright (c) Oracle Corporation 1994. All rights reserved.
> >
> >
> >--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
> >New trace stream is "C:\ORANT\network\trace\listener.trc"
> >New trace level is 6
> >--- TRACE CONFIGURATION INFORMATION ENDS ---
> >
> >--- PARAMETER SOURCE INFORMATION FOLLOWS ---
> >Attempted load of system pfile source C:
> >\ORANT\network\admin\listener.ora
> >Parameter source loaded successfully
> >
> >Attempted load of command line source
> >Parameter source was not loaded
> >
> > -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
> >Successful parameter table load
> > -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
> > STARTUP_WAIT_TIME_LISTENER = 0
> > SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ORCL)))
> > CONNECT_TIMEOUT_LISTENER = 10
> > TRACE_LEVEL_LISTENER = ADMIN
> > PASSWORDS_LISTENER = (oracle)
> > LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY=
> >oracle.world)) (ADD
> >RESS= (PROTOCOL= IPC) (KEY= ORCL)) (ADDRESS= (COMMUNITY= TCP.world)
> >(Host = ml07
> >3953) (PROTOCOL= TCP) (Port= 1521)) (ADDRESS= (COMMUNITY= TCP.world)
> >(Host = ml0
> >73953) (PROTOCOL= TCP) (Port= 1526)))
> >--- PARAMETER SOURCE INFORMATION ENDS ---
> >
> >--- LOG CONFIGURATION INFORMATION FOLLOWS ---
> >Log stream will be "C:\ORANT\network\log\listener.log"
> >Log stream validation requested
> >Log stream is valid
> >--- LOG CONFIGURATION INFORMATION ENDS ---
> >
> >Resolved "CONNECT_TIMEOUT_LISTENER" to: 10
> >Resolved "STARTUP_WAIT_TIME_LISTENER" to: 0
> >(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)
> >(KEY=oracle.world)))
> >opening transport...
> >listening on pipe 132
> >transport is open
> >global context check-in (to slot 0) complete
> >completing partial addr: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=
> >(PROTOCOL=IPC
> >)(KEY=oracle.world)))Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=
\\.
> >\pipe\ora
> >cle.worldipc))
> >(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
> >opening transport...
> >listening on pipe 164
> >transport is open
> >global context check-in (to slot 1) complete
> >(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=ORCL)))
> >opening transport...
> >listening on pipe 168
> >transport is open
> >global context check-in (to slot 2) complete
> >completing partial addr: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=
> >(PROTOCOL=IPC
> >)(KEY=ORCL)))Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.
> >\pipe\ORCLipc))
> >(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(COMMUNITY=TCP.world)
> >(Host=ml073953)(P
> >ROTOCOL=TCP)(Port=1521)))
> >port resolved to 1521
> >looking up IP addr for host: ml073953
> >opening transport...
> >No PROTOCOL.ORA file is found
> >Validnode Table IN use; err 0x0
> >getting sockname
> >transport is open
> >global context check-in (to slot 3) complete
> >completing partial addr: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=
> >(COMMUNITY=TC
> >P.world)(Host=ml073953)(PROTOCOL=TCP)(Port=1521)))Listening on:
> >(ADDRESS=(PROTOC
> >OL=tcp)(DEV=196)(HOST=146.125.8.205)(PORT=1521))
> >(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(COMMUNITY=TCP.world)
> >(Host=ml073953)(P
> >ROTOCOL=TCP)(Port=1526)))
> >port resolved to 1526
> >looking up IP addr for host: ml073953
> >opening transport...
> >Validnode Table IN use; err 0x0
> >getting sockname
> >transport is open
> >global context check-in (to slot 4) complete
> >completing partial addr: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=
> >(COMMUNITY=TC
> >P.world)(Host=ml073953)(PROTOCOL=TCP)(Port=1526)))Listening on:
> >(ADDRESS=(PROTOC
> >OL=tcp)(DEV=224)(HOST=146.125.8.205)(PORT=1526))
> >Testing for 2 cxds on protocol Windows NT TCP/IP NT Protocol Adapter
> >Testing for 2 cxds on protocol Windows NT Named Pipes IPC NT Protocol
> >Adaptor
> >Testing for 2 cxds on protocol Windows NT Named Pipes IPC NT Protocol
> >Adaptor
> >Testing for 2 cxds on protocol Windows NT TCP/IP NT Protocol Adapter
> >Testing for 2 cxds on protocol Windows NT Named Pipes IPC NT Protocol
> >Adaptor
> >Testing for 2 cxds on protocol Windows NT TCP/IP NT Protocol Adapter
> >Testing for 2 cxds on protocol Windows NT Named Pipes IPC NT Protocol
> >Adaptor
> >..........
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 29 1999 - 10:16:27 CDT