- 视窗 7 32 位笔记本电脑
- Oracle 11g XE 的本地实例
询问之前，我一直在自己研究这个问题，虽然周围有很多参考/建议，但我无法自己解决问题。
突然之间，当我尝试登录我的本地业余爱好者 Oracle 11g XE 实例时，我得到以下结果：
SQL> connect
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
它一直运行良好，最后一次尝试可能是 4 周前没有问题。 据我所知，什么都没有改变。
根据网络上的建议，我尝试过的事情：
1 - 已检查侦听器状态
C:>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 19-JAN-2016 23:53:50
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 19-JAN-2016 18:18:13
Uptime 0 days 5 hr. 35 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:oraclexeapporacleproduct11.2.0servernetworkadminlistener.ora
Listener Log File C:oraclexeapporaclediagtnslsnrSUPPORT-WIN7-32listeneralertlog.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SUPPORT-WIN7-32)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
检查相关服务已启动 - OracleServiceXE & OracleXETNSListener。 也已停止/重新启动。
3 - 检查我的路径变量是否正确，似乎是 - C：\oraclexe\app\oracle\product\11.2.0\server\bin;
4 - 已检查相关文件 tnsname 和侦听器文件 - C：\oraclexe\app\oracle\product\11.2.0\serveretwork\ADMIN。 我认为他们还可以，但也许我错过了一些明显的东西。
tsnnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SUPPORT-WIN7-32)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
听众.ora
ID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = SUPPORT-WIN7-32)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
5 - 在注册表中签入ORACLE_HOME和ORACLE_SID
HKEY_LOCAL_MACHINESOFTWAREORACLEKEY_XE
ORACLE_SID=XE
ORACLE_HOME=C:oraclexeapporacleproduct11.2.0server
6 - 尝试启动实例 - 引发另一个错误：ORA-03113：通信通道上的文件结束
C:>SQLPLUS / AS SYSDBA
SQL*Plus: Release 11.2.0.2.0 Production on Wed
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 644468736 bytes
Fixed Size 1385488 bytes
Variable Size 398461936 bytes
Database Buffers 239075328 bytes
Redo Buffers 5545984 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 3988
Session ID: 130 Serial number: 5
7 - 检查了 C：\oraclexe\app\oracle\diag\tnslsnr\SUPPORT-WIN7-32\listener\alert 中的侦听器日志，但这对我来说并不明显。
8 - C 中的数据库日志：\oraclexe\app\oracle\diag\rdbms\xe\xe\alert
数据库日志不是侦听器日志：
<msg time='2016-01-20T00:12:06.368+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15120:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> sessions = 172
</txt>
</msg>
<msg time='2016-01-20T00:12:06.370+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> spfile = "C:ORACLEXEAPPORACLEPRODUCT11.2.0SERVERDBSSPFILEXE.ORA"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.372+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15120:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> memory_target = 1G
</txt>
</msg>
<msg time='2016-01-20T00:12:06.374+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> control_files = "C:ORACLEXEAPPORACLEORADATAXECONTROL.DBF"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.376+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> compatible = "11.2.0.0.0"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.379+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> db_recovery_file_dest = "C:oraclexeapporaclefast_recovery_area"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.381+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15120:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> db_recovery_file_dest_size= 20G
</txt>
</msg>
<msg time='2016-01-20T00:12:06.383+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> undo_management = "AUTO"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.385+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> undo_tablespace = "UNDOTBS1"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.387+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> remote_login_passwordfile= "EXCLUSIVE"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.389+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.391+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15120:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> shared_servers = 5
</txt>
</msg>
<msg time='2016-01-20T00:12:06.394+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15120:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> job_queue_processes = 20
</txt>
</msg>
<msg time='2016-01-20T00:12:06.396+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> audit_file_dest = "C:ORACLEXEAPPORACLEADMINXEADUMP"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.398+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> db_name = "XE"
</txt>
</msg>
<msg time='2016-01-20T00:12:06.400+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15120:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> open_cursors = 300
</txt>
</msg>
<msg time='2016-01-20T00:12:06.402+00:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15111:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6680'>
<txt> diagnostic_dest = "C:ORACLEXEAPPORACLE"
</txt>
</msg>
<msg time='2016-01-20T00:12:08.320+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='3020'>
<txt>PMON started with pid=2, OS id=3020
</txt>
</msg>
<msg time='2016-01-20T00:12:08.345+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7356'>
<txt>PSP0 started with pid=3, OS id=7356
</txt>
</msg>
<msg time='2016-01-20T00:12:10.390+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7980'>
<txt>VKTM started with pid=4, OS id=7980 at elevated priority
</txt>
</msg>
<msg time='2016-01-20T00:12:10.414+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='7980'>
<txt>VKTM running at (10)millisec precision with DBRM quantum (100)ms
</txt>
</msg>
<msg time='2016-01-20T00:12:10.423+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='1820'>
<txt>GEN0 started with pid=5, OS id=1820
</txt>
</msg>
<msg time='2016-01-20T00:12:10.445+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7936'>
<txt>DIAG started with pid=6, OS id=7936
</txt>
</msg>
<msg time='2016-01-20T00:12:10.471+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7672'>
<txt>DBRM started with pid=7, OS id=7672
</txt>
</msg>
<msg time='2016-01-20T00:12:10.498+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7636'>
<txt>DIA0 started with pid=8, OS id=7636
</txt>
</msg>
<msg time='2016-01-20T00:12:10.520+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7296'>
<txt>MMAN started with pid=9, OS id=7296
</txt>
</msg>
<msg time='2016-01-20T00:12:10.555+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='8120'>
<txt>DBW0 started with pid=10, OS id=8120
</txt>
</msg>
<msg time='2016-01-20T00:12:10.584+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7988'>
<txt>LGWR started with pid=11, OS id=7988
</txt>
</msg>
<msg time='2016-01-20T00:12:10.609+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='4716'>
<txt>CKPT started with pid=12, OS id=4716
</txt>
</msg>
<msg time='2016-01-20T00:12:10.631+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6944'>
<txt>SMON started with pid=13, OS id=6944
</txt>
</msg>
<msg time='2016-01-20T00:12:10.653+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7560'>
<txt>RECO started with pid=14, OS id=7560
</txt>
</msg>
<msg time='2016-01-20T00:12:10.675+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='7996'>
<txt>MMON started with pid=15, OS id=7996
</txt>
</msg>
<msg time='2016-01-20T00:12:10.702+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='6680'>
<txt>starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
</txt>
</msg>
<msg time='2016-01-20T00:12:10.761+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='6680'>
<txt>starting up 5 shared server(s) ...
</txt>
</msg>
<msg time='2016-01-20T00:12:11.437+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksu_setup_oracle_base:25413:2787919602' client_id='' type='NOTIFICATION'
group='startup' level='16' host_id='SUPPORT-WIN7-32'
host_addr='fe80::6cc6:21a3:2980:ac01%14' module='' pid='6680'>
<txt>ORACLE_BASE from environment = C:oraclexeapporacle
</txt>
</msg>
<msg time='2016-01-20T00:12:11.566+00:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2974:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='SUPPORT-WIN7-32'
host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe' pid='8112'>
<txt>alter database mount exclusive
</txt>
</msg>
<msg time='2016-01-20T00:12:10.702+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='4464'>
<txt>MMNL started with pid=16, OS id=4464
</txt>
</msg>
<msg time='2016-01-20T00:12:15.737+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='7988'>
<txt>Successful mount of redo thread 1, with mount id 2782727451
</txt>
</msg>
<msg time='2016-01-20T00:12:15.755+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>Database mounted in Exclusive Mode
</txt>
</msg>
<msg time='2016-01-20T00:12:15.771+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>Lost write protection disabled
</txt>
</msg>
<msg time='2016-01-20T00:12:16.409+00:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3045:2802784106' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='SUPPORT-WIN7-32'
host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe' pid='8112'>
<txt>Completed: alter database mount exclusive
</txt>
</msg>
<msg time='2016-01-20T00:12:16.414+00:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2974:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='SUPPORT-WIN7-32'
host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe' pid='8112'>
<txt>alter database open
</txt>
</msg>
<msg time='2016-01-20T00:12:16.688+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='7988'>
<txt>LGWR: STARTING ARCH PROCESSES
</txt>
</msg>
<msg time='2016-01-20T00:12:16.721+00:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4282:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14'
pid='6572'>
<txt>ARC0 started with pid=24, OS id=6572
</txt>
</msg>
<msg time='2016-01-20T00:12:17.722+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='7988'>
<txt>ARC0: Archival started
</txt>
</msg>
<msg time='2016-01-20T00:12:17.725+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='7988'>
<txt>LGWR: STARTING ARCH PROCESSES COMPLETE
</txt>
</msg>
<msg time='2016-01-20T00:12:18.088+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>Errors in file C:ORACLEXEAPPORACLEdiagrdbmsxexetracexe_ora_8112.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 21474836480 bytes is 100.00% used, and has 0 remaining bytes available.
</txt>
</msg>
<msg time='2016-01-20T00:12:18.091+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>************************************************************************
</txt>
</msg>
<msg time='2016-01-20T00:12:18.094+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>You have following choices to free up space from recovery area:
</txt>
</msg>
<msg time='2016-01-20T00:12:18.097+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
</txt>
</msg>
<msg time='2016-01-20T00:12:18.099+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt> then consider changing RMAN ARCHIVELOG DELETION POLICY.
</txt>
</msg>
<msg time='2016-01-20T00:12:18.101+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>2. Back up files to tertiary device such as tape using RMAN
</txt>
</msg>
<msg time='2016-01-20T00:12:18.104+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt> BACKUP RECOVERY AREA command.
</txt>
</msg>
<msg time='2016-01-20T00:12:18.106+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>3. Add disk space and increase db_recovery_file_dest_size parameter to
</txt>
</msg>
<msg time='2016-01-20T00:12:18.109+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt> reflect the new space.
</txt>
</msg>
<msg time='2016-01-20T00:12:18.111+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>4. Delete unnecessary files using RMAN DELETE command. If an operating
</txt>
</msg>
<msg time='2016-01-20T00:12:18.114+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt> system command was used to delete files, then use RMAN CROSSCHECK and
</txt>
</msg>
<msg time='2016-01-20T00:12:18.116+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt> DELETE EXPIRED commands.
</txt>
</msg>
<msg time='2016-01-20T00:12:18.118+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>************************************************************************
</txt>
</msg>
<msg time='2016-01-20T00:12:18.122+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>ARCH: Error 19809 Creating archive log file to 'C:ORACLEXEAPPORACLEFAST_RECOVERY_AREAXEARCHIVELOG2016_01_20O1_MF_1_932_%U_.ARC'
</txt>
</msg>
<msg time='2016-01-20T00:12:18.133+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>Errors in file C:ORACLEXEAPPORACLEdiagrdbmsxexetracexe_ora_8112.trc:
ORA-16038: log 2 sequence# 932 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: 'C:ORACLEXEAPPORACLEFAST_RECOVERY_AREAXEONLINELOGO1_MF_2_8X88V21X_.LOG'
</txt>
</msg>
<msg time='2016-01-20T00:12:18.193+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>USER (ospid: 8112): terminating the instance due to error 16038
</txt>
</msg>
<msg time='2016-01-20T00:12:18.507+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='7936'>
<txt>System state dump requested by (instance=1, osid=8112), summary=[abnormal instance termination].
</txt>
</msg>
<msg time='2016-01-20T00:12:18.511+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='7936'>
<txt>System State dumped to trace file C:ORACLEXEAPPORACLEdiagrdbmsxexetracexe_diag_7936.trc
</txt>
</msg>
<msg time='2016-01-20T00:12:17.725+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='6572'>
<txt>ARC0: STARTING ARCH PROCESSES
</txt>
</msg>
<msg time='2016-01-20T00:12:18.728+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='6572'>
<txt>Logins disabled; aborting ARCH process startup (1092)
</txt>
</msg>
<msg time='2016-01-20T00:12:18.747+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='6572'>
<txt>ARC0: Archival disabled due to shutdown: 1092
</txt>
</msg>
<msg time='2016-01-20T00:12:18.751+00:00' org_id='oracle' comp_id='rdbms'
msg_id='krso_proc_stop:2101:825284245' client_id='' type='NOTIFICATION'
group='shutdown' level='16' host_id='SUPPORT-WIN7-32'
host_addr='fe80::6cc6:21a3:2980:ac01%14' module='' pid='6572'>
<txt>Shutting down archive processes
</txt>
</msg>
<msg time='2016-01-20T00:12:18.754+00:00' org_id='oracle' comp_id='rdbms'
msg_id='krso_proc_stop:2123:1369042098' client_id='' type='NOTIFICATION'
group='shutdown' level='16' host_id='SUPPORT-WIN7-32'
host_addr='fe80::6cc6:21a3:2980:ac01%14' module='' pid='6572'>
<txt>Archiving is disabled
</txt>
</msg>
<msg time='2016-01-20T00:12:18.870+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module=''
pid='7936'>
<txt>Dumping diagnostic data in directory=[cdmp_20160120001218], requested by (instance=1, osid=8112), summary=[abnormal instance termination].
</txt>
</msg>
<msg time='2016-01-20T00:12:20.556+00:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='SUPPORT-WIN7-32' host_addr='fe80::6cc6:21a3:2980:ac01%14' module='oradim.exe'
pid='8112'>
<txt>Instance terminated by USER, pid = 8112
</txt>
</msg>
将不胜感激任何帮助。 如果您可以指导我，可以提供任何进一步的信息。
非常感谢
根据您的警报日志，您的DB_RECOVERY_FILE_DEST_SIZE已超出：
19809, 00000, "limit exceeded for recovery files"
//*Cause: The limit for recovery files specified by the
// DB_RECOVERY_FILE_DEST_SIZE was exceeded.
// *Action: There are five possible solutions:
// 1) Take frequent backup of recovery area using RMAN.
// 2) Consider changing RMAN retention policy.
// 3) Consider changing RMAN archived log deletion policy.
// 4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
// 5) Delete files from recovery area using RMAN.
因此，您需要增加 initfile 或 spfile 中的数据库参数DB_RECOVERY_FILE_DEST_SIZE，然后启动数据库并删除所有归档日志：
rman target /
delete archivelog all;
您还可以删除所有归档日志（如果不需要它们），因为您的数据库可以成功挂载：
sqlplus / as sysdba
shutdown abort
startup mount
exit
rman target /
delete archivelog all
exit
sqlplus /as sysdba
alter database open;
之后，我建议您禁用数据库中的归档日志模式，以避免将来出现相同的情况。 我相信你不做热备份：
sqlplus / as sysdba
shutdown immediate
startup mount
alter database noarchivelog;
alter database open;