| 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?
<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>
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> |
|
|
|
|
|
|
|
| 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: 13937
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
)