Home » RDBMS Server » Server Administration » DB Time Zone change (merged) (HP-UNIX,10g Rel2 , HPUX 11.11)
DB Time Zone change (merged) [message #438638] Mon, 11 January 2010 05:52 Go to next message
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 Go to previous messageGo to next message
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 #438645 is a reply to message #438638] Mon, 11 January 2010 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
My Oracle Support notes:
Dates & Calendars - Frequently Asked Questions, id 227334.1
Timestamps & time zones - Frequently Asked Questions, id 340512.1

Regards
Michel
Re: DB Time Zone change (merged) [message #438733 is a reply to message #438645] Tue, 12 January 2010 00:08 Go to previous messageGo to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Hello Michel,

Thanks for your reply , where can i find FAQ's , provide me a link to overcome with this queries.


Thanks & Rgd's
Re: DB Time Zone change (merged) [message #438737 is a reply to message #438733] Tue, 12 January 2010 00:41 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Those were Metalink Document ID number( search there for the specified note.

My Oracle Support notes:
sriram Smile
Re: DB Time Zone change (merged) [message #439374 is a reply to message #438645] Sat, 16 January 2010 00:07 Go to previous messageGo to next message
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 Go to previous message
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 .........


Previous Topic: Kill back end session & Time taken to kill session (merged)
Next Topic: ora 00205
Goto Forum:
  


Current Time: Wed Sep 28 09:15:23 CDT 2016

Total time taken to generate the page: 0.16535 seconds