- 论坛徽章:
- 0
|
建库过程中出现ora-01092错误，查看alter 发现如下问题
Wed Aug 6 04:53:27 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
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 = 318767104
large_pool_size = 16777216
java_pool_size = 218103808
control_files = /oradata/ybzs/control01.ctl, /oradata/ybzs/control02.ctl, /oradata/ybzs/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = LOCATION=/archlog/ybzs/archive
log_archive_format = %t_%s.dbf
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 =
instance_name = ybzs
dispatchers = (PROTOCOL=TCP) (SERVICE=ybzsXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /oradata/admin/ybzs/bdump
user_dump_dest = /oradata/admin/ybzs/udump
core_dump_dest = /oradata/admin/ybzs/cdump
sort_area_size = 524288
db_name = ybzs
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 6 04:53:29 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
ARC1 started with pid=13
ARC1: Archival started
Wed Aug 6 04:53:29 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Aug 6 04:53:29 2008
ARC1: Thread not mounted
Wed Aug 6 04:53:29 2008
ARC0: Thread not mounted
Wed Aug 6 04:53:31 2008
CREATE DATABASE ybzs
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/oradata/ybzs/system01.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/ybzs/temp01.dbf' SIZE 4000M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oradata/ybzs/undotbs01.dbf' SIZE 4000M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oradata/ybzs/redo01.log', '/oradata/ybzs/redo04.log') SIZE 204800K,
GROUP 2 ('/oradata/ybzs/redo02.log', '/oradata/ybzs/redo05.log') SIZE 204800K,
GROUP 3 ('/oradata/ybzs/redo03.log', '/oradata/ybzs/redo06.log') SIZE 204800K
Wed Aug 6 04:53:33 2008
Database mounted in Exclusive Mode.
Wed Aug 6 04:54:03 2008
Successful mount of redo thread 1, with mount id 287352076.
Assigning activation ID 287352076 (0x1120a50c)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /oradata/ybzs/redo01.log
Current log# 1 seq# 1 mem# 1: /oradata/ybzs/redo04.log
Successful open of redo thread 1.
Wed Aug 6 04:54:03 2008
SMON: enabling cache recovery
Wed Aug 6 04:54:03 2008
ARC1: Media recovery disabled
Wed Aug 6 04:54:03 2008
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Wed Aug 6 04:54:03 2008
create tablespace SYSTEM datafile '/oradata/ybzs/system01.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
ORA-1119 signalled during: create tablespace SYSTEM datafile '/oradata/ybzs/...
Wed Aug 6 04:54:03 2008
Errors in file /oradata/admin/ybzs/udump/ybzs_ora_360624.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/oradata/ybzs/system01.dbf'
ORA-27039: create file failed, file size limit reached
Additional information: 1
Wed Aug 6 04:54:03 2008
Errors in file /oradata/admin/ybzs/udump/ybzs_ora_360624.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 642
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/oradata/ybzs/system01.dbf'
ORA-27039: create file failed, file size limit reached
Additional information: 1
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Wed Aug 6 04:54:03 2008
Errors in file /oradata/admin/ybzs/bdump/ybzs_lgwr_307368.trc:
ORA-01519: error while processing file '' near line
Wed Aug 6 04:54:03 2008
Errors in file /oradata/admin/ybzs/bdump/ybzs_dbw0_303290.trc:
ORA-01519: error while processing file '' near line
Wed Aug 6 04:54:03 2008
Errors in file /oradata/admin/ybzs/bdump/ybzs_ckpt_319646.trc:
ORA-01519: error while processing file '' near line
Wed Aug 6 04:54:05 2008
Errors in file /oradata/admin/ybzs/bdump/ybzs_pmon_110790.trc:
ORA-01519: error while processing file '' near line
Wed Aug 6 04:54:16 2008
Instance terminated by USER, pid = 360624
ORA-1092 signalled during: CREATE DATABASE ybzs
MAXINSTANCES 1
MAXLOGHISTORY ...
追踪ybzs_ora_360624.trc
/oradata/admin/ybzs/udump/ybzs_ora_360624.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /oracle/app/oracle/product/9.2.0
System name: AIX
Node name: lqyb01
Release: 3
Version: 5
Machine: 00C94AB04C00
Instance name: ybzs
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 360624, image: oracle@lqyb01 (TNS V1-V3)
*** SESSION ID 11.1) 2008-08-06 04:54:03.288
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/oradata/ybzs/system01.dbf'
ORA-27039: create file failed, file size limit reached
Additional information: 1
Offending statement at line 642
create tablespace SYSTEM datafile '/oradata/ybzs/system01.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 642
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/oradata/ybzs/system01.dbf'
ORA-27039: create file failed, file size limit reached
Additional information: 1
紧急在线等，请大家帮忙看下 |
|
免费注册
发表于 2008-08-06 13:27
