Home » Server Options » Text & interMedia » not a valid time zone error
not a valid time zone error [message #76125] Thu, 07 October 2004 03:36
nanda
Messages: 11
Registered: February 2003
Junior Member
Initially we had Oracle 8.1.5 and we upgraded that to Oracle 8.1.7

I have got a UNIX shell script which does the following,

1.Changes the time zone so that we scroll back to the previous day
  (setting the system date as the date of the previous day)
 TZ=EST5EDT

Using condition,

for previous day - code added 12 with 5 (12 +5)

for next day - code subtracted 12 with 5(12 -5)

2.Connects to oracle and queries the database.

When we had oracle 8.1.5 this code was working fine without any problems
but in Oracle 8.1.7 I am getting the following error,
ERROR:
ORA-01857: not a valid time zone

SP2-0306: Invalid option.
Usage: CONN[[ECT]] [[logon]] [[AS {SYSDBA&#124SYSOPER}]] | [[INTERNAL]]
where <logon>  ::= <username>[[/<password>]][[@<connect_string>]] | /
SP2-0306: Invalid option.
Usage: CONN[[ECT]] [[logon]] [[AS {SYSDBA&#124SYSOPER}]] | [[INTERNAL]]
where <logon>  ::= <username>[[/<password>]][[@<connect_string>]] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
ERROR IN RETRIEVAL PROCESSING

Does Oracle 8.1.7 supports the time zone of adjusting the date to previous or next day??

Due to this problem & not able to connect to oracle database.

Please help me out .
Previous Topic: Re: how to insert into a blob/raw column a ..doc/.xml using PL/SQL
Next Topic: CTX INDEX DEFRAGMENTATION - help needed
Goto Forum:
  


Current Time: Thu Mar 28 04:35:40 CDT 2024