Hi all,
We have recently installed 19c on one server (Linux). I'm trying to connect via SQLcl 19.1 to DB with 11.2.0.4 (Unix) however SQLcl is giving ORA-01882. The same connection via sqlplus works.
In support web is mentioned that for GUI tools like for example data modeler user has to modify *.conf file and add timezone for example as: AddVMOption -Duser.timezone="+02:00"
SQLcl however doesn't have such config file.
It means that I should modify directly sql shell file and add zone to this section?:
#
# set up the main arguments for java.
#
function setupArgs {
#
# Standard JVM options which are always used
#
AddVMOption -Djava.awt.headless=true
AddVMOption -Dapple.awt.UIElement=true
AddVMOption -Xss10M
}
Also this timezone, it should be of the source or target server?