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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24867586/viewspace-692654/