Most people may choose to use the Upgrade Assistant(UA) (i.e. ua.bat|sh) but there is a much easier way. The way I’m showing you below does not require the RPD to be automatically deployed to a running Oracle Bi 11g instance either which is the default result when using the UA GUI. In other words, don’t use the Upgrade Assistant to upgrade just an RPD; just keep it around for Web catalog , BIP, and Scheduler Schema initial upgrades. Of course, the UA can be run by command-line as well but more on that in a future post.
As you should know by now, for the Oracle BI server installation all core server command files reside the under <BI_HOME>/server/bin folder. For the client tools install this path is <CLIENT_HOME>/server/bin/.
Just open a terminal window or a command prompt, cd to that directory path and if you list the items in the directory you’ll see a lot of files, one of them is obieerpdmigrateutil.
The important thing that I noticed here is that the client tool only installation is the best software option to use for this operation. The reason why is that the client tool provides an option to launch a BI Command Prompt. This option doesn’t come with the server installation. So from the Client Tools windows program option, select BI Command Prompt. This automatically loads all Oracle BI 11g environment paths and prepares the command prompt now opened for you to just type in any of the Oracle BI CLI commands.
So, what does it look like to migrate the Usage Tracking RPD that comes with 11.1.1.6? Just move that RPD to a temporary folder like C:\tmp\. Then enter the syntax as follows.
obieerpdmigrateutil -I C:\Tmp\UsageTracking.rpd -O C:\Tmp\UsageTracking11116.rpd -U Administrator -L C:\Tmp\OBI_RPD_UserGroups.LDIF
If you don’t use the client tools option then you’ll probably get prompted with a CLI error stating something about setting the ORACLE_INSTANCE. The easiest thing here would be to copy the logic from the client tools launch of the BI command Prompt and incorporate that into your Oracle BI server installation location.
