Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Timezone set incorrectly in Oracle automated database maintenance tasks

    Timezone set incorrectly in Oracle automated database maintenance tasks

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We find that the time zone is set incorrectly in our Oracle automated database maintenance tasks (see, for instance, KB 16384-31441), so that they run in the middle of the day instead of at night.

    Resolution:
    Use the following script, and the attached class (GetSystemTimeZone.class), to set the timezone correctly:

    #!/bin/csh

    set get_timezone=`java -cp . GetSystemTimeZone`

    set primo_dba_pw=`get_ora_passwd primo_dba`

    sqlplus -s primo_dba/$primo_dba_pw as sysdba << EOF

    exec dbms_scheduler.set_scheduler_attribute('default_timezone','$get_timezone');

    EOF
    exit

    At this particular site the above did not work....

    I tried this on several servers under several Java implementations, but cannot don't find any which have GetSystemTimeZone. Tried under both our Aleph 20 and Primo server accounts, and get missing definitions

    aleph20@timothy(a20_1) NDU50> java -cp . GetSystemTimeZone
    Exception in thread "main" java.lang.NoClassDefFoundError: GetSystemTimeZone

    primo@martha(p3_1):~/p3_1/primom$java -cp . GetSystemTimeZone
    Exception in thread "main" java.lang.NoClassDefFoundError: GetSystemTimeZone
    Caused by: java.lang.ClassNotFoundException: GetSystemTimeZone
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
    Could not find the main class: GetSystemTimeZone. Program will exit.

    The site *was* able to do the following successfully:

    exec DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('default_timezone','US/Eastern');


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Timeout on first global patron search after pc_server restart
      • Tips and precautions for transition from Sublibraries to Order Units method
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved