create database fatal error

From: Tommy Halsbrekk <tommy_at_dummy.no>
Date: Fri, 04 Jul 2008 15:55:26 +0100
Message-ID: <g4la4a$l13$1@aioe.org>

Hi

I am having some serious problems with my create data procedure. After the CREATE DATABASE statement i run the catalog.sql and catproc.sql scripts. During the catproc script it after a while encounters a massive amounts of errors ending up in a fatal error whihc terminates the session. All statements after that do not complete because its not connected to oracle.

Does anybody know what the problem is? I am running 10.2 on solaris 10.

regards

tommy

The error log is as follows:

Type created.

Grant succeeded.

Type created.

Grant succeeded.

CREATE OR REPLACE PACKAGE kupcc wrapped
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM

GRANT EXECUTE ON sys.kupcc TO PUBLIC

                      *

ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist

Synonym created.

Warning: Type Body created with compilation errors.

Warning: Type Body created with compilation errors.

Warning: Type Body created with compilation errors.

---

Then there are errors for the next several hundred statements and the the fatal error

---

CREATE OR REPLACE LIBRARY sys.dbms_logstdby_lib wrapped *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.OBJ$ by 13 in tablespace SYSTEM

CREATE OR REPLACE PACKAGE BODY sys.dbms_logstdby wrapped

                                              *

ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

The create database statement, and details I used is as follows:

connect / as sysdba
startup nomount
create database scrtst11

   controlfile reuse undo tablespace "undotbs"    datafile
'/oracle/oracle_inst/oradata/scrtst11/system01.dbf' size 100m
   sysaux datafile
'/oracle/oracle_inst/oradata/scrtst11/sysaux01.dbf' size 100M
   logfile
'/oracle/oracle_inst/oradata/scrtst11/redo01.dbf' size 50M,
'/oracle/oracle_inst/oradata/scrtst11/redo02.dbf' size 50M
   default temporary tablespace mytemp
   tempfile
'/oracle/oracle_inst/oradata/scrtst11/temp01.dbf' SIZE 500M
   noarchivelog
   maxdatafiles 1000
   maxlogfiles 10;
@${ORACLE_HOME}/rdbms/admin/catalog.sql
@${ORACLE_HOME}/rdbms/admin/catproc.sql
connect system/manager
@${ORACLE_HOME}/sqlplus/admin/pupbld.sql connect / as sysdba
shutdown
exit

${ORACLE_BASE}/admin/${ORACLE_SID}/pfile/init${ORACLE_SID}.ora :

#
# initscrtst11.ora file
#

db_name=scrtst11
compatible=10.2.0.1.0
undo_management=auto

shared_pool_size=1493172224

db_recovery_file_dest=/oracle/oracle_inst/flash_recovery_area db_recovery_file_dest_size=2147483648
control_files=(/oracle/oracle_inst/oradata/scrtst11/control01.ctl,/oracle/oracle_inst/oradata/scrtst11/control02.ctl)

background_dump_dest=/oracle/oracle_inst/admin/scrtst11/bdump
core_dump_dest=/oracle/oracle_inst/admin/scrtst11/cdump
user_dump_dest=/oracle/oracle_inst/admin/scrtst11/udump


--------------------

This is all run by a script whihc creates dirs and prepares the files before execution and is as follows:

---

#!/usr/bin/csh -f

if (! $?ORACLE_SID) then

     echo "ORACLE_SID is not set. Can't create database."
     exit

endif

echo "Create database ${ORACLE_SID}"

if (! -e $ORACLE_BASE/admin) then

     mkdir $ORACLE_BASE/admin
endif

cd $ORACLE_BASE/admin
mkdir -p ${ORACLE_SID}/pfile

mkdir ${ORACLE_SID}/udump
mkdir ${ORACLE_SID}/cdump
mkdir ${ORACLE_SID}/bdump

cp `dirname $0`/../etc/initdefault_ora10.ora ${ORACLE_BASE}/admin/${ORACLE_SID}/pfile/init${ORACLE_SID}.ora perl -p -i -e 's|ORACLE_SID|'${ORACLE_SID}'|g;' ${ORACLE_BASE}/admin/${ORACLE_SID}/pfile/init${ORACLE_SID}.ora perl -p -i -e 's|ORACLE_BASE|'${ORACLE_BASE}'|g;' ${ORACLE_BASE}/admin/${ORACLE_SID}/pfile/init${ORACLE_SID}.ora

cd ${ORACLE_HOME}/dbs
ln -s ${ORACLE_BASE}/admin/${ORACLE_SID}/pfile/init${ORACLE_SID}.ora

mkdir -p ${ORACLE_BASE}/oradata/${ORACLE_SID}

orapwd file=${ORACLE_HOME}/dbs/orapw${ORACLE_SID} password=qaz entries=5

cd
cp `dirname $0`/create_oracle_database_ora10.sql / create_oracle_database_${ORACLE_SID}.sql perl -p -i -e 's|ORACLE_SID|'${ORACLE_SID}'|g;' / create_oracle_database_${ORACLE_SID}.sql perl -p -i -e 's|ORACLE_BASE|'${ORACLE_BASE}'|g;' / create_oracle_database_${ORACLE_SID}.sql sqlplus /nolog @create_oracle_database_${ORACLE_SID}.sql #rm create_oracle_database_${ORACLE_SID}.sql

echo -n "create_oracle_database.csh COMPLETED." Received on Fri Jul 04 2008 - 09:55:26 CDT