| 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|SYSOPER}]] | [[INTERNAL]]
where <logon> ::= <username>[[/<password>]][[@<connect_string>]] | /
SP2-0306: Invalid option.
Usage: CONN[[ECT]] [[logon]] [[AS {SYSDBA|SYSOPER}]] | [[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 .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
