I receive this error while create a database with CREATE DATABASE statement.
OS is Solaris 10 x86
Oracle Database Software: 10.2.0.2 for Solaris x86, upgraded to 10.2.0.4 with patch set for Solaris x86
When I start the script to build the database after a while it throws the error: ORA-01092: ORACLE instance terminated. Disconnection forced
My init file initmydb.ora is:
db_name=mydb
db_domain=''
db_file_multiblock_read_count = 16
db_block_size=4096
sga_target=314572800
shared_pool_size=188743680
undo_management=AUTO
undo_tablespace='UNDOTBS1'
db_recovery_file_dest='/export/home/oracle/recovery_area'
db_recovery_file_dest_size=2G
#diagnostic_dest='/export/home/oracle'
processes = 1000
job_queue_processes=12
sessions=100
open_cursors=300
parallel_max_servers=0
control_files = (ora_control1, ora_control2)
utl_file_dir = '/export/home/oracle/tmp'
background_dump_dest = '/export/home/oracle/admin/bdump'
core_dump_dest = '/export/home/oracle/admin/cdump'
user_dump_dest = '/export/home/oracle/admin/udump'
remote_login_passwordfile='EXCLUSIVE'
compatible='10.2.0'
My script to build the db is:
CREATE DATABASE mydb
USER SYS IDENTIFIED BY pass1234
USER SYSTEM IDENTIFIED BY pass1234
LOGFILE GROUP 1 ('/export/home/oracle/logs/mydb/redo01a.log','/export/home/oracle/logs/mydb/redo01b.log') SIZE 100M,
GROUP 2 ('/export/home/oracle/logs/mydb/redo02a.log','/export/home/oracle/logs/mydb/redo02b.log') SIZE 100M,
GROUP 3 ('/export/home/oracle/logs/mydb/redo03a.log','/export/home/oracle/logs/mydb/redo03b.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/export/home/oracle/oradata/mydb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/export/home/oracle/oradata/mydb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE usrdata
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/export/home/oracle/oradata/mydb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE UNDOTBS1
DATAFILE '/export/home/oracle/oradata/mydb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
This is an excerpt from the alert.log file:
...
Completed: CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE '/export/home/oracle/oradata/mydb/temp01.dbf'
SIZE 20M REUSE
Tue Jun 7 17:57:46 2011
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Tue Jun 7 17:57:46 2011
Errors in file /export/home/oracle/admin/udump/mydb_ora_2293.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Tue Jun 7 17:57:46 2011
Errors in file /export/home/oracle/admin/udump/mydb_ora_2293.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6268
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 = 2293
...
I read around in the forum as well as in another forums, tried this and that but with no success. Please, advise!
Edited by: user13080027 on Jun 7, 2011 8:40 AM