ora 12500 oracle 9i processes,WARNING: oradism not set up correctly(Oracle9i)

WARNING: oradism not set up correctly

最近，在重新启动企业核心SFCS Oracle database后，我们发现在DB Alert log发现如下信息：

Sun Apr 10 12:08:38 2011

ARCH: STARTING ARCH PROCESSES COMPLETE

Sun Apr 10 12:08:38 2011

ARC1: Archival started

Sun Apr 10 12:08:38 2011

ARC0: Thread not mounted

Sun Apr 10 12:08:38 2011

ARC1: Thread not mounted

Sun Apr 10 12:08:38 2011

WARNING: -------------------------------

WARNING: oradism not set up correctly.

Dynamic ISM can not be locked. Please

setup oradism, or unset sga_max_size.

[diagnostic 0, 16, 100]

----------------------------------------

Sun Apr 10 12:08:39 2011

ALTER DATABASE MOUNT

以前在其它DB均没有发现此类问题，查询metalink发现这是由于开启new Oracle9i feature Dynamic

SGA时设置不当造成的。解决这个问题有两个方法：

1. Unset

SGA_MAX_SIZE;

2. Set

Dynamic SGA correctly;

我们是建议去设定Dynamic SGA，所以将Dynamic SGA设定正确。检查了一下，主要是Dynamic

ISM文件的权限不正确：

$cd /home/oracle/bin

$ls -l

......

-rwxr-xr-x 1

root dba 12928 Mar 25 2004 oradism

-rwxr-xr-x 1

root dba 12912 Jul 27 2003 oradism.sav

应该按照如下方法设定权限：

1- cd $ORACLE_HOME/bin

2- chmod 4550 oradism

3- chmod g+s oradism

4- chown root:dba oradism 5- Bounce the database