在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了,无处不在啊。