ora 02097 parameter cannot be modified because specified value is invalid

[Former Member]

hi

i did vbox parititon everything has gone well, but i am getting this error

"ora 02097 parameter cannot be modified because specified value is invalid:

if any body come across please let me know

oracle 10g

ecc 6.0

solaris

balaji

[Former Member]

After partitioning VBox, we saw the following error messages in the alert. Log

PRMX: Alter session failed: ORA-02097: parameter cannot be modified because specified value is invalid

ORA-00940: invalid ALTER command

ORA-00922: missing or invalid option

These messages appear exactly in the execution of each command for creating the new partition in the alert. But not log into the sqlplus session from which you execute the command.

It was exactly the same number of lines before and after operation.

SQL> SELECT /*+ parallel(50) / count() FROM SAPR3.VBOX;

COUNT(*)

-

---

4830953651

Kind Regards,

Balaji

[Former Member]

Hi ,

Kindly update which parameter you want to alter on Database Version.

Some Parameter value depends on Database ver also might be possible parameter absolute.

If parameter is dynamic then you can modify by alter command and if parameter static

then u can edit by change the value in pfile.

Thnx

SurendraJain

[former_member265710]

Hi,

Despite the initialization parameter is modifiable, the modified value is not acceptable to the parameter.

That means value would not be within range. Please check what value can fit for this parameter. Please let us know the which parameter you tried to change.

Regards,

Arun.

[markus_doehr2]

It would be VERY helpful if you would tell us, which parameter with which value you are trying to alter...

Markus

[Former Member]

still we are getting this error

PRMX: Alter session failed: ORA-02097: parameter cannot be modified because specified value is invalid

ORA-00940: invalid ALTER command

ORA-00922: missing or invalid option