设为首页收藏本站
开启辅助访问 切换到窄版
搜索
第一问答网»论坛 › 中问网 › 问答 › 手工建立数据库时强行断开连接的问题

手工建立数据库时强行断开连接的问题

[复制链接]
查看11 | 回复9 | 2005-2-28 12:57:00 | 显示全部楼层 |阅读模式
系统：WINDOWS 2000 ADVANCED SERVER 数据库：ORACLE 9i
我是这样作的
(1)建目录：copy D:\oracle\ora92\admin\sample to D:\oracle\admin目录下 改名inter
new D:\oracle\oradata\inter ...\archive
(2)复制init.ora文件并修改参数
(3)创建实例
oradim –new –sid inter –intpwd nerazzurri -startmode manual
-pfile d:\oracle\admin\inter\pfile\init.ora
(4)在注册表中设置主键：oracle_sid
设置环境变量: set oracle_sid = inter
(5)sqlplusw /nolog
(6)conn / as sysdba
(7)startup nomount pfile=D:\oracle\admin\inter\pfile\init.ora
(8)建立CREATE SPFILE FROM PFILE='d:\oracle\admin\inter\pfile\init.ora';
[B](9)create database inter
maxlogfiles 60
maxdatafiles 400
MAXINSTANCES 1
logfile group 1 'd:\oracle\oradata\inter\redo01.log' SIZE 15m,

group 2 'd:\oracle\oradata\inter\redo02.log' SIZE 15m,

group 3 'd:\oracle\oradata\inter\redo03.log' SIZE 15m
datafile 'D:\Oracle\oradata\inter\system01.dbf' SIZE 100m
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16;
当进行到这里时出现以下错误
ORA-01092: ORACLE 例程终止。强行断开连接


