Understand what can be deleted and what not from rdbms and tnslsnr paths
Hello all,
The org I work for is experiencing a situation in which the folder rdbms and tnslsnr are getting large 40gb+ and therefore exahusting the drive space completaly,
In order for me to asses what can be deleted or archive I do require to understand what these two folders do. i.e. their funcion within the Oracle architecture for windows.
I have had search over the internet before comming here to post a question that can be answered with a five min query, but the results I have encounter are too superficial, and they don’t manage to address what are the functions of those two folders, hence why creating this post asking for your help clarifying the functionality and importance of rdbms and tnslsnr.
Detailed explanation
OracleDBdiagrdbms
For this path the bulk of the data is stored between:
- alert = 34.1 gb
- trace = 9.43 gb
The path OracleDBdiagrdbmscl3v1dbcl3v1alert is storing files in the form of log_n.xml with content as shown below:
<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>
OracleDBdiagtnslsnr
For me is confusing that the path OracleDBdiagtnslsnr also has an alert folder with very similar log_n.xml files as in rdbms.
OracleDBdiagtnslsnrhostnamelisteneralert:
<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>