SQL> Startup
ORACLE instance started.
The Total System Global Area 1593835520 bytes
Fixed Size of 2924880 bytes
Variable Size of 1023413936 bytes
The Database Buffers 553648128 bytes
Redo Buffers 13848576 bytes
The Database mounted.
ORA - 01092: ORACLE instance terminated. Disconnection forced
ORA - 14693: The MAX_STRING_SIZE parameter must be EXTENDED.
The Process ID: 103962
The Session ID: 237 Serial number: 55929
According to clew: oracle for MAX_STRING_SIZE this stand was stopped, the original database is modified by me into the extended, but suddenly without electricity, can't start the instance will start, how to restore excuse me
CodePudding user response:
Perform the following steps in turn see what error message and prompt
Startup nomount
The alter database mount
The alter database open
CodePudding user response:
12 c? Take a look at this:up sqlplus'/as sysdba '
Startup nomount
Show parameter MAX_STRING_SIZE
Should be stand, before you change should be the instance life cycle, there is no change in the parameter file, you can modify the parameters after the restart, just log in under the condition of the database instance to perform:
the alter system set max_string_size=extended scope=spfile;
Startup force