用oracle 的databaase configuration assistant 向导来创建数据库出错....请大家帮忙看看ORA-01092:oracle 例程终止.强制断开连接
Dump file d:\oracle\product\10.1.0\admin\jx\bdump\alert_jx.log
Fri May 28 08:57:08 2010
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:1080M/2046M, PG:2864M/3943M, VA:1955M/2047M
Fri May 28 08:57:08 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle\product\10.1.0\db_1\RDBMS
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
sga_target = 167772160
control_files = D:\ORACLE\PRODUCT\10.1.0\JX\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.1.0\JX\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.1.0\JX\CONTROL03.CTL
db_block_size = 8192
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=jxXDB)
job_queue_processes = 10
background_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\JX\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\JX\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\JX\CDUMP
sort_area_size = 65536
db_name = jx
open_cursors = 300
pga_aggregate_target = 25165824
Fri May 28 08:57:12 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
DBW0 started with pid=4, OS id=2352
LGWR started with pid=5, OS id=2360
MMAN started with pid=3, OS id=2344
PMON started with pid=2, OS id=2336
CKPT started with pid=6, OS id=2356
RECO started with pid=8, OS id=2348
CJQ0 started with pid=9, OS id=2368
SMON started with pid=7, OS id=2364
Fri May 28 08:57:17 2010
CREATE DATABASE "jx"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'D:\oracle\product\10.1.0\jx\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'D:\oracle\product\10.1.0\jx\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\product\10.1.0\jx\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\product\10.1.0\jx\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('D:\oracle\product\10.1.0\jx\redo01.log') SIZE 10240K,
GROUP 2 ('D:\oracle\product\10.1.0\jx\redo02.log') SIZE 10240K,
GROUP 3 ('D:\oracle\product\10.1.0\jx\redo03.log') SIZE 10240K
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY
Fri May 28 08:57:18 2010
Controlfile identified with block size 16384
Fri May 28 08:57:18 2010
Controlfile created with 174 blocks of size 16384 bytes
Fri May 28 08:57:18 2010
Published database character set on system events channel
Database mounted in Exclusive Mode.
Fri May 28 08:57:19 2010
Successful mount of redo thread 1, with mount id 875825261
Assigning activation ID 875825261 (0x3434086d)
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\PRODUCT\10.1.0\JX\REDO01.LOG
Successful open of redo thread 1
Fri May 28 08:57:20 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri May 28 08:57:20 2010
All processes have switched to database character set
Fri May 28 08:57:20 2010
SMON: enabling cache recovery
Fri May 28 08:57:20 2010
create tablespace SYSTEM datafile 'D:\oracle\product\10.1.0\jx\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL onlineFri May 28 08:57:27 2010
Completed: create tablespace SYSTEM datafile 'D:\oracle\prod
Fri May 28 08:57:27 2010
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEM
Fri May 28 08:57:29 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\udump\jx_ora_3064.trc:
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????Fri May 28 08:57:29 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\udump\jx_ora_3064.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ????? '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' ???? 2356 ???
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Fri May 28 08:57:29 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_reco_2348.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:29 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_smon_2364.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:30 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_mman_2344.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:30 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_ckpt_2356.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:30 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_lgwr_2360.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:30 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_dbw0_2352.trc:
ORA-01519: error while processing file '' near line Instance terminated by USER, pid = 3064
ORA-1092 signalled during: CREATE DATABASE "jx"
MAXINSTANCES 8
MAXLOGHISTORY ...
Fri May 28 08:57:32 2010
Shutting down instance (abort)
Dump file d:\oracle\product\10.1.0\admin\jx\bdump\alert_jx.log
Fri May 28 08:57:08 2010
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:1080M/2046M, PG:2864M/3943M, VA:1955M/2047M
Fri May 28 08:57:08 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle\product\10.1.0\db_1\RDBMS
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
sga_target = 167772160
control_files = D:\ORACLE\PRODUCT\10.1.0\JX\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.1.0\JX\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.1.0\JX\CONTROL03.CTL
db_block_size = 8192
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=jxXDB)
job_queue_processes = 10
background_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\JX\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\JX\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\JX\CDUMP
sort_area_size = 65536
db_name = jx
open_cursors = 300
pga_aggregate_target = 25165824
Fri May 28 08:57:12 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
DBW0 started with pid=4, OS id=2352
LGWR started with pid=5, OS id=2360
MMAN started with pid=3, OS id=2344
PMON started with pid=2, OS id=2336
CKPT started with pid=6, OS id=2356
RECO started with pid=8, OS id=2348
CJQ0 started with pid=9, OS id=2368
SMON started with pid=7, OS id=2364
Fri May 28 08:57:17 2010
CREATE DATABASE "jx"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'D:\oracle\product\10.1.0\jx\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'D:\oracle\product\10.1.0\jx\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\product\10.1.0\jx\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\product\10.1.0\jx\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('D:\oracle\product\10.1.0\jx\redo01.log') SIZE 10240K,
GROUP 2 ('D:\oracle\product\10.1.0\jx\redo02.log') SIZE 10240K,
GROUP 3 ('D:\oracle\product\10.1.0\jx\redo03.log') SIZE 10240K
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY
Fri May 28 08:57:18 2010
Controlfile identified with block size 16384
Fri May 28 08:57:18 2010
Controlfile created with 174 blocks of size 16384 bytes
Fri May 28 08:57:18 2010
Published database character set on system events channel
Database mounted in Exclusive Mode.
Fri May 28 08:57:19 2010
Successful mount of redo thread 1, with mount id 875825261
Assigning activation ID 875825261 (0x3434086d)
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\PRODUCT\10.1.0\JX\REDO01.LOG
Successful open of redo thread 1
Fri May 28 08:57:20 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri May 28 08:57:20 2010
All processes have switched to database character set
Fri May 28 08:57:20 2010
SMON: enabling cache recovery
Fri May 28 08:57:20 2010
create tablespace SYSTEM datafile 'D:\oracle\product\10.1.0\jx\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL onlineFri May 28 08:57:27 2010
Completed: create tablespace SYSTEM datafile 'D:\oracle\prod
Fri May 28 08:57:27 2010
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEM
Fri May 28 08:57:29 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\udump\jx_ora_3064.trc:
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????Fri May 28 08:57:29 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\udump\jx_ora_3064.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ????? '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' ???? 2356 ???
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Fri May 28 08:57:29 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_reco_2348.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:29 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_smon_2364.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:30 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_mman_2344.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:30 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_ckpt_2356.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:30 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_lgwr_2360.trc:
ORA-01519: error while processing file '' near line Fri May 28 08:57:30 2010
Errors in file d:\oracle\product\10.1.0\admin\jx\bdump\jx_dbw0_2352.trc:
ORA-01519: error while processing file '' near line Instance terminated by USER, pid = 3064
ORA-1092 signalled during: CREATE DATABASE "jx"
MAXINSTANCES 8
MAXLOGHISTORY ...
Fri May 28 08:57:32 2010
Shutting down instance (abort)
解决方案 »
- oracle用一张表的字段更新另一张表的字段
- ORACLE error 1 in FDPSTP
- oracle长时间使用odbc连接不上!但oem和sqlplus却能正常使用!郁闷中!
- 请问ORACLE登录问题 报错:ora-01017
- 期待高手
- *急问*急问*要用pro*c把对数据库的查询,update,都做成dll,现在做成 .pc文件,编译成c后,单独运行没有问题,但是一旦 加入到vc的一个工
- 请问如何切换使用不同版本的oracle数据库?
- 日期格式对于内部缓冲区过长
- 关于:在9i中新增有一个叫固定视图或叫汇总视图的技术,哪位大狭可以讲讲!!!
- 求助,大神帮帮忙,oracle无法启动
- SQL中 WHERE 后 LIKE %(select语句)%
- 闪回表可以闪回多久的数据,可不可以设置的?
dbca 是用来创建新的实例。 你贴的日志是你现在实例的日志。 你是怎样操作的, dbca都是下一步的问题,一般不会出先问题。
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977