Error Accessing Package Dbms Application Info Oracle
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 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 http://metalink.oracle.com but access to it requires a support contract/CSI number. As SYS do the following: 1. Rerun CATPROC.SQL. 2. Rerun DBMSUTIL.SQL. 3. AL
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 suggest.RegardsDev burleson View Member Profile May 27 2008, 08:03 AM Post #2 Advanced Member Group: Members Posts: 13,227 http://www.dbforums.com/showthread.php?995294-error-accessing-package-quot-DBMS_APPLICATION_INFO-quot 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 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 http://dbaforums.org/oracle/index.php?showtopic=12066 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 selected.all the sys owned objects are invalid.Please suggest.RegardsDev burleson View Member Profile May 28 2008, 08:34 AM Post #4 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 Hi Dev,>> ORA-03114Did you connect in SQL*Plus first, before running it?Here is how to troubleshoot the ORA-03114http://www.dba-oracle.com/t_ora_03114.htm -------------------- Hope this helps. . . Donald
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: https://dbhk.wordpress.com/2015/02/04/error-accessing-package-dbms_application_info/ 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, http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=62560 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. error accessing 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 error accessing package 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 do
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | No question at this time DBA Top 10 1 M. Cadot 37400 2 F. Diaz 33800 3 J. Schnackenberg 18400 4 B. Vroman 16350 5 A. Kavsek 15950 6 P. Wisse 14750 7 T. Boles 14400 8 M. Hidayathullah ... 11500 9 A. Hudspith 8600 10 A. Khan 4400 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47779Total active users2112Act. users last 24h3Act. users last hour2Registered user hits last week561Registered user hits last month6457 Go up ERROR: ORA-06553: PLS-801: internal error [56319] Error accessing package DBMS_APPLICATION_INFO Next thread: Help Reqquires in SQL Loader Prev thread: Insert record based on insert in another table is different schema Message Score Author Date Hi everybody, Plz help me in resolving this iss...... krishna kongara Apr 26, 2013, 11:19 please guide me in resolving the issue....... krishna kongara Apr 26, 2013, 11:20 Maybe you should learn to read:
DOC> The...... Michel Cadot Apr 26, 2013, 11:32 Thnks for the reply... i Did the Same thing and...... krishna kongara Apr 26, 2013, 11:45 i hope it's better that if you do the same t