Re: create database fatal error
- From: "Shakespeare" <whatsin@xxxxxxxxx>
- Date: Mon, 7 Jul 2008 10:37:05 +0200
"Tommy Halsbrekk" <tommy@xxxxxxxx> schreef in bericht
news:g4la4a$l13$1@xxxxxxxxxxx
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
.
- Follow-Ups:
- Re: create database fatal error
- From: Tommy Halsbrekk
- Re: create database fatal error
- References:
- create database fatal error
- From: Tommy Halsbrekk
- create database fatal error
- Prev by Date: Re: create database fatal error
- Next by Date: Re: Enterprise manager is Not Connecting to database
- Previous by thread: Re: create database fatal error
- Next by thread: Re: create database fatal error
- Index(es):
Relevant Pages
|
