Solved

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

Posted on 2001-06-28
5
2,121 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
use lov values 2 72
best datatype for oracle table email creation 8 78
error in my cursor 5 51
how to tune the query 17 63
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

730 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