Search This Blog

Friday, November 8, 2013


Hi Folks,

As of January 2013, I am certified as Oracle Database 11g Administrator Certified Professional.

Hurrayyyy.... :)
Last week I encountered a issue in the customer server where the time zone is not changed to PST from CST when its done on server side.

Problem Description
****************
new 11g oracle install was performed on AIX unix server with Central Time zone. Later server time zone was changed to Pacific time zone.

with this change, we only see PST time if login to sqlplus from server and getting sysdate from dual.

user are complaining about seeing Cental time.

one such example is that AWR report snapshot is still running in Central time (awrgrpt.sql ).

Customer Requirement
*****************

Customer wants to have PST time zone for the complete server including database and remote login using tnsnames.ora file.

Problem Analysis
*************
CAUSE
*********

Below are the reasons for the occurrence of the error

1. Listener might have a different Envs variable setting for Timezone

2. Listener is started by LSNRCTL instead of SRVCTL or vice versa

3. PMON only reads the OS environment variables when the database is started. If TZ is changed after the database is started PMON will not pick up the changed value.

For 11.2.0.2 and above the TZ entry in $GRID_HOME/crs/install/s_crsconfig__env.txt sets to correct time zone! This enables resources started under the Grid Infrastructure home (listener, databases) using the timezone set in here and so has no requirement anymore to set TZ for DB and listener via setenv.

ACTION PLAN
*****************

1. Check the environment variables set for database and listener in your CRS configuration

2. Check the current environment variables used for PMON and Listener

3. Compare and if required set the TZ setting with the above

4. If required set the correct TZ value for the database via SRVCTL

5.  Restart the CRS

6. Start the database instance and listener via SRVCTL.


Proposed Solution/ Workaround
*************************

Kindly check if the TZ entry in the file $GRID_HOME/crs/install/s_crsconfig__env.txt is set to the correct time zone.

After the changes are done the file then CRS needs to be restarted in order for the changes to take effect.

The database instance and the listener are to be started using SRVCTL.