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@(protected)]
Sent: Friday, February 20, 2004 5:42 PM
To: oracle-l@(protected); tday6@(protected)
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 (See ORA-03113.ora-code.com): 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@(protected)
>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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
