Search This Blog

Monday, July 22, 2019

Hi All,

Its been a very long time since I am writing here. Currently I am working in Oracle Cloud Installation/Operations team after been transferred. It was exciting in early days. But now a days it became a routine with no changes to the work except for the pressure that keeps increasing. Need to see how things will change once I complete my Exadata certification 1Z0-070.

See you all...!!!

Regards,
Sri

Wednesday, February 5, 2014

Exadata Patching

Dear All,

It's been a long time and I promise that your waiting is worth it. 

Hot news is that I am preparing to do patching for SAP on Exadata machines for customers..... 

WOW..... Sound exciting after knowing the process for patching....

NSH

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.

Saturday, July 24, 2010

Database Links

today we got a issue that required the data export and import utility to be used and we used it and the data is imported successfully.

Saturday, May 8, 2010

OCP Completion

hi,
i completed my OCP exam today, i got 92% in the exam. From now on I will be on the job hunt just like many other professionals. hope i would succeed in this and would be in a job (even it is a small one i will join in the job).

Saturday, May 1, 2010

relatives

do u know that relatives r as important as they make u feel miserable. i understood this through experience i had from the past. so never ever get loose on to relatives as they can make ur life bad or even worst.