| database creation problem [message #128660] |
Wed, 20 July 2005 01:12  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
hi to all,
I m creating a new database on my machine .
Platform - win XP
ORACLE 9i.
I created service , password file for new database. i started the database in nomount stage. now when i run create database command it gives following error ---
SQL> startup nomount pfile="D:\oracle\admin\tanudb1\scripts\init.ora";
ORACLE instance started.
Total System Global Area 110172924 bytes
Fixed Size 453372 bytes
Variable Size 58720256 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
SQL> CREATE DATABASE tanudb1
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 5
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 DATAFILE 'D:\oracle\oradata\tanudb1\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MA
XSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\oradata\tanudb1\temp01.dbf' SIZE 40M REUS
E AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
10 UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\oradata\tanudb1\undotbs01.dbf' SIZE 200M REUSE A
UTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
11 CHARACTER SET WE8MSWIN1252
12 NATIONAL CHARACTER SET AL16UTF16
13 LOGFILE GROUP 1 ('D:\oracle\oradata\tanudb1\redo01.log') SIZE 102400K,
14 GROUP 2 ('D:\oracle\oradata\tanudb1\redo02.log') SIZE 102400K,
15 GROUP 3 ('D:\oracle\oradata\tanudb1\redo03.log') SIZE 102400K;
CREATE DATABASE tanudb1
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
But when i check the oradata/tanudb1 folder, then i can find redo log files, control files , system01.dbf, temp01.dbf and undotbs01.dbf but the rest of the files are not present.
Please help me to come out of this situation.
regards,
TArun
|
|
|
|
| Re: database creation problem [message #128663 is a reply to message #128660] |
Wed, 20 July 2005 01:30  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
Pls do check the alert log file in order to obtain the point when error is happening.
Also, as mandatory, before starting recreation, pls do delete all such file (data files, redo log files, control files) created during the erroneous process.
Regds
Girish
|
|
|
|
| Re: database creation problem [message #128665 is a reply to message #128663] |
Wed, 20 July 2005 01:32 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi
Also check
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\oradata\tanudb1\undotbs01.dbf' SIZE 200M REUSE A
UTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
Whats the name for undo tablespace that You have specified in the pfile. It should be same as the one specified in the create database command.
Regds
Girish
|
|
|
|
| Re: database creation problem [message #128698 is a reply to message #128665] |
Wed, 20 July 2005 03:38 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi Girish,
I got the solution, actually while creating the new database i located the password file in the bin directory and Oracle was looking it in database. I checked the alert log n got the solution.
Thanks a lot.
Regards,
Tarun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
