BI Upgrade from 11.1.1.7. to 12c latest release

Mukeshs · Dec 26, 2016 2:11AM

Hi,

We are planning to upgrade BI 11.1.1.7.0 with 10.2.0 DB to 12c latest release (Both DB & Appl). Could anyone please suggest document for same.

Thanks,

Mukesh

Joel · Dec 26, 2016 2:15AM

Try this - http://docs.oracle.com/middleware/1221/core/BIMIG/GUID-9D62DC32-532F-48F6-9AC9-2AE404D57A79.htm#BIMIG-GUID-9D62DC32-532F-48F6-9AC9-2AE404D57A79

Sent from my iPhone

Mukeshs · Dec 27, 2016 1:46AM

Hi Joel,

Thanks for your reply!

We are planning to migrate both application & db to new server. Please suggest if we can follow below action plan !

- Install 12c & DB in new server

-export BI schema and IMP in new DB

-take metada export from 11G server and import in 12c serve

-Migrate catalog , user groups to 12c.

-Test application

Thanks,

Mukesh

Joel · Dec 27, 2016 2:16AM

For step 1 do you mean install OBIEE and Oracle DB?

Can you clarify what you mean by "BI schema"? If you mean your data warehouse schema then that is correct for step 2.

Step 3 and 4 are done using the migration assistant

Mukeshs · Dec 27, 2016 2:19AM

Hi,

Step 1 is to installing fresh 12C OBIEE and 12C database in new server.

Bi Schema is repository schema currently used in 11g. Do we need to migrate this schema as well or metada export will take care?

Thanks,

Mukesh

Joel · Dec 27, 2016 2:24AM

Migration Assistant will manage that for you.

Mukeshs · Dec 27, 2016 2:40AM

Hi Joel,

Do you have any document for BI Upgrade ? Please share if available it will be very helpful!

Thanks,

Mukesh

Joel · Dec 27, 2016 2:45AM

This is what Oracle recommends - https://blogs.oracle.com/pa/entry/what_you_need_to_know

Mukeshs · Dec 27, 2016 3:01AM

Thanks Joel!

Joel · Dec 27, 2016 3:04AM

If your question is now answered @Mukeshs, mark as correct to help others who may have this issue in future.

Mukeshs · Dec 27, 2016 7:22AM

Hi,

We are getting error while running config.cmd

[2016-12-27T16:10:22.310+04:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 42] [ecid: 0000L_06XH3Bl3C_zD5EiW1OO^Xq000004,0] Non-skipped failure during configuration action: Execution of [cmd, /c, C:\Oracle12c\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\bitools\bin\start.cmd] failed with exit value 3[[

oracle.bi.exec.ExecutionStatusException: Execution of [cmd, /c, C:\Oracle12c\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\bitools\bin\start.cmd] failed with exit value 3

at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:99)

at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)

at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95)

at oracle.bi.install.config.steps.startup.StartAllServersStep.executeSingleShot(StartAllServersStep.java:63)

at oracle.bi.install.config.basesteps.SingleShotActionStep.execute(SingleShotActionStep.java:31)

at oracle.bi.install.config.basesteps.StepList.execute(StepList.java:85)

at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:127)

at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:405)

at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)

at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:108)

at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)

at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:284)

at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:260)

at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:185)

at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82)

at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87)

at java.lang.Thread.run(Thread.java:745)

]]

[2016-12-27T16:10:22.311+04:00] [bi] [NOTIFICATION] [] [oracle.bi.configassistant.config.actions.startup] [tid: 42] [ecid: 0000L_06XH3Bl3C_zD5EiW1OO^Xq000004,0] Collecting diagnostic information following startup failure. See log file: C:\Program Files\Oracle\Inventory\logs\config2016-12-27_02-54-28PM\jpsOnFailedStartup.out

[2016-12-27T16:10:22.312+04:00] [bi] [NOTIFICATION] [] [oracle.bi.exec] [tid: 42] [ecid: 0000L_06XH3Bl3C_zD5EiW1OO^Xq000004,0] Executing: [jps, -l]

[2016-12-27T16:10:22.312+04:00] [bi] [NOTIFICATION] [] [oracle.bi.exec] [tid: 42] [ecid: 0000L_06XH3Bl3C_zD5EiW1OO^Xq000004,0] Logging script stderr and stdout to C:\Program Files\Oracle\Inventory\logs\config2016-12-27_02-54-28PM\jpsOnFailedStartup.out

[2016-12-27T16:10:22.335+04:00] [bi] [WARNING] [] [oracle.bi.configassistant.config.actions.startup] [tid: 42] [ecid: 0000L_06XH3Bl3C_zD5EiW1OO^Xq000004,0] Failed to gather additional diagnostic information due to Failed to run [jps, -l][[

oracle.bi.exec.ExecutionException: Failed to run [jps, -l]

at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:46)

at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)

at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95)

at oracle.bi.configassistant.config.actions.startup.BIConfigStartup.jps(BIConfigStartup.java:146)

at oracle.bi.configassistant.config.actions.startup.BIConfigStartup.runFailureDiagnostics(BIConfigStartup.java:105)

at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:134)