Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!feeder.news-service.com!feeder.news-service.com!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!newsgate.cistron.nl!xs4all!transit2.news.xs4all.nl!post.news.xs4all.nl!not-for-mail From: "Shakespeare" Newsgroups: comp.databases.oracle.server References: Subject: Re: create database fatal error Date: Mon, 7 Jul 2008 10:37:05 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-RFC2646: Format=Flowed; Response Lines: 218 Message-ID: <4871d5bf$0$14355$e4fe514c@news.xs4all.nl> NNTP-Posting-Host: 82.95.215.210 X-Trace: 1215419839 news.xs4all.nl 14355 [::ffff:82.95.215.210]:49741 X-Complaints-To: abuse@xs4all.nl Xref: usenetserver.com comp.databases.oracle.server:446299 X-Received-Date: Mon, 07 Jul 2008 04:37:19 EDT (text.usenetserver.com) "Tommy Halsbrekk" schreef in bericht news: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." Tommy, I think this is the trap you stepped in: DATAFILE Clause Specify one or more files to be used as datafiles. All these files become part of the SYSTEM tablespace. Use the datafile_tempfile_spec form of file_specification to create regular datafiles and tempfiles in an operating system file system or to create Automatic Storage Management disk group files. Caution: This clause is optional, as is the DATAFILE clause of the undo_tablespace clause. Therefore, to avoid ambiguity, if your intention is to specify a datafile for the SYSTEM tablespace with this clause, then do not specify it immediately after an undo_tablespace clause that does not include the optional DATAFILE clause. If you do so, Oracle Database will interpret the DATAFILE clause to be part of the undo_tablespace clause. Shakespeare