OraFAQ Forum: Server Administration » What is the function of the folders rdbms and tnslsnr on Oracle database

Home » RDBMS Server » Server Administration » What is the function of the folders rdbms and tnslsnr on Oracle database (Oracle 19c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What is the function of the folders rdbms and tnslsnr on Oracle database [message #689929]

Thu, 01 August 2024 08:54

alexis19apl
Messages: 1
Registered: August 2024

Junior Member

Question
What is the function of the folders rdbms and tnslsnr on Oracle database ( Windows ) ?

The folders rdbms and tnslsnr are getting large 40gb+ and therefore exhausting the drive space completely,

Question in more detail
The folders rdbms and tnslsnr are getting large 40gb+, and for me to assess what can be deleted without affecting the DB operation I do require to understand what these two folders do. I.e. their function within the Oracle architecture for Windows.

Further details
OracleDB\diag\rdbms

For this path the bulk of the data is stored between:

alert = 34.1 gb
trace = 9.43 gb
Are important the files stored on the path OracleDB\diag\rdbms\cl3v1db\cl3v1\alert for the DB restore or recovery?

Code: [Select all] [Show/ hide]

<msg time='2023-07-12T10:55:48.147+02:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='HOSTNAME'
 host_addr='hex value' pid='5708'>
 <txt>Number of processor sockets in the system is 1
 </txt>
</msg>

OracleDB\diag\tnslsnr

For tnslsnr path the bulk of the data is stored between:

alert = 25.4 gb

trace = 13.0 gb

Are critical the files stored on the path OracleDB\diag\tnslsnr\hostname\listener\alert for DB recovery or restore?

Code: [Select all] [Show/ hide]

<msg time='2023-12-21T07:21:03.082+01:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='hostname'
 host_addr='hex value' pid='5264'>
 <txt>21-DEC-2023 07:21:03 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=SYSTEM))(SERVICE_NAME=CL3v1DB)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50137)) * establish * CL3v1DB * 0
 </txt>
</msg>

Report message to a moderator

Re: What is the function of the folders rdbms and tnslsnr on Oracle database [message #689930 is a reply to message #689929]

Thu, 01 August 2024 10:02

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Those contain trace, log and dump files to help you to debug when you encounter problems (or to audit activity).
They are not needed for current DB operations.
You can delete them as you want (at least the oldest ones).

Report message to a moderator

Re: What is the function of the folders rdbms and tnslsnr on Oracle database [message #689931 is a reply to message #689929]

Thu, 01 August 2024 10:17

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Apart from all those trace files, Alexis, I bet you have several million (million!) audit records that have accumulated in your Windows application log, and maybe millions more in the database audit tables. Better remove them too (after reading them all, of course Smile

)

ps - to do the Moderator bit:

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: What is the function of the folders rdbms and tnslsnr on Oracle database [message #689933 is a reply to message #689931]

Fri, 02 August 2024 04:59

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have the files in these folders been building up slowly over a long time (lots of smallish files over a very large date range)
or has it built up quickly over a much smaller time frame (either some really big files or lots of small files over a small time range)?
If it's the first option then you've just missed out setting up housekeeping for these files.
If it's the second then that probably means something is erroring out a lot and you need to fix it.

Report message to a moderator

Previous Topic:	How to know if my oracle DB is on premise or cloud
Next Topic:	How to fix XDB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 11:49:08 CDT 2025