Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problems when creating a 9i database
i_rahim_at_hotmail.com (Imran Rahim) wrote in message news:<e7519cfe.0305050451.2de87a52_at_posting.google.com>...
> Hi,
>
> In my database creation script I run the following procedures for
> 8.1.7 but have been told that if I'm not using the latest 9i features
> then this is still valid:
>
> echo catproc starting......
> @$ORACLE_HOME/rdbms/admin/catproc.sql
> echo caths starting......
> @$ORACLE_HOME/rdbms/admin/caths.sql
> echo otrcvr starting....
> @$ORACLE_HOME/rdbms/admin/otrcsvr.sql
>
>
> however, during catproc I get the following errors...
> Package body created.
>
>
> Package body created.
>
> BEGIN SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS('/usr/oracle/9.2.0/rdbms/xml/xsl');
> END;
>
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
>
>
> CREATE OR REPLACE PACKAGE dbms_cdc_utility
> *
> ERROR at line 1:
> ORA-03114: not connected to ORACLE
>
>
> CREATE OR REPLACE PACKAGE DBMS_CDC_PUBLISH
> *
> ERROR at line 1:
> ORA-03114: not connected to ORACLE
>
>
> GRANT EXECUTE ON sys.dbms_cdc_publish TO execute_catalog_role
> *
> ERROR at line 1:
> ORA-03114: not connected to ORACLE
> ......and so on
>
>
> what happned? - I can't understand
> please help. thanks
3113, 3114 - core dump, session crashed.
once you had a 3113, nothing else mattered.
check in /cdump.
also check http://www.nyoug.org/ora-3113.pdf
Pd Received on Tue May 06 2003 - 00:39:43 CDT