Alter Session Failed: ORA-02097: Parameter Cannot Be Modified Because Specified Value Is Invalid (Doc ID 1584176.1)

Last updated on DECEMBER 02, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

 

e.g.

ALTER SESSION SET "sec_protocol_error_further_action" = "delay, 10"

or the following, which shows an extract from the error stack dumped for 20297:

*** MODULE NAME:(DBMS_SCHEDULER) 2013-09-07 01:54:54.245
*** ACTION NAME:(IDX_RB$J_402_1) 2013-09-07 01:54:54.245

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-02097: parameter cannot be modified because specified value is invalid
----- Current SQL Statement for this session (sql_id=69h48q8c4n9nd) -----
ALTER SESSION SET "sec_protocol_error_further_action" = delay, 10, drop, 10
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
41cb23b00      1862  package body SYS.DBMS_I_INDEX_UTL
41cb23b00      1263  package body SYS.DBMS_I_INDEX_UTL
4f4613fa8         1  anonymous block

----- Call Stack Trace -----
    kgeade <- kgeselv <- ksesecl0 <- opisecparamvalcb <- 112
       <- kspsetv0 <- kkyase <- kksExecuteCommand <- opiexe <- opipls
        <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2
         <- rpidrv <- psddr0 <- psdnal <- pevm_EXIM <- pfrinstr_EXIM
          <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe
           <- opiexe <- kpoal8 <- opiodr <- kpoodr <- upirtrc
            <- kpurcsc <- kpuexec <- OCIStmtExecute
 
  
SQL> show parameter sec_protocol

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_protocol_error_further_action    string      delay, 10, drop, 10
or
SQL> show parameter sec_protocol

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_protocol_error_further_action    string      delay, 10
 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms