Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

ORA-01882 in SQLcl connection

peter.ocelkaJul 17 2020

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?

Comments
Post Details
Added on Jul 17 2020
0 comments
105 views