Error Accessing Package Dbms_application_info Ora-06550
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 Guard DB Tuning impdp Installation LDom mySQL trouble
Catproc Invalid [message #500634] Tue, 22 March 2011 09:18 it_me24 Messages: 167Registered: March 2006 Location: delhi Senior Member Hello Everybody, I am getting below error while connecting to sqlplus. SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 22 12:47:48 2011 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. ERROR: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared ORA-06550: line 1, column https://dbhk.wordpress.com/2015/02/04/error-accessing-package-dbms_application_info/ 7: PL/SQL: Statement ignored ERROR: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Error accessing package DBMS_APPLICATION_INFO SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level Executed the below scripts but it didnt resolve the issue, http://www.orafaq.com/forum/t/169584/ whereas some of the SYS objects and catproc got invalid... dbmsotpt.sql dbmsapin.sql Now even after reexecuting the catproc.sql and utlrp...Sys objects and the catproc status is still INvalid. I tried to manually compile the sys objects, but it didnt work. OWNER SUBSTR(OBJECT_NAME,1,40) OBJECT_TYPE -------------------- ---------------------------------------- -------------------- SYS DBMS_XPLAN PACKAGE BODY SYS AQ$AQ_SRVNTFN_TABLE VIEW SYS DBMS_LOGREP_DEF_PROC PACKAGE SYS DBMS_LOGREP_DEF_PROC PACKAGE BODY SYS INITJVMAUX PACKAGE BODY SYS XMLDOM SYNONYM SYS XMLPARSER SYNONYM SYS XSLPROCESSOR SYNONYM SYS SQLJUTL PACKAGE SYS XMLVALIDATE PROCEDURE SYS DBMS_XQUERYINT PACKAGE BODY OWNER SUBSTR(OBJECT_NAME,1,40) OBJECT_TYPE -------------------- ---------------------------------------- -------------------- SYS _DBA_REGISTERED_ARCHIVED_LOG VIEW SYS KU$_XMLSCHEMA_VIEW VIEW SYS AQ$_SCHEDULER$_JOBQTAB_F VIEW SYS AQ$SCHEDULER$_JOBQTAB VIEW SYS AQ$SCHEDULER$_JOBQTAB_R VIEW SYS AQ$_SCHEDULER$_EVENT_QTAB_F VIEW SYS AQ$SCHEDULER$_EVENT_QTAB_R VIEW SYS AQ$_AQ$_MEM_MC_F VIEW SYS AQ$_ALERT_QT_F VIEW SYS AQ$ALERT_QT_R VIEW SYS PRVT_ADVISOR PACKAGE BODY OWNER SUBSTR(OBJECT_NAME,1,40) OBJECT_TYPE -------------------- ---------------------------------------- -------------------- SYS DBMS_SQLTUNE_INTERNAL PACKAGE BODY SYS DBMS_SQLTUNE PACKAGE BODY SYS AQ$_AQ_SRVNTFN_TABLE_F VIEW SYS SQLJUTL PACKAG
Old Discussions [ReadOnly] OCILIB - C and C++ Driver for Oracle Open source https://sourceforge.net/p/orclib/discussion/470800/thread/dfb46863/ C and C++ library for accessing Oracle Databases Brought to you by: vince_del_paris Summary Files Reviews Support Tickets ▾ Bugs Support Requests Feature Requests Patches Old Mailing Lists [ReadOnly] Old Discussions [ReadOnly] Create Topic Stats Graph Forums OCILIB general discussions (ReadOnly - Use GitHub tracker instead) 92 OCILIB error accessing troubleshooting (ReadOnly - Use GitHub tracker instead) 230 Help Formatting Help Problem connectiong (it's not a typical conn) Forum: OCILIB troubleshooting (ReadOnly - Use GitHub tracker instead) Creator: Nobody/Anonymous Created: 2008-05-30 Updated: 2012-09-26 Labels: Nobody/Anonymous - 2008-05-30 Hi, my problem is that I am trying to connect error accessing package to a database server with "Oracle Network Manager", so when I am using SQLplus console it works with the following command: CONNECT user/password@"(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 194.14.3.)(PORT = 1630))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.1..*)(PORT = 1521)))(SOURCE_ROUTE = yes)(CONNECT_DATA =(SERVICE_NAME = INFAbase))) " This is the output: " ERROR: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored ERROR: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Error accessing package DBMS_APPLICATION_INFO Connected. " The are two errors, but may be they are not critical, because I am able to execute some sql statements. But when I am using ocilib the following calling of function "OCI_ConnectionCreate" returns FALSE; cn = OCI_ConnectionCreate("\"(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 194.14.3.)(PORT =