Error Accessing Package Dbms_application_info 11g
#113364] Fri, 01 April 2005 11:38 poaudain Messages: 5Registered: March 2005 Junior Member Hello! While accessing to my database using sql*plus or error accessing package dbms_application_info solution others utility, I find this message "Error accessing package DBMS_APPLICATION_INFO", "Package error accessing package dbms application info 10g Standard not accessible". When I go on DBA Studio I find that the package is invalid and I can compile it. Could anyone help me please? PS. The Oracle version is 8.1.7 and the operating system is Win 2000 server. Report message to a moderator Re: Error accessing package dbms_application_info [message #113514 is a reply to message #113364] Mon, 04 April 2005 06:03 Maaher Messages: 7062Registered: December 2001 Senior Member I'd say: reinstall the package: Connect as SYS and run the standard.sql file. HTH, MHE Report message to a moderator Re: Error accessing package dbms_application_info [message #226506 is a reply to message #113364] Sat, 24 March 2007 06:16 tndeepakbharadwaj Messages: 3Registered: March 2007 Location: Chennai, India Junior Member The same can be rectified by executing catalog.sql and catproc.sql from $ORACLE_HOME/rdbms/admin dir which will re-create the data dictionary Report message to a moderator Re: Error accessing package dbms_application_info [message #226523 is a reply to message #113364] Sat, 24 March 2007 09:38 BlackSwan Messages: 24930Registered: January 2009 Location: SoCal Senior Member tndeepakbharadwaj, I suspect that you really are/were trying to be helpful, but responding to a post that is almost TWO years old might be considered less than 100% useful. Report message to a moderator Re: Error accessing package dbms_application_info [message #323121 is a reply to message #113364] Tue, 27 May 2008 06:23 debajyoti Messages: 5Registered: April 2007 Junior Member Hi, I am facing the same problem but while tr
06:58 AM Post #1 Newbie Group: Members Posts: 5 Joined: 1-April 08 Member No.: 20,235 Hi All,All of a sudden one of the oracle database that I am managing is not allowing any one it is displaying the message 'Error accessing package DBMS_APPLICATION_INFO'While trying to run standard.sql the database is almost in a hanged state. Please http://www.orafaq.com/forum/t/42974/ suggest.RegardsDev burleson View Member Profile May 27 2008, 08:03 AM Post #2 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 Hi Dev, and welcome to the forum!>> 'Error accessing package DBMS_APPLICATION_INFO'Did you run $ORACLE_HOME/rdbms/admin/standard.sql as the SYS user?If the database "hangs", I would bounce him, and verofy that http://dbaforums.org/oracle/index.php?showtopic=12066 standard.sql was run peoperly.Sometimes, hanging can be a result of locking. Hanging in export can occur for a variety of reasons, and you can check check v$session_wait for details, or run a 10046 trace to see exactly what's wrong. If you want complete details on Oracle Troubleshooting, I published a book on it:http://www.rampant-books.com/book_2003_1_perf.htm -------------------- Hope this helps. . . Donald K. BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference debajyoti View Member Profile May 28 2008, 01:22 AM Post #3 Newbie Group: Members Posts: 5 Joined: 1-April 08 Member No.: 20,235 Hi Don,It got solved.However now the db is giving a new probelm.when I am trying to run catproc.sql file I am getting the error message ERROR:ORA-03114: not connected to ORACLEEnter value for wpi_file_var:Enter value for owa_file_var:when I am trying to run utlrp.sql I am getting the message Please-00201: identifier 'DBMS_REGISTRY_SYS.VALIDATE_COMPONENTS' must be declaredselect object_name, object_type, status, owner from dba_objects where status='INVALID';5231 rows
later use when tracking the performance of various modules and debugging. This chapter contains the following topics: Using DBMS_APPLICATION_INFO Overview Security Model Operational Notes Summary of DBMS_APPLICATION_INFO Subprograms Using DBMS_APPLICATION_INFO Overview Security Model Operational Notes Overview https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_appinf.htm Registering the application allows system administrators and performance tuning specialists to track performance https://dbhk.wordpress.com/2015/02/04/error-accessing-package-dbms_application_info/ by module. System administrators can also use this information to track resource use by module. When an application registers with the database, its name and actions are recorded in the V$SESSION and V$SQLAREA views. Security Model Note: The public synonym for DBMS_APPLICATION_INFO is not dropped before creation so that you can redirect the error accessing public synonym to point to your own package. No further privileges are required. The DBMSAPIN.SQL script is already run as a part of standard database creation . Operational Notes Your applications should set the name of the module and name of the action automatically each time a user enters that module. The module name could be the name of a form in an Oracle Forms application, error accessing package or the name of the code segment in an Oracle Precompilers application. The action name should usually be the name or description of the current transaction within a module. If you want to gather your own statistics based on module, you can implement a wrapper around this package by writing a version of this package in another schema that first gathers statistics and then calls the SYS version of the package. The public synonym for DBMS_APPLICATION_INFO can then be changed to point to the DBA's version of the package. Summary of DBMS_APPLICATION_INFO Subprograms Table 19-1 DBMS_APPLICATION_INFO Package Subprograms Subprogram Description READ_CLIENT_INFO Procedure Reads the value of the client_info field of the current session READ_MODULE Procedure Reads the values of the module and action fields of the current session SET_ACTION Procedure Sets the name of the current action within the current module SET_CLIENT_INFO Procedure Sets the client_info field of the session SET_MODULE Procedure Sets the name of the module that is currently running to a new module SET_SESSION_LONGOPS Procedure Sets a row in the V$SESSION_LONGOPS table READ_CLIENT_INFO Procedure This procedure reads the value of the client_info field of the current session. Syntax DBMS_APPLICATION_INFO.READ_CLIENT_INFO ( client_info OUT VARCH
database from 7.3.4.0 to Oracle 12c1, some old oracle 7.3.4 clients showed the errors below Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-06550: line 1, column 40: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated When asking oracle support, of course, they said that it was not support and upgraded to latest clients.Luckly, I found that it was caused by the database character set. After I recreated the database with the default characeter set WE8MSWIN1252. The problem was fixed. Like this:Like Loading... Related Categories: ORA-XXX Comments (0) Trackbacks (0) Leave a comment Trackback No comments yet. No trackbacks yet. Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. sendmail show "domain.com: Name servertimeout" Dynamic reconfiguration of the virtual device on domain failed with error code(-122). RSS feed Google Youdao Xian Guo Zhua Xia My Yahoo! newsgator Bloglines iNezha Recent Posts DBCA, running on oracle zone, pops up "Out ofMemory"ORA-00392: log 1 of thread 1 is being cleared, operation notallowedvnet: [ID 214931 kern.info] vnet0: vnet_addmac: programming macaddr(2:8:20:ad:ea:21) is notsupportedORA-27054: NFS file system where the file is created or resides is not mounted with correctoptionsORA-01157: cannot identify/lock data file 44 - see DBWR tracefilesendmail show "domain.com: Name servertimeout"Error accessing package DBMS_APPLICATION_INFODynamic reconfiguration of the virtual device on domain failed with error code(-122).[ctssd(1883)]CRS-2409:The clock on host XXXXX is not synchronous with the mean cluster time. No action has been taken as the Cluster Time Synchronization Service is running in observermode.ORA-15031: disk specification matches nodisks Categories Administration Administration with ASM ADR apache ASM Audit clusterware Data