Re: SQLcl Connection

Are there any special characters in the incorrect password? If so, maybe you need to quote the value to prevent the shell from interpreting the value. Something like:

sql charlotte/"wrongpassword"_at_myhost/MYSID

On Mon, Aug 23, 2021 at 9:37 AM Charlotte Hammond < dmarc-noreply_at_freelists.org> wrote:

> Hello,
>
> I have only just started playing with SQLcl (version 19.1 on Linux) and
> have hit an oddity - just want to check if this is expected?
>
> sql charlotte/mypassword_at_myhost/MYSID <-- connects fine
> sql charlotte/wrongpassword_at_myhost/MYSID <-- hangs
>
> Is it meant to hang if I get my password wrong? It looks like a bug (or
> at least a misconfiguration) but since I'm new I want to make sure I'm not
> overlooking something obvious.
>
> Verbose mode shows nothing after:
> INFO: Attempting to connect using URL= "jdbc:oracle:oci8:_at_myhost:MYSID"
>
> The hang also happens if I get the username or service wrong (it errors if
> the host is wrong). And it's the same if I use nolog and then the connect
> command.
>
> Thank you!
> Charlotte
>

-- 
"In the beginning the Universe was created. This has made a lot of people
very angry and been widely regarded as a bad move." -Douglas Adams

--
http://www.freelists.org/webpage/oracle-l