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: 数据库已安装
已连接。
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: 数据库已安装
到底有什么深意,我不太清楚
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'???