in the end. 2) Had to run utlirp.sql when database is in migration mode. (remember I ported the db from 32 bit to 64 bit). Delete the question. The Oracle version is 8.1.7 and the operating system is Win 2000 server. Experience comes from bad judgement. http://axishost.net/error-accessing/error-accessing-package-dbms-application-info-10g.php
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 This post really helped me after porting the DB from 32 to 64 bit. Still accepting suggestions regards, Reply With Quote 04-22-04,14:05 #8 SkyWriter View Profile View Forum Posts Registered User Join Date Jan 2004 Posts 370 Did you shutdown all instances when you relinked? 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. view publisher site
You will have to drop these packages and rerun catproc as SYS. 3) Try running "catalog.sql" and "catproc.sql" while opening a spool file to catch any errors that may have occurred. END; / SET_ACTION Subsequent processing should use the SET_ACTION procedure to reflect the current status or action of the session. Can you check for the SGA size of your database: SVRMGR> show sga I feel (as sbenyo suggested) either you have wrongly entered the shared_pool_size parameter or you have given a You may need to run PUPBLD.SQL as SYSTEM ORA-24323: value not allowed Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-03114: not connected to ORACLE Use of Oracle SQL feature not in SQL92 Entry
Like this:Like Loading... Forgot your password? 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 Solved Cannot connect to Sql*Plus Posted on 2000-11-21 Oracle Database 1 Verified Solution 8 Comments 1,332 Views Last Modified: 2012-05-04 Hello, we've got the following problems: 1.We received an error :
totalwork Any number the client wants to store. Your options are: 1. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process. 4. ORA-24323: value not allowed Connected to: Oracle8 Enterprise Edition Release 22.214.171.124.0 - Production PL/SQL Release 126.96.36.199.0 - Production 3.
Report message to a moderator Re: Error accessing package dbms_application_info [message #507363 is a reply to message #507359] Sat, 14 May 2011 08:48 BlackSwan Messages: 24930Registered: January 2009 The maximum length is 64 bytes. Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 The AWR Report includes the module in all the reported SQL statistics.
You should probably set the action name before the start of every transaction. https://www.experts-exchange.com/questions/11934818/Cannot-connect-to-Sql-Plus.html This make it a more scalable solution, since extra calls to the database are not required. Error Accessing Package Dbms_application_info Solution who is "you"? virginie faraj Apr 01, 2005, 09:48 May be your connection has timed out.disconnect yo......
Try aggain and if the problem remain check the program. my review here Operational Notes Your applications should set the name of the module and name of the action automatically each time a user enters that module. Example This example performs a task on 10 objects in a loop. http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt Please click the Help Desk link on the left for Member Guidelines, Member Agreement and the Question/Answer process.
Good judgement comes from experience. You can lead some folks to knowledge, but you can not make them think. http://www.experts-exchange.com/questions/Q.20066400.html http://www.experts-exchange.com/questions/Q.20013177.html http://www.experts-exchange.com/questions/Q.20068655.html http://www.experts-exchange.com/questions/Q.20074482.html http://www.experts-exchange.com/questions/Q.20074638.html http://www.experts-exchange.com/questions/Q.20084905.html http://www.experts-exchange.com/questions/Q.11676419.html http://www.experts-exchange.com/questions/Q.11934818.html PLEASE DO NOT AWARD THE POINTS TO ME. ------------> EXPERTS: Please leave any comments regarding your closing recommendations if this item http://axishost.net/error-accessing/error-accessing-package-dbms-application-info-ora-06550.php Oracle Database Advertise Here 804 members asked questions and received personalized solutions in the past 7 days.
Examples The following sample query illustrates the use of the MODULE and ACTION column of the V$SQLAREA. Delete the question (if it has no potential value for others). --> Post comments for expert of your intention to delete and why --> You cannot delete a question Question(s) below appears to have been abandoned.
Wisse 14750 7 T. 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 It appears as the TARGET column of v$session_longops. For most folks, they don't know, what they don't know.
The ASH Report includes a breakdown of activity based on Service/Module. Do the following: 1) Check the status of the package STANDARD using: connect sys/
The time now is 05:33 AM. Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Oracle error accessing package "DBMS_APPLICATION_INFO" If this is your first Force-accepted by Netminder CS Moderator 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. FLASHBACK Database Oracle 11Gr2 Installation Pre-Task ► 2010 (83) ► December (5) ► November (4) ► October (4) ► September (15) ► August (12) ► July (9) ► June (12) ►
All rights reserved. If your environment is unix you can check the memory status with: ulimit -a Also be sure you've set the default kernel parameters in the /etc/system file as oracle requires (and Check the database status using svrmgr30 on the server machine with: select Go to Solution 8 Comments LVL 3 Overall: Level 3 Oracle Database 3 Message Expert Comment by:bkowalski2000-11-21 Are ADMINISTRATION WILL BE CONTACTING YOU SHORTLY.
Now for the problem itself: What happens in your case is that you are trying to create an SGA size more than the possible size of you memory. 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 Moondancer Moderator @ Experts Exchange P.S. Verify that all mandatory parameters are properly initialized.
Syntax DBMS_APPLICATION_INFO.SET_CLIENT_INFO ( client_info IN VARCHAR2); Parameters Table 19-5 SET_CLIENT_INFO Procedure Parameters Parameter Description client_info Supplies any additional information about the client application. To view your open questions, please click the following link(s) and keep them all current with updates.