sys使用者無法連線到DB
sys使用者無法連線到DB!
問題描述:
SQL> conn system/ygzhou518
已連線。
SQL>
SQL> desc v$pwfile_users
名稱 是否為空? 型別
------------------------- ------------------ -------------------
USERNAME VARCHAR2(30)
SYSDBA VARCHAR2(5)
SYSOPER VARCHAR2(5)
SYSASM VARCHAR2(5)
SQL> select *from v$pwfile_users; //密碼檔案中有sys使用者
USERNAME SYSDB SYSOP SYSAS
------------------------------ ------------- ------------ -------------
SYS TRUE TRUE FALSE
SQL> alter user sys identified by ygzhou518;
使用者已更改。
SQL> conn sys/ygzhou518 as sysdba
ERROR:
ORA-28056: 未能將審計記錄寫入 Windows 事件日誌
OSD-260360600: Message 260360600 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 6) 控制程式碼無效。
ORA-01075: 您現在已登入
警告: 您不再連線到 ORACLE。
SQL> show user;
USER 為 ""
SQL>
在create database 的時候有出現‘ORA-28056: 未能將審計記錄寫入 Windows 事件日誌’錯誤,通過對系統日誌內容的清理,順利安裝。
檢視alter.ora檔案:
Fri Apr 15 23:59:25 2011
AUD: OS Error = 1502 encountered while writing audit record
AUD: OS Error = 1502 encountered while writing audit record
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production.
Using parameter settings in client-side pfile E:\ORACLE11G\ADMIN\DB01\PFILE\INIT.ORA on machine YGZHOU02
System parameters with non-default values:
processes = 150
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 300M
control_files = "E:\ORACLE11G\ORADATA\DB01\CONTROL01.CTL"
control_files = "E:\ORACLE11G\ORADATA\DB01\CONTROL02.CTL"
control_files = "E:\ORACLE11G\BACKUP\CONTROL\CONTROL03.CTL"
control_files = "E:\ORACLE11G\BACKUP\CONTROL\CONTROL04.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=E:\Oracle11g\backup\archive\"
log_archive_format = "ARC%S_%R.%T"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "E:\ORACLE11G\ADMIN\DB01\ADUMP"
audit_trail = "DB"
db_name = "DB01"
open_cursors = 300
diagnostic_dest = "E:\ORACLE11G"
Fri Apr 15 23:59:29 2011
PMON started with pid=2, OS id=1544
Fri Apr 15 23:59:29 2011
PSP0 started with pid=3, OS id=1072
Fri Apr 15 23:59:30 2011
VKTM started with pid=4, OS id=1288 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Fri Apr 15 23:59:30 2011
GEN0 started with pid=5, OS id=1012
Fri Apr 15 23:59:30 2011
DIAG started with pid=6, OS id=1088
Fri Apr 15 23:59:30 2011
DBRM started with pid=7, OS id=644
Fri Apr 15 23:59:30 2011
DIA0 started with pid=8, OS id=212
Fri Apr 15 23:59:30 2011
MMAN started with pid=9, OS id=1556
Fri Apr 15 23:59:30 2011
DBW0 started with pid=10, OS id=1876
Fri Apr 15 23:59:30 2011
LGWR started with pid=11, OS id=1452
Fri Apr 15 23:59:30 2011
CKPT started with pid=12, OS id=1304
Fri Apr 15 23:59:30 2011
SMON started with pid=13, OS id=800
Fri Apr 15 23:59:30 2011
RECO started with pid=14, OS id=1372
Fri Apr 15 23:59:30 2011
MMON started with pid=15, OS id=792
Fri Apr 15 23:59:30 2011
MMNL started with pid=16, OS id=1408
ORACLE_BASE from environment = E:\Oracle11g
Sat Apr 16 00:00:26 2011
ALTER DATABASE DEFAULT TABLESPACE "USERS"
ORA-1507 signalled during: ALTER DATABASE DEFAULT TABLESPACE "USERS"...
Sat Apr 16 00:02:36 2011
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 396): terminating the instance
Instance terminated by USER, pid = 396
Sat Apr 16 00:02:36 2011
Instance shutdown complete
Sat Apr 16 00:03:56 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production.
Using parameter settings in client-side pfile E:\ORACLE11G\ADMIN\DB01\PFILE\INIT.ORA on machine YGZHOU02
System parameters with non-default values:
processes = 150
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 300M
control_files = "E:\ORACLE11G\ORADATA\DB01\CONTROL01.CTL"
control_files = "E:\ORACLE11G\ORADATA\DB01\CONTROL02.CTL"
control_files = "E:\ORACLE11G\BACKUP\CONTROL\CONTROL03.CTL"
control_files = "E:\ORACLE11G\ORADATA\DB01\CONTROL04.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=E:\Oracle11g\backup\archive\"
log_archive_format = "ARC%S_%R.%T"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=ygzhouXDB)"
audit_file_dest = "E:\ORACLE11G\ADMIN\DB01\ADUMP"
audit_trail = "DB"
db_name = "DB01"
open_cursors = 300
diagnostic_dest = "E:\ORACLE11G"
Sat Apr 16 00:04:05 2011
PMON started with pid=2, OS id=296
Sat Apr 16 00:04:05 2011
PSP0 started with pid=3, OS id=708
Sat Apr 16 00:04:06 2011
VKTM started with pid=4, OS id=1328 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sat Apr 16 00:04:06 2011
GEN0 started with pid=5, OS id=1192
Sat Apr 16 00:04:06 2011
DIAG started with pid=6, OS id=1880
Sat Apr 16 00:04:06 2011
DBRM started with pid=7, OS id=260
Sat Apr 16 00:04:06 2011
DIA0 started with pid=8, OS id=1732
Sat Apr 16 00:04:06 2011
MMAN started with pid=9, OS id=188
Sat Apr 16 00:04:06 2011
DBW0 started with pid=10, OS id=1748
Sat Apr 16 00:04:06 2011
LGWR started with pid=11, OS id=432
Sat Apr 16 00:04:06 2011
CKPT started with pid=12, OS id=1144
Sat Apr 16 00:04:06 2011
SMON started with pid=13, OS id=1560
Sat Apr 16 00:04:06 2011
RECO started with pid=14, OS id=1256
Sat Apr 16 00:04:06 2011
MMON started with pid=15, OS id=1184
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Apr 16 00:04:06 2011
MMNL started with pid=16, OS id=784
starting up 1 shared server(s) ...
ORACLE_BASE from environment = E:\Oracle11g
Sat Apr 16 00:04:06 2011
CREATE DATABASE "DB01"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'E:\Oracle11g\oradata\DB01\system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'E:\Oracle11g\oradata\DB01\sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\Oracle11g\oradata\DB01\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE 'E:\Oracle11g\oradata\DB01\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('E:\Oracle11g\oradata\DB01\redo01.log') SIZE 51200K,
GROUP 2 ('E:\Oracle11g\oradata\DB01\redo02.log') SIZE 51200K,
GROUP 3 ('E:\Oracle11g\oradata\DB01\redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY
Database mounted in Exclusive Mode
Lost write protection disabled
Sat Apr 16 00:04:18 2011
Successful mount of redo thread 1, with mount id 1379883703
Assigning activation ID 1379883703 (0x523f5ab7)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Successful open of redo thread 1
Sat Apr 16 00:04:19 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Apr 16 00:04:19 2011
SMON: enabling cache recovery
processing %ORACLE_HOME%\RDBMS\ADMIN\dcore.bsq
create tablespace SYSTEM datafile 'E:\Oracle11g\oradata\DB01\system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Sat Apr 16 00:04:56 2011
Completed: create tablespace SYSTEM datafile 'E:\Oracle11g\oradata\DB01\system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
UNDO_SEG_CRT: Could not find usn tail
Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Undo initialization finished serial:0 start:4747546 end:4747578 diff:32 (0 seconds)
processing %ORACLE_HOME%\RDBMS\ADMIN\dsqlddl.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dmanage.bsq
CREATE TABLESPACE sysaux DATAFILE 'E:\Oracle11g\oradata\DB01\sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
Sat Apr 16 00:05:25 2011
Completed: CREATE TABLESPACE sysaux DATAFILE 'E:\Oracle11g\oradata\DB01\sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
processing %ORACLE_HOME%\RDBMS\ADMIN\dplsql.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dtxnspc.bsq
CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE 'E:\Oracle11g\oradata\DB01\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
Sat Apr 16 00:05:37 2011
[404] Successfully onlined Undo Tablespace 2.
Completed: CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE 'E:\Oracle11g\oradata\DB01\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CREATE SMALLFILE TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\Oracle11g\oradata\DB01\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: CREATE SMALLFILE TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\Oracle11g\oradata\DB01\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
ALTER DATABASE DEFAULT TABLESPACE SYSTEM
Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM
processing %ORACLE_HOME%\RDBMS\ADMIN\dfmap.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\denv.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\drac.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dsec.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\doptim.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dobj.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\djava.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dpart.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\drep.bsq
Sat Apr 16 00:05:48 2011
processing %ORACLE_HOME%\RDBMS\ADMIN\daw.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dsummgt.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dtools.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dexttab.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\ddm.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\dlmnr.bsq
processing %ORACLE_HOME%\RDBMS\ADMIN\ddst.bsq
Sat Apr 16 00:05:57 2011
SMON: enabling tx recovery
Starting background process SMCO
Sat Apr 16 00:05:58 2011
SMCO started with pid=21, OS id=1528
Sat Apr 16 00:06:13 2011
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sat Apr 16 00:06:13 2011
QMNC started with pid=23, OS id=412
Completed: CREATE DATABASE "DB01"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'E:\Oracle11g\oradata\DB01\system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'E:\Oracle11g\oradata\DB01\sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\Oracle11g\oradata\DB01\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE 'E:\Oracle11g\oradata\DB01\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('E:\Oracle11g\oradata\DB01\redo01.log') SIZE 51200K,
GROUP 2 ('E:\Oracle11g\oradata\DB01\redo02.log') SIZE 51200K,
GROUP 3 ('E:\Oracle11g\oradata\DB01\redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY
Sat Apr 16 00:06:16 2011
CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE 'E:\Oracle11g\oradata\DB01\users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE 'E:\Oracle11g\oradata\DB01\users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Sat Apr 16 00:06:39 2011
Thread 1 advanced to log sequence 2 (LGWR switch)
Current log# 2 seq# 2 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO02.LOG
Sat Apr 16 00:06:55 2011
Starting ORACLE instance (normal)
Sat Apr 16 00:07:33 2011
alter database mount
ORA-1100 signalled during: alter database mount...
Sat Apr 16 00:07:39 2011
Thread 1 advanced to log sequence 3 (LGWR switch)
Current log# 3 seq# 3 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO03.LOG
Sat Apr 16 00:08:41 2011
Thread 1 cannot allocate new log, sequence 4
Checkpoint not complete
Current log# 3 seq# 3 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO03.LOG
Thread 1 advanced to log sequence 4 (LGWR switch)
Current log# 1 seq# 4 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Sat Apr 16 00:09:45 2011
Thread 1 cannot allocate new log, sequence 5
Checkpoint not complete
Current log# 1 seq# 4 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Thread 1 advanced to log sequence 5 (LGWR switch)
Current log# 2 seq# 5 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO02.LOG
Sat Apr 16 00:10:39 2011
Create Relation IPS_PACKAGE_UNPACK_HISTORY
Sat Apr 16 00:10:57 2011
Thread 1 cannot allocate new log, sequence 6
Checkpoint not complete
Current log# 2 seq# 5 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO02.LOG
Thread 1 advanced to log sequence 6 (LGWR switch)
Current log# 3 seq# 6 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO03.LOG
Sat Apr 16 00:11:37 2011
Thread 1 cannot allocate new log, sequence 7
Checkpoint not complete
Current log# 3 seq# 6 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO03.LOG
Thread 1 advanced to log sequence 7 (LGWR switch)
Current log# 1 seq# 7 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Sat Apr 16 00:13:05 2011
Errors in file E:\ORACLE11G\diag\rdbms\db01\ygzhou\trace\ygzhou_ora_636.trc (incident=1353):
ORA-04030: 在嘗試分配 4076 位元組 (PLS CGA hp,pdz7M87_Make) 時程式記憶體不足
Incident details in: E:\ORACLE11G\diag\rdbms\db01\ygzhou\incident\incdir_1353\ygzhou_ora_636_i1353.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Apr 16 00:13:30 2011
Dumping diagnostic data in directory=[cdmp_20110416001330], requested by (instance=1, sid=636), summary=[incident=1353].
Sat Apr 16 00:13:34 2011
Sweep [inc][1353]: completed
Sweep [inc2][1353]: completed
Sat Apr 16 00:13:38 2011
Thread 1 advanced to log sequence 8 (LGWR switch)
Current log# 2 seq# 8 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO02.LOG
Sat Apr 16 00:15:39 2011
Thread 1 cannot allocate new log, sequence 9
Checkpoint not complete
Current log# 2 seq# 8 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO02.LOG
Thread 1 advanced to log sequence 9 (LGWR switch)
Current log# 3 seq# 9 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO03.LOG
Sat Apr 16 00:17:32 2011
Thread 1 cannot allocate new log, sequence 10
Checkpoint not complete
Current log# 3 seq# 9 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO03.LOG
Thread 1 advanced to log sequence 10 (LGWR switch)
Current log# 1 seq# 10 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Sat Apr 16 00:19:09 2011
Errors in file E:\ORACLE11G\diag\rdbms\db01\ygzhou\trace\ygzhou_ora_636.trc (incident=1354):
ORA-04030: 在嘗試分配 4076 位元組 (PLS CGA hp,pdz2M87_Allocate_Permanent) 時程式記憶體不足
Incident details in: E:\ORACLE11G\diag\rdbms\db01\ygzhou\incident\incdir_1354\ygzhou_ora_636_i1354.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details. //有提到server的記憶體不足
Errors in file E:\ORACLE11G\diag\rdbms\db01\ygzhou\trace\ygzhou_ora_636.trc (incident=1355):
ORA-04030: 在嘗試分配 8156 位元組 (callheap,kdbmal allocation) 時程式記憶體不足
ORA-04030: 在嘗試分配 4076 位元組 (PLS CGA hp,pdz2M87_Allocate_Permanent) 時程式記憶體不足
Incident details in: E:\ORACLE11G\diag\rdbms\db01\ygzhou\incident\incdir_1355\ygzhou_ora_636_i1355.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Apr 16 00:19:15 2011you
Dumping diagnostic data in directory=[cdmp_20110416001915], requested by (instance=1, sid=636), summary=[incident=1355].
Errors in file E:\ORACLE11G\diag\rdbms\db01\ygzhou\trace\ygzhou_ora_636.trc (incident=1356):
ORA-04030: 在嘗試分配 8156 位元組 (callheap,kcbtmal allocation) 時程式記憶體不足
Incident details in: E:\ORACLE11G\diag\rdbms\db01\ygzhou\incident\incdir_1356\ygzhou_ora_636_i1356.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Apr 16 00:19:18 2011
Process startup failed, error stack:
Errors in file E:\ORACLE11G\diag\rdbms\db01\ygzhou\trace\ygzhou_psp0_708.trc:
ORA-27300: 作業系統系統相關操作: CreateThread 失敗, 狀態為: 1455
ORA-27301: 作業系統故障訊息: 頁面檔案太小,無法完成操作。
ORA-27302: 錯誤發生在: ssthrddcr
Sat Apr 16 00:19:19 2011
Errors in file E:\ORACLE11G\diag\rdbms\db01\ygzhou\trace\ygzhou_ora_636.trc (incident=1357):
ORA-04030: 在嘗試分配 8156 位元組 (callheap,kdbmal allocation) 時程式記憶體不足
ORA-04030: 在嘗試分配 8156 位元組 (callheap,kcbtmal allocation) 時程式記憶體不足
Incident details in: E:\ORACLE11G\diag\rdbms\db01\ygzhou\incident\incdir_1357\ygzhou_ora_636_i1357.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Apr 16 00:19:19 2011
Process m000 died, see its trace file
Dumping diagnostic data in directory=[cdmp_20110416001921], requested by (instance=1, sid=636), summary=[incident=1357].
Doing block recovery for file 3 block 15812
Resuming block recovery (PMON) for file 3 block 15812
Block recovery from logseq 10, block 47581 to scn 149503
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Block recovery completed at rba 10.56586.16, scn 0.149505
Doing block recovery for file 1 block 1563
Resuming block recovery (PMON) for file 1 block 1563
Block recovery from logseq 10, block 39517 to scn 149492
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Block recovery completed at rba 10.56122.16, scn 0.149493
Sat Apr 16 00:19:50 2011
Thread 1 cannot allocate new log, sequence 11
Checkpoint not complete
Current log# 1 seq# 10 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Thread 1 advanced to log sequence 11 (LGWR switch)
Current log# 2 seq# 11 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO02.LOG
Sat Apr 16 00:20:22 2011
Sweep [inc][1357]: completed
Sweep [inc][1356]: completed
Sweep [inc][1355]: completed
Sweep [inc][1354]: completed
Sweep [inc2][1357]: completed
Sweep [inc2][1356]: completed
Sweep [inc2][1355]: completed
Sweep [inc2][1354]: completed
Sat Apr 16 00:21:45 2011
AUD: OS Error = 1726 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 00:21:49 2011
Thread 1 cannot allocate new log, sequence 12
Checkpoint not complete
Current log# 2 seq# 11 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO02.LOG
Thread 1 advanced to log sequence 12 (LGWR switch)
Current log# 3 seq# 12 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO03.LOG
Sat Apr 16 00:22:06 2011
Starting background process CJQ0
Sat Apr 16 00:22:06 2011
CJQ0 started with pid=31, OS id=372
Sat Apr 16 00:22:53 2011
Thread 1 cannot allocate new log, sequence 13
Checkpoint not complete
Current log# 3 seq# 12 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO03.LOG
Thread 1 advanced to log sequence 13 (LGWR switch)
Current log# 1 seq# 13 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO01.LOG
Sat Apr 16 00:25:18 2011
SERVER COMPONENT id=CATPROC: timestamp=2011-04-16 00:25:18
Sat Apr 16 00:25:27 2011
AUD: OS Error = 6 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 00:26:11 2011
AUD: OS Error = 6 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 00:29:20 2011
AUD: OS Error = 6 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 00:30:42 2011
AUD: OS Error = 6 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 00:33:14 2011
AUD: OS Error = 6 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 00:37:03 2011
create tablespace ygzhou datafile 'E:\Oracle11g\backup\data\ygzhou.dbf'size 5m
Completed: create tablespace ygzhou datafile 'E:\Oracle11g\backup\data\ygzhou.dbf'size 5m
Sat Apr 16 00:42:03 2011
AUD: OS Error = 6 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 00:56:06 2011
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 01:04:31 2011
Thread 1 advanced to log sequence 14 (LGWR switch)
Current log# 2 seq# 14 mem# 0: E:\ORACLE11G\ORADATA\DB01\REDO02.LOG
Sat Apr 16 01:13:35 2011
AUD: OS Error = 6 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
Sat Apr 16 01:21:43 2011
AUD: OS Error = 6 encountered while writing audit record
AUD: OS Error = 6 encountered while writing audit record
自己的思路:
1,檢查oracle.exe佔用的記憶體資源為160M;
2,發現有提示記憶體不足的問題,檢查配置記憶體為900M、虛擬記憶體設定為0M,將虛擬記憶體設定為1G,最小值為200M;
2,檢視sga情況如下:
SQL> conn system/ygzhou518
已連線。
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- --------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 0
SQL> alter system set sga_max_size=400m scope=spfile;
alter system set sga_max_size=400m scope=spfile
*
第 1 行出現錯誤:
ORA-32001: 已請求寫入 SPFILE, 但是沒有正在使用的 SPFILE
SQL> create spfile from pfile;
create spfile from pfile
*
第 1 行出現錯誤:
ORA-01031: 許可權不足
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24867586/viewspace-692654/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 無法連線到web伺服器iisWeb伺服器
- AirPods無法連線到蘋果Mac怎麼辦?AI蘋果Mac
- win10突然無法連線wifi怎麼辦_win10突然無法連線到wifi如何解決Win10WiFi
- 無法連線到代理伺服器win10怎麼辦_win10無法連線到代理伺服器如何解決伺服器Win10
- win10無法連線到這個網路怎麼辦_win10無法連線到這個網路如何解決Win10
- 電腦無法連線到這個網路是什麼原因 電腦無法連線到這個網路怎麼解決
- win10網路受限無法連線到internet怎麼辦 win10網路受限無法連線到internet解決方法Win10
- win10 無法連線到systemeventnotificationservice怎麼解決Win10
- root使用者無法通過ssh連線Linux系統Linux
- mysql 遠端無法連線MySql
- bitbucket無法使用ssh連線
- centos無法建立ssl連線CentOS
- milvus 異常——無法連線
- vs2019 無法連線到Web伺服器“IIS Express”Web伺服器Express
- 無法連線到雲伺服器失敗怎麼辦伺服器
- ORA-01940 無法刪除當前連線的使用者
- 無法連線遠端,Windows系統電腦無法遠端連線怎麼辦Windows
- 本地無法連線Mysql的原因MySql
- linux 下 github ssh 無法連線LinuxGithub
- springboot連線hive無法啟動Spring BootHive
- win10提示無法連線到寬頻連線不能建立到遠端計算機怎麼解決Win10計算機
- Oracle連線Db2OracleDB2
- [Windows無法連線到 System Event Notification Service服務]解決方案Windows
- Win10遠端桌面無法多使用者連線如何解決_Win10無法實現多使用者遠端桌面連線怎麼處理Win10
- win10提示無法連線你的組織網路怎麼辦_win無法連線到組織網路的解決方法Win10
- win10電腦無法連線網路怎麼解決_win10提示無法連線到這個網路如何處理Win10
- 解決虛擬網路卡無法連線到 Internet 問題(之一)
- win10 guest共享無法連線到印表機怎麼設定Win10
- 【YashanDB資料庫】PHP無法透過ODBC連線到資料庫資料庫PHP
- link/Extended dependency 無法顯示連線
- 無法連線java visualvm外掛中心JavaLVM
- 連線上網路無法上網
- Windows無法配置此無線連線這個問題的解決辦法Windows
- windowsXP使用者無法遠端桌面連線天翼雲2008雲主機?Windows
- 蘋果手機iPhone XR無法連線到APP Store的解決方法蘋果iPhoneAPP
- wget下載提示:無法建立SSL連線wget
- 遠端桌面無法連線伺服器?伺服器
- mysql8 無法連線navicat問題MySql
- raw.githubusercontent.com 無法建立 SSL 連線Github