Home » SQL & PL/SQL » Client Tools » user had different system date extracted compared with oracle (Oracle 7.3.4, Solaris 8)
user had different system date extracted compared with oracle [message #671503] Sun, 02 September 2018 22:41 Go to next message
reym21
Messages: 238
Registered: February 2010
Location: Philippines
Senior Member

Gurus,

Good day!

This is the first time we encountered a user when logged in at SQLplus
had different timestamp extracted compared to Oracle user who had it correctly.

In the attached screenshot, once ORACLE user logged in, it can select the correct
sysdate/timestamp, but when said user logged-in, it can select the correct sysdate
but a delayed (of 6 hours) timestamp. The logins were done both at the same server.
The server were once administered by our contractors and was later turned-over to us.
We haven't changed any configurations to said dB server since we started managing this.

What's causing this? Thank you in advance.

Re: user had different system date extracted compared with oracle [message #671504 is a reply to message #671503] Mon, 03 September 2018 00:27 Go to previous messageGo to next message
pablolee
Messages: 2881
Registered: May 2007
Location: Scotland
Senior Member
Must be connected to different dabases
Re: user had different system date extracted compared with oracle [message #671505 is a reply to message #671503] Mon, 03 September 2018 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 66715
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SELECT DISTINCT hostname FROM v$session WHERE type = 'BACKGROUND';

No need to post images to post text, post it inside the post.
Before, Please read How to use [code] tags and make your code easier to read.

Re: user had different system date extracted compared with oracle [message #671508 is a reply to message #671505] Mon, 03 September 2018 05:33 Go to previous messageGo to next message
Littlefoot
Messages: 21517
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle 7.3? Really? Whoa!
Re: user had different system date extracted compared with oracle [message #671513 is a reply to message #671503] Mon, 03 September 2018 09:13 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
FYI, many sites block attachements, and many of us refuse to open them for the same (security) reasons others block them. As Michael said, just copy and paste the text.
Re: user had different system date extracted compared with oracle [message #671627 is a reply to message #671508] Mon, 10 September 2018 06:47 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Littlefoot wrote on Mon, 03 September 2018 11:33
Oracle 7.3? Really? Whoa!
sqlplus 3.3 was what got me Shocked
Re: user had different system date extracted compared with oracle [message #671745 is a reply to message #671503] Mon, 17 September 2018 08:53 Go to previous messageGo to next message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

Holy moly, 1997/7.3.4?

To put things in perspective, imagine asking why Windows 95 was acting weird for you.

Do you have ANY plans or exit strategies to get your data in a more recent copy of the Oracle Database? Maybe even something from the 2000's?
Re: user had different system date extracted compared with oracle [message #671747 is a reply to message #671503] Mon, 17 September 2018 11:48 Go to previous messageGo to next message
Michel Cadot
Messages: 66715
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

@reym21, a feedback would be welcome if you want help in your future topics.

Re: user had different system date extracted compared with oracle [message #672063 is a reply to message #671747] Sun, 30 September 2018 20:51 Go to previous messageGo to next message
reym21
Messages: 238
Registered: February 2010
Location: Philippines
Senior Member

Sir, sorry for this. It's been a busy month for me (trainings, preparation of TORs, etc.) and I was struck with a flu last week. Also, this had been resolved by restarting the dB server's zone.
Anyway, as instructed, below was the output:

"SQL*Plus: Release 3.3.4.0.1 - Production on Mon Oct 1 09:35:14 2018
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Connected to:
Oracle7 Server Release 7.3.4.5.0 - Production
With the distributed and parallel query options
PL/SQL Release 2.3.4.5.0 - Production

SQL> SELECT DISTINCT hostname FROM v$session WHERE type = 'BACKGROUND';
SELECT DISTINCT hostname FROM v$session WHERE type = 'BACKGROUND'
*
ERROR at line 1:
ORA-00904: invalid column name

SQL> exit"


Thank you very much, and again, sorry for late response.
Re: user had different system date extracted compared with oracle [message #672064 is a reply to message #671745] Sun, 30 September 2018 20:56 Go to previous messageGo to next message
reym21
Messages: 238
Registered: February 2010
Location: Philippines
Senior Member

@thatjeffsmith,

We already did, in fact we already deployed last 2016 a 10g version of this nationwide legacy system but in phases.
By next year, this will be enhance/upgrade to 12c version.

Thanks.
Re: user had different system date extracted compared with oracle [message #672065 is a reply to message #671513] Sun, 30 September 2018 20:59 Go to previous message
reym21
Messages: 238
Registered: February 2010
Location: Philippines
Senior Member

@EdStevens

Well noted, Sir.

I uploaded image file based on the email attachments provided to me by our end-users.

Thanks.
Previous Topic: SQL Developer Loosing Connect
Next Topic: DBMS_OUTPUT not showing lines when procedure executes OK
Goto Forum:
  


Current Time: Sun Dec 08 15:19:00 CST 2019