Compatible parameter, Oracle 9i to 11g upgrade
I'm going to migrate from Oracle 9i to 11g. Currently my compatible
parameter is set to 9.2.0.0.0 in my 9i init.ora. The preupgrade script
identifies the compatible parameter as a problem: WARNING: -->
"compatible" must be set to at least 10.1.0. I comment out the
compatible parameter in my 9i init.ora and get the following error when I
try to start the 9i database:
Database mounted.
ORA-00402: database changes by release 9.2.0.0.0 cannot be used by release
8.1.0.0.0
ORA-00405: compatibility type "Locally Managed SYSTEM tablespace"
1. Shouldn't I be able to comment out the compatible parameter in the 9i init.ora and have the database open normally without errors? Do I need to fix something?
ORA-00402: database changes by release 9.2.0.0.0 cannot be used by release
8.1.0.0.0
ORA-00405: compatibility type "Locally Managed SYSTEM tablespace"
1. Shouldn't I be able to comment out the compatible parameter in the 9i init.ora and have the database open normally without errors? Do I need to fix something?
0