{"id":369,"date":"2017-04-14T11:46:08","date_gmt":"2017-04-14T07:16:08","guid":{"rendered":"http:\/\/www.enhisecure.com\/isecureblog\/?p=369"},"modified":"2017-04-14T11:46:08","modified_gmt":"2017-04-14T07:16:08","slug":"solved-http-proxy-setting-has-incorrect-value","status":"publish","type":"post","link":"https:\/\/www.enhisecure.com\/isecureblog\/2017\/04\/14\/solved-http-proxy-setting-has-incorrect-value\/","title":{"rendered":"Solved: “HTTP proxy setting has incorrect value”"},"content":{"rendered":"

Environment:<\/strong><\/p>\n

OS: Oracle Linux 7.0<\/a><\/p>\n

Java: jdk1.8<\/a><\/p>\n

DB: Oracle Database 11G R2<\/a><\/p>\n

DB Installed mode: Single Instance Server<\/p>\n

 <\/p>\n

Problem Statement:<\/strong><\/p>\n

A connection to an Oracle database<\/a>, via CLI<\/a> mode, may be achieved using the following commands in a Linux Shell<\/a>.<\/p>\n

Start the listener by typing below command:<\/p>\n

>lsnrctl start<\/strong><\/p>\n

Start the database by typing below command:<\/p>\n

>sqlplus sys as sysdba<\/strong><\/p>\n

>startup<\/strong><\/p>\n

Error:<\/p>\n

Error 46 initializing SQL*Plus
\nHTTP proxy setting has incorrect value
\nSP2-1502: The HTTP proxy server specified by http_proxy is not accessible.<\/strong><\/p>\n

\"HTTP

Error: HTTP proxy setting has incorrect value<\/p><\/div>\n

 <\/p>\n

Reasoning:<\/strong><\/p>\n

In the above error message, \u201cHTTP proxy server specified by http_proxy variable\u201d, the specified value is incorrect.The error may have occurred because sqlplus uses the http_proxy<\/a> and no_proxy<\/a> environment variables to determine if proxy is used. To bypass the proxy settings, both these values need to be unset or exported.<\/p>\n

http_proxy: Specify the value to use as the HTTP proxy for all connections.<\/p>\n

For example: http_proxy=\u201chttp:\/\/proxy.mycompany.com:8080\u201d<\/p>\n

no_proxy: Determine hosts that should bypass the proxy.<\/p>\n

For example: no_proxy=localhost, mycompany.com, 192.168.0.10:80 so it can\u2019t access this proxy.<\/p>\n

 <\/p>\n

Solution<\/strong>–<\/p>\n

First check the proxy settings , it should be correct value or unset it if no proxy is needed. SQL*Plus may get the proxy name from the environment variable http_proxy<\/a>.This problem could be resolved by using the following commands \u2013<\/p>\n

>unset http_proxy<\/strong><\/p>\n

>unset no_proxy<\/strong><\/p>\n

Or<\/p>\n

>export http_proxy=<\/strong><\/p>\n

>export no_proxy=<\/strong><\/p>\n

 <\/p>\n

\"HTTP<\/p>\n","protected":false},"excerpt":{"rendered":"

Environment: OS: Oracle Linux 7.0 Java: jdk1.8 DB: Oracle Database 11G R2 DB Installed mode: Single Instance Server   Problem Statement: A connection to an Oracle database, via CLI mode, may be achieved using the following commands in a Linux Shell. Start the listener by typing below command: >lsnrctl start Start the database by typing […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[70,72],"class_list":["post-369","post","type-post","status-publish","format-standard","hentry","category-technology","tag-http-proxy","tag-http-proxy-setting-has-incorrect-value"],"_links":{"self":[{"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/posts\/369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/comments?post=369"}],"version-history":[{"count":3,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/posts\/369\/revisions"}],"predecessor-version":[{"id":373,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/posts\/369\/revisions\/373"}],"wp:attachment":[{"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/media?parent=369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/categories?post=369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/tags?post=369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}