create database fatal error
in [Oracle]
|
Prev: Fresh Enterprise Manager Install Can't connect "Connection Closed"
Next: Oracle support is sub-optimal
From: Tommy Halsbrekk on 4 Jul 2008 10:55 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."
From: sybrandb on 4 Jul 2008 10:09 On Fri, 04 Jul 2008 15:55:26 +0100, Tommy Halsbrekk <tommy(a)dummy.no> 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. Surely. You are using the wrong tools for the wrong job. Tools like OUI (Oracle Universal Installer) and DBCA (Database Creation Assistant) all come with a silent mode. Using silent mode, you would need to set up a template only once, and you can use dbca from the commandline to create your database. Your second problem is you don't even try to understand error messages. If you would have done so, you would have noticed your SYSTEM tablespace is out of space. Which is not surprising as a SYSTEM tablespace of 100M is a joke. It needs to be 250M minimum. Finally: I don't think any serious DBA would like to see third party software create a database. DBAs need to decide where to host the data. Forcing your customers to create a separate database for your application is unacceptable. -- Sybrand Bakker Senior Oracle DBA
From: hpuxrac on 4 Jul 2008 10:19 On Jul 4, 10:55 am, Tommy Halsbrekk <to...(a)dummy.no> wrote: snip Look at this error message in what you copied and pasted ... ORA-01653: unable to extend table SYS.OBJ$ by 13 in tablespace SYSTEM
From: Tommy Halsbrekk on 4 Jul 2008 12:49 sybrandb(a)hccnet.nl wrote: > Surely. You are using the wrong tools for the wrong job. > Tools like OUI (Oracle Universal Installer) and DBCA (Database > Creation Assistant) all come with a silent mode. > Using silent mode, you would need to set up a template only once, and > you can use dbca from the commandline to create your database. I agree, but its not my call. > Your second problem is you don't even try to understand error > messages. With the enourmous complexity of Oracle systems its hard to understand anything without studying it or taking courses. > If you would have done so, you would have noticed your SYSTEM > tablespace is out of space. > Which is not surprising as a SYSTEM tablespace of 100M is a joke. > It needs to be 250M minimum. I saw the error message but its not a very informative message if you dont know what it means I revised the statment with larger numbers but I still get the same error message. I thought "size 500M" at the end of the system01.dbf was the correct place to fix the problem, but I was mistaken. Any info is highly appreciated. create database ORACLE_SID controlfile reuse undo tablespace "undotbs" datafile 'ORACLE_BASE/oradata/ORACLE_SID/system01.dbf' size 500M sysaux datafile 'ORACLE_BASE/oradata/ORACLE_SID/sysaux01.dbf' size 500M logfile 'ORACLE_BASE/oradata/ORACLE_SID/redo01.dbf' size 50M, 'ORACLE_BASE/oradata/ORACLE_SID/redo02.dbf' size 50M extent management local default temporary tablespace mytemp tempfile 'ORACLE_BASE/oradata/ORACLE_SID/temp01.dbf' SIZE 500M noarchivelog maxdatafiles 1000 maxlogfiles 10; regards tommy
From: Ana C. Dent on 4 Jul 2008 13:27
Tommy Halsbrekk <tommy(a)dummy.no> wrote in news:g4lgqr$fds$1(a)aioe.org: > sybrandb(a)hccnet.nl wrote: > >> Surely. You are using the wrong tools for the wrong job. >> Tools like OUI (Oracle Universal Installer) and DBCA (Database >> Creation Assistant) all come with a silent mode. >> Using silent mode, you would need to set up a template only once, and >> you can use dbca from the commandline to create your database. > > I agree, but its not my call. > >> Your second problem is you don't even try to understand error >> messages. > > With the enourmous complexity of Oracle systems its hard to understand > anything without studying it or taking courses. > >> If you would have done so, you would have noticed your SYSTEM >> tablespace is out of space. >> Which is not surprising as a SYSTEM tablespace of 100M is a joke. >> It needs to be 250M minimum. > > I saw the error message but its not a very informative message if you > dont know what it means > > I revised the statment with larger numbers but I still get the same > error message. I thought "size 500M" at the end of the system01.dbf was > the correct place to fix the problem, but I was mistaken. Any info is > highly appreciated. > > create database ORACLE_SID > controlfile reuse undo tablespace "undotbs" > datafile > 'ORACLE_BASE/oradata/ORACLE_SID/system01.dbf' size 500M > sysaux datafile > 'ORACLE_BASE/oradata/ORACLE_SID/sysaux01.dbf' size 500M > logfile > 'ORACLE_BASE/oradata/ORACLE_SID/redo01.dbf' size 50M, > 'ORACLE_BASE/oradata/ORACLE_SID/redo02.dbf' size 50M > extent management local > default temporary tablespace mytemp > tempfile > 'ORACLE_BASE/oradata/ORACLE_SID/temp01.dbf' SIZE 500M > noarchivelog > maxdatafiles 1000 > maxlogfiles 10; > > > regards > > tommy We can only see what you post & what you post may not actually reflect reality. I am *HIGHLY* suspicious of the SQL above for 2 reasons. 1) IMO, the "ORACLE_BASE" & "ORACLE_SID" I suspect should preceeded by dollar sign so they would be interpreted as environmental variables and not used as hard coded strings. 2) The SQL above contains "reuse undo tablespace" which it should to succeed on multiple retries; but it does NOT contain "reuse" for the other files. If it did not error out then I suspect multiple system01.dbf files exist. Who knows which is actually opened & being used. OK, you have a problem, but nobody here has enough credible data to get you much closer to a working database. It appears you know enough to dig yourself into a nice hole, but continue to flail away hoping to get back to level ground. BTW, what actual OS name & version? What version of Oracle to 4 decimal placess? |