oracle数据库无法关闭,报错ORA-24323

在AIX5.3平台中,Oracle10gR2的版本Oracle10.2.0.1,
在关闭shutdown immediate数据库时,报错ORA-24323,
alert文件出现错误PMON failed to acquire latch, see PMON dump。

1、关闭数据库报错

[iapbill]$sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 8 11:03:48 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected to an idle instance.
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-00020: maximum number of processes (%s) exceeded
SQL> shutdown abort
ORA-01031: insufficient privileges
SQL> exit
Disconnected

看alert日志:PMON failed to acquire latch, see PMON dump。

Thu Nov  8 11:03:46 2012
PMON failed to acquire latch, see PMON dump
Thu Nov  8 11:04:46 2012
PMON failed to acquire latch, see PMON dump

 

2、解决过程

后来换了种模式重新登录数据库:

[iapbill]$sqlplus "/ as sysdba" 

set line 220  pages 999 tab off

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 8 11:23:26 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected.
SQL> SQL> SQL> define
DEFINE _DATE           = "08-NOV-12" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "szdevp" (CHAR)
DEFINE _USER           = "SYS" (CHAR)
DEFINE _PRIVILEGE      = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
DEFINE _EDITOR         = "ed" (CHAR)
DEFINE _O_VERSION      = "" (CHAR)
DEFINE _O_RELEASE      = "" (CHAR)
SQL>
SQL>
SQL> shutdown abort
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size                  2024536 bytes
Variable Size             171969448 bytes
Database Buffers          658505728 bytes
Redo Buffers                6361088 bytes
Database mounted.
Database opened.

 估计是遇到oralce BUG了,无处不在啊。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值