Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle11g Trigger Debugging Record Error: PLS-00201: identifier SYS.DBMS_SYSTEM 'must be declared     - 17 How to install the Ubuntu 14.04 and Linux Mint Kodi14 (XBMC) (Linux)

- Nodejs mysql pool Example (Programming)

- Django Web dynamic three linkage (Programming)

- To compile and install OpenCV-2.3.1 FFmpeg-2.1.2 under CentOS (Linux)

- Through the source code to install MySQL 5.6.26 under CentOS6 (Database)

- When Linux Detailed time zone and common function of time (Linux)

- CentOS 7.0 Experience with previous versions (Linux)

- Hanoi problem Java Solution (Programming)

- How to configure a server in a MySQL Cluster (Database)

- Fedora 22 Server how to upgrade to Fedora 23 Beta Server (Linux)

- Windows 7 hard disk to install Ubuntu 14.10 (Linux)

- RPM package creation Getting Started (Linux)

- Sublime Text 3 shortcuts summary (Linux)

- Oracle Linux 5.5 (64bit) Install Oracle 11gR2 RAC detailed tutorial (Database)

- Java in the final qualifier (Programming)

- error 1819 (HY000): your password does not satisfy the current policy requirements (Database)

- Linux kernel log --dmesg (Linux)

- Enable Intel Rapid Start in GNU / Linux (Linux)

- pkg-config to use (Linux)

- Packages with Snort intrusion monitoring light (Linux)

 
         
  Oracle11g Trigger Debugging Record Error: PLS-00201: identifier SYS.DBMS_SYSTEM 'must be declared
     
  Add Date : 2018-11-21      
         
         
         
  1, The trigger content is as follows

CREATE OR REPLACE TRIGGER "LOGON_DENIED_TO_ALERT"

AFTER servererror ON DATABASE

DECLARE

Message VARCHAR2 (168);

Ip VARCHAR2 (15);

V_os_user VARCHAR2 (80);

V_module VARCHAR2 (50);

V_action VARCHAR2 (50);

V_pid VARCHAR2 (10);

V_sid NUMBER;

V_program VARCHAR2 (48);

BEGIN

IF (ora_is_servererror (1017)) THEN

- get ip FOR remote connections:

IF upper (sys_context ( 'userenv', 'network_protocol')) = 'TCP' THEN

Ip: = sys_context ( 'userenv', 'ip_address');

END IF;

SELECT sid INTO v_sid FROM sys.v_ $ mystat WHERE rownum < 2;

SELECT p.spid, v.program

INTO v_pid, v_program

FROM v $ process p, v $ session v

WHERE p.addr = v.paddr

AND v.sid = v_sid;

V_os_user: = sys_context ( 'userenv', 'os_user');

Dbms_application_info.read_module (v_module, v_action);

Message: = to_char (SYSDATE, 'YYYYMMDD HH24MISS') ||

'Logon denied from' || nvl (ip, 'localhost') || '' ||

V_pid || '' || v_os_user || 'with' || v_program || '-' ||

V_module || '' || v_action;

Sys.dbms_system.ksdwrt (2, message);

ENDIF;

END;

2, the implementation of error information:

Compilation errors for TRIGGERTIMDBA.LOGON_DENIED_TO_ALERT

Error: PL / SQL: ORA-00942: table or viewdoes not exist

Line: 20

Text: SELECT sid INTO v_sid FROMsys.v_ $ mystat WHERE rownum < 2;

Error: PL / SQL: SQL Statement ignored

Line: 20

Text: SELECT sid INTO v_sid FROMsys.v_ $ mystat WHERE rownum < 2;

Error: PL / SQL: ORA-00942: table or viewdoes not exist

Line: 23

Text: FROM v $ process p, v $ session v

Error: PL / SQL: SQL Statement ignored

Line: 21

Text: SELECT p.spid, v.program

Error: PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared

Line: 35

Text: sys.dbms_system.ksdwrt (2, message);

Error: PL / SQL: Statement ignored

Line: 35

Text: sys.dbms_system.ksdwrt (2, message);

Solution

Grant execute on sys.dbms_system to timdba;

3, re-implementation is still being given:

Compilation errors for TRIGGER TIMDBA.LOGON_DENIED_TO_ALERT

Error: PL / SQL: ORA-00942: table or viewdoes not exist

Line: 20

Text: SELECT sid INTO v_sid FROMsys.v_ $ mystat WHERE rownum < 2;

Error: PL / SQL: SQL Statement ignored

Line: 20

Text: SELECT sid INTO v_sid FROMsys.v_ $ mystat WHERE rownum < 2;

Error: PL / SQL: ORA-00942: table or viewdoes not exist

Line: 23

Text: FROM v $ process p, v $ session v

Error: PL / SQL: SQL Statement ignored

Line: 21

Text: SELECT p.spid, v.program

Solution:

Grant select on sys.v_ $ mystat to timdba;

4, debugging error message again 3

Compilation errors for TRIGGERTIMDBA.LOGON_DENIED_TO_ALERT

Error: PL / SQL: ORA-00942: table or viewdoes not exist

Line: 23

Text: FROM v $ process p, v $ session v

Error: PL / SQL: SQL Statement ignored

Line: 21

Text: SELECT p.spid, v.program

Solution:

Grant select on sys.v_ $ process to timdba;

Grant select on sys.v_ $ session to timdba;
     
         
         
         
  More:      
 
- Linux process group, session daemon (Linux)
- AngularJS notes --- Data Binding (Programming)
- Change all child files and subdirectories in the owner permissions Ubuntu (Linux)
- How to deploy Python Web application: Heroku deployment process complete records (Server)
- 5 tips to improve your Linux desktop security (Linux)
- Ubuntu 14.04 LTS installed Hadoop 1.2.1 (distributed cluster mode) (Server)
- Oracle 12C RAC optimizer_adaptive_features cause of data into overtime (Database)
- Linux crontab commands and detailed usage examples (Linux)
- Denyhosts prevent hackers using SSH scanning (Linux)
- Python interview must look at 15 questions (Programming)
- Python developer of time-saving method (Programming)
- MongoDB polymerization being given (Database)
- C ++ Const breaking rules (Programming)
- Qt shared memory interprocess communication (Programming)
- Sort search algorithm Java - application examples with recursive dichotomy (Programming)
- To setup Cocos2dx project under Ubuntu (Linux)
- Java String and StringBuffer and StringBuilder Comments (Programming)
- Amazon EC2 server using Rsync + Inotify real-time synchronization (Server)
- Linux directory configuration (Linux)
- Effect MongoDB plan cache (Database)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.