Database Administration (MOSC)

MOSC Banner

How to change the Listener log file location in Oracle 19c ?

Below is the example.


Current Log File Location

Listener Log File     /u02/app/oracle/product/19.0.0.0/dbhome_1/admin/hostname/diag/tnslsnr/hostname/sid/alert/log.xml


New Location:

/u02/app/oracle/diag/tnslsnr/hostname/SID/alert/log.xml


I have tried with lsnrctl set log_directory, but getting error.

LSNRCTL> sho log_directory

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-01190: The user is not authorized to execute the requested listener command.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center