0 Replies Latest reply on Jul 17, 2020 9:07 AM by peter.ocelka

    ORA-01882 in SQLcl connection

    peter.ocelka

      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?