Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Saturday, 7 April 2012

RMAN-06035: Wrong version version recover.bsq


I had installed Oracle 9i first after that 10g  on Windows environment. After installing 10g when I am trying to start database through SQLplus every time it is opening 10g database and accessing RMAN for oracle 9i database backup. It is giving error

RMAN initiation problem
-------------------------------------------------------------------------------------------
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-03000: recovery manager compiler component initialization failed
RMAN-06035: wrong version of recover.bsq, expecting 10.2.0.4, found 9.2.0.7

After diging i came to know When an install process takes place in a windows platform, Oracle locates the latest installation at the start of the PATH environment variable. So we should watch out of this issue or if you are uncertain about the path your OS is reading, then use absolute paths. In this kind of situation, you can invoke rman by going to HOME path/bin directory

C:\>SET PATH=%ORACLE_HOME%\bin;%PATH%
RMAN> connect target /

Tip: To avoid these complications, Oracle always recommend to maintain same version of database under a release in the server

In that case if you want your SQLplus will open oracle 9i database first override the rule of latest installation or
highest version then it is better to create BAT file to set PATH and ORACLE_HOME. It will help out you to ignore using absolute path again and again.



0 comments:

Post a Comment