Solved

ORA-06553: PLS-707: unsupported construct or internal error [2603]

Posted on 2001-06-28
5
2,036 Views
Last Modified: 2012-06-27
I have migrated my database from 8.1.6 to 8.1.7. When connecting to the database using SQLPLUS, I get the ORA-06553: PLS-707: unsupported construct or
  internal error [2603] twice.
 The second error notes the following:
 Error accessing package DBMS_APPLICATION_INFO



0
Comment
Question by:Intikhab
5 Comments
 
LVL 1

Expert Comment

by:ashokskumar
ID: 6234742
Hi,

Run the pupbld package in <ORACLE_HOME>/rdbms/admin from sqlplus as system.

Ashok.
0
 
LVL 3

Expert Comment

by:mathavra
ID: 6234877
This seems like bug 1281320. There is a patch available on 8.1.7. I do not think that it is available via Metalink. You can request via iTAR.
0
 
LVL 3

Accepted Solution

by:
mathavra earned 50 total points
ID: 6234891
I found the following from Metalink:

fact: MS Windows 2000
fact: MS Windows NT
fact: Oracle Server - Enterprise Edition 8.1.7
fact: Oracle Enterprise Manager 2.2
symptom: Oracle Management Server
symptom: Oracle Management Server (OMS) service does not exist
symptom: Enterprise Manager Configuration Assistant (EMCA) shortcut does not exist
symptom: emca.bat file not installed in $ORACLE_HOME\bin
symptom: Database connection fails
symptom: ORA-06553: PLS-707 Unsupported construct or internal error [2603]
symptom: Error accessing package DBMS_APPLICATION_INFO
change: Upgraded the Database from Oracle Server - Enterprise Edition 8.1.6 to 8.1.7
cause: Problems with Oracle Procedural Option. Reference BUG:1281320.

fix:

Rerun catalog.sql and catproc.sql scripts logged as SYS or internal from server manager at the database (You already did this).

Reinstall Oracle Management Server from custom install option in OEM 2.2, Management Framework, to build the EMCA shortcut on the desktop.
.

Hope this helps.
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7052522
Hi Intikhab,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. If there is no objection or further activity, I will suggest to:

    Accept mathavra's comment(s) as an answer.

Intikhab, if you think your question was not answered at all, you can post a request in Community Support and ask them to delete this question and refund your points (please include a link to this
Question: http:Q.20142872.html in any posts to Community Support).
If you want to post to Community Support, click here:
      http://www.experts-exchange.com/jsp/qAskQuestion.jsp?ta=commspt

Please do not accept this comment as an answer!

EXPERTS: Your input for closing recommendations is appreciated.
==========
DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7054038
Thanks, Dan.
I finalized this today and will monitor it in the event an adjustment is needed.
Moondancer - EE Moderator
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now