ORADATA相应目录下多了CONTROL01.CTL，CONTROL02.CTL，CONTROL03.CTL，redo01.log，redo02.log，redo03.log6个文件
接下来该怎么解决？先谢谢拉[/B]
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
附上：init.ora
dispatchers="(PROTOCOL=TCP) (SERVICE=misXDB)"
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE
job_queue_processes=10
instance_name=inter
aq_tm_processes=1
compatible=9.2.0.0.0
remote_login_passwordfile=EXCLUSIVE
pga_aggregate_target=25165824
sort_area_size=524288
db_domain=inter.it
db_name=inter
control_files=("D:\oracle\oradata\inter\CONTROL01.CTL", "D:\oracle\oradata\inter\CONTROL02.CTL", "D:\oracle\oradata\inter\CONTROL03.CTL&quot

java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=50331648
open_cursors=300
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
background_dump_dest=D:\oracle\admin\inter\bdump
core_dump_dest=D:\oracle\admin\inter\cdump
timed_statistics=TRUE
user_dump_dest=D:\oracle\admin\inter\udump
processes=150
fast_start_mttr_target=300
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_count=16
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
顶：）
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
先看看alert.log，以及background_dump_dest 和user_dump_dest 目录下的 .trc 文件，有些什么错误信息？
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
把alert.log中的内容也贴出来
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
好的
Dump file d:\oracle\admin\inter\bdump\alert_inter.log
Tue Aug 17 16:43:20 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Aug 17 16:43:20 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= D:\oracle\oradata\inter\CONTROL01.CTL, D:\oracle\oradata\inter\CONTROL02.CTL, D:\oracle\oradata\inter\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 25165824
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
= inter.it
instance_name
= inter
dispatchers
= (PROTOCOL=TCP) (SERVICE=misXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\inter\bdump
user_dump_dest = D:\oracle\admin\inter\udump
core_dump_dest = D:\oracle\admin\inter\cdump
sort_area_size = 524288
db_name
= inter
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Aug 17 16:43:23 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Aug 17 18:18:26 2004
create database inter
maxlogfiles 60
maxdatafiles 400
MAXINSTANCES 1
logfile group 1 'd:\oracle\oradata\inter\redo01.log' SIZE 15m,

group 2 'd:\oracle\oradata\inter\redo02.log' SIZE 15m,

group 3 'd:\oracle\oradata\inter\redo03.log' SIZE 15m
datafile 'D:\Oracle\oradata\inter\system01.dbf' SIZE 100m
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
Tue Aug 17 18:18:27 2004
Database mounted in Exclusive Mode.
Tue Aug 17 18:18:30 2004
Successful mount of redo thread 1, with mount id 1215990514.
Assigning activation ID 1215990514 (0x487a8af2)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\INTER\REDO01.LOG
Successful open of redo thread 1.
Tue Aug 17 18:18:31 2004
SMON: enabling cache recovery
Tue Aug 17 18:18:31 2004
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Tue Aug 17 18:18:31 2004
Errors in file d:\oracle\admin\inter\udump\inter_ora_2456.trc:
ORA-01501: CREATE DATABASE ??
ORA-30045: ??????????
Error 30045 happened during db open, shutting down database
USER: terminating instance due to error 30045
Instance terminated by USER, pid = 2456
ORA-1092 signalled during: create database inter
maxlogfiles 60
maxda...
Tue Aug 17 18:31:29 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= D:\oracle\oradata\inter\CONTROL01.CTL, D:\oracle\oradata\inter\CONTROL02.CTL, D:\oracle\oradata\inter\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 25165824
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
= inter.it
instance_name
= inter
dispatchers
= (PROTOCOL=TCP) (SERVICE=misXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\inter\bdump
user_dump_dest = D:\oracle\admin\inter\udump
core_dump_dest = D:\oracle\admin\inter\cdump
sort_area_size = 524288
db_name
= inter
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Aug 17 18:31:33 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Aug 17 18:31:59 2004
create database inter
maxlogfiles 60
maxdatafiles 400
MAXINSTANCES 1
logfile group 1 'd:\oracle\oradata\inter\redo01.log' SIZE 15m,

group 2 'd:\oracle\oradata\inter\redo02.log' SIZE 15m,

group 3 'd:\oracle\oradata\inter\redo03.log' SIZE 15m
datafile 'D:\Oracle\oradata\inter\system01.dbf' SIZE 100m
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
Tue Aug 17 18:32:02 2004
ORA-1501 signalled during: create database inter
maxlogfiles 60
maxda...
Tue Aug 17 20:50:33 2004
create database inter
maxlogfiles 60
maxdatafiles 400
MAXINSTANCES 1
logfile group 1 'd:\oracle\oradata\inter\redo01.log' SIZE 15m,

group 2 'd:\oracle\oradata\inter\redo02.log' SIZE 15m,

group 3 'd:\oracle\oradata\inter\redo03.log' SIZE 15m
datafile 'D:\Oracle\oradata\inter\system01.dbf' SIZE 100m
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
Tue Aug 17 20:50:35 2004
Database mounted in Exclusive Mode.
Tue Aug 17 20:50:37 2004
Successful mount of redo thread 1, with mount id 1215946905.
Assigning activation ID 1215946905 (0x4879e099)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\INTER\REDO01.LOG
Successful open of redo thread 1.
Tue Aug 17 20:50:38 2004
SMON: enabling cache recovery
Tue Aug 17 20:50:38 2004
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Tue Aug 17 20:50:38 2004
Errors in file d:\oracle\admin\inter\udump\inter_ora_2592.trc:
ORA-01501: CREATE DATABASE ??
ORA-30045: ??????????
Error 30045 happened during db open, shutting down database
USER: terminating instance due to error 30045
Instance terminated by USER, pid = 2592
ORA-1092 signalled during: create database inter
maxlogfiles 60
maxda...
Tue Aug 17 21:00:08 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= D:\oracle\oradata\inter\CONTROL01.CTL, D:\oracle\oradata\inter\CONTROL02.CTL, D:\oracle\oradata\inter\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 25165824
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
= inter.it
instance_name
= inter
dispatchers
= (PROTOCOL=TCP) (SERVICE=misXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\inter\bdump
user_dump_dest = D:\oracle\admin\inter\udump
core_dump_dest = D:\oracle\admin\inter\cdump
sort_area_size = 524288
db_name
= inter
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Aug 17 21:00:12 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Dump file d:\oracle\admin\inter\bdump\alert_inter.log
Wed Aug 18 10:44:35 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Wed Aug 18 10:44:35 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= D:\oracle\oradata\inter\CONTROL01.CTL, D:\oracle\oradata\inter\CONTROL02.CTL, D:\oracle\oradata\inter\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 25165824
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
= inter.it
instance_name
= inter
dispatchers
= (PROTOCOL=TCP) (SERVICE=misXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\inter\bdump
user_dump_dest = D:\oracle\admin\inter\udump
core_dump_dest = D:\oracle\admin\inter\cdump
sort_area_size = 524288
db_name
= inter
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Aug 18 10:44:40 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Aug 18 10:45:10 2004
create database inter
logfile group 1 'd:\oracle\oradata\inter\redo01.log' SIZE 15m,

group 2 'd:\oracle\oradata\inter\redo02.log' SIZE 15m,

group 3 'd:\oracle\oradata\inter\redo03.log' SIZE 15m
datafile 'D:\Oracle\oradata\inter\system01.dbf' SIZE 100m
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
Wed Aug 18 10:45:13 2004
ORA-1501 signalled during: create database inter
logfile group 1 'd:\orac...
Wed Aug 18 10:47:00 2004
Starting ORACLE instance (normal)
Wed Aug 18 10:48:03 2004
Starting ORACLE instance (normal)
Wed Aug 18 10:48:26 2004
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Wed Aug 18 10:48:28 2004
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Aug 18 10:48:38 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= D:\oracle\oradata\inter\CONTROL01.CTL, D:\oracle\oradata\inter\CONTROL02.CTL, D:\oracle\oradata\inter\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 25165824
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
= inter.it
instance_name
= inter
dispatchers
= (PROTOCOL=TCP) (SERVICE=misXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\inter\bdump
user_dump_dest = D:\oracle\admin\inter\udump
core_dump_dest = D:\oracle\admin\inter\cdump
sort_area_size = 524288
db_name
= inter
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Aug 18 10:48:41 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
ORA-01501 CREATE DATABASE failed
Cause: An error occurred during CREATE DATABASE.
Action: See accompanying errors.
ORA-30045 No undo tablespace name specified
Cause: If Create Database has the datafile clause, then undo tablespace
name has to be specified, unless using OMF.
Action: Specify the undo tablespace name.
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
新增undo tablespace后，执行create database inter
maxlogfiles 60
maxdatafiles 400
MAXINSTANCES 1
logfile group 1 'd:\oracle\oradata\inter\redo01.log' SIZE 15m,

group 2 'd:\oracle\oradata\inter\redo02.log' SIZE 15m,

group 3 'd:\oracle\oradata\inter\redo03.log' SIZE 15m
datafile 'D:\Oracle\oradata\inter\system01.dbf' SIZE 100m
undo tablespace undo
datafile 'D:\Oracle\oradata\inter\undotbs01.dbf' SIZE 40M
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16;出错，但是比原来的命令，除了建立了DATAFILE，CONTROLFILE，REDO。LOG，UNDO DATAFILE
以下是alert_inter.log
Dump file d:\oracle\admin\inter\bdump\alert_inter.log
Wed Aug 18 14:00:40 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Wed Aug 18 14:00:40 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= D:\oracle\oradata\inter\CONTROL01.CTL, D:\oracle\oradata\inter\CONTROL02.CTL, D:\oracle\oradata\inter\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 25165824
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
= inter.it
instance_name
= inter
dispatchers
= (PROTOCOL=TCP) (SERVICE=misXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\inter\bdump
user_dump_dest = D:\oracle\admin\inter\udump
core_dump_dest = D:\oracle\admin\inter\cdump
sort_area_size = 524288
db_name
= inter
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Aug 18 14:00:43 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Aug 18 14:01:08 2004
create database inter
maxlogfiles 60
maxdatafiles 400
MAXINSTANCES 1
logfile group 1 'd:\oracle\oradata\inter\redo01.log' SIZE 15m,

group 2 'd:\oracle\oradata\inter\redo02.log' SIZE 15m,

group 3 'd:\oracle\oradata\inter\redo03.log' SIZE 15m
datafile 'D:\Oracle\oradata\inter\system01.dbf' SIZE 100m
undo tablespace undo
datafile 'D:\Oracle\oradata\inter\undotbs01.dbf' SIZE 40M
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
Wed Aug 18 14:01:09 2004
Database mounted in Exclusive Mode.
Wed Aug 18 14:01:12 2004
Successful mount of redo thread 1, with mount id 1216012836.
Assigning activation ID 1216012836 (0x487ae224)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\INTER\REDO01.LOG
Successful open of redo thread 1.
Wed Aug 18 14:01:12 2004
SMON: enabling cache recovery
Wed Aug 18 14:01:12 2004
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Wed Aug 18 14:01:12 2004
create tablespace SYSTEM datafile'D:\Oracle\oradata\inter\system01.dbf' SIZE 100m
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Completed: create tablespace SYSTEM datafile'D:\Oracle\orad
Wed Aug 18 14:01:16 2004
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM

[B]Wed Aug 18 14:01:37 2004
CREATE UNDO TABLESPACE UNDO DATAFILE'D:\Oracle\oradata\inter\undotbs01.dbf' SIZE 40M
Wed Aug 18 14:01:39 2004
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDO DATAFILE'D:\Oracle\o...
Wed Aug 18 14:01:39 2004
Errors in file d:\oracle\admin\inter\udump\inter_ora_2464.trc:
ORA-00604: ?? SQL ? 1 ????
ORA-30012: ????? 'UNDOTBS1' ?????????
Wed Aug 18 14:01:39 2004
Errors in file d:\oracle\admin\inter\udump\inter_ora_2464.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ?????'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ'????5161???
ORA-00604: ?? SQL ? 1 ????
ORA-30012: ????? 'UNDOTBS1' ?????????
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 2464
ORA-1092 signalled during: create database inter
maxlogfiles 60
maxda...[/B]
请教 yangtingkun 斑竹。。。。
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
BTW：比如ORA-30045这些错误代码的含义是这么查出来的？
回复

使用道具 举报

千问 | 2005-2-28 12:57:00 | 显示全部楼层
tahiti.oracle.com
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

千问

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
回复楼主 返回列表
热门排行