My Oracle Support Banner

Getting ORA-02097 while setting parameter max_idle_time (Doc ID 2596196.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

"Modification to max_idle_time is failing with ""ORA-02097: parameter cannot be modified because specified value is invalid""

SQL> alter system set max_idle_time=360 scope=both sid='*';
alter system set max_idle_time=360 scope=both sid='*'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-02097: parameter cannot be modified because specified value is invalid "

Changes

 no changes

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.