OraFAQ Forum: Server Administration » Oracle 10g/Fedora Core 4

Home » RDBMS Server » Server Administration » Oracle 10g/Fedora Core 4 - Error creating database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 10g/Fedora Core 4 - Error creating database [message #190710]

Thu, 31 August 2006 21:46

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;

Report message to a moderator

Re: Oracle 10g/Fedora Core 4 - Error creating database [message #190729 is a reply to message #190710]

Fri, 01 September 2006 01:05

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Oracle 10g/Fedora Core 4 - Error creating database [message #190796 is a reply to message #190729]

Fri, 01 September 2006 05:21

debarros
Messages: 6
Registered: August 2006

Junior Member

That did it !!! Thanks Mahesh.

Report message to a moderator

Previous Topic:	Tablespace
Next Topic:	Estimation of DataFiles to be added while Importing a new user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 14:48:26 CST 2024