Oracle 11g Error Accessing Package Dbms Application Info
first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 9 of 9 Thread: error accessing package "DBMS_APPLICATION_INFO" Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-22-04,12:47 #1 midget View Profile View Forum Posts Visit Homepage Registered User Join Date Mar 2003 Location SJ, Costa Rica Posts 48 Unanswered: error accessing package "DBMS_APPLICATION_INFO" Hi everybody! Everytime I log in oracle with the system user, I get the following message: Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-06509: PL/SQL: ICD vector missing for this package ORA-06512: at "SYSTEM.DBMS_APPLICATION_INFO", line 37 ORA-06512: at line 1 I've read something about that the package must be owned by the sys user, I ran several scripts but haven't resolved this yet. Any pointers about this? thanks in advance. regards, Reply With Quote 04-22-04,12:57 #2 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 looks like you ran CATALOG.SQL and/or CATPROC.SQL as a user other than SYS, see Note:1015902.4 on ways how to cure this, You can lead some folks to knowledge, but you can not make them think. The average person thinks he's above average! For most folks, they don't know, what they don't know. Good judgement comes from experience. Experience comes from bad judgement. Reply With Quote 04-22-04,13:01 #3 midget View Profile View Forum Posts Visit Homepage Registered User Join Date Mar 2003 Location SJ, Costa Rica Posts 48 where can I find this note? thanks! regards, Reply With Quote 04-22-04,13:04 #4 anacedent View Profile View Forum Posts Registered User Join Date Aug
be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredERROR:ORA-06550: line 1, column 7:PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredError accessing package DBMS_APPLICATION_INFOSP2-0575: Use of Oracle http://dbanote.blogspot.com/2009/11/error-accessing-package.html SQL feature not in SQL92 Entry Level.Solution I tried:I executed the below files after logging in as SYSDBASQL>@$ORACLE_HOME/rdbms/admin/dbmsotpt.sqlSQL>@$ORACLE_HOME/rdbms/admin/dbmsapin.sql Posted by Ragu Ponnusamy at 1:45 AM 1 comment: Srini said... Thank you https://oracle-base.com/articles/8i/dbms_application_info for this solution. It was just what I was looking for :). November 12, 2009 at 10:57 PM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments oracle 11g (Atom) ORACLE Database Docs Oracle Documentation (Main Page) Oracle11g Release 2 (11.2) Oracle11g Release 1 (11.1) Oracle10g Release 2 (10.2) Oracle10g Release 1 (10.1) Oracle9i Database 9.2 Oracle9i Database 9.0.1 Oracle8i Database 8.1.7 Oracle Application Server Docs Oracle10g Release 3 (10.1.3) Oracle10g Release 2 (10.1.2) Oracle10g (9.0.4) Oracle9i (9.0.2) Oracle Support and Software Oracle Sales Team Contact List Oracle Support (Metalink) oracle 11g error OTN (Oracle Software) E-Delivery (Oracle Software) About Me Ragu Ponnusamy Something to share my DBA Experience........ View my complete profile Archives ► 2011 (1) ► August (1) ► 2010 (15) ► June (1) ► May (4) ► April (2) ► March (2) ► February (6) ▼ 2009 (48) ► December (7) ▼ November (24) NUM_ROWS in ALL_INDEXES/USER_INDEXES/DBA_INDEXES h... How do I Select Oracle tables from Linked server (... How to Create SQL Server Linked Server? / Establis... How do I extract cpio file? How to change Solaris10 Hostname? ORA-20000: Oracle Text error: DRG-10599: column is... Cloning Oracle database/Hotbackup Restoration/Sync... ORA-01113 "Media Recovery" "DBA_REGISTRY" status "INVALID" after an upgrade Oracle Database Packages and Types INVALID status ... PROCEDURE TO SHUTDOWN ORACLE APPLICATION SERVER 10... Oracle Application Server Release 2 URL's PROCEDURE TO START ORACLE APPLICATION SERVER 10g R... How do I check USB drive connected to Solaris x86?... ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identif... ORA-00932: inconsistent datatypes: expected BLOB, ... PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be ... Error accessing package DBMS_APPLICATION_INFO ORA-04063: ORA-04063: package body "EXFSYS.DBMS_RL... How do I install Sample Schema in Oracle 10g
Social Links Printer Friendly About Search 8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux Home » Articles » 8i » Here DBMS_APPLICATION_INFO : For Code Instrumentation The DBMS_APPLICATION_INFO package allows programs to add information to the V$SESSION and V$SESSION_LONGOPS views to make tracking of session activities more accurate. Later releases of Oracle can make use of this information in auditing, SQL tracing and performance tuning. The dynamic performance views are not conventional views against tables, but wrappers over memory structures in the Oracle kernel, so the DBMS_APPLICATION_INFO package is writing the data to memory, which means there is very little overhead in using this functionalty. SET_MODULE SET_ACTION SET_CLIENT_INFO V$SESSION View Performance Analysis SET_SESSION_LONGOPS V$SESSION_LONGOPS View End-To-End Tracing From Java Instrumentation Library for Oracle (ILO) Related articles. SQL trace, 10046, trcsess and tkprof in Oracle DBMS_SESSION : Managing Sessions From a Connection Pool in Oracle Databases SET_MODULE Once a program makes a connection to the database it should register itself as a module using the SET_MODULE procedure. In doing so it also sets the initial action. The following code shows how to register a program called "add_order" and indicate it is currently attempting to add records to the "order" table. BEGIN DBMS_APPLICATION_INFO.set_module(module_name => 'add_order', action_name => 'insert into orders'); -- Do insert into ORDERS table. END; / SET_ACTION Subsequent processing should use the SET_ACTION procedure to reflect the current status or action of the session. Following on from the previous example, the program continues by adding records to the "order_lines" table, so the action is altered reflect this status change. BEGIN DBMS_APPLICATION_INFO.set_action(action_name => 'insert into order_lines'); -- Do insert into ORDER_LINES table. END; / SET_CLIENT_INFO The SET_CLIENT_INFO procedure can be used if any additional information is needed. It is useful to adding a little more context to the action, as shown in the example below. This should not be confused with the CLIENT_IDENTIFIER column, set using the DBMS_SESSION package. BEGIN DBMS_APPLICATION_INFO.set_action(action_name => 'insert into orders'); DBMS_APPLICATION_INFO.set_client_info(client_info => 'Issued by Web Client'); -- Do insert into ORDERS table. END; / V$SESSION View The information set by these procedures can