Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help database down after ALTER SYSTEM SET max_string_size=extended SCOPE=SPFILE;

BenGonGonJan 3 2018 — edited Jan 4 2018

Hello,

I have tra to extend varchar2 to 4000.

I have do this command

ALTER SYSTEM SET max_string_size=extended SCOPE=SPFILE;

And after my database are down

When I have try to connect and start it with SQLPlus, the result :

SQL> startup

ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size 2926472 bytes

Variable Size 452987000 bytes

Database Buffers 75497472 bytes

Redo Buffers 5459968 bytes

Base de donnees montee.

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration

ID de processus : 943

ID de session : 357, Numero de serie : 13708

Please, someone have an idea what I need to do now?

This post has been answered by L. Fernigrini on Jan 3 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2018

Added on Jan 3 2018

#general-database-discussions

9 comments

1,036 views