Dbms_application_info

Hello, i have created a new database IMD510.
i am able to startup and shutdown the db without any problem.
i am able also to access the db

SQL> connect sys/manager as sysdba
Connected to an idle instance.

BUT i am not able to connect into it when i access in the way specified below:

hostname% sqlplus system/manager@IMD510

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Mar 22 17:58:57 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

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-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_APPLICATION_INFO" does not
exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

Error accessing package DBMS_APPLICATION_INFO

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production

Please note that i've already run standard.sql, dbmsapin.sql, dbmsstdx.sql

Mar 22 '06 #1

Subscribe Post Reply

6842

Rena

Hello, i have created a new database IMD510.
i am able to startup and shutdown the db without any problem.
i am able also to access the db

SQL> connect sys/manager as sysdba
Connected to an idle instance.

BUT i am not able to connect into it when i access in the way specified below:

hostname% sqlplus system/manager@IMD510

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Mar 22 17:58:57 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

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-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_APPLICATION_INFO" does not
exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

Error accessing package DBMS_APPLICATION_INFO

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production

Please note that i've already run standard.sql, dbmsapin.sql, dbmsstdx.sql

Please note that after running catalog.sql and catproq.sql i have now the following error:

hostname% sqlplus system/manager@IMD510

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Mar 22 23:12:30 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYSTEM.DBMS_APPLICATION_INFO" does not
exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

Error accessing package DBMS_APPLICATION_INFO

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production

Mar 22 '06 #2

by: Andre | last post by:

Hello all, I have made a procedure which is running a very, very long time (about 20 hours) Within the procedure I put some output-lines, to show the user that the procedure is still running....

Oracle Database

Tools for debug PL/SQL

by: Julia Sats | last post by:

Please advise what tools good for debugging PL/SQL: a) commercial b) free I tried some of them but they not to good work with debugging inside packages. Any opinions welcome.

Oracle Database

Function used in where clause - executed too many times

by: Christian | last post by:

HI, I have a function that is used to constrain a query: Select COl1, Col2 From MyTable WHERE col1 = ... AND col2 = ... And MyFunction(col1) = ... My problem is that MyFunction is executed...

Oracle Database

how to do dbms_application_info.set_module from JDBC code

by: Digvijay Lamba | last post by:

Hi, I want to use the Oracle dbms_application_module's set_module and set_action functionality for tracing my calls. However my client uses JDBC to connect. I can't find how I can make sure the...

Oracle Database

Find out the percentage complete of Stored Procedure

by: nitinsharma717 | last post by:

hi, In my code i have to increment progress bar based on percentage completion of Stored Procedure.I am not to get any solution on this. Please Help me on this issue. I am using win forms...

Microsoft SQL Server

How to check if oracle stored procedure already running

by: rash123 | last post by:

How can i check if a oracle stored procedure is already already running

Software Development

How can we Check if Oracle stored procedure already running

by: rash123 | last post by:

Hi all , Please help me on the the following query How can we Check if Oracle stored procedure already running

Oracle Database

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Dbms_application_info

Similar topics