Repository Object Navigator problem

[Guest_imported]

hi all!
i'm facing problem in Repository Object Navigator and am unable to use Designer6i

When I try to open Repository Object Navigator, it is giving following errors:

1. ORA-04068:"existing state of packages has been discarded"


Cause: One of errors 4060 - 4067 when attempt to execute a stored
procedure.
Action: Try again after proper re-initialization of any application's
state.


2. ORA-04063,package body CDAPI has errors"
Cause: Attempt to execute a stored procedure or use a view that has
errors. For stored procedures, the problem could be syntax errors
or references to other, non-existent procedures. For views,
the problem could be a reference in the view's defining query to
a non-existent table.
Action: Fix the errors and/or create referenced objects as necessary.

3. ORA-06508: "PL/SQL: could not find program unit being called"

4. ORA-06512: at line 1

Cause: Backtrace message as the stack is unwound by unhandled
exceptions.
Action: Fix the problem causing the exception or write an exception
handler for this condition. Or you may need to contact your
application administrator or DBA.
5. RME-02124: Failed to execute SQL statement: begin :stacksize := cdapi.stacksize; if cdapi.stacksize > 0 then cdapi.pop_messagefac,:code,0,1,2,3,4,5,6,7); end if; end;
Cause : An error occurred while executing a SQL statement.
Action : Examine reported errors for specific details.

Can you please suggest the possible cause and solutions to this problem?

 

[tigreeuropeo]

These errors are caused by the INVALID status of the packages and package bodies that you are trying to execute.
Check the status of the packages owned by SYS and SYSTEM users from SQL*Plus:

connect sys/password@mydb as sysdba;
select owner, object_name
from dba_objects
where status = 'INVALID' and
owner in ('SYS','SYSTEM','REP_OWNER') and
status = 'INVALID'
order by 1,2;

You have to recompile every package that is in this INVALID status using:
alter package <package_name> compile;
alter package <package_name> compile body;
Remember that there are a lot of dependencies between packages in the repository, so maybe you'll have to issue this statements several times until every package is VALID.
Good Luck.

 

[JFlack]

Why fix this the hard way? Go into the Repository Administration Utility, and press the Recreate button. One of the options under that button is &quot;Recompile Objects&quot;. Select this, press Start, and it will recompile everything, and will stop if there is a problem.