Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Exclamation Unanswered: Database create fails


    Can anyone please help me???? I've run a script which automatically installs Oracle on a Unix machine. It then creates a database.
    The database creation has failed, and I came across the following error in the logs:

    ORA-01857: not a valid time zone
    Undoing the database creation. Please wait...

    The TZ in the /etc/TIMEZONE file is Mideast/Riyadh89
    and Mideast/Riyadh when I type date.

    All suggestions gratefully accepted!!!!!!

  2. #2
    Join Date
    Jul 2003
    Is that even a valid timezone??
    answer = no

    selecting from the database I get:

    PHP Code:
      1  select from V$TIMEZONE_NAMES
    where tzname like '%Riy%'
    16:10:31 kod:stagedemo> /
    TZNAME               TZABBREV
    -------------------- ----------
    Asia/Riyadh          LMT
    /Riyadh          AST 
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts