Error 46 Initializing Sql Plus Linux
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business
Error 46 Initializing Sqlplus Linux
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation error 46 initializing sql * plus windows Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just
Sp2-1502: The Http Proxy Server Specified By Http_proxy Is Not Accessible
like you, helping each other. Join them; it only takes a minute: Sign up [RESOLVED]Oracle throwing SP2-1502 where there is no http_proxy variable set up vote 0 down vote favorite I have a problem trying to conect to ora-01034: oracle not available 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? Thank you. 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% windows oracle sqlplus http-proxy share|improve this question edited Nov 12 '13 at 13:14 asked Nov 12 '13 at 12:50 Ílson Bolzan 15518 1 What's the output of echo %http_proxy%? –Marco Baldelli Nov 12 '13 at 12:59 @MarcoBaldelli Thank you. I made a mistake. I assumed that synce typing proxy on the command line outputs the content of the variable, typing http_proxy perhaps would do the same. –Ílson Bolzan Nov 12 '13 at 13:08 1 also you can view velue of your variable by using: set http_proxy –MartinB Nov 12 '13 at 13:17 Please, post an answer with the solution. Stack Overflow is not a forum, here you mark an answer as correct indicating the problem was solved. –brasofilo Aug 5 '14 at 8:32 Downrated due to confusing q+a. (Resolved the problem myself by unsetting all proxy variables.) –ropata Sep 29 '15 at 22:13 | show 1 more comment 3 Answers 3 active oldest votes up vote 1 down vote accepted http_proxy is variable, so on Windows you must set this value c:\>set http_proxy = whatever unse
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and http://stackoverflow.com/questions/19929691/resolvedoracle-throwing-sp2-1502-where-there-is-no-http-proxy-variable-set rise to the top Oracle Instant Client installation woes - “HTTP proxy setting has incorrect value” up vote 3 down vote favorite 1 When I run sqlplus I get the following error: #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 I've just installed the oracle instant client on fedora 12 by doing the following: I http://serverfault.com/questions/179003/oracle-instant-client-installation-woes-http-proxy-setting-has-incorrect-valu downloaded the rpms from http://www.oracle.com/technetwork/topics/linuxsoft-082809.html oracle-instantclient11.2-basic-11.2.0.1.0-1.i386.rpm oracle-instantclient11.2-devel-11.2.0.1.0-1.i386.rpm oracle-instantclient11.2-jdbc-11.2.0.1.0-1.i386.rpm oracle-instantclient11.2-odbc-11.2.0.1.0-1.i386.rpm oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.i386.rpm oracle-instantclient11.2-tools-11.2.0.1.0-1.i386.rpm I then installed them all using rpm In addition I added this to my /etc/bashrc file and restarted the shell: export ORACLE_HOME=/usr/lib/oracle/11.2/client export LD_LIBRARY=/usr/lib/oracle/11.2/client/lib/ OS: Fedora 12, 2.6.32.16-150.fc12.i686.PAE This is a VMWare vm - that doesn't have access to the internet. Perhaps I be using the i686 versions? Thanks SF oracle fedora sqlplus share|improve this question asked Sep 8 '10 at 0:51 chickeninabiscuit 74431531 add a comment| 3 Answers 3 active oldest votes up vote 1 down vote Turns out I had set my password to the wrong value in profile.d/proxy.sh share|improve this answer answered Sep 8 '10 at 1:10 chickeninabiscuit 74431531 add a comment| up vote 1 down vote The only thing that worked for me was to set http_proxy to blank: export http_proxy= Then run SQL Plus share|improve this answer answered Nov 12 '10 at 18:02 Chepech 1113 add a comment| up vote 1 down vote sqlplus uses the http_proxy and no_proxy environment variables to determine if proxy is used. To bypass the proxy settings then both these values need to be unset. unset http_proxy unset no_proxy or export http_proxy= export no_proxy= share|improve this answer answered Jul 28 '11 at 1:14 swe
communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about http://askubuntu.com/questions/679310/problems-with-running-sqlplus64-sp2-1502-the-http-proxy-server-specified-by hiring developers or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute: Sign up Here's https://perfp.wordpress.com/2010/11/26/oracle-and-http_proxy/ how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Problems with running sqlplus64 == SP2-1502: The HTTP proxy server specified by http_proxy is not accessible up vote error 46 0 down vote favorite Very new to the whole Linux scene. Running Ubuntu 14.10 I installed the Oracle Client version 11_2 but when I try to run sqlplus64 command I get: Error 46 initializing SQL*Plus HTTP proxy setting has incorrect value SP2-1502: The HTTP proxy server specified by http_proxy is not accessible ORACLE_HOME=/opt/oracle/instantclient_11_2/files ORACLE_SID=$ORACLE_HOME Another peculiar thing. If I try to run sqlplus64 with sudo, as in: sudo sqlplus64 I get a "command not found" message though that may not error 46 initializing be important right now. I just want to be able to run sqlplus64. I have googled and searched here and couldn't find a solution to my problem. I've tried setting http_proxy the same way that is set on the Ubuntu network settings [and it's working, as I'm typing this from the ubuntu machine] but the error message still says my http_proxy is not accessible for some reason. Any ideas? server proxy oracle share|improve this question asked Sep 28 '15 at 13:32 tyranius 112 Welcome to Ask Ubuntu! ;-) We're sorry, but Ubuntu 14.10 is an end-of life product and is not supported any more, so it's off-topic here too. Please refer to help.ubuntu.com/community/Upgrades on how to upgrade. –Fabby Sep 30 '15 at 12:39 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote Found an obscure answer and it worked unset no_proxy That did it for me, sqlplus64 ran like a charm share|improve this answer answered Sep 28 '15 at 13:45 tyranius 112 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged server proxy oracle or
Filed under: code |Legg igjen en kommentar I've been working with Oracle lately. I've installed a local instance of Oracle XE to use while developing to make it easier for me to test NHibernate Mappings and Fluent Migrator (which is a really nice product, there will be a blog post about it someday). Anyway, I've had all sorts of strange errors happen to me, and the strange thing was that none of these happened at home, only at work: Immediately after install, http://localhost:8080/apex wasn't working. Checking the logs gave me no useful information, they looked like this: 2010-11-23 16:08:35.574: [ CSSCLNT][3364]clsssinit: error(33 ) in OCR initialization
[ OCRUTL][6304]u_set_comp_error: Parameter was NULL
[ OCRUTL][6304]u_set_ocr_error: Parameter was NULL
2010-11-26 12:17:41.822: [ OCROSD][6304]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.
[ OCRUTL][6304]u_set_gbl_comp_error: Parameter was NULL
[ OCRUTL][6304]u_set_gbl_comp_error: Parameter was NULL
2010-11-26 12:17:41.822: [ OCRRAW][6304]proprinit: Could not open raw device
2010-11-26 12:17:41.822: [ default][6304]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][6304]u_set_ocr_error: Parameter was NULL All suggestions i found on the net pointed to using SQL*plus to update and check system variables. But SQL*plus gave me this:
Error 46 initializing SQL*Plus
HTTP proxy setting has incorrect value
SP2-1502: The HTTP proxy server specified by http_proxy is not accessible
OK, thats a hint: remove the HTTP_PROXY system variable (which I've set to be able to use cygwin, maven and other command line tools that needs to download stuff from the web). That fixed SQL*plus, but surprisingly also fixed Apex ??! And not because the browser was using HTTP_PROXY, I tried using telnet to port 8080. It the port is open and accepts input, but after typing the usual:
GET /apex HTTP/1.1
Location: locahost
the connection will hang indefinitely wit