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

Gary Graham-Oracle
Hi,

Please read through the following post from this forum on a similar issue, but related to a driver version mismatch:
10557983

If that does not apply, then the mismatch may be something you can fix by changing some settings -- the following thread provides additional advice and reference links:
10589044

Hope this helps,
Gary
1 - 1

Post Details

Added on Jul 17 2020
0 comments
104 views