Re: create database fatal error
Date: Sat, 05 Jul 2008 21:11:51 -0500
Message-ID: <tPVbk.9196$LG4.6380@nlpi065.nbdc.sbc.com>
Tommy Halsbrekk wrote:
> 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."
Were you able to get your problem solved?
Make sure your database directories are owned by oracle user.
Have a look at http://www.fast-track.cc/10g_02.htm
- specifically these lines: DATAFILE '/usr/oracle/OraHome1/oradata/aultdb1/test/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
See if you can get your db created - then work backwards to figure out how big your system.dbf datafile needs to be... Received on Sat Jul 05 2008 - 21:11:51 CDT