What about a bug encountered when starting an Oracle11g instance on Solaris10
Xiaobian to share with you how to do a bug encountered in starting Oracle 11g instance on Solaris10, I hope you have gained something after reading this article, let's discuss it together!
The instance can start normally. Check alert.log for WARNING as follows:
(repeated many times)
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.1 describes 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
[Operation steps]
[@more@]
bash-3.00$ ls -l oradism
-rwsr-x--- 1 oracle dba 1684488 Sep 26 2008 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 oracle dba 1684488 Sep 26 2008 oradism
-rwxr-x--- 1 oracle oinstall 1684488 Jul 7 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 oracle dba 1684488 Sep 26 2008 oradism
-rwxr-x--- 1 oracle oinstall 1684488 Jul 7 08:08 oradism.bak
bash-3.00$ chmod g+s oradism
bash-3.00$ ls -l oradism*
-r-sr-s--- 1 oracle dba 1684488 Sep 26 2008 oradism
-rwxr-x--- 1 oracle oinstall 1684488 Jul 7 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 oracle dba 1684488 Sep 26 2008 oradism
-rwxr-x--- 1 oracle oinstall 1684488 Jul 7 08:08 oradism.bak
#
# chown root:dba oradism
#
# ls -l oradism*
-r-sr-s--- 1 root dba 1684488 Sep 26 2008 oradism
-rwxr-x--- 1 oracle oinstall 1684488 Jul 7 08:08 oradism.bak
#
After reading this article, I believe you have a certain understanding of "How to do a bug encountered in starting Oracle 11g instance on Solaris10". If you want to know more about it, please pay attention to the industry information channel. Thank you for reading!
