disp+work启动一分钟后变灰，SAP无法登陆

显示全部楼层 · 2006-9-16 14:27:11

请看dev_disp文件和dev_ms,dev_w0文件
***************************************************
***************************************************
dev_disp文件
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "620"
---------------------------------------------------
Tue Jul 18 17:35:05 2006
kernel runs with dp version 3(ext=1) (@(#) DPLIB-INT-VERSION-3)
length of sys_adm_ext is 304 bytes
systemid 560 (PC with Windows NT)
relno6200
patchlevel 0
patchno674
intno20020600
pid3188
***LOG Q00=> DpSapEnvInit, DPStart (00 3188) [dpxxdisp.c 978]

shared lib "dw_xml.dll" version 674 successfully loaded

shared lib "dw_xtc.dll" version 674 successfully loaded

shared lib "dw_stl.dll" version 674 successfully loaded
Tue Jul 18 17:35:11 2006
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c3212]
MtxInit: -2 0 0
DpShMCreate: sizeof(wp_adm)
9776
(752)
DpShMCreate: sizeof(tm_adm)
1690816
(8412)
DpShMCreate: sizeof(wp_ca_adm)
18000
(60)
DpShMCreate: sizeof(appc_ca_adm)
6000
(60)
DpShMCreate: sizeof(comm_adm)
192000
(384)
DpShMCreate: sizeof(wall_adm)
(22440/34344/56/100)
DpShMCreate: SHM_DP_ADM_KEY
(addr: 03340040, size: 1974816)
DpShMCreate: allocated sys_adm at 03340040
DpShMCreate: allocated wp_adm at 03340560
DpShMCreate: allocated tm_adm_list at 03342B90
DpShMCreate: allocated tm_adm at 03342BB8
DpShMCreate: allocated wp_ca_adm at 034DF878
DpShMCreate: allocated appc_ca_adm at 034E3EC8
DpShMCreate: allocated comm_adm_list at 034E5638
DpShMCreate: allocated comm_adm at 034E5650
DpShMCreate: allocated ca_info at 03514450
DpShMCreate: allocated wall_adm at 03514458
MBUF state OFF
EmInit: MmSetImplementation( 2 ).
client 0 initializing ....
InitFreeList
block size is 1024 kByte.
Using implementation std
Memory Reset enabled as NT default
EsIUnamFileMapInit: Initialize the memory 268 MB
267 blocks reserved for free list.
ES initialized.
Tue Jul 18 17:35:12 2006
***LOG Q0K=> DpMsAttach, mscon ( usa2006) [dpxxdisp.c 9115]
Tue Jul 18 17:35:30 2006
CCMS: Initalizing shared memory of size 20000000 for monitoring segment.
Tue Jul 18 17:35:34 2006
CCMS: start to initalize 3.X shared alert area (first segment).
Tue Jul 18 17:35:35 2006
DpMsgAdmin: Set release to 6200, patchlevel 0
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 941]
DpMsgAdmin: Set patchno for this platform to 674
Release check o.K.
Tue Jul 18 17:36:33 2006
*** ERROR => W0 (pid 3248) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W0
*** ERROR => W1 (pid 3256) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W1
*** ERROR => W2 (pid 3264) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W2
*** ERROR => W3 (pid 3272) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W3
*** ERROR => W4 (pid 3280) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W4
*** ERROR => W5 (pid 3288) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W5
*** ERROR => W6 (pid 3296) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W6
*** ERROR => W7 (pid 3304) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W7
*** ERROR => W8 (pid 3312) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W8
*** ERROR => W9 (pid 3320) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W9
*** ERROR => W10 (pid 3328) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W10
*** ERROR => W11 (pid 3336) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W11
*** ERROR => W12 (pid 3344) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W12
my types changed after wp death/restart 0xbf --> 0x80
*** DP_FATAL_ERROR => DpEnvCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
DpModState: change server state from STARTING to SHUTDOWN
Tue Jul 18 17:36:43 2006
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9341]
MBUF state OFF
MBUF component DOWN
***LOG Q05=> DpHalt, DPStop ( 3188) [dpxxdisp.c 7883]
*****************************************************************************
*****************************************************************************
dev_ms文件

---------------------------------------------------
trc file: "dev_ms", trc level: 1, release: "620"
---------------------------------------------------
[Thr 3184] Tue Jul 18 17:35:03 2006
[Thr 3184] MsSSetTrcLog: trc logging not active
[Thr 3184] relno6200
[Thr 3184] patchlevel 0
[Thr 3184] patchno665
[Thr 3184] intno20020600
[Thr 3184] pid3180
[Thr 3184] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3180) [msxxserv.c 1524]
[Thr 3184] Tue Jul 18 17:35:04 2006
[Thr 3184] MsHttpPortInsert: set HTTP state to LISTEN
[Thr 3184] *** I listen to port sapmsQAS (3600) ***
[Thr 3184] *** HTTP LISTEN ***
[Thr 3184] *** I listen to HTTP port 8100 ***
[Thr 3184] CUSTOMER KEY: >V0049409186 NiPRead: recv (10054: WSAECONNRESET: Connection reset by peer) [ninti.c 1094]
[Thr 3184] *** ERROR => MsSRead: NiBufReceive (rc=NIECONN_BROKEN) [msxxserv.c 8523]
[Thr 3184] *** ERROR => MsSClientHandle: MsSRead C1 (usa2006_QAS_00), MSEINTERN [msxxserv.c 3662]
[Thr 3184] Tue Jul 18 17:47:04 2006
[Thr 3184] *** ERROR => MsSCheckConnections: no response from client C0 (192.168.102.200) after 300 secs received [msxxserv.c 2910]
[Thr 3184] *** ERROR => MsSCheckConnections: disconnect now [192.168.102.200] [msxxserv.c 2914]
[Thr 3208] Tue Jul 18 19:43:44 2006
[Thr 3208] MsSExit: received SIGINT (2)
[Thr 3208] ***LOG Q02=> MsSHalt, MSStop (Msg Server 3180) [msxxserv.c 4811]
************************************************************************************
************************************************************************************
dev_w0文件

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "620"
---------------------------------------------------
*
*ACTIVE TRACE LEVEL 1
*ACTIVE TRACE COMPONENTSall, M
*
B
B Tue Jul 18 17:35:27 2006
Bcreate_con (con_name=R/3)
BLoading DB library 'C:\usr\sap\QAS\SYS\exe\run\dboraslib.dll' ...
BLibrary 'C:\usr\sap\QAS\SYS\exe\run\dboraslib.dll' loaded
BVersion of 'C:\usr\sap\QAS\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)
BNew connection 0 created
Msystemid 560 (PC with Windows NT)
Mrelno6200
Mpatchlevel 0
Mpatchno674
Mintno20020600
Mpid3248
M
M***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3248) [dpxxdisp.c 1028]
IMtxInit: -2 0 0
M
M Tue Jul 18 17:35:30 2006
MDpShMCreate: sizeof(wp_adm)
9776
(752)
MDpShMCreate: sizeof(tm_adm)
1690816
(8412)
MDpShMCreate: sizeof(wp_ca_adm)
18000
(60)
MDpShMCreate: sizeof(appc_ca_adm)
6000
(60)
MDpShMCreate: sizeof(comm_adm)
192000
(384)
MDpShMCreate: sizeof(wall_adm)
(22440/34344/56/100)
MDpShMCreate: SHM_DP_ADM_KEY
(addr: 03340040, size: 1974816)
MDpShMCreate: allocated sys_adm at 03340040
MDpShMCreate: allocated wp_adm at 03340560
MDpShMCreate: allocated tm_adm_list at 03342B90
MDpShMCreate: allocated tm_adm at 03342BB8
MDpShMCreate: allocated wp_ca_adm at 034DF878
MDpShMCreate: allocated appc_ca_adm at 034E3EC8
MDpShMCreate: allocated comm_adm_list at 034E5638
MDpShMCreate: allocated comm_adm at 034E5650
MDpShMCreate: allocated ca_info at 03514450
MDpShMCreate: allocated wall_adm at 03514458
X
X Tue Jul 18 17:35:34 2006
XEmInit: MmSetImplementation( 2 ).
X client 0 initializing ....
X
X Tue Jul 18 17:35:35 2006
XUsing implementation std
M Memory Reset enabled as NT default
XES initialized.
M
M Tue Jul 18 17:35:36 2006
Mcalling db_connect ...
CGot ORACLE_HOME=D:\oracle\ora92 from environment
C
C Tue Jul 18 17:35:59 2006
CClient NLS settings: AMERICAN_AMERICA.WE8DEC
CLogon as OPS$-user to get SAPQAS's password
CConnecting as /@QAS on connection 0 ...
C
C Tue Jul 18 17:36:00 2006
CAttaching to DB Server QAS (con_hdl=0,svchp=0318CD3C,svrhp=062D4A14)
C
C Tue Jul 18 17:36:15 2006
CStarting user session (con_hdl=0,svchp=0318CD3C,srvhp=062D4A14,usrhp=062DD1EC)
C
C Tue Jul 18 17:36:17 2006
C*** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c3718]
C*** ERROR => CONNECT failed with sql error '1017'
[dboci.c9601]
CTry to connect with default password
CConnecting as SAPQAS/@QAS on connection 0 ...
CStarting user session (con_hdl=0,svchp=0318CD3C,srvhp=062D4A14,usrhp=062DD1EC)
C*** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c3718]
C*** ERROR => CONNECT failed with sql error '1017'
[dboci.c9601]
B***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 962] [dbsh0962 ]
B***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 962] [dbsh0962 ]
B***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink0419 ]
B***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink0419 ]
M***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1102]
Min_ThErrHandle: 1
M*** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8437]
M
MInfo for wp 0
M
Mstat = 4
Mreqtype = 1
Mact_reqtype = -1
Mtid = -1
Mmode = 255
Mlen = -1
Mrq_id = -1
Mrq_source = 255
Mlast_tid = 0
Mlast_mode = 0
Mrfc_req = 0
Mreport = >
ThrSaveSPAFields ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]
M*** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c237]
MEntering ThSetStatError
MEntering ThReadDetachMode
Mcall ThrShutDown (1)...
M***LOG Q02=> wp_halt, WPStop (Workproc 0 3248) [dpnttool.c 346]

