Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Migrating from Oracle BI 11g to 12c

Received Response
1
Views
12
Comments
3384785
3384785 Rank 2 - Community Beginner
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

Hi Team,

We planned to migrate BI Publisher from 11g to 12c.  In Oracle standard doc: E65741-05 shows migration-tool.sh script used for migration process.

But  in the specified directory we don't have migration script (12c)  "migration-tool.sh". Following Location: Oracle/Middleware/Oracle_Home/user_projects/domains/bi_1/bitools/bin/.

I believe this script is more important for standard migration. Please share your knowledge. Thank you so much.

Version Details:

From on premise:

Weblogic - 12.1.3.0.0

BI Publisher- 11.1.1.9.0

To Cloud:

Weblogic - 12.2.1.1.0

BI Publisher - 12.2.1.1.0

Database: - 12.1.0.2.0

Attached snap shot for further reference.

location1.PNG

Thanks,

Subramani R

«1

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Standalone BIP? The community is that way -->

    This is the OBIEE space

  • 3384785
    3384785 Rank 2 - Community Beginner

    OBIEE 12C edition.  Attached snap shot for package which I configured in server.

    201.PNG

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    a) still not sure what your actual question is so yoi will have to be a lot more clear

    b) the upgrade process has been done by hundreda of clients already

    c) Why does your version listing imply going from on-premises to cloud but does not match any of the actual cloud destination versions?

  • 3384785
    3384785 Rank 2 - Community Beginner

    Hi Christian,

    Very Simple. To migrate OBIEE 11G to 12c , we need migration-tool.sh script in the following directory as per doc reference E65741-05.

    Oracle/Middleware/Oracle_Home/user_projects/domains/bi_1/bitools/bin/... in 12c.

    But no such file exists in the specified directory. 

    Thanks,

    Subramani R

  • Gianni Ceresa
    Gianni Ceresa Mod 
    3384785 wrote:But no such file exists in the specified directory.

    If you configured your OBIEE first you will find the file, if you just installed OBIEE (the screenshot you posted) you simply pushed the binaries and files in place, but your OBIEE isn't configured at all.

    You need to execute $ORACLE_HOME/bi/bin/config.sh and do the config before to be able to import the content you migrate from 11g.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Beaten by Gianni. You have to finish the installation of 12c correctly first.

    pastedImage_0.png

  • 3384785
    3384785 Rank 2 - Community Beginner

    It is already configured successfully. BI instance running.. And we started to create OVR as well. 

    Only problm migration-tool.sh file missing.

    Thanks,

    Subramani R

  • Gianni Ceresa
    Gianni Ceresa Mod

    Are all the other scripts present in the bitools/bin folder? Because it's kind of difficult to have everything there except the migration-tool.sh if nobody moved it or deleted it .... (always got it there)

    Did you try searching your system if maybe, by "mistake", somebody didn't move that file? (if they delete it ... well ... it's gone).

    There is another file named like that in the install, I guess it's the original reference and never checked what's the difference with the one placed inside bitools/bin .

    Also another thing: in your original post you wrote "to cloud" : is that install a cloud offering you got somewhere or a standard install on a standard server "just not hosted in your place anymore" ?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Just opened the script on a 12.2.1.3.0, it is mainly a shortcut to call the main one and setting a variable first:

    #!/bin/sh# WARNING: This file is created by the Configuration Wizard.# Any changes to this script may be lost when adding extensions to this configuration.DOMAIN_HOME="<path to your domain: ...../domains/bi>"export DOMAIN_HOME<your ORACLE_HOME>/bi/modules/oracle.bi.migration/scripts/migration-tool.sh "$@"

    So just create the file by replacing the value of DOMAIN_HOME with the right path pointing to your domain home and replacing the path of your oracle home in the call of the main script.

  • 3384785
    3384785 Rank 2 - Community Beginner

    Hi Gianni,

    Thank you for you continuous support! ..

    1.Yes all other scripts are present in bitools/bin folder. Location reference attached in my first post.

    2.This is fresh installation which I did step by step as per oracle guide. So no deletion possible.

    3.File not exist in system .

    4. Cloud: We are using Baremetal cloud for vm machine.

    I specifically downloaded OBIEE software from edelivery. And did fresh installation in oracle linux 7 which is on cloud.

    Thanks,

    Subramani R