I did the upgrade from 126.96.36.199 to 188.8.131.52 grid Oracle restart with asm on linux.
The upgradation was done successfully. now the client is compalning that the time zone change from CDT to UTC.
SQL> select DBTIMEZONE from dual;
It was 00:00 before upgrade. I dont know how the time zone got changed after upgradation.
As i can see OS is also using UTC time zone. Now I am confused.
Sat Aug 25 17:57:02 UTC 2012
Os is also using UTC. I guess the database will also use the same time zone which OS uses.
If time zone is changed now. How to change it to previous time zone?
AFAIK, upgrade process does not change the database timezone. Either the timezone on the OS was changed, or someone issued an ALTER DATABASE SET TIMEZONE command
I believe timezone doesnot change at server and database. I am the one who did the upgrade activty.
In 11gR2, I guess time zone change but it does not change the time zone of server.
Pl post in detail all of the steps you took in the upgrade process. Was the server on UTC before the upgrade ? When was the server last rebooted ?
Since 184.108.40.206 is new, it may possibly be a bug - pl also log an SR for this issue.
Pl check for any errors in the upgrade log file
1st i upgrade the asm by choosing the option upgrade grid infrastrucure or asm.
Then i install the oracle 220.127.116.11 biraries.
I upgraded the database using dbua.
During that time , i did not select upgrade time zone version.
Everything went fine.
I dont know what was the server time zone before upgrade.
Client says that the time zone was CDT before upgrade.
I diont thing upgrade will change the Os time zone.
1. Db upgrade should not change your OS or db level Timezone
2. Please review:
How To Change Timezone for 11gR2 Grid Infrastructure [ID 1209444.1]
How to Determine Whether Time Zone Changes Will Affect Your Database [ID 406410.1]
Pl see the steps in this MOS Doc - these should have been performed as part of the upgrade. What upgrade documentation did you follow ?
Actions For DST Updates When Upgrading To 18.104.22.168 Base Release [ID 815679.1]