RE: Trying to run catproc.sql with no luck.

I agree. The alert log whould tell you what is happening. The Oracle install process is still not as clean as it should be. My guess is that the database crashed. Probably an init.ora param is incorrect.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Tim Johnston [mailto:tjohnston_at_quallaby.com] Sent: Friday, February 20, 2004 5:42 PM
To: oracle-l_at_freelists.org; tday6_at_csc.com Subject: Re: Trying to run catproc.sql with no luck.

What's in the alert log? Any trace files being generated?

Thomas Day wrote:

>Windows 2K, Oracle 9.2.
>
>Any ideas gratefully accepted (except change operating system - that's not
>within my scope).
>
>SQL> DECLARE
> 2 vt sys.re$variable_type_list;
> 3 BEGIN
> 4 vt := sys.re$variable_type_list(
> 5 sys.re$variable_type('DML', 'SYS.LCR$_ROW_RECORD',
> 6 'SYS.DBMS_STREAMS_INTERNAL.ROW_VARIABLE_VALUE_FUNCTION',
> 7 'SYS.DBMS_STREAMS_INTERNAL.ROW_FAST_EVALUATION_FUNCTION'),
> 8 sys.re$variable_type('DDL', 'SYS.LCR$_DDL_RECORD',
> 9 'SYS.DBMS_STREAMS_INTERNAL.DDL_VARIABLE_VALUE_FUNCTION',
> 10 'SYS.DBMS_STREAMS_INTERNAL.DDL_FAST_EVALUATION_FUNCTION'));
> 11
> 12 dbms_rule_adm.create_evaluation_context(
> 13 evaluation_context_name=>'SYS.STREAMS$_EVALUATION_CONTEXT',
> 14 variable_types=>vt,
> 15 evaluation_function=>
> 16 'SYS.DBMS_STREAMS_INTERNAL.EVALUATION_CONTEXT_FUNCTION');
> 17 EXCEPTION WHEN OTHERS THEN
> 18 IF SQLCODE = -24145 THEN
> 19 -- suppress evaluation context already exists error to minimize
> 20 -- unwanted noise during upgrade.
> 21 NULL;
> 22 ELSE
> 23 RAISE;
> 24 END IF;
> 25 END;
> 26 /
>
>PL/SQL procedure successfully completed.
>
>SQL>
>SQL> begin
> 2 dbms_rule_adm.grant_object_privilege(
> 3 privilege=>dbms_rule_adm.EXECUTE_ON_EVALUATION_CONTEXT,
> 4 object_name=>'SYS.STREAMS$_EVALUATION_CONTEXT',
> 5 grantee=>'PUBLIC', grant_option=>FALSE);
> 6 end;
> 7 /
>begin
>*
>ERROR at line 1:
>ORA-03113: end-of-file on communication channel
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>

-- 
Regards,
Tim Johnston
Tel: 978-322-4226
Fax: 978-322-4100


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------