Skip to Main Content

AI Services

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sqlplus login as SYSDBA gives correct time but after connect to the schema gives different time

ArjunaSep 5 2024

Hi,

Our DB is currently hosted on the Oracle cloud and the server time is set to South Pacific / Fiji. Still, when you log in to the DB using SQL developer it gives the US TIME and date. , when you log in through Putty, and connect to sqlplus as sysdba it gives the correct Fiji time, but when you connect to one of the schemas its date time shows the US date time and for a much better understanding I will upload some screenshots. please help me to configure to get the correct local date and time (Fiji).

Comments
Post Details
Added on Sep 5 2024
0 comments
44 views