Oracle Database time differ than HP-UX OS

[Horia Chirculescu]

>. ./.oraenv.db
>$ set |grep TNS
TNS_ADMIN=/u01/app/oracle/oracle/product/10.2.0/db_1/network/admin
>$ set |grep TZ
>ORA_TZFILE=/u01/app/oracle/oracle/product/10.2.0/db_1/oracore/zoneinfo/timezlrg.dat
>TZ=WAT-3
>$ sqlplus system@DB2

Try this:

shutdown the app/database

unset ORA_TZFILE

Comment the line that is setting the variable ORA_TZFILE from ./.oraenv.db (I belive this would be the place for it or else check the user's profile for setting up this variable.)

re-start the app/database

Horia.