ORA -10134,ora27101-白红宇

ORA -10134,ora27101

阅读量：5828 次

发布时间：2019-06-18

本文共 7381 字，大约阅读时间需要 24 分钟。

今天早上连接数据发现数据不好使

报ORA-10134,ORA-27101错误，

ORA-10134：oracle not available;

ORA-27101: share memory realm does not exist'

SQL> sqlplus

sql>sys/**@orac as sysdba

sql>startup;

oracle 例程已经启动，，，，，，

ora-03113：通信通道的文件结束：

于是GOOGLE 网上说 ora-03113是数据库比较经典的错误，说其是经典的错误的主要原因是照成ora-03113的原因是很多种情况。网上看见别人的帖子里有（ora-03113错误分析）：如下情况：

核心参数设置不当

Oracle执行文件权限不正确／环境变量问题

客户端通信不能正确处理

数据库服务器崩溃/操作系统崩溃/进程被kill

Oracle 内部错误

特定SQL、PL/SQL引起的错误

空间不够

防火墙的问题

其它原因

于是对照分析，照着网上的点例子一点一点做，发现并不能解决问题。但是照成这个错误的原因：应该是前一天断电照成的。于是进入oracle alert日志：

日志信息如下：

Tue Dec 04 08:19:38 2012

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =18

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

processes = 150

__shared_pool_size = 130023424

__large_pool_size = 4194304

__java_pool_size = 4194304

__streams_pool_size = 0

spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORABJB.ORA

sga_target = 612368384

control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORABJB\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORABJB\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORABJB\CONTROL03.CTL

db_block_size = 8192

__db_cache_size = 465567744

compatible = 10.2.0.1.0

db_file_multiblock_read_count= 16

db_recovery_file_dest = D:\oracle\product\10.2.0/flash_recovery_area

db_recovery_file_dest_size= 12884901888

undo_management = AUTO

undo_tablespace = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain =

dispatchers = (PROTOCOL=TCP) (SERVICE=orabjbXDB)

job_queue_processes = 10

audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORABJB\ADUMP

background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORABJB\BDUMP

user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORABJB\UDUMP

core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORABJB\CDUMP

db_name = orabjb

open_cursors = 300

pga_aggregate_target = 203423744

PMON started with pid=2, OS id=7836

PSP0 started with pid=3, OS id=4240

MMAN started with pid=4, OS id=8020

DBW0 started with pid=5, OS id=5868

LGWR started with pid=6, OS id=5464

CKPT started with pid=7, OS id=5508

SMON started with pid=8, OS id=4516

RECO started with pid=9, OS id=8180

CJQ0 started with pid=10, OS id=4192

MMON started with pid=11, OS id=8168

MMNL started with pid=12, OS id=1096

Tue Dec 04 08:19:39 2012

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Tue Dec 04 08:19:39 2012

ALTER DATABASE MOUNT

Tue Dec 04 08:19:43 2012

Setting recovery target incarnation to 2

Tue Dec 04 08:19:43 2012

Successful mount of redo thread 1, with mount id 1546923419

Tue Dec 04 08:19:43 2012

Allocated 3981204 bytes in shared pool for flashback generation buffer

Starting background process RVWR

RVWR started with pid=16, OS id=8244

Tue Dec 04 08:19:45 2012

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Tue Dec 04 08:19:46 2012

ALTER DATABASE OPEN

Tue Dec 04 08:19:46 2012

Beginning crash recovery of 1 threads

parallel recovery started with 2 processes

Tue Dec 04 08:19:46 2012

Started redo scan

Tue Dec 04 08:19:47 2012

Completed redo scan

4318 redo blocks read, 399 data blocks need recovery

Tue Dec 04 08:19:47 2012

Started redo application at

Thread 1: logseq 642, block 89116

Tue Dec 04 08:19:48 2012

Recovery of Online Redo Log: Thread 1 Group 3 Seq 642 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORABJB\REDO03.LOG

Tue Dec 04 08:19:48 2012

Completed redo application

Tue Dec 04 08:19:48 2012

Errors in file d:\oracle\product\10.2.0\admin\orabjb\bdump\orabjb_p000_8264.trc:

ORA-00600: internal error code, arguments: [2037], [12629040], [12629040], [162], [6], [1], [13351933], [822095872]

Tue Dec 04 08:19:48 2012

Hex dump of (file 7, block 114952) in trace file d:\oracle\product\10.2.0\admin\orabjb\bdump\orabjb_dbw0_5868.trc

Corrupt block relative dba: 0x01c1c108 (file 7, block 114952)

Bad header found during preparing block for write

Data in bad block:

type: 0 format: 6 rdba: 0x56003300

last change scn: 0x0000.00cbbab9 seq: 0x3 flg: 0x58

spare1: 0x0 spare2: 0x20 spare3: 0x5e86

consistency value in tail: 0xbab90003

check value in block header: 0x0

block checksum disabled

Tue Dec 04 08:19:54 2012

Errors in file d:\oracle\product\10.2.0\admin\orabjb\bdump\orabjb_p000_8264.trc:

ORA-00600: internal error code, arguments: [2037], [12629040], [12629040], [162], [6], [1], [13351933], [822095872]

Tue Dec 04 08:19:54 2012

Errors in file d:\oracle\product\10.2.0\admin\orabjb\bdump\orabjb_dbw0_5868.trc:

ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], []

Tue Dec 04 08:19:55 2012

Errors in file d:\oracle\product\10.2.0\admin\orabjb\bdump\orabjb_dbw0_5868.trc:

ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], []

DBW0: terminating instance due to error 471

Tue Dec 04 08:19:55 2012

Errors in file d:\oracle\product\10.2.0\admin\orabjb\bdump\orabjb_p001_8268.trc: