实例能正常启动,查看 alert.log出现WARNING如下:
(重复出现很多次)
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 105
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 105
Metalink note 374367.1describes the issue and provides the solution:
The real problem is with the oradism executable itself.
The oradism executable cannot have 755 permissions, and owned by root or oracle
(rwx-r-x-r-x)like the other executables have in this directory
The permissions for oradism must be 4550 with the setid for the group.
(-r-sr-s--- 1 root dba 12912 Feb 16 2005 oradism)
(Solaris8 64-bit / oracle v9.2.0.4)
Solution
1- cd $ORACLE_HOME/bin
2- chmod 4550 oradism
3- chmod g+s oradism
4- chown root:dba oradism
5- Bounce the database
【操作步骤】[@more@]
bash-3.00$ ls -l oradism
-rwsr-x---1 oracledba1684488 Sep 262008 oradism
bash-3.00$ bash-3.00$
bash-3.00$ cp oradism oradism.bak
bash-3.00$
bash-3.00$ ls -l oradism*
-rwsr-x---1 oracledba1684488 Sep 262008 oradism
-rwxr-x---1 oracleoinstall 1684488 Jul7 08:08 oradism.bak
bash-3.00$
bash-3.00$ chmod 4550 oradism
bash-3.00$
bash-3.00$ ls -l oradism*
-r-sr-x---1 oracledba1684488 Sep 262008 oradism
-rwxr-x---1 oracleoinstall 1684488 Jul7 08:08 oradism.bak
bash-3.00$ chmod g+s oradism
bash-3.00$ ls -l oradism*
-r-sr-s---1 oracledba1684488 Sep 262008 oradism
-rwxr-x---1 oracleoinstall 1684488 Jul7 08:08 oradism.bak
bash-3.00$ chown root:dba oradism
chown: oradism: Not owner
bash-3.00$
bash-3.00$ su
Password:
# ls -l oradism*
-r-sr-s---1 oracledba1684488 Sep 262008 oradism
-rwxr-x---1 oracleoinstall 1684488 Jul7 08:08 oradism.bak
#
# chown root:dba oradism
#
# ls -l oradism*
-r-sr-s---1 rootdba1684488 Sep 262008 oradism
-rwxr-x---1 oracleoinstall 1684488 Jul7 08:08 oradism.bak
#