We are planning to upgrade the timesten release in our production from 18.104.22.168.0 to 22.214.171.124.0 version.
I have already gone through oracle timesten docs for upgrade process.They are provided three scenario's for upgarde process.
3.Online upgrades with replication
from the above scenario's which is the best option.
Actually our main concern to upgrade the timesten version 126.96.36.199.0 for the below feature:
We can create or drop a table, index or synonym in an active standby pair without stopping the replication agent and dropping the schema. We can choose to have these statements replicated to the standby database. You can include a table in an active standby pair when the table is created. Use the DDLReplicationLevel and DDLReplicationAction connection attributes to control what is replicated.
so,If I want to upgarde the verison to 188.8.131.52.0.What are patches I have to install in my servers and how to install the patches and upgrde the version in a active standby pair replication.
Please find the below details for reference:
OS: Linux (RHEL 5.3)
Kernel Version: 2.6.18-128.el5 SMP
Existing Timesten Details :
Current TIMESTEN Version: 184.108.40.206.0 (64 bit Linux/x86_64)
TImesten Instance Name: TT_tt70_32
Instance home directory: /opt/timesten/tt7032/TimesTen/TT_tt70_32
Port No: 53388.
In Our schema I have two masters(one is active and other one is standby) and four subscribers.
If you can't afford any downtime then online upgrade is the option you should consider.
You should look into the following section of the Installation guide
"Performing an online upgrade with active standby pair replication" .
All the steps were mentioned in detail.
Now can you let us know why you want to upgrade to TT 220.127.116.11.0 ? Any specific reason for that ? The current Timesten version in TT 11.2.1.x branch is TT 18.104.22.168.2. We always recommend you to upgrade to latest version so that you will get benefit of all the bug fixes.
The main reason behind for upgrading the timesten version to 22.214.171.124.0 is when we are doing any
db changes(like adding new table or sequences )in our production we are stopping the replication and dropping the active standby pair replication.In 126.96.36.199.0 they are implemented without stopping and dropping the refplication agents in active standby we colud add new tables also.
Please let me know as per suggestion If I want to go with current version 188.8.131.52.2 then wat is procedure I mean can I reinstall the latest verison or only installing the patches will enough.
And also they didn't mentioned the how to install the paches in TT when we are doing the upgrde process in online with active standby pair
TT 184.108.40.206.2 has those feature which you have mentioned. The changes between TT 220.127.116.11.2 and TT 18.104.22.168.0 is mentioned in the release note.
When you run the setup.sh , you will asked for below option
* Install a new instance.
* Upgrade an existing instance. (This option allows you to upgrade from a release previous to the TimesTen11.2.1 release.)
* Display information about an existing instance.
* Quit the installation.
You can choose this Option 2 to upgrade the existing Timesten Instance.