RV: Ever seen any of these errors?

Hi,
I believe that you must be connectd as SYS or Internal and you must to run the script catproc.sql
PATH: .../product/.../rdbms/admin/catproc.sql

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, August 01, 2001 5:51 PM

> Our Financials production database server crashed last week. When it came
> back up Oracle seemed to come up with no errors, everything connected
> properly, etc. That evening the SA rebooted the machine to turn on
> diagnostics for Sun. Oracle shutdown normally but after it came back up I
> started getting paged that some of the Financials processes weren't
working.
> I tried to start them and failed so I began poking around. When I logged
> into SQL*Plus I got errors. Unfortunately I didn't start writing things
> down until I had it 90% fixed :-{ but I *think* this was the order. I
> backed up before and after. Then, after each step, I recompiled any
invalid
> objects in the database. I ran sqlplus /nolog, then connect internal,
both
> for consistancy and to run the $ORACLE_HOME/rdbms/admin scripts.
>
> 1) ORA-06553: PLS-213: PACKAGE STANDARD not accessible
> Error accessing package DBMS_APPLICATION_INFO
> I checked for invalid objects, one _next_object (which appears to be a
bug)
> and a Financials package that is always invalid.
> 2) OK, let's try to recreate STANDARD. Ran the script, no errors....
> SQL*Plus is still complaining.
> 3) Somewhere along the line I saw references to catalog and catproc on
> Metalink. After some more searching, I decided I didn't have anything to
> lose. Ran catalog without errors. Catproc had errors in a number of
> places. I got dbms_output errors:
> create or replace package dbms_output as
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00001: unique constraint (SYS.I_OBJ2) violated
> Hmmmm, it's doing 'create or replace', something's fishy....
> Got a 'ORA-00921: unexpected end of SQL command' when it was running
> catqueue.sql.
> Got the errors:
> create or replace type sys.aq$_dummy_t as object (data char(1));
> *
> ERROR at line 1:
> ORA-6545: PL/SQL: compilation error - compilation aborted
> ORA-06550: line 2, column 1:
> PLS-00103: Encountered the symbol "GRANT"
> ORA-06550: line 0, column 0:
> PLS-00565: AQ$_DUMMY_T must be completed as a potential REF target
> (object type)
> These were the only error messages (other than dropping non-existant
indexes
> and those type of messages).
> 4) I reran catproc, now the STANDARD errors are gone in SQL*Plus! But,
when
> I logged in then I got:
> PLS-00201: identifier DBMS_OUTPUT.DISABLE must be declared
> and
> Use of Oracle SQL feature not in SQL92 Entry Level
> 5) I changed catqueue.sql to get rid of a blank line and fixed the ORA-921
> error.
> 6) In prvtaq.plb I removed the ; at the end of the first line and inserted
a
> / on the second line to fix the sys.aq$_dummy_t error messages
> 7) Reran catproc again (I actually ran it twice, once after each script I
> changed). Finally, no errors, including the DBMS_OUTPUT.DISABLE!
> 8) Logged into SQL*Plus with no errors!
>
> Whew! So what could have caused the problems to begin with? There were
no
> errors in the alert log. I ran dbv on all the datafiles, everything was
> clean. The server crashed because of a bad processor, not because of a
bad
> disk (that was the development box on Sunday :-} ). No core dumps. I
> especially love the unique constraint violation on sys.i_obj2....
>
> I count myself lucky, I didn't have to call Support, we didn't have
problems
> until after the reboot at 8:30 pm instead of during the middle of the day,
> and it's been a week without any other problems.
>
> Thanks!
>
> Linda
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seley, Linda
> INET: LSeley_at_IQNavigator.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Natalia Laracca
  INET: nlaracca_at_afip.gov.ar

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).