Home » RDBMS Server » Server Administration » Problem creating database (10g,Windows xp)
Problem creating database [message #340734] Thu, 14 August 2008 01:34 Go to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi,
I tried to create a new database in Oracle express edition 10g. I was able to startup nomount the new service but got error while executing create command ,the extract of alert log is as follows,
:
:
:
:
CREATE DATABASE ntier
LOGFILE GROUP 1 ('c:/oraclexe/oradata/ntier/redo01.log') SIZE 100M,
GROUP 2 ('c:/oraclexe/oradata/ntier/redo02.log') SIZE 100M,
GROUP 3 ('c:/oraclexe/oradata/ntier/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'c:/oraclexe/oradata/ntier/system01.dbf' SIZE 10m REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'c:/oraclexe/oradata/ntier/sysaux01.dbf' SIZE 10M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'c:/oracle/oradata/ntier/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE 'c:/oracle/oradata/ntier/undo.dbf'
SIZE 20M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Thu Aug 14 11:54:34 2008
Database mounted in Exclusive Mode
Thu Aug 14 11:54:39 2008
Successful mount of redo thread 1, with mount id 175567993
Assigning activation ID 175567993 (0xa76f479)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:\ORACLEXE\ORADATA\NTIER\REDO01.LOG
Successful open of redo thread 1
Thu Aug 14 11:54:40 2008
SMON: enabling cache recovery
Thu Aug 14 11:54:40 2008
create tablespace SYSTEM datafile 'c:/oraclexe/oradata/ntier/system01.dbf' SIZE 10m REUSE

EXTENT MANAGEMENT LOCAL online

Thu Aug 14 11:54:40 2008
Completed: create tablespace SYSTEM datafile 'c:/oraclexe/oradata/ntier/system01.dbf' SIZE 10m REUSE

EXTENT MANAGEMENT LOCAL online
Thu Aug 14 11:54:40 2008
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Thu Aug 14 11:54:44 2008
Errors in file c:\oraclexe\app\oracle\admin\ntier\udump\ntier_ora_2484.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-00942: table or view does not exist

Thu Aug 14 11:54:44 2008
Errors in file c:\oraclexe\app\oracle\admin\ntier\udump\ntier_ora_2484.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 2713
ORA-00604: error occurred at recursive SQL level 2
ORA-00942: table or view does not exist

Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Thu Aug 14 11:54:44 2008
Errors in file c:\oraclexe\app\oracle\admin\ntier\bdump\ntier_dbw0_2220.trc:
ORA-01519: error while processing file '' near line

Thu Aug 14 11:54:44 2008
Errors in file c:\oraclexe\app\oracle\admin\ntier\bdump\ntier_lgwr_2712.trc:
ORA-01519: error while processing file '' near line
:
:
:
:



Pls give me some solution
Re: Problem creating database [message #340735 is a reply to message #340734] Thu, 14 August 2008 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is in the trace file?
What is "near line 2713" in "%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ"?

Regards
Michel
Re: Problem creating database [message #340737 is a reply to message #340735] Thu, 14 August 2008 01:45 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi Michel, following are the contents of the ntier_ora_2484.trc file,

----------------------------------------------------------------
Dump file c:\oraclexe\app\oracle\admin\ntier\udump\ntier_ora_2484.trc
Thu Aug 14 12:10:00 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:442M/1015M, Ph+PgF:1574M/2442M, VA:1620M/2047M
Instance name: ntier

Redo thread mounted by this instance: 0 <none>

Oracle process number: 18

Windows thread id: 2484, image: ORACLE.EXE (SHAD)


*** SERVICE NAME:() 2008-08-14 12:10:00.529
*** SESSION ID:(38.1) 2008-08-14 12:10:00.529
kccsga_update_ckpt: num_1 = 1, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 416 blocks
*** 2008-08-14 12:10:07.575
ORA-00604: error occurred at recursive SQL level 2
ORA-00942: table or view does not exist
Offending statement at line 2713
create table oid$ /* OID mapping table for schema objects */
(
user# number not null, /* user this mapping is for (user$.user#) */
oid$ raw(16) not null, /* OID for typed table/view or type */
obj# number not null) /* target object number (obj$.obj#) */
/* key: (user#, oid$) */
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 2713
ORA-00604: error occurred at recursive SQL level 2
ORA-00942: table or view does not exist
----------------------------------------------------------------

Well, i was not sure about "near line 2713"

Thanks,
Arun
Re: Problem creating database [message #340753 is a reply to message #340737] Thu, 14 August 2008 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Well, i was not sure about "near line 2713"

Open the file and post 10 lines (at least 1 complete statement) before and after line 2713.

Regards
Michel
Re: Problem creating database [message #340761 is a reply to message #340753] Thu, 14 August 2008 03:39 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi Michel,
I have posted the lines as you asked.The line 2713 is boldened in the following ,



create index i_slog1 on slog$(snaptime)
/
rem NOTE
rem Logminer/Streams uses contents of this table.
rem Please do not reuse any flags without verifying the impact of your
rem changes on inter-op.
create table coltype$ /* additional column info table */
( obj# number not null, /* object number of base object */
col# number not null, /* column number */
intcol# number not null, /* internal column number */
toid raw(16) not null, /* column's ADT type OID */
version# number not null, /* internal type version number */
packed number not null, /* 0 = unpacked, 1 = packed */
intcols number, /* number of internal columns */
/* storing the exploded ADT column */
intcol#s raw("M_CSIZ"), /* list of intcol#s of columns storing */
/* the unpacked ADT column; stored in packed form; */
/* each intcol# is stored as a ub2 */
flags number,
/* flags to indicate whether column type is ADT, Array, */
/* REF or Nested table */
/* 0x02 - adt column */
/* 0x04 - nested table column */
/* 0x08 - varray column */
/* 0x10 - ref column */
/* 0x20 - retrieve collection out-of-line */
/* 0x20 - don't strip the null image */
/* 0x40 - don't chop null image */
/* 0x40 - collection storage specified */
/* 0x80 - column stores an old (8.0) format image */
/* 0x100 - data for this column not yet upgraded */
/* 0x200 - ADT column is substitutable */
/* 0x400 - NOT SUBSTITUTABLE specified explicitly */
/* 0x800 - SUBSTITUTABLE specified explicitly */
/* 0x1000 - implicitly not substitutable */
/* 0x2000 - The typeid column stores the toid */
/* 0x4000 - The column is an opaque type column */
/* 0x8000 - nested table name is system generated */
typidcol# number, /* intcol# of the type discriminant column */
synobj# number) /* obj# of type synonym of the col type */
cluster c_obj#(obj#)
/
create index i_coltype1 on coltype$(obj#, col#)
/
create unique index i_coltype2 on coltype$(obj#, intcol#)
/
create table subcoltype$
( obj# number not null, /* object number of base object */
intcol# number not null, /* internal column number */
toid raw(16) not null, /* column's ADT type OID */
version# number not null, /* internal type version number */

intcols number, /* number of internal columns */
/* storing the exploded ADT column */
intcol#s raw("M_CSIZ"), /* list of intcol#s of columns storing */
/* the unpacked ADT column; stored in packed form; */
/* each intcol# is stored as a ub2 */
flags number,
/* 0x01 - This type was stated in the IS OF clause */
/* 0x02 - This type has ONLY in the IS OF clause */
synobj# number) /* obj# of synonym specified for substitutable type */
cluster c_obj#(obj#)
/
create index i_subcoltype1 on subcoltype$(obj#, intcol#)
/
rem NOTE
rem Logminer/Streams uses contents of this table.
rem Please do not reuse any flags without verifying the impact of your
rem changes on inter-op.
create table attrcol$ /* ADT attribute column table */
( obj# number not null, /* object number of base object */
intcol# number not null, /* internal column number */
name varchar2("M_VCSZ") not null) /* fully-qualified name */
cluster c_obj#(obj#)
/
create unique index i_attrcol1 on attrcol$(obj#, intcol#)
/
create table viewtrcol$ /* triggering view column table */
( obj# number not null, /* object number of base object */
intcol# number not null, /* internal column number */
attribute# number not null, /* attribute# inside col for views */
name varchar2("M_VCSZ") not null) /* fully-qualified name */
cluster c_obj#(obj#)
/
create unique index i_viewtrcol1 on viewtrcol$(obj#, intcol#,attribute#)
/
create table id_gens$ /* ID generators table */
( total number not null) /* total number of ID generators */
/
create table oid$ /* OID mapping table for schema objects */
(
user# number not null, /* user this mapping is for (user$.user#) */
oid$ raw(16) not null, /* OID for typed table/view or type */
obj# number not null) /* target object number (obj$.obj#) */
/* key: (user#, oid$) */
/
create unique index i_oid1 on oid$(user#, oid$)
/
create table type_misc$ /* type miscellaneous information table */
( obj# number not null, /* type object number */
audit$ varchar2("S_OPFL") not null, /* auditing options */
properties number not null) /* properties */
/* 0x01 = (flag PRP) potential REF-dependency parent */
/* 0x02 = invoker's rights */
/* 0x04 = Repeeatable */
/* 0x08 = TO8 Trusted */
/* 0x10 = SQLJ type */
/* 0x20 = SQLJ type with helper class */
/* 0x40 = Natively compiled */
/* 0x80 = Shrink-wrapped type */
/* 0x100 = Compiled with debug info */
cluster c_obj#(obj#)
/
create cluster c_toid_version#
( toid raw(16), /* TOID */
version# number) /* internal version number */
storage (initial 10k next 100k maxextents unlimited pctincrease 0)
/
create index i_toid_version# on cluster c_toid_version#
/
rem NOTE
rem Logminer/Streams uses contents of this table.
rem Please do not reuse any flags without verifying the impact of your
rem changes on inter-op.
create table type$ /* type table */
( toid raw(16) not null, /* TOID */
version# number not null, /* internal version number */
version varchar2("M_IDEN") not null, /* user-supplied version name */
tvoid raw(16) not null, /* type version's OID */
typecode number not null, /* typecode */
properties number not null, /* type's properties: */
/* 0x00000001 = 1 = contains at least one (embedded) ADT attribute */
/* 0x00000002 = 2 = contains at least one REF attribute */
/* 0x00000004 = 4 = contains at least one "complex" attribute:
multiset, table, array, LOB, file, etc. */
/* 0x00000008 = 8 = is NOT FINAL type */
/* 0x00000010 = 16 = is a predefined system/builtin type(unalterable) */
/* 0x00000080 = 128 = contains at least one multiset attribute */
/* 0x00000100 = 256 = is incomplete */
/* 0x00000200 = 512 = contains at least one LOB attribute */
/* 0x00000400 = 1024 = contains at least one file attribute */
/* 0x00000800 = 2048 = is a system-generated type */
/* 0x00001000 = 4096 = contains opaque types */
/* 0x00002000 = 8192 = is a SUBTYPE */
/* 0x00004000 = 16384 = is invoker rights type */
/* 0x00008000 = 32768 = contains varray attribute */
/* 0x00010000 = 65536 = is not instantiable */
/* 0x00020000 = 131072 = is java type */
/* 0x00040000 = 262144 = old type version */
/* 0x00080000 = 524288 = contain TSLTZ attr/element */
/* 0x00100000 = 1048576 = has embedded non final type */
/* 0x00200000 = 2097152 = has embedded subtype */
/* 0x00400000 = 4194304 = has user-defined constructor */
/* 0x00800000 = 8388608 = type is cursor duration */

attributes number, /* number of attributes */
methods number, /* number of methods */
hiddenMethods number, /* number of methods */
supertypes number, /* reserved */
subtypes number, /* reserved */
externtype number, /* external type */
/* 1 = SQLData SQLJ type */
/* 2 = CustomDatum SQLJ type */
/* 3 = serializable SQLJ type */
/* 4 = internal serializable SQLJ type */
/* 5 = ORAData SQLJ type */
externname varchar2("M_VCSZ"), /* java class implementing the type */
helperclassname varchar2("M_VCSZ"), /* Generated helper class (SQLJ) */
local_attrs number, /* Number of local attributes */
local_methods number, /* Number of local methods */
typeid raw(16), /* short typeid value (for non final and sub types) */
roottoid raw(16), /* TOID of root type (null if not subtype) */
spare1 number, /* reserved */
spare2 number, /* reserved */
spare3 number, /* reserved */
supertoid raw(16), /* supertype OID */
hashcode raw("KOTHCL")) /* hashcode */
Re: Problem creating database [message #340781 is a reply to message #340761] Thu, 14 August 2008 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know if it is a problem when you posted or the actual but it seems there is a missing new line there (between the 2 red characters):
Quote:
/* key: (user#, oid$) */
/create unique index i_oid1 on oid$(user#, oid$)
/

Regards
Michel
Re: Problem creating database [message #340784 is a reply to message #340781] Thu, 14 August 2008 04:57 Go to previous message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Sorry,that was my defect,the following are the actual,


create table oid$ /* OID mapping table for schema objects */
(
user# number not null, /* user this mapping is for (user$.user#) */
oid$ raw(16) not null, /* OID for typed table/view or type */
obj# number not null) /* target object number (obj$.obj#) */
/* key: (user#, oid$) */
/
create unique index i_oid1 on oid$(user#, oid$)
/



Thanks,
Arun
Previous Topic: Force one TableSpace
Next Topic: Text from a ddl
Goto Forum:
  


Current Time: Tue Dec 06 02:44:55 CST 2016

Total time taken to generate the page: 0.06787 seconds