Oradism Did Not S…

Alertlog:

 

  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 403
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 403
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 403
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 403
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 403
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 403
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 403
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 403
WARNING: -------------------------------
WARNING: oradism did not start up correctly.

 

 

 

 Not setting SGA_MAX_SIZE removes the warning

 

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 20G
sga_target                           big integer 0
SQL> show parameter sp

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offload_plan_display            string      AUTO
cursor_space_for_time                boolean     FALSE
dispatchers                          string
java_max_sessionspace_size           integer     0
java_soft_sessionspace_limit         integer     0
lock_name_space                      string
max_dispatchers                      integer
redo_transport_user                  string
spfile                               string      /u01/dev/db/tech_st/11.2.0/dbs
                                                 /spfileDEV2.ora
undo_tablespace                      string      UNDOTBS2
SQL>  alter system reset sga_max_size scope=spfile;
 alter system reset sga_max_size scope=spfile
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE

SQL> alter system set sga_max_size=0 ;
alter system set sga_max_size=0
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set sga_max_size=0 scope=spfile;

System altered.

SQL> shutdown
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1.2831E+10 bytes
Fixed Size                  2186536 bytes
Variable Size            4328522456 bytes
Database Buffers         8489271296 bytes
Redo Buffers               11501568 bytes
SQL> show parameter pga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 0
SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 12G
sga_target                           big integer 0
SQL>

还是有SGA_MAX_SIZE的设置？自动改成了12G，hwo to  not setting SGA_MAX_SIZE?

 

警告日志里没有了WARNING: oradism did not start up correctly.的相关信息 Why?

 

 参考：

 

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.2.0.2 [Release 10.2 to 11.2]
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)

Symptoms

-- Problem Statement:

Receive warning about oradism not set up correctly in alert.log when trying to set SGA_MAX_SIZE in spfile.  Not setting SGA_MAX_SIZE removes the warning.  This works fine on other Solaris boxes.

Example:

WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.
oradism creation failed for unknown reasons 0 8 1001

Cause

The $ORACLE_HOME disk volume was mounted NOSETUID which invalidated the SETUID needed for this executable.

Solution

-- To implement the solution, please execute the following steps:

1. Unmount $ORACLE_HOME

2. Remount with SETUID enabled ( mount with suid option)