Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upgrade/Migrate 9.3.3 Planning apps to 11.1.2.2

user6403406Sep 19 2013 — edited Oct 14 2013

I am in the next step of our upgrade from 9.3.3 to 11.1.2.2 and ready to migrate our Planning applications. I have read many of the posts related to this and have a general list of steps, but I have slightly different situation than what I have seen posted before.

To summarize, we have installed 11.1.2.2 on new servers.  Our old 9.3.3 is still up and running on different environment.  I have sucessfully completed the following:

1.     Foundation Services/Shared Services installed and up and running and users/groups successfully migrated.

2.     Essbase and EAS installed and up and running.  All Essbase applications (except for the Planning apps), have been successfully migrated from 9.3.3 to 11.1.2.2.

3.     Planning has been installed and is up and running.  While there are no Planning apps in the new system, I can open the Planning Administrator via WorkSpace.

So the next step is to get my Planning apps moved/migrated from the 9.3.3 environment to the new 11.1.2.2.

To complicate matters, we are switching from SQL Server repository in 9.3.3 to Oracle in our new 11.1.2.2.  So the first thing we did was to create a new Oracle schema for our Planning app repository and using SQL Developer migrate wizard, we copied/migrated the tables and data from the old SQL Server to Oracle.  It appears that all the tables and data were successfully copied into Oracle.

Our old Planning application is called PlanTest. The application owner is a native user called planadm.  My intended migration plan (and my questions) are:

1.     Do I create a new blank Planning app called PlanTest using native account planamd in 11.1.2.2?

2.     If I use my new Oracle repository for this blank app, will it wipe out the old converted data or will it try to upgrade/migrate it?

3.     Or..should I take a backup of my new converted repository first.  Then drop/recreate the Oracle Schema (so no tables) and let Planning build the repository when I create the blank Planning app?  Then capture the owner SID in the new HSP_USER table.  Stop Planning. Then overlay the database backup of 9.3.3 over the newly created repository and replace the owner SID info. Then Restart Planning.

          ** My concern:  Is the Planning app repository table structures the same between 9.3.3 and 11.1.2.2?

4.     Open Planning and hope that the application PlanTest appears!

5.     Use Planning upgrade Wizard to finish the migration and upgrade the repository.

6.     Push/Create app to Essbase.

7.     Export data from old app to .txt load file and reload into new Planning cube.

8.     Convert/Migrate Business Rules using info from John's blog.

I am sure I missed something.  Any suggestions or comments on these steps would be appreciated.  Bottom line is I need to get this app (and several others) migrated successfully with all metadata, security, forms, rules etc. working.  Rebuilding them from scratch is NOT an option.

Also, to clarify.  This is a Classic Planning app.  We are not using EPMA.

Thanks,

Mike
This post has been answered by JohnGoodwin on Sep 20 2013
Jump to Answer

Comments

Emad Al-Mousa

please check this documentation from oracle: http://docs.oracle.com/cd/B19306_01/network.102/b14213/sqlnet.htm

recommended value is 10

SQLNET.EXPIRE_TIME=10

can you try it and update us if it works fine with you...

garywicke

Thanks for the quick response.


I have set the parameter to 120 minutes due to the way the application needs to connect to the database.  It holds the connection open on purpose and I need it to be 120 minutes to cover the gap in processing time. 


I'm looking to find out more details about when and why the database connection is being dropped by the database if indeed it is being dropped from the database side at all.


I was hoping there was an database audit command but I haven't found it yet.


Thanks again!!


-gary

Ratnesh Kumar Roy

Hello,

Where  do you get this issue.  It usually comes in sql developer when you connect to database.

Regards.

garywicke

Thanks for your response!


As noted above the application holds the database connection open while it does some SELECTs and some processing and then tries to write the data back out to the database but by that time it appears the connection has been open too long and the application gets a 'Connection closed' error message.


I've raised the SQLNET.EXPIRE_TIME to 120 minutes and the error occurs before that much time has expired so I'm assuming that parameter is not the cause.


The profile for the user has the IDLE_TIME set to UNLIMITED so I ruled out that as well.


The network folks say there is no firewall parm set to cancel a connection.


I'm looking for the AUDIT command or whatever setting I can change in the database to increase the audit trail detail to try and identify who is breaking the connection and why. 


Is there a database tracing parm I can set to see all the detail about the connections and especially when the database terminates one?



Thanks very much!

-gary

garywicke

This did indeed turn out to be a firewall setting.

My original question was never answered so I'm closing the discussion.

I'll try elsewhere.

-gary

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 11 2013
Added on Sep 19 2013
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
7 comments
710 views