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!

What is the function of the folders rdbms and tnslsnr on Oracle database

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?

<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?

<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>
Comments
Post Details
Added on Aug 1 2024
1 comment
214 views