错误---------ORA-01501: CREATE DATABASE 失败ORA-01100: ORA-01100: 数据库已安装

[tongdayong1981]

大家帮我看一下到底是哪儿错了
1----创建好目录后
2----创建oracle服务
Oradim –NEW –SID TestDB –INTPWD password –STARTMODE manual –PFILE “D:\Oracle9\admin\TestDB\pfile\initTestDB.ora”
3-----SET ORACLE_SID=TestDB
4------conn TestDB/password as sysdba
5-------
create database TestDB
maxlogfiles 5
maxdatafiles 100
datafile 'd:\oracle\oradata\TestDB\system01.dbf' size 10m reuse
autoextend on next 100k maxsize unlimited
undo tablespace "undotbs" datafile 'd:\oracle\oradata\TestDB\undotbs01.dbf' size 10m reuse
autoextend on next 100k maxsize unlimited
logfile
group 1 'D:\oracle\oradata\TestDB\redo01.log' size 10m,
group 2 'd:\oracle\oradata\TestDB\redo02.log' size 10m,
group 3 'd:\oracle\oradata\TestDB\redo03.log' size 10m;

ERROR 位于第 1 行:
ORA-01501: CREATE DATABASE 失败
ORA-01100: 数据库已安装
请问怎么解决

[tongdayong1981]

SQL> conn TestDB/password as sysdba
已连接。
SQL> create database TestDB
2 maxlogfiles 5
3 maxdatafiles 100
4 datafile 'd:\oracle\oradata\TestDB\system01.dbf' size 10m reuse
5 autoextend on next 100k maxsize unlimited
6 undo tablespace "undotbs" datafile 'd:\oracle\oradata\TestDB\undotbs01.dbf' size 10m reuse
7 autoextend on next 100k maxsize unlimited
8 logfile
9 group 1 'D:\oracle\oradata\TestDB\redo01.log' size 10m,
10 group 2 'd:\oracle\oradata\TestDB\redo02.log' size 10m,
11 group 3 'd:\oracle\oradata\TestDB\redo03.log' size 10m;
create database TestDB
*
ERROR 位于第 1 行:
ORA-01501: CREATE DATABASE 失败
ORA-01100: 数据库已安装

[tongdayong1981]

还有设置Oradim –NEW –SID TestDB –INTPWD password –STARTMODE manual –PFILE “D:\Oracle9\admin\TestDB\pfile\initTestDB.ora”
到底有什么深意,我不太清楚

[tongdayong1981]

我查了一下,要把原来的数据库关闭,但是还是出现下面的错误,我该怎么办
SQL> conn sys/password as sysdba;
已连接到空闲例程。
SQL> startup nomount pfile="D:\oracle\admin\TestDB\pfile\initTestDB.ora";
LRM-00101: unknown parameter name 'service_name'
ORA-01078: 处理系统参数失败
SQL> startup nomount;
ORACLE 例程已经启动。

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> create database TestDB
2 maxlogfiles 5
3 maxdatafiles 100
4 datafile 'd:\oracle\oradata\TestDB\system01.dbf' size 10m reuse
5 autoextend on next 100k maxsize unlimited
6 undo tablespace "undotbs" datafile 'd:\oracle\oradata\TestDB\undotbs01.dbf' size 10m reuse
7 autoextend on next 100k maxsize unlimited
8 logfile
9 group 1 'D:\oracle\oradata\TestDB\redo01.log' size 10m,
10 group 2 'd:\oracle\oradata\TestDB\redo02.log' size 10m,
11 group 3 'd:\oracle\oradata\TestDB\redo03.log' size 10m;
create database TestDB
*
ERROR 位于第 1 行:
ORA-01501: CREATE DATABASE ??
ORA-01504: ????'TESTDB'??? db_name 'student'???

[常遇道]

怎么你的创库这么复杂呀

[ComponentOne]

把 initTestDB.ora 中的 service_name 改一下。看行不行。

[tongdayong1981]

我写了还是不行,有谁遇到相同的问题给我讲一下啊??我几个星期都没创建好这个数据库