Re: create database fatal error

"Tommy Halsbrekk" <tommy_at_dummy.no> schreef in bericht news:g4la4a$l13$1_at_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 Received on Mon Jul 07 2008 - 03:37:05 CDT