Dienstag, 25. November 2008

minimal init.ora

my minimal init.ora has only 4 lines:
where I have to check if I can omit the compatible. So it would be down to 3 lines. nice!
Without setting compatible, I get
ORA-00201: control file version incompatible with ORACLE version
ORA-00202: control file: '/appl/oracle/oradata/BERX2/control01.ctl'
and a show parameter compatible gives
compatible                           string      11.0.0
strange, as the instance identifies itselve as
SQL> select version from v$instance;

So it seems the automatic value for compatible is derived only from the first Version number of v$instance.

Keine Kommentare: