oracle10g online docs--create database statments's error

使用 Oracle® Database Administrator's Guide
10g Release 2 (10.2)
Part Number B14231-02

 

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

创建数据库，报

ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

 

跟踪日志 ：

[oracle@localhost log]$ more mydb_ora_6422.trc
Dump file /opt/oracle/app/oracle/product/10.2.0/db_1/rdbms/log/mydb_ora_6422.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/oracle/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      localhost
Release:        2.6.9-67.ELsmp
Version:        #1 SMP Wed Nov 7 13:58:04 EST 2007
Machine:        i686
Instance name: mydb
Redo thread mounted by this instance: 0
Oracle process number: 12
Unix process pid: 6422, image: oracle@localhost (TNS V1-V3)

*** 2012-08-12 16:19:13.831
*** SERVICE NAME:() 2012-08-12 16:19:13.829
*** SESSION ID:(51.1) 2012-08-12 16:19:13.829
kccsga_update_ckpt: num_1 = 1, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 416 blocks
*** 2012-08-12 16:20:20.659
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Offending statement at line 6262
CREATE  TABLESPACE TBS_1 DATAFILE  SEGMENT SPACE MANAGEMENT MANUAL
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6262
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name

 

file '?/rdbms/admin/sql.bsq' near line 6262

rem
rem create the default permanent tablespace for the database
rem
"D_CRTDPTS"
/

问题在这里，DEFAULT TABLESPACE tbs_1
指定 数据文件，创建库成功。

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/18914315/viewspace-740817/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/18914315/viewspace-740817/