Oracle 11.0 under Windows Upgrade from 2.0.1 to Oracle 11.0 2.0.4

1. Problem phenomenon ：

oracle11.2.0.1 adopt dblink visit oracle 11.2.0.4 Report errors ORA-00600[2252]

According to the data, it is because the lower version database passed dblink Access to a higher version of the database , The database version needs to be upgraded ,.

2. Upgrade environment ：

3. Upgrade steps ：

1、 Do a good job of data backup in advance , I won't elaborate here .

2、 Upload the installation package and unzip it .

3、 Collect database information before upgrading .


4、 Close the database , lsnrctl stop

5、 Decompress the generated database Under the table of contents , Run as administrator setup, Remove the check mark of security update , next step .

6、 Skip updates , next step

6、 Choose to upgrade the existing database , next step

7、 Choice language , next step .

8、 Select enterprise , next step

9、 Select the installation directory , primary ：D:\app\oracle\product\11.2.0\dbhome_1, The new directory is D:\app\oracle\product\11.2.0\dbhome_2

10、 Start installation

11、 To 80% When I play, I play oracle netca Program , Check execute typical configuration , next step .

12、 next step

13、 Select database

14、 Select continue upgrade

15、 Check to recompile invalid objects after upgrade , next step .

16、 Do not move data files , next step .

17、 next step

18、 Choose to finish .

19、 Wait for the upgrade to complete

20、 Upgrade is complete , An error was reported during the upgrade , It's configuration em Failure , This post-processing , It will not affect the overall data upgrade .


21、 complete

1. Check ：

You can see that the current version has been upgraded to 11.2.0.4 了


Finally, set the environment variable ,windows After upgrading, it will be automatically set ,linux Words , Note that after the upgrade , take $ORACL{E}_{H}OMEand$PATH Change to a new path , And make it effective .