SQL> show parameter compatible;
NAME TYPE VALUE
------------- ------------ -----------------------
compatible string 10.2.0.5.0
SQL> alter system set compatible='11.2.0.4.0' scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2253664 bytes
Variable Size 603983008 bytes
Database Buffers 989855744 bytes
Redo Buffers 7319552 bytes
Database mounted.
Database opened.
SQL> show parameter compatible;
NAME TYPE VALUE
------------- ------------ -----------------------
compatible string 11.2.0.4.0
这样就升级好了。
单机Oracle10.2.0.5升级11.2.0.4
最新推荐文章于 2023-03-30 17:29:18 发布