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)
sys.x$dbgalertext alert log info text access [message #683518] Mon, 25 January 2021 09:43 Go to next message
wtolentino
Messages: 341
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.
Re: sys.x$dbgalertext alert log info text access [message #683519 is a reply to message #683518] Mon, 25 January 2021 10:46 Go to previous messageGo to next message
John Watson
Messages: 8576
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.
Re: sys.x$dbgalertext alert log info text access [message #683521 is a reply to message #683518] Mon, 25 January 2021 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 67918
Registered: March 2007
Location: Nanterre, France, http://...
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).

Re: sys.x$dbgalertext alert log info text access [message #683526 is a reply to message #683521] Mon, 25 January 2021 13:30 Go to previous message
John Watson
Messages: 8576
Registered: January 2010
Location: Global Village
Senior Member
I'm sure you correct. Sorry about that Smile
Previous Topic: how to verify if Audit Trail is capturing the latest
Next Topic: How to IMPDP to PDB?
Goto Forum:
  


Current Time: Fri Jul 23 11:11:04 CDT 2021