Home » RDBMS Server » Server Administration » database creattion error (Oracle 10g, Suse, Linux)
database creattion error [message #340097] Mon, 11 August 2008 07:54 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
My inittestdb.ora file is

control_files              = (/home/oracle/oradata/testdb/control01.ctl,
                              /home/oracle/oradata/testdb/control02.ctl,
                              /home/oracle/oradata/testdb/control03.ctl)
db_name                    = testdb
undo_tablespace            = 'UNDOTBS'
undo_management            = 'AUTO'
compatible                 = 10.2.0.1.0



CREATE DATABASE testdb
   USER SYS IDENTIFIED BY cyb123
   USER SYSTEM IDENTIFIED BY cyb123
   LOGFILE GROUP 1 ('/home/oracle/oradata/testdb/redo01.log') SIZE 100M,
           GROUP 2 ('/home/oracle/oradata/testdb/redo02.log') SIZE 100M,
           GROUP 3 ('/home/oracle/oradata/testdb/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/home/oracle/oradata/testdb/system01.dbf' SIZE 125M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/home/oracle/oradata/testdb/sysaux01.dbf' SIZE 125M REUSE
   DEFAULT TABLESPACE tbs_1
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/home/oracle/oradata/testdb/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/home/oracle/oradata/testdb/undotbs.dbf'
      SIZE 100M REUSE;Connected to an idle instance.

CREATE DATABASE testdb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


Alert.log file.

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Mon Aug 11 14:47:37 2008
Errors in file /home/oracle/product/admin/ora01/udump/ora01_ora_17020.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Mon Aug 11 14:47:37 2008
Errors in file /home/oracle/product/admin/ora01/udump/ora01_ora_17020.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6262
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 17020
ORA-1092 signalled during: CREATE DATABASE testdb
   USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE GROUP 1 ('/home/oracle/oradata/testdb/redo01.log') SIZE 100M,
	   GROUP 2 ('/home/oracle/oradata/testdb/redo02.log') SIZE 100M,
	   GROUP 3 ('/home/oracle/oradata/testdb/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/home/oracle/oradata/testdb/system01.dbf' SIZE 125M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/home/oracle/oradata/testdb/sysaux01.dbf' SIZE 125M REUSE
   DEFAULT TABLESPACE tbs_1
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/home/oracle/oradata/testdb/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/home/oracle/oradata/testdb/undotbs.dbf'
      SIZE 100M REUSE...


Please tell What could be the reason to cause the problem of ORA-01092: ORACLE instance terminated. Disconnection forced?

Thanks,

[Updated on: Mon, 11 August 2008 07:55]

Report message to a moderator

Re: database creattion error [message #340100 is a reply to message #340097] Mon, 11 August 2008 08:11 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519

ORA-01519: error while processing file '%s' near line %s
 *Cause:  CREATE DATABASE encountered a problem while processing
            specified file.  The specified file is bad.
 *Action: Retry your system installation procedure or contact
            your customer support representative.

Regards
Michel
Previous Topic: catlog.sql
Next Topic: 10g upgrade questions
Goto Forum:
  


Current Time: Fri Nov 29 19:49:33 CST 2024