Home > Error Accessing > Error Accessing Package Dbms_application_info Ora-06550

Error Accessing Package Dbms_application_info Ora-06550

Please don't fill out this field. TIA Sean followed up "segmentation fault..." July 06, 2003 - 8:14 pm UTC Reviewer: Sean It looked like you had answered my query, because it showed in today's asktom.com. Good judgement comes from experience. Oracle Application Server Release 2 URL's PROCEDURE TO START ORACLE APPLICATION SERVER 10g R... More about the author

But I am back to the original prob now. [aix]/home/oracle$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 23 00:02:01 2011 Copyright (c) 1982, 2010, Oracle. Promoted by Recorded Future Are you wondering if you actually need threat intelligence? I do not know how is it happening. Please don't fill out this field.

Anyways, I am able to connect now. Could it make a difference? 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 Senior Member Paste output of, select owner, object_type from all_objects where object_name='DUAL'; Report message to a moderator Re: SYS objects and Catproc Invalid [message #500710 is a reply

Register Forum Archives Databases Oracle Server Dbms_application_info Dbms_application_info - Oracle Server Hi Im a new user of oracle. Get 1:1 Help Now Advertise Here Enjoyed your answer? your SID or SERVICE it probably wrong in the tnsnames entry. Covered by US Patent.

locally, you just have the sid set in the environment -- it is not used on the "connect" string. SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 22 12:47:48 2011 Copyright (c) 1982, 2010, Oracle. Privacy Policy Site Map Support Terms of Use Ask Tom Sign In QuestionsArchivesPopularHotResourcesAbout Questionscannot connect to oracle 92 database Breadcrumb Question and Answer Thanks for the question, tammy. All rights reserved.

dbmsapin.sql 2. For example a 9.0.1 client can be used to connect to databases from 7.x (??) thru 10g. ALTER PACKAGE DBMS_APPLICATION_INFO COMPILE. Perl is a server-side tool as well so there really should be no requirement for the listener, in an environment with only one db installed on that server (as far as

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 http://www.justskins.com/forums/dbms_application_info-127917.html Asked: September 25, 2002 - 7:35 pm UTC Answered by: Tom Kyte – Last updated: June 13, 2008 - 7:50 am UTC Category: Database – Version: 9.2.0.1.0 Latest Followup You Asked Register Help Remember Me? Regards Michel Report message to a moderator Re: SYS objects and Catproc Invalid [message #500785 is a reply to message #500779] Wed, 23 March 2011 09:08 it_me24 Messages:

Join our community for more solutions or to ask questions. my review here There is absolutely no warranty for GDB; type "show warranty" for details. If not the new executable would not have been copied to $ORACLE_HOME/bin Reply With Quote 03-03-05,15:47 #9 midget View Profile View Forum Posts Visit Homepage Registered User Join Date Mar 2003 Thanks.

In short, I don't have sufficient data to diagnose this issue. Sign up for the SourceForge newsletter: I agree to receive quotes, newsletters and other information from sourceforge.net and its partners regarding IT services and products. Not what you want to hear, but it solves all the problems. http://axishost.net/error-accessing/error-accessing-package-dbms-application-info-10g.php Followup September 23, 2005 - 8:40 pm UTC i've never used perl, however -- a 10.1 client would need to use sqlnet to connect to 10.2 - are you a 10.1

And i have also applied patch 10 for my developer components. we can use TWO_TASK in unix (local in windows) as an enviroment variable to set the "default" connect string. Good luck!

In both cases tnsnames entry were exactly same.

All Rights Reserved. i am able to startup and shutdown the db without any problem. Followup September 24, 2005 - 8:06 am UTC there is always a client, unless you are the database itself. Oracle Database Advertise Here 802 members asked questions and received personalized solutions in the past 7 days.

BTW: Reading the Oracle documentation I did not understand a concept of having multiple database services. I was able to connect to the database as it was running, but after shutdown it is not possible anymore? Were they valid at any point in time? navigate to this website I understand that I can withdraw my consent at any time.

Cloning Oracle database/Hotbackup Restoration/Sync... Please help Followup June 11, 2008 - 8:14 am UTC see Note 286964.1 in metalink June 12, 2008 - 4:25 am UTC Reviewer: Asheesh Dhupper from India Dear Sir, I do this is pretty urgent, thank you for your help! Vincent If you would like to refer to this comment somewhere else in this project, copy and paste the following link: Anonymous Cancel Add attachments You seem to have CSS turned

Can you please give us a example of this (and how to configure this in init.ora)) //* A database can be presented as multiple services and a service can be implemented Who knows? symcjit.dll November 20, 2003 - 3:08 am UTC Reviewer: Tomas Ericson from Sweden Work Around: 1. Didn't expect any response on a Sat - but thanks!