Windows – Oracle throwing SP2-1502 where there is no http_proxy variable set

http-proxyoraclesqlpluswindows

I have a problem trying to conect to an Oracle database via sqlplus.

The command line looks like this:

C:\oracle\product\11.2.0\client_1>sqlplus
Error 46 initializing SQL*Plus
HTTP proxy setting has incorrect value
SP2-1502: The HTTP proxy server specified by http_proxy is not accessible

C:\oracle\product\11.2.0\client_1>http_proxy
'http_proxy' não é reconhecido como um comando interno
ou externo, um programa operável ou um arquivo em lotes.

Acording to this blog post! it apears to complain about the value on the http_proxy variable, but this variable don't even exist in the client machine.

Anyone had this same problem over windows?

Edit:

Sorry guys. I had http_proxy set as a user variable. I was just trying to look at it the wrong way.

Wrong:

C:\Users\ilson.bolzan>http_proxy

Right:

C:\Users\ilson.bolzan>echo %http_proxy%

Best Answer

I got the same problem on Linux.

When I unsetted 'http_proxy' environment variable as

unset http_proxy
or
export http_proxy=

the problem was repeated.

I found, that 'no_proxy' environment variable spoils the case.

I had right value for http_proxy

http_proxy=http://localhost:3128/

but I had no_proxy=localhost,127.0.0.0/8,::1 too.

I've unset 'no_proxy' environment variable and sqlplus start to work as expected.

Related Solutions

Sql – ny boolean type in Oracle databases

Not only is the boolean datatype missing in Oracle's SQL (not PL/SQL), but they also have no clear recommendation about what to use instead. See this thread on asktom. From recommending CHAR(1) 'Y'/'N' they switch to NUMBER(1) 0/1 when someone points out that 'Y'/'N' depends on the English language, while e.g. German programmers might use 'J'/'N' instead.

The worst thing is that they defend this stupid decision just like they defend the ''=NULL stupidity.

Windows – How to set commands output as a variable in a batch file

FOR /F "tokens=* USEBACKQ" %%F IN (`command`) DO (
SET var=%%F
)
ECHO %var%

I always use the USEBACKQ so that if you have a string to insert or a long file name, you can use your double quotes without screwing up the command.

Now if your output will contain multiple lines, you can do this

SETLOCAL ENABLEDELAYEDEXPANSION
SET count=1
FOR /F "tokens=* USEBACKQ" %%F IN (`command`) DO (
  SET var!count!=%%F
  SET /a count=!count!+1
)
ECHO %var1%
ECHO %var2%
ECHO %var3%
ENDLOCAL

Best Answer

Related Solutions

Sql – ny boolean type in Oracle databases

Windows – How to set commands output as a variable in a batch file

Related Topic