OraFAQ Forum: Server Administration » sys.x$dbgalertext alert log info text access

Home » RDBMS Server » Server Administration » sys.x$dbgalertext alert log info text access (racle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sys.x$dbgalertext alert log info text access [message #683518]

Mon, 25 January 2021 09:43

wtolentino
Messages: 422
Registered: March 2005

Senior Member

I am attempting to query the alert log view/table thru sys.x$dbgalertext. I found out that I had no access to it. I tried to check if the view/table exist thru the dba_objects. It appears to be it does not exists on the dba_objects view but I know somehow that object exists and I just don't have access to it.

SQL> describe sys.x$dbgalertext;
ERROR:
ORA-04043: object sys.x$dbgalertext does not exist


SQL> select count(*) from dba_objects where object_name like '%DBGALERTTEXT%';

  COUNT(*)
----------
         0

SQL>

I have a dba access but not a sys or sysdba access. I know that somehow I had to request an access for it from our "infrastructure dba group" and I just want to be sure that sys.x$dbgalertext exists. Please advise.

Thank you.

Report message to a moderator

Re: sys.x$dbgalertext alert log info text access [message #683519 is a reply to message #683518]

Mon, 25 January 2021 10:46

John Watson
Messages: 8977
Registered: January 2010
Location: Global Village

Senior Member

You need to ask your DBA to create a view on x$dbgalertext and grant you SELECT on the view. This is done by default in release 12.x.

Report message to a moderator

Re: sys.x$dbgalertext alert log info text access [message #683521 is a reply to message #683518]

Mon, 25 January 2021 11:25

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It exists (at least in enterprise edition):

SYS> describe sys.x$dbgalertext;
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 ADDR                                      RAW(4)
 INDX                                      NUMBER
 INST_ID                                   NUMBER
 ORIGINATING_TIMESTAMP                     TIMESTAMP(3) WITH TIME
                                            ZONE
 NORMALIZED_TIMESTAMP                      TIMESTAMP(3) WITH TIME
                                            ZONE
 ORGANIZATION_ID                           VARCHAR2(64)
 COMPONENT_ID                              VARCHAR2(64)
 HOST_ID                                   VARCHAR2(64)
 HOST_ADDRESS                              VARCHAR2(46)
 MESSAGE_TYPE                              NUMBER
 MESSAGE_LEVEL                             NUMBER
 MESSAGE_ID                                VARCHAR2(64)
 MESSAGE_GROUP                             VARCHAR2(64)
 CLIENT_ID                                 VARCHAR2(64)
 MODULE_ID                                 VARCHAR2(64)
 PROCESS_ID                                VARCHAR2(32)
 THREAD_ID                                 VARCHAR2(64)
 USER_ID                                   VARCHAR2(64)
 INSTANCE_ID                               VARCHAR2(64)
 DETAILED_LOCATION                         VARCHAR2(160)
 PROBLEM_KEY                               VARCHAR2(64)
 UPSTREAM_COMP_ID                          VARCHAR2(100)
 DOWNSTREAM_COMP_ID                        VARCHAR2(100)
 EXECUTION_CONTEXT_ID                      VARCHAR2(100)
 EXECUTION_CONTEXT_SEQUENCE                NUMBER
 ERROR_INSTANCE_ID                         NUMBER
 ERROR_INSTANCE_SEQUENCE                   NUMBER
 VERSION                                   NUMBER
 MESSAGE_TEXT                              VARCHAR2(2048)
 MESSAGE_ARGUMENTS                         VARCHAR2(128)
 SUPPLEMENTAL_ATTRIBUTES                   VARCHAR2(128)
 SUPPLEMENTAL_DETAILS                      VARCHAR2(128)
 PARTITION                                 NUMBER
 RECORD_ID                                 NUMBER

SYS> @v

Oracle version: 11.2.0.4.181016 EE

@John, are you sure there is a view on it in 12.*? I didn't find it in my databases (there is only one on x$diag_ALERT_EXT).

Report message to a moderator

Re: sys.x$dbgalertext alert log info text access [message #683526 is a reply to message #683521]

Mon, 25 January 2021 13:30

John Watson
Messages: 8977
Registered: January 2010
Location: Global Village

Senior Member

I'm sure you correct. Sorry about that Smile

Report message to a moderator

Previous Topic:	how to verify if Audit Trail is capturing the latest
Next Topic:	How to IMPDP to PDB?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 16 00:27:06 CDT 2025