Re: create database fatal error

"Tommy Halsbrekk" <tommy_at_dummy.no> wrote in message 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."

You know you can run dbca and have dbca create the scripts for you. Then if you really want to build it yourself you can do it from that. You can reverse engineer the scripts from the scripts that are produced. Jim Received on Sun Jul 06 2008 - 10:36:20 CDT