Hi all,
I'd like to configure database for extended data types. I need to run following commands to do this:
sqlplus sys/password@orcl as sysdba
SHUTDOWN IMMEDIATE;
STARTUP UPGRADE;
ALTER SYSTEM SET max_string_size=extended;
@?/rdbms/admin/utl32k.sql
SHUTDOWN IMMEDIATE;
STARTUP;
After running "SHUTDOWN IMMEDIATE", I can't connect to the oracle instance anymore.
When I run "STARTUP UPGRADE" I get a segmentation fault error (I guess it happens because sqlplus can't connect to oracle instance).
I use sqlplus from oracle database installation (database and sqlplus run on the same machine).
Do I need to change configuration to run "STARTUP UPGRADE"?
Is there any other way to run oracle in upgrade mode without using sqlplus?
I found that the crash happens submitting any sql command if you shutdown database before that.