Database - RAC/Scalability (MOSC)

MOSC Banner

Read listener,asm,CRS,tnslsnr xml logs from sqlplus

edited Mar 7, 2019 10:42AM in Database - RAC/Scalability (MOSC) 7 commentsAnswered ✓

Hello All,

Below is my db version in RAC:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

I am able to only read instance specific alert logs using V$DIAG_ALERT_EXT.

select distinct COMPONENT_ID from V$DIAG_ALERT_EXT;

COMPONENT_ID

----------------------

rdbms

Please let me know how can i access listener,asm,CRS,tnslsnr xml logs from sqlplus. I have DBA privilege in the database but do no have access to the database hosts.

Referred Metalink :

No Entry In V$DIAG_ALERT_EXT With COMPONENT_ID='tnslsnr' In 12.2 (Doc ID 2362105.1)

Message was edited by: 3038653

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