9i 手工创建库排错

来源：互联网发布：js中创建字符串对象编辑：程序博客网时间：2024/05/29 16:37

手工创建9i数据，复制了官方模版，修改后，如下：

SQL> CREATE DATABASE tan1
2     USER SYS IDENTIFIED BY pz6r58
3     USER SYSTEM IDENTIFIED BY y1tz5p
4     LOGFILE GROUP 1 ('/apps/oracle/oradata/tan1/redo01.log') SIZE 100M,
5             GROUP 2 ('/apps/oracle/oradata/tan1/redo02.log') SIZE 100M,
6             GROUP 3 ('/apps/oracle/oradata/tan1/redo03.log') SIZE 100M
7     MAXLOGFILES 5
8     MAXLOGMEMBERS 5
9     MAXLOGHISTORY 1
10     MAXDATAFILES 100
11     MAXINSTANCES 1
12     CHARACTER SET AL32UTF8
13     NATIONAL CHARACTER SET AL16UTF16
14     DATAFILE '/apps/oracle/oradata/tan1/system01.dbf' SIZE 325M REUSE
15     EXTENT MANAGEMENT LOCAL
16     DEFAULT TEMPORARY TABLESPACE tempts1
17        DATAFILE '/apps/oracle/oradata/tan1/temp01.dbf'
18        SIZE 20M REUSE
19     UNDO TABLESPACE UNDOTBS1
20        DATAFILE '/apps/oracle/oradata/tan1/undotbs01.dbf'
21        SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
      DATAFILE '/apps/oracle/oradata/tan1/temp01.dbf'
      *
ERROR at line 17:
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
报错，将DATAFILE改为TEMPFILE

CREATE DATABASE tan1
   USER SYS IDENTIFIED BY pz6r58
   USER SYSTEM IDENTIFIED BY y1tz5p
   LOGFILE GROUP 1 ('/apps/oracle/oradata/tan1/redo01.log') SIZE 100M,
           GROUP 2 ('/apps/oracle/oradata/tan1/redo02.log') SIZE 100M,
           GROUP 3 ('/apps/oracle/oradata/tan1/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/apps/oracle/oradata/tan1/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/apps/oracle/oradata/tan1/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE UNDOTBS1
      DATAFILE '/apps/oracle/oradata/tan1/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

CREATE DATABASE tan1
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

又异常终止，检查各个参数，发现compatible设置为8.2.0。
修改下面的参数后再来尝试：

SQL> alter system set compatible='9.2.0' scope=spfile;

System altered.

SQL> startup force;
ORACLE instance started.

Total System Global Area 106272064 bytes
Fixed Size                   451904 bytes
Variable Size             104857600 bytes
Database Buffers             819200 bytes
Redo Buffers                 143360 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

SQL> CREATE DATABASE tan1
2     USER SYS IDENTIFIED BY pz6r58
3     USER SYSTEM IDENTIFIED BY y1tz5p
4     LOGFILE GROUP 1 ('/apps/oracle/oradata/tan1/redo01.log') SIZE 100M,
5             GROUP 2 ('/apps/oracle/oradata/tan1/redo02.log') SIZE 100M,
6             GROUP 3 ('/apps/oracle/oradata/tan1/redo03.log') SIZE 100M
7     MAXLOGFILES 5
8     MAXLOGMEMBERS 5
9     MAXLOGHISTORY 1
10     MAXDATAFILES 100
11     MAXINSTANCES 1
12     CHARACTER SET AL32UTF8
13     NATIONAL CHARACTER SET AL16UTF16
14     DATAFILE '/apps/oracle/oradata/tan1/system01.dbf' SIZE 325M REUSE
15     EXTENT MANAGEMENT LOCAL
16     DEFAULT TEMPORARY TABLESPACE tempts1
17        TEMPFILE '/apps/oracle/oradata/tan1/temp01.dbf'
18        SIZE 20M REUSE
19     UNDO TABLESPACE UNDOTBS1
20        DATAFILE '/apps/oracle/oradata/tan1/undotbs01.dbf'
21        SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

Database created.

SQL>