| DB Time Zone change (merged) [message #438638] |
Mon, 11 January 2010 05:52  |
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
|
Member |
|
|
Hi,
The difference of time between HP-UX servers and Oracle Database.
Need an expertise view before i make any changes to the timezone and date on HP-UX server 11iv1.
# After stopping database and make a change in timezone and date on HP-UX 11.11 via (set_params)
# Does it effect the TZ-Agents of database and restrict to start.
# Or the behavior of database will be OK after time change on UNIX side .
#If i need to take any precaution lets me know before doing this task.
#As i did this task on HP-UX 11i V3 without any reboot successfully, But 11iv1 require boot after timezone change which matters me about the oracle database start up specially TZ agents of Database.
Help me to work on this issue ......
|
|
|
|
| DB Time Zone change [message #438640 is a reply to message #438638] |
Mon, 11 January 2010 06:02  |
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
|
Member |
|
|
Hi,
As i am planning to change time zone on unix server require your expertise feedback without disturbing Database.
#I perform this task on HP-UX 11i V3 its works without any hurdle.
#Due to HP-UX 11i v1 which require reboot after making changes in TIMEZONE.
#First stop the database
#From GUI change the timezone,date and then reboot
### IMP Questions ###
# AFter making changes via set_params can i start my database smoothly or it create TZ-AGENT problem.
So kindly if you guide me with your live experience as i am worried only about DB.
Thanks & Rgd's
|
|
|
|
|
|
|
|
|
|
| Re: DB Time Zone change (merged) [message #439374 is a reply to message #438645] |
Sat, 16 January 2010 00:07 |
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
|
Member |
|
|
Hi All,
As my present time "08:59" OK with OS , But sysdate output is far behind the actual time find other investigations details below .........
SQL> ho date
Sat Jan 16 08:59:08 WAT 2010 ....... Actual date & time
SQL> select to_char(sysdate, 'HH:MM:SS') from dual;
TO_CHAR(
--------
12:01:35
SQL> SELECT SESSIONTIMEZONE, CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIMESTAMP FROM DUAL;
SESSIONTIMEZONE
---------------------------------------------------------------------------
CURRENT_D
---------
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
LOCALTIMESTAMP
---------------------------------------------------------------------------
+03:00
16-JAN-10
16-JAN-10 09.00.20.691494 AM +03:00
16-JAN-10 09.00.20.691494 AM
SQL> SELECT DBTIMEZONE FROM dual;
DBTIME
------
-04:00
SQL> SELECT SYSTIMESTAMP FROM dual;
SYSTIMESTAMP
---------------------------------------------------------------------------
16-JAN-10 01.01.25.599885 AM -05:00
SQL> SELECT EXTRACT( timezone_region from systimestamp ) FROM dual;
EXTRACT(TIMEZONE_REGIONFROMSYSTIMESTAMP)
----------------------------------------------------------------
UNKNOWN
SQL> SELECT TZ_OFFSET(SESSIONTIMEZONE), TZ_OFFSET(DBTIMEZONE) FROM DUAL;
TZ_OFFS TZ_OFFS
------- -------
+03:00 -04:00
SQL> select dbms_scheduler.stime from dual;
STIME
-----------------------------------------------------------------
16-JAN-10 01.02.34.382852000 AM -05:00
Need your valuable inputs to solve this issue either with Oracle Enterprise manger or command line.......
Thanks & Rgd's
|
|
|
|
| Re: DB Time Zone change (merged) [message #439448 is a reply to message #439374] |
Sat, 16 January 2010 23:36 |
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
|
Member |
|
|
Hi All,
$ . ./.oraenv.DB NAME
$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 17 08:27:51 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system ......(#login WITHOUT instance name)
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> ho date
Sun Jan 17 08:28:15 WAT 2010 .... .(UNIX Server TIME)
SQL> select to_char(sysdate, 'HH:MM:SS') from dual;
TO_CHAR(
--------
08:01:36
$ . ./.oraenv.nprd
$ sqlplus system@DB INST2 ........... #login WITH instance name)
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 17 08:29:08 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select to_char(sysdate, 'HH:MM:SS') from dual;
TO_CHAR(
--------
12:01:27
When i login as system the time is 08:01:36 and login as system@instance2 the time is 12:01:27 where as HP-UX & sqlplus time is 08:28:15 which is ok.
Do i need to change HP-UX . ./.oraenv.<DB NAME> variable to get actual date.
Any update will be appreciated to over come with this issue .........
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
