Home » RDBMS Server » Server Administration » Oracle 10g/Fedora Core 4 - Error creating database
Oracle 10g/Fedora Core 4 - Error creating database [message #190710] Thu, 31 August 2006 21:46 Go to next message
debarros
Messages: 6
Registered: August 2006
Junior Member
Hi, when I try to execute the script to create a new database, I get an error for Invalid File Name, as seen on the alert.log file below. I'd appreciate any help.

Thanks,

M.D.

================================================================
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Thu Aug 31 22:17:27 2006
Errors in file /opt/oracle/product/10.1.0/db_1/rdbms/log/orcl_ora_2926.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Thu Aug 31 22:17:27 2006
Errors in file /opt/oracle/product/10.1.0/db_1/rdbms/log/orcl_ora_2926.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 = 2926
ORA-1092 signalled during: CREATE DATABASE dev
===============================================================

Here is my full create script:

CREATE DATABASE dev
USER SYS IDENTIFIED BY adv71016
USER SYSTEM IDENTIFIED BY adv71016
LOGFILE GROUP 1 ('/u03/oradata/dev/redo01.log') SIZE 100M,
GROUP 2 ('/u03/oradata/dev/redo02.log') SIZE 100M,
GROUP 3 ('/u03/oradata/dev/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u03/oradata/dev/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u03/oradata/dev/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE dev_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u03/oradata/dev/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undodev
DATAFILE '/u03/oradata/dev/undotbs01.dbf'
SIZE 60M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
Re: Oracle 10g/Fedora Core 4 - Error creating database [message #190729 is a reply to message #190710] Fri, 01 September 2006 01:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> DEFAULT TABLESPACE dev_1
you are using the default clause ( and provided no name/location for the datafile).
To do this, you must set DB_CREATE_FILE_DEST (a parameter in initsid.ora) for the location of datafile for the tablespace.
Did you do that?
else
try it.
or
Make it to use the DATAFILE clause along with ( as you did for other tablespaces)
or
remove that line.
You can create individual tablespaces later.
icon14.gif  Re: Oracle 10g/Fedora Core 4 - Error creating database [message #190796 is a reply to message #190729] Fri, 01 September 2006 05:21 Go to previous message
debarros
Messages: 6
Registered: August 2006
Junior Member
That did it !!! Thanks Mahesh.
Previous Topic: Tablespace
Next Topic: Estimation of DataFiles to be added while Importing a new user
Goto Forum:
  


Current Time: Sat Dec 03 17:51:53 CST 2016

Total time taken to generate the page: 0.05941 seconds