Cecil,
That error mesage usually indicates that you have invalid packages after the
patch upgrade. Did you run:
svrmgrl>@?/rdbms/admin/catalog.sql
svrmgrl>@?/rdbms/admin/catproc.sql
svrmgrl>@?/rdbms/admin/utlrt.sql
after the patch installation. Check the patch release notes for the exact
commands syntax. I do not have the exact last line from the top of my head.
Check the latest Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
Hope that helps,
Trifon Anguelov
Senior Oracle DBA
http://www.dbaclick.com
"Cecil D'Souza" <cecildsouza_at_comcast.net> wrote in message
news:I%BD8.151160$q8.15660861_at_bin3.nnrp.aus1.giganews.com...
> Hello
>
> I have installed oracle 8.1.6.2 on the SUN sparc 20. (solaris 8). I
created
> a user but when I login at the SQL plus prompt, I get the following
errors.
> ORA-04068: existing state of package has been discarded.
> ORA-04067: not executed, package body 'SYSTEM.DBMS_OUTPUT' does not exist
> ORA-06508: PL/SQL could not find the program unit being called
> ORA-06512: at line 1
>
> I have checked the errors on the web. The joke about Oracle's error
messages
> is that they say the following:
>
> ORA-04067 not executed, string does not exist
> Cause: Attempt to execute a non-existent stored procedure.
> Action: Make sure that a correct name is given.
>
> ORA-04068 existing state of packagesstringstringstring has been discarded
> Cause: An error occurred when attempting to execute a stored procedure.
> Action: Refer to the accompanying messages and fix the error mentioned.
Try
> the procedure again after proper reinitialization of any application's
> state.
>
>
> IT DOES NOT SAY HOW TO SOLVE THE PROBLEM.
>
> I would like to know what I have to do to avoid getting this error each
time
> I log in whether as a user or SYS or SYSTEM, the error is the same. Have I
> missed out on running any scripts after installation?.
>
> Thanks for all the help
>
> Cecil
>
>
>
>
>
Received on Sun May 12 2002 - 18:27:48 CDT
