Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problems when creating a 9i database

Re: problems when creating a 9i database

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 5 May 2003 22:39:43 -0700
Message-ID: <1ac7c7b3.0305052139.6c71459a@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US