| Database creation error [message #49985] |
Thu, 21 February 2002 14:09  |
balu
Messages: 23
Registered: March 2001
|
Junior Member |
|
|
When I was trying to start the database manually this is the error I am getting foolowing. I tried by anlysing the logfiles but no successes.
Using hp-ux 11i.
This is what I did...
export $ORACLE_SID=newdb(dbname)
#sqlplus /nolog
#connect /as sysdba
connected to idle instance
sql>startup nomount
(It starts fine with the server parameter file)
sql>@/oracle1/9.0.1/dbsql/crnewdb.sql
(After some time I am getting the foolowing error)
CREATE DATABASE newdb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Here is the crenewdb.sql file:
=============================
CREATE DATABASE newdb
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 10
MAXDATAFILES 100
DATAFILE '/oracle1/9.0.1/oradata/newdb/system01.dbf' SIZE 325M REUSE
UNDO TABLESPACE undotbs DATAFILE '/oracle1/9.0.1/oradata/newdb/undo.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temts1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oracle1/9.0.1/oradata/newdb/redo01.log') SIZE 100M,
GROUP 2 ('/oracle1/9.0.1/oradata/newdb/redo02.log') SIZE 100M,
GROUP 3 ('/oracle1/9.0.1/oradata/newdb/redo03.log') SIZE 100M;
This is what alert_log says.
============================
Thu Feb 21 14:23:48 2002
Errors in file /oracle1/9.0.1/admin/newdb/udump/ora_4642_newdb.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5298
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 = 4642
ORA-1092 signalled during: CREATE DATABASE newdb
MAXINSTANCES 1
MAXLOGHISTORY...
|
|
|
|
| Re: Database creation error [message #49989 is a reply to message #49985] |
Thu, 21 February 2002 19:00  |
Satish Mehta
Messages: 6
Registered: January 2002
|
Junior Member |
|
|
Hi Balu,
I have faced similar error when i wanted to create a database in 9i. I got over it by allocating more memory to SGA and large_object_pool. It may or maynot work for you but you may like to try.
Please let me know if any other solution works!
thanx
warm regards
Satish
|
|
|
|
|
|
| Re: Database creation error [message #50002 is a reply to message #49985] |
Fri, 22 February 2002 09:28 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
Look in your bdump and udump directories for trace files. This will give you more information to work with. Things that can cause this is having remote_login_passwordfile set to EXCLUSIVE and not creating a password file first. Your trace files should give you more info.
|
|
|
|
| Re: Database creation error [message #50006 is a reply to message #50002] |
Fri, 22 February 2002 10:10 |
balu
Messages: 23
Registered: March 2001
|
Junior Member |
|
|
Hello,
This is what my trace file says.
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Offending statement at line 5298
CREATE TEMPORARY TABLESPACE TEMP_TS TEMPFILE
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5298
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
|
|
|
|
| Re: Database creation error [message #50008 is a reply to message #50002] |
Fri, 22 February 2002 11:08 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
It appears there is something wrong with your temporary tablespace name. You have "temts1" in your create script and the error says "CREATE TEMPORARY TABLESPACE TEMP_TS TEMPFILE" which doesn't match. Try taking it out and see if that is the problem. Have you tried using dbassist and saving it as a script and doing a compare between your script and the one dbassist creates?
|
|
|
|
| Re: Database creation error [message #57173 is a reply to message #49985] |
Sun, 25 May 2003 08:25 |
golshan
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
I problem in create database please help me :
CREATE DATABASE sss controlfile reuse logfile
'c:red.log' size 1M reuse,
datafile'c:system01.dbf' size 10M
autoextend on next 10M maxsize 200M ;
message error is:
ORA-02236 :invalid file name.
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
