Search code examples
windowsoracle-databasesqlplushttp-proxy

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


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%

Solution

  • http_proxy is variable, so on Windows you must set this value

    c:\>set http_proxy = whatever
    

    unset value

    c:\>set http_proxy =
    

    IMHO U have problem with your ORACLE_SID variable or ORACLE_HOME variable. Please check this variables that are correctly filled with this command: c:\>set