This content has been marked as final. Show 13 replies
1. New agents will be created. In 11g, you can choose between a standalone agent (like the runtime agent in 10g) or a J2EE agent on a weblogic server. If you choose the second one, you can deploy webservices, use the ODI console (thin client for monitoring/executing), use the entreprise manager, ...
2. I think that the repositories upgrade itself will last less than one hour. But you have to do backup and such before.
3. Yes it does.
4. I would go for db first, test that everything is ok within ODI 10g, then upgrade to ODI 11g. But the opposite should work too.
Hope it helps,
Thanks a lot Jerome Fr! This is really helpful.
1. Got it!
2. Got it!
3. Got it! but do i need to add a jdbc driver for Oracle Database 11g to connect to it?
4. How do you migrate the master and work repository of ODI 10g to 11g? is it already included in the Update Assistant process?
so for my case first i need to upgrade the database first and then import the master and work repository to the new version of database. After that, can i now run the update assistant?
Not seen many, if any write-ups, additional to the documentation (suggest you read it here : http://docs.oracle.com/cd/E23943_01/upgrade.1111/e12642/prevusers.htm#BCFFJFDF)
What I have found:
Any customised Knowledge modules are not upgraded automatically, for example - we had a modified SQL Loader LKM - 11G changes the API method from odiRef.getTargetTable("FILE_SEP_ROW") to odiRef.getTargetTable("XFILE_SEP_ROW") - you have to do this yourself on your custom LKM -
The Source / Target datatype mapping across technologies has changed in a few cases - not sure if its because my client had changed 10G beforehand, but I had to remap some SQL Server datatypes to a different Oracle datatype to retain our ETL functionality.
You might have fun with variables (set and evaluate variable steps in scenarios), we have had to update snp_scen_step on a lot of scenarios because an 11G new column (var_long_value) did not get transfered from the 10G column (var_value)
Also check out ML ID 1409867.1 regards to having to change the format of date variables due to changes in the JDBC driver.
Double check your source / targets are covered in the Certification matrix - One of our sources is Oracle 9i and this isnt supported by 11G ODI - We had to move to DBLinks to get around this (Agent just woudnt connect and I couldnt get the older drivers working with it)
That just about covers my last upgrade :-)
Not sure to be honest, we had to ensure continuity so have upgraded to another cluster for testing, will cut over to the new cluster (and back again) for production on a strict schedule.
I assume it can be done with no downtime, as the new agent has separate libraries - they can co-exist on the same box without a problem - you just have to stop the 10G jobs / schedules and activate the 11G jobs / schedules.
948135 wrote:Either use the Upgrade Assistant and choose 'Middle Tier' to be upgraded, this will copy your ODI Params details over into your new 11G Agent ODIParams, or you can simply :
1.) How do you upgrade ODI 10g Standalone Agent to 11g? what are the procedures?
1) Install the 11G Agent on same location as current 10G agent ,
2) Configure 11G Agent ODI Params (using same details as 10G Agent , I would re-run the password encyption to be sure)
3) Launch 11G Agent - Either using a different port number (linked with your 11G Topology) or using the same Port Number as the 10G agent but shut down the 10G agent first.
I have only ever done it manually to be honest, not used the Middle Tier upgrade myself.
2.) Does the ODI 10g Standalone Agent support Oracle Database as its master and work repository?For sure !!! You dont think Oracle want you to use other databases do you ;-) Saying that, Agent repos supported on other DB technologies also.
Hope this helps,