Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Limit what is in listener.log to reduce growth

User_M8BYZOct 18 2016 — edited Oct 18 2016

Hello,

We just had an issue where our listener.log exceeded 4GB and caused the listener to stop working.  We figured that out, but now I want to know if I can limit what is being added to the listener.log file so that it doesn't get that large.   Here are a few lines from our listener.log file.  I put the start and the end lines of the file.

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

12-OCT-2016 16:29:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=54326)) * establish * orcl.temp.com * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

12-OCT-2016 16:29:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=54327)) * establish * orcl.temp.com * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

12-OCT-2016 16:29:16 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=54330)) * establish * orcl.temp.com * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

12-OCT-2016 16:29:16 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=54331)) * establish * orcl.temp.com * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

Tue Oct 18 12:13:36 2016

18-OCT-2016 12:13:36 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=49678)) * establish * orcl.temp.com * 0

18-OCT-2016 12:13:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=49681)) * establish * orcl.temp.com * 0

18-OCT-2016 12:13:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=49682)) * establish * orcl.temp.com * 0

18-OCT-2016 12:13:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=49685)) * establish * orcl.temp.com * 0

18-OCT-2016 12:13:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=49686)) * establish * orcl.temp.com * 0

Tue Oct 18 12:13:53 2016

18-OCT-2016 12:13:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=49689)) * establish * orcl.temp.com * 0

Tue Oct 18 12:14:07 2016

18-OCT-2016 12:14:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=TEST$))(SERVICE_NAME=orcl.temp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.17.186)(PORT=49691)) * establish * orcl.temp.com * 0

Thank you for any help you can give me.

This post has been answered by John Thorton on Oct 18 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2016
Added on Oct 18 2016
13 comments
789 views