千问 · 2006-9-16 14:27:11

原因很明显, 连接数据库的用户口令不对,
Try to connect with default password
Connecting as SAPQAS/@QAS on connection 0 ...
ORA-01017: invalid username/password; logon denied
应该通过用户qasadm登陆启动R/3系统, 该用户的口令应与sapr3的口令一致, 系统缺省就是使用登陆用户的口令做为sapr3(或sapsr3)的口令连接数据库的. 可以检查是否可以连接数据库, 运行:
sqlplussapr3/yourpassword@QAS
看能否联结数据库

千问 · 2006-9-16 14:27:11

千问 · 2006-9-16 14:27:11

alert_qas.log

Dump file d:\oracle\admin\qas\bdump\alert_qas.log
Tue Jul 18 00:24:15 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Jul 18 00:24:15 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 00:24:18 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 00:24:20 2006
CREATE DATABASE QAS
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'D:\oracle\oradata\QAS\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\oradata\QAS\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\oradata\QAS\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('D:\oracle\oradata\QAS\redo01.log') SIZE 102400K,
GROUP 2 ('D:\oracle\oradata\QAS\redo02.log') SIZE 102400K,
GROUP 3 ('D:\oracle\oradata\QAS\redo03.log') SIZE 102400K
Tue Jul 18 00:24:20 2006
Database mounted in Exclusive Mode.
Tue Jul 18 00:24:28 2006
Successful mount of redo thread 1, with mount id 1985531636.
Assigning activation ID 1985531636 (0x7658cef4)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\QAS\REDO01.LOG
Successful open of redo thread 1.
Tue Jul 18 00:24:28 2006
SMON: enabling cache recovery
Tue Jul 18 00:24:28 2006
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Tue Jul 18 00:24:28 2006
create tablespace SYSTEM datafile'D:\oracle\oradata\QAS\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Completed: create tablespace SYSTEM datafile'D:\oracle\orad
Tue Jul 18 00:24:34 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM

Tue Jul 18 00:24:47 2006
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'D:\oracle\oradata\QAS\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
Tue Jul 18 00:24:52 2006
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$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'D:\orac
Tue Jul 18 00:24:53 2006
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE'D:\oracle\oradata\QAS\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE'D:\ora
Tue Jul 18 00:24:53 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Tue Jul 18 00:24:56 2006
SMON: enabling tx recovery
Tue Jul 18 00:24:58 2006
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: CREATE DATABASE QAS
MAXINSTANCES 1
MAXLOGHISTORY 1
Tue Jul 18 00:24:58 2006
CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'D:\oracle\oradata\QAS\drsys01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Tue Jul 18 00:24:59 2006
Completed: CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'D:\ora
Tue Jul 18 00:24:59 2006
CREATE TABLESPACE "EXAMPLE" LOGGING DATAFILE 'D:\oracle\oradata\QAS\example01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "EXAMPLE" LOGGING DATAFILE 'D:\o
Tue Jul 18 00:25:02 2006
CREATE TABLESPACE "INDX" LOGGING DATAFILE 'D:\oracle\oradata\QAS\indx01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "INDX" LOGGING DATAFILE 'D:\orac
Tue Jul 18 00:25:03 2006
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'D:\oracle\oradata\QAS\tools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'D:\ora
Tue Jul 18 00:25:03 2006
CREATE TABLESPACE "USERS" LOGGING DATAFILE 'D:\oracle\oradata\QAS\users01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "USERS" LOGGING DATAFILE 'D:\ora
Tue Jul 18 00:25:04 2006
CREATE TABLESPACE "XDB" LOGGING DATAFILE 'D:\oracle\oradata\QAS\xdb01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "XDB" LOGGING DATAFILE 'D:\oracl
Tue Jul 18 00:25:11 2006
Restarting dead background process QMN0
QMN0 started with pid=12
Tue Jul 18 00:28:27 2006
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: D:\ORACLE\ORADATA\QAS\REDO02.LOG
Tue Jul 18 00:30:54 2006
Restarting dead background process QMN0
QMN0 started with pid=12
Tue Jul 18 00:36:22 2006
Thread 1 advanced to log sequence 3
Current log# 3 seq# 3 mem# 0: D:\ORACLE\ORADATA\QAS\REDO03.LOG
Tue Jul 18 00:38:07 2006
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 3744
Dump file d:\oracle\admin\qas\bdump\alert_qas.log
Tue Jul 18 00:42:52 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Jul 18 00:42:52 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 00:42:54 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 00:42:55 2006
CREATE DATABASE QAS
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'D:\oracle\QAS\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\QAS\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\QAS\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('D:\oracle\oradata\QAS\redo01.log') SIZE 102400K,
GROUP 2 ('D:\oracle\oradata\QAS\redo02.log') SIZE 102400K,
GROUP 3 ('D:\oracle\oradata\QAS\redo03.log') SIZE 102400K
Tue Jul 18 00:42:56 2006
Database mounted in Exclusive Mode.
Tue Jul 18 00:43:04 2006
Successful mount of redo thread 1, with mount id 1985546319.
Assigning activation ID 1985546319 (0x7659084f)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\QAS\REDO01.LOG
Successful open of redo thread 1.
Tue Jul 18 00:43:04 2006
SMON: enabling cache recovery
Tue Jul 18 00:43:04 2006
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Tue Jul 18 00:43:04 2006
create tablespace SYSTEM datafile'D:\oracle\QAS\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Completed: create tablespace SYSTEM datafile'D:\oracle\QAS\
Tue Jul 18 00:43:11 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM

Tue Jul 18 00:43:24 2006
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'D:\oracle\QAS\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
Tue Jul 18 00:43:29 2006
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$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'D:\orac
Tue Jul 18 00:43:30 2006
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE'D:\oracle\QAS\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE'D:\ora
Tue Jul 18 00:43:30 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Tue Jul 18 00:43:32 2006
SMON: enabling tx recovery
Tue Jul 18 00:43:34 2006
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: CREATE DATABASE QAS
MAXINSTANCES 1
MAXLOGHISTORY 1
Tue Jul 18 00:43:34 2006
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 164
Dump file d:\oracle\admin\qas\bdump\alert_qas.log
Tue Jul 18 00:44:48 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Jul 18 00:44:48 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 00:44:51 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 00:44:52 2006
CREATE DATABASE QAS
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'D:\oracle\QAS\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\QAS\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\QAS\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('D:\oracle\oradata\QAS\redo01.log') SIZE 102400K,
GROUP 2 ('D:\oracle\oradata\QAS\redo02.log') SIZE 102400K,
GROUP 3 ('D:\oracle\oradata\QAS\redo03.log') SIZE 102400K
Tue Jul 18 00:44:52 2006
Database mounted in Exclusive Mode.
Tue Jul 18 00:45:01 2006
Successful mount of redo thread 1, with mount id 1985515460.
Assigning activation ID 1985515460 (0x76588fc4)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\QAS\REDO01.LOG
Successful open of redo thread 1.
Tue Jul 18 00:45:01 2006
SMON: enabling cache recovery
Tue Jul 18 00:45:01 2006
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Tue Jul 18 00:45:01 2006
create tablespace SYSTEM datafile'D:\oracle\QAS\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Completed: create tablespace SYSTEM datafile'D:\oracle\QAS\
Tue Jul 18 00:45:07 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM

Tue Jul 18 00:45:20 2006
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'D:\oracle\QAS\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
Tue Jul 18 00:45:25 2006
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$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'D:\orac
Tue Jul 18 00:45:26 2006
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE'D:\oracle\QAS\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE'D:\ora
Tue Jul 18 00:45:26 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Tue Jul 18 00:45:28 2006
SMON: enabling tx recovery
Tue Jul 18 00:45:31 2006
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: CREATE DATABASE QAS
MAXINSTANCES 1
MAXLOGHISTORY 1
Tue Jul 18 00:45:31 2006
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 1144
Dump file d:\oracle\admin\qas\bdump\alert_qas.log
Tue Jul 18 00:45:42 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Jul 18 00:45:42 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 00:45:44 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 00:45:45 2006
CREATE DATABASE QAS
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'D:\oracle\QAS\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\QAS\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\QAS\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('D:\oracle\oradata\QAS\redo01.log') SIZE 102400K,
GROUP 2 ('D:\oracle\oradata\QAS\redo02.log') SIZE 102400K,
GROUP 3 ('D:\oracle\oradata\QAS\redo03.log') SIZE 102400K
Tue Jul 18 00:45:45 2006
Database mounted in Exclusive Mode.
Tue Jul 18 00:45:54 2006
Successful mount of redo thread 1, with mount id 1985533433.
Assigning activation ID 1985533433 (0x7658d5f9)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\QAS\REDO01.LOG
Successful open of redo thread 1.
Tue Jul 18 00:45:54 2006
SMON: enabling cache recovery
Tue Jul 18 00:45:54 2006
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Tue Jul 18 00:45:54 2006
create tablespace SYSTEM datafile'D:\oracle\QAS\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Completed: create tablespace SYSTEM datafile'D:\oracle\QAS\
Tue Jul 18 00:46:04 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM

Tue Jul 18 00:46:17 2006
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'D:\oracle\QAS\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
Tue Jul 18 00:46:24 2006
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$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'D:\orac
Tue Jul 18 00:46:25 2006
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE'D:\oracle\QAS\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE'D:\ora
Tue Jul 18 00:46:26 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Tue Jul 18 00:46:28 2006
SMON: enabling tx recovery
Tue Jul 18 00:46:30 2006
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: CREATE DATABASE QAS
MAXINSTANCES 1
MAXLOGHISTORY 1
Tue Jul 18 00:46:30 2006
CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'D:\oracle\QAS\drsys01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Tue Jul 18 00:46:31 2006
Completed: CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'D:\ora
Tue Jul 18 00:46:31 2006
CREATE TABLESPACE "EXAMPLE" LOGGING DATAFILE 'D:\oracle\QAS\example01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "EXAMPLE" LOGGING DATAFILE 'D:\o
Tue Jul 18 00:46:36 2006
CREATE TABLESPACE "INDX" LOGGING DATAFILE 'D:\oracle\QAS\indx01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "INDX" LOGGING DATAFILE 'D:\orac
Tue Jul 18 00:46:37 2006
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'D:\oracle\QAS\tools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'D:\ora
Tue Jul 18 00:46:37 2006
CREATE TABLESPACE "USERS" LOGGING DATAFILE 'D:\oracle\QAS\users01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "USERS" LOGGING DATAFILE 'D:\ora
Tue Jul 18 00:46:38 2006
CREATE TABLESPACE "XDB" LOGGING DATAFILE 'D:\oracle\QAS\xdb01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO
Completed: CREATE TABLESPACE "XDB" LOGGING DATAFILE 'D:\oracl
Tue Jul 18 00:46:42 2006
Restarting dead background process QMN0
QMN0 started with pid=12
Tue Jul 18 00:49:59 2006
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: D:\ORACLE\ORADATA\QAS\REDO02.LOG
Tue Jul 18 00:51:45 2006
Restarting dead background process QMN0
QMN0 started with pid=12
Tue Jul 18 00:55:59 2006
Thread 1 advanced to log sequence 3
Current log# 3 seq# 3 mem# 0: D:\ORACLE\ORADATA\QAS\REDO03.LOG
Tue Jul 18 00:59:44 2006
Thread 1 advanced to log sequence 4
Current log# 1 seq# 4 mem# 0: D:\ORACLE\ORADATA\QAS\REDO01.LOG
Tue Jul 18 01:05:21 2006
Thread 1 advanced to log sequence 5
Current log# 2 seq# 5 mem# 0: D:\ORACLE\ORADATA\QAS\REDO02.LOG
Tue Jul 18 01:13:44 2006
Thread 1 advanced to log sequence 6
Current log# 3 seq# 6 mem# 0: D:\ORACLE\ORADATA\QAS\REDO03.LOG
Tue Jul 18 01:17:13 2006
Thread 1 advanced to log sequence 7
Current log# 1 seq# 7 mem# 0: D:\ORACLE\ORADATA\QAS\REDO01.LOG
Tue Jul 18 01:23:14 2006
Thread 1 advanced to log sequence 8
Current log# 2 seq# 8 mem# 0: D:\ORACLE\ORADATA\QAS\REDO02.LOG
Tue Jul 18 01:28:02 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 4
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jul 18 01:28:07 2006
ALTER DATABASE CLOSE NORMAL
Tue Jul 18 01:28:07 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jul 18 01:28:08 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 8
Successful close of redo thread 1.
Tue Jul 18 01:28:09 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jul 18 01:28:09 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Tue Jul 18 01:28:19 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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

千问 · 2006-9-16 14:27:11

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 Jul 18 01:28:22 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 01:28:23 2006
ALTER DATABASE MOUNT
Tue Jul 18 01:28:27 2006
Successful mount of redo thread 1, with mount id 1985518071.
Tue Jul 18 01:28:27 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Jul 18 01:28:27 2006
ALTER DATABASE OPEN
Tue Jul 18 01:28:28 2006
Thread 1 opened at log sequence 8
Current log# 2 seq# 8 mem# 0: D:\ORACLE\ORADATA\QAS\REDO02.LOG
Successful open of redo thread 1.
Tue Jul 18 01:28:28 2006
SMON: enabling cache recovery
Tue Jul 18 01:28:29 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 18 01:28:29 2006
SMON: enabling tx recovery
Tue Jul 18 01:28:29 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Tue Jul 18 01:52:53 2006
alter database open
Tue Jul 18 01:52:53 2006
ORA-1531 signalled during: alter database open...
Tue Jul 18 01:53:41 2006
Starting ORACLE instance (normal)
Tue Jul 18 02:05:12 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 5
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jul 18 02:05:16 2006
ALTER DATABASE CLOSE NORMAL
Tue Jul 18 02:05:16 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jul 18 02:05:17 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 8
Successful close of redo thread 1.
Tue Jul 18 02:05:17 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jul 18 02:05:18 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Tue Jul 18 02:05:37 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 02:05:40 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 02:05:41 2006
ALTER DATABASE MOUNT
Tue Jul 18 02:05:45 2006
Successful mount of redo thread 1, with mount id 1985501877.
Tue Jul 18 02:05:45 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Jul 18 02:05:45 2006
ALTER DATABASE OPEN
Tue Jul 18 02:05:46 2006
Thread 1 opened at log sequence 8
Current log# 2 seq# 8 mem# 0: D:\ORACLE\ORADATA\QAS\REDO02.LOG
Successful open of redo thread 1.
Tue Jul 18 02:05:46 2006
SMON: enabling cache recovery
Tue Jul 18 02:05:47 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 18 02:05:47 2006
SMON: enabling tx recovery
Tue Jul 18 02:05:47 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Dump file d:\oracle\admin\qas\bdump\alert_qas.log
Tue Jul 18 09:53:35 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Jul 18 09:53:35 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 09:53:43 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 09:53:45 2006
alter database mount exclusive
Tue Jul 18 09:53:51 2006
Successful mount of redo thread 1, with mount id 1985493354.
Tue Jul 18 09:53:51 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 18 09:53:51 2006
alter database open
Tue Jul 18 09:53:53 2006
Beginning crash recovery of 1 threads
Tue Jul 18 09:53:53 2006
Started first pass scan
Tue Jul 18 09:53:54 2006
Completed first pass scan
381 redo blocks read, 84 data blocks need recovery
Tue Jul 18 09:53:55 2006
Started recovery at
Thread 1: logseq 8, block 34112, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\QAS\REDO02.LOG
Tue Jul 18 09:53:56 2006
Completed redo application
Tue Jul 18 09:53:57 2006
Ended recovery at
Thread 1: logseq 8, block 34493, scn 0.163927
84 data blocks read, 84 data blocks written, 381 redo blocks read
Crash recovery completed successfully
Tue Jul 18 09:54:00 2006
Thread 1 advanced to log sequence 9
Thread 1 opened at log sequence 9
Current log# 3 seq# 9 mem# 0: D:\ORACLE\ORADATA\QAS\REDO03.LOG
Successful open of redo thread 1.
Tue Jul 18 09:54:02 2006
SMON: enabling cache recovery
Tue Jul 18 09:54:04 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 18 09:54:04 2006
SMON: enabling tx recovery
Tue Jul 18 09:54:07 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Starting ORACLE instance (normal)
Tue Jul 18 10:42:43 2006
alter database open
Tue Jul 18 10:42:43 2006
ORA-1531 signalled during: alter database open...
Tue Jul 18 10:46:06 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jul 18 10:46:09 2006
ALTER DATABASE CLOSE NORMAL
Tue Jul 18 10:46:10 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jul 18 10:46:10 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 9
Successful close of redo thread 1.
Tue Jul 18 10:46:11 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jul 18 10:46:11 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Dump file d:\oracle\admin\qas\bdump\alert_qas.log
Tue Jul 18 10:48:14 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Jul 18 10:48:14 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 10:48:17 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 10:48:18 2006
alter database mount exclusive
Tue Jul 18 10:48:22 2006
Successful mount of redo thread 1, with mount id 1985496370.
Tue Jul 18 10:48:22 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 18 10:48:22 2006
alter database open
Tue Jul 18 10:48:23 2006
Thread 1 opened at log sequence 9
Current log# 3 seq# 9 mem# 0: D:\ORACLE\ORADATA\QAS\REDO03.LOG
Successful open of redo thread 1.
Tue Jul 18 10:48:23 2006
SMON: enabling cache recovery
Tue Jul 18 10:48:24 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 18 10:48:24 2006
SMON: enabling tx recovery
Tue Jul 18 10:48:24 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Starting ORACLE instance (normal)
Starting ORACLE instance (normal)
Tue Jul 18 11:04:42 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 15
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jul 18 11:04:48 2006
ALTER DATABASE CLOSE NORMAL
Tue Jul 18 11:04:49 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jul 18 11:04:50 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 9
Successful close of redo thread 1.
Tue Jul 18 11:04:51 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jul 18 11:04:51 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Tue Jul 18 11:17:02 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 11:17:05 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 11:17:06 2006
ALTER DATABASE MOUNT
Tue Jul 18 11:17:10 2006
Successful mount of redo thread 1, with mount id 1985491442.
Tue Jul 18 11:17:10 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Jul 18 11:18:06 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Jul 18 11:21:44 2006
alter database open
Tue Jul 18 11:21:46 2006
Thread 1 opened at log sequence 9
Current log# 3 seq# 9 mem# 0: D:\ORACLE\ORADATA\QAS\REDO03.LOG
Successful open of redo thread 1.
Tue Jul 18 11:21:46 2006
SMON: enabling cache recovery
Tue Jul 18 11:21:47 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 18 11:21:47 2006
SMON: enabling tx recovery
Tue Jul 18 11:21:47 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue Jul 18 11:22:21 2006
drop tablespace drsys including contents
Tue Jul 18 11:22:22 2006
ORA-2449 signalled during: drop tablespace drsys including contents...
Tue Jul 18 11:23:10 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Jul 18 11:23:26 2006
drop tablespace tablespace_name including contents
Tue Jul 18 11:23:26 2006
ORA-959 signalled during: drop tablespace tablespace_name including contents...
Tue Jul 18 11:24:13 2006
drop tablespace xdb including contents
Tue Jul 18 11:24:13 2006
ORA-29857 signalled during: drop tablespace xdb including contents...
Tue Jul 18 11:35:26 2006
drop tablespace example including contents
Tue Jul 18 11:35:26 2006
ORA-23515 signalled during: drop tablespace example including contents...
Tue Jul 18 11:35:59 2006
drop tablespacetemp including contents
Tue Jul 18 11:35:59 2006
ORA-12906 signalled during: drop tablespacetemp including contents...
Tue Jul 18 11:37:05 2006
drop tablespace xdb including contents
Tue Jul 18 11:37:05 2006
ORA-29857 signalled during: drop tablespace xdb including contents...
Tue Jul 18 11:38:19 2006
alter tablespace xdb offline
Tue Jul 18 11:38:20 2006
Completed: alter tablespace xdb offline
Tue Jul 18 11:38:56 2006
alter tablespace xdb online
Tue Jul 18 11:38:56 2006
Completed: alter tablespace xdb online
Tue Jul 18 11:39:35 2006
altertablespacetemp
defaultstorage(pctincrease1)
Tue Jul 18 11:39:35 2006
ORA-3217 signalled during: altertablespacetemp
defaultstorage(pctincrea...
Tue Jul 18 11:40:03 2006
altertablespacetemp defaultstorage(pctincrease1)
Tue Jul 18 11:40:03 2006
ORA-3217 signalled during: altertablespacetemp defaultstorage(pctincrea...
Tue Jul 18 11:42:18 2006
alter tablespace temp defaultstorage(pctincrease 1)
Tue Jul 18 11:42:18 2006
ORA-3217 signalled during: alter tablespace temp defaultstorage(pctincrease...
Tue Jul 18 11:42:31 2006
altertablespacetempcoalesce
Tue Jul 18 11:42:31 2006
ORA-3217 signalled during: altertablespacetempcoalesce...
Tue Jul 18 11:43:20 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jul 18 11:43:22 2006
ALTER DATABASE CLOSE NORMAL
Tue Jul 18 11:43:22 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jul 18 11:43:23 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 9
Successful close of redo thread 1.
Tue Jul 18 11:43:23 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jul 18 11:43:23 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Dump file d:\oracle\admin\qas\bdump\alert_qas.log
Tue Jul 18 17:13:14 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Jul 18 17:13:14 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 17:13:18 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 17:13:21 2006
alter database mount exclusive
Tue Jul 18 17:13:26 2006
Successful mount of redo thread 1, with mount id 1985565809.
Tue Jul 18 17:13:26 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 18 17:13:26 2006
alter database open
Tue Jul 18 17:13:28 2006
Thread 1 opened at log sequence 9
Current log# 3 seq# 9 mem# 0: D:\ORACLE\ORADATA\QAS\REDO03.LOG
Successful open of redo thread 1.
Tue Jul 18 17:13:28 2006
SMON: enabling cache recovery
Tue Jul 18 17:13:32 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 18 17:13:32 2006
SMON: enabling tx recovery
Tue Jul 18 17:13:32 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue Jul 18 17:35:00 2006
Starting ORACLE instance (normal)
Tue Jul 18 19:56:52 2006
alter database open
Tue Jul 18 19:56:53 2006
ORA-1531 signalled during: alter database open...
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 15
Tue Jul 18 20:04:50 2006
Active call for process 1804 user 'SYSTEM' program 'ORACLE.EXE'
SHUTDOWN: waiting for active calls to complete.
Dump file d:\oracle\admin\qas\bdump\alert_qas.log
Tue Jul 18 20:38:04 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Jul 18 20:38:04 2006
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.4.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\QAS\control01.ctl, D:\oracle\oradata\QAS\control02.ctl, D:\oracle\oradata\QAS\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
=
instance_name
= QAS
dispatchers
= (PROTOCOL=TCP) (SERVICE=QASXDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\QAS\bdump
user_dump_dest = D:\oracle\admin\QAS\udump
core_dump_dest = D:\oracle\admin\QAS\cdump
sort_area_size = 524288
db_name
= QAS
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 Jul 18 20:38:07 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 18 20:38:08 2006
alter database mount exclusive
Tue Jul 18 20:38:12 2006
Successful mount of redo thread 1, with mount id 1985595760.
Tue Jul 18 20:38:12 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 18 20:38:12 2006
alter database open
Tue Jul 18 20:38:12 2006
Beginning crash recovery of 1 threads
Tue Jul 18 20:38:13 2006
Started first pass scan
Tue Jul 18 20:38:13 2006
Completed first pass scan
12 redo blocks read, 13 data blocks need recovery
Tue Jul 18 20:38:13 2006
Started recovery at
Thread 1: logseq 9, block 7308, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 9 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\QAS\REDO03.LOG
Tue Jul 18 20:38:14 2006
Completed redo application
Tue Jul 18 20:38:14 2006
Ended recovery at
Thread 1: logseq 9, block 7320, scn 0.203335
13 data blocks read, 13 data blocks written, 12 redo blocks read
Crash recovery completed successfully
Tue Jul 18 20:38:15 2006
Thread 1 advanced to log sequence 10
Thread 1 opened at log sequence 10
Current log# 1 seq# 10 mem# 0: D:\ORACLE\ORADATA\QAS\REDO01.LOG
Successful open of redo thread 1.
Tue Jul 18 20:38:16 2006
SMON: enabling cache recovery
Tue Jul 18 20:38:19 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 18 20:38:19 2006
SMON: enabling tx recovery
Tue Jul 18 20:38:19 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Starting ORACLE instance (normal)
Tue Jul 18 22:05:22 2006
Starting ORACLE instance (normal)
Tue Jul 18 22:05:37 2006
ALTER DATABASE OPEN
Tue Jul 18 22:05:37 2006
ORA-1531 signalled during: ALTER DATABASE OPEN...
Tue Jul 18 22:08:02 2006
Starting ORACLE instance (normal)

千问 · 2006-9-16 14:27:11

不用贴那么多的log了, 能用system正常连接数据库表明它完全正常,问题就出在dispather连接R/3数据库的用户SAPR3(或SAPSR3)密码上, 你运行sqlplus sapr3/usa2006@QAS能正常运行么?不行再尝试口令全大写试试, 保持你的qasadm口令与它一致

千问 · 2006-9-16 14:27:11

ERROR：
ORA-01017：invalid username/password; logon denied
该怎么办啊

千问 · 2006-9-16 14:27:11

但是运行
SQLPLUS SYSTEM/USA2006@QAS可以连接
显示connected to

racle9i enterprise edition release 9.2.0.4.0 - production with the partionting,OLAP and Oracle Date Mining options Jserver Release 9.2.0.4.0

千问 · 2006-9-16 14:27:11

谢谢LIUQS，然后我该怎么办呢？

千问 · 2006-9-16 14:27:11

前天，我用DBCA删除了有问题的旧数据库，创建了新数据库。名称和旧的一样，是QAS。不知道会不会有影响