cx_Oracle with Oracle XE - Python

I had a surprising amount of trouble last night getting cx_Oracle working with Oracle XE on a clean Kubuntu machine. It turns out that cx_Oracle's setup.py can't recognize a version number for XE. I eventually figured it out, made a patch, and blogged it at http://catherinedevlin.blogspot.com/2007/10/cxoracle-and-oracle-xe-on-ubuntu.html
Check that if you're getting error messages like "error in cx_Oracle setup command: Oracle home does not refer to an 8i, 9i, 10g or 11g installation"
Just thought I'd post here, in hopes that the gods of Search will lead lost travelers to safety. 

Hi Catherine,
just a suggestion but maybe you should let Anthony T. know about it so he can fix the official cx_Oracle setup.py. The Cx_Oracle mailing list (http://sourceforge.net/mail/?group_id=84168) has low traffic and it's an excellent place to talk to Anthony.
Mariano.

Related

Business Intellingence Application Server installation hangs !!!

hello i am trying to install the Oracle Business intelligence 10g Server( the BI components of the AS 10g ) on a Windows XP machine.I know its not supported but no where they say you should not install it, they only say not recommended .
I successfully installed one instance on one machine, but while installing on a second one the Oracle Universal installer just froze at "java security configuration assistant", looking in the log file i found
" Start output from spawned process:
----------------------------------
Oracle JAAS [Mon Feb 05 10:37:14 EET 2007]: invoking command:C:\BIToolsHome\ASPlus\dcm\bin\dcmctl.bat resyncInstance "
With nothing , no errors no output nothing !!
and it stayed like that for almost an hour and when i tried to stop this component's configuration also no action occured until i decided to stop the installation becasue i had no choice, i couldnt go forward i couldnt go back and i couldnt cancel either , so i forcively terminated the installation . And when i tried to uninstall , also nothing happened the installer just froze again !
i am trying now to manually complete the configuration using the other machine's log file.
I have googled for this and seen many occurences of the problem but no specific answer, if anybody could help me i'll be grateful.
Thanks 
Try disabling your anti-virus or any software that may interfere with system changes. 
Another possible option is that you might also be that you have named your ias instance using a reserved keyword. Did you try using different names during the install process?
Other issues logged with your support team include other software packages such as anti-virus (as mentioned in the previous post) and also VPN software. The recommendation is to de-install the offending software then install iAS and finally re-install the original software.
Other things to consider include Possible causes:
- OPMN may not be running,
- OPMN is running in an alternate ORACLE_HOME using duplicate port values
- OPMN may be misconfigured.
Hope this helps
Keith Laker
Data Warehouse Solution Architect
Oracle EMEA Consulting
BI Blog : http://oraclebi.blogspot.com
DM Blog : http://oracledmt.blogspot.com 
Well before i reinstall is there a way to cleanly uninstall everything from the previous installation, because right now i cannot remove anything ! 
Another possible option is that you might also be that you have named your >> ias instance using a reserved keywordi have named my instance "bias", is this a reserved keyword ?
Other issues logged with your support team include other software packages >> such as anti-virusregarding conflicts with other softwares such as the antivirus,can't i just disable it ,
install and then enable it ?
Other things to consider include Possible causes:
- OPMN may not be running,
- OPMN is running in an alternate ORACLE_HOME using duplicate port values
- OPMN may be misconfigured.Well i'm sure it is not running in another oracle home and that the ports are not being used by other processes, that leaves the 1st and 3rd options.Whenever i try to run it , it fails so i think it may be misconfigured but i still do not know the cause of this, and i will not try to re-install until first i am sure it wont do the same thing and second until i remove the bad installation .
So can you help me first remove the bad installation?
Thank you. 
There is note on Metalink, reference number 208256.1, called How to Remove a Single ORACLE_HOME and Its Traces on Microsoft Windows Platforms
This will explain all the steps required to clean out a failed installation. There are far too many steps to list in a reply on the forum so I cannot really cut & paste the text into this posting.
Hope this helps
Keith Laker
Data Warehouse Solution Architect
Oracle EMEA Consulting
BI Blog : http://oraclebi.blogspot.com
DM Blog : http://oracledmt.blogspot.com 
Hello
i don't have a metalink account, i'm only using oracle products under the developer lisence , so i guess i won't be able to view the web page.
i will be grateful if you could send it to me via e-mail
steven_acer<AT>hotmail.com 
Hi
That's where it always stops if it is going to fail. Its maddening because some work and some don't. Generally, I find that if I have anything Oracle already installed on my XP machine that the Discoverer server will not install and will fail at the resyncinstance point of the java configuration step.
I've never ever been able to get it to install successfully on a machine that has encountered such a failure without wiping the entire machine, reinstalling Windows and starting with a completely clean machine. It generally installs ok in this scenario.
I even used exactly the same names during the subsequent install and it worked fine.
All I can do is shake my head. I can't believe that in this day and age with XP being so popular that Oracle would not bring out a release for it. The very fact that it gives you the warning about not being certified means that someone inside Oracle must have encountered issues and they never fixed them.
Best wishes and good luck
Michael 
Hello Michael
Thanks for the detailed explanation.
well all i can say is DAMMIT !!
ok i will forget about installing the product but can't i remove it at least?? 
I am not going to get drawn into the XP certification debate. However, most of the Disco PM team run XP and do not have any problems installing the software. As this issue is difficult to reproduce I don't know what to say really. I will email you the de-installation instructions so you can at least remove it.
One thought - have you installed any other Oracle software on this machine before? May be there is something left over from a prior install using an older version of the installer?
May be you could view this as an excellent opportunity to rid yourself of XP and make the move to Linux.
Keith 
I have managed to track down a possible bug relating to this. It seems it might be related to some sort of JDK issue on Windows platforms. I think the bug fix was merged into the very latest build release of Discoverer 10.1.2(?). If you were using the latest version then it seems the bug might not be fixed. As you do not have a Metalink account it will not be possible to log a bug with Support and we would need to look at your machine to try and get more info about the issue to see where it is going wrong this time.
Not sure this helps but just registering this for completeness.
Keith 
Thanks alot Keith you have been a great help !
One thought - have you installed any other Oracle software on this machine >before? May be there is something left over from a prior install using an older >version of the installer?there are no left overs on the machine.
all i had was a 10g Database R10.1.2, that is a single Oracle home 1st-time successfully installed and the unviersal installer version is 10g.
but the weird thing is that i have successfully installed the same product on another twin XP that also has the exact same hardware, and the exact same softwares and oracle products installed.
May be you could view this as an excellent opportunity to rid yourself of XP and >make the move to Linux.actually im shifting to Linux , i like complexity :).
I have managed to track down a possible bug relating
to this. It seems it might be related to some sort
of JDK issue on Windows platforms. I think the bug
fix was merged into the very latest build release of
Discoverer 10.1.2(?). If you were using the latest
version then it seems the bug might not be fixed. it was not the latest version no , i think the latest was a 10.3 (?)
i will go about inspecting this and see if i can get the latest version installed. 
Hi
As I mentioned in my previous email, if you have anything else on there, even an Oracle database, you are at much greater risk of failure. There is no guarantee that it will fail, as you have found out, but when it does, it always fails at the same point; always, always, always, which is in the Java configuration section.
In my experience, and I have installed it perhaps 20 times now on XP, for every four that I have successfully installed I seem to get one that will not. That incidence rises dramatically to around 1 in 2 when there is some other Oracle product on the machine. Also, the closer I am to having a clean machine with nothing else potential Java on there the better are the chances.
I will reiterate my comment that once it starts to fail I have never seen it successfully install onto the same machine without reformatting and re-installing the operating system. Believe me I have spent many a midnight oil trying this out. I used to think that this was an XP service pack 1 issue but after upgrading to service pack 2 it still happened.
When I raised my support request with Oracle a year ago they were not interested because they said it was a non-certified platform and they were unable to recreate it. In the end it has been installed onto all of my XP machines, desktops and laptops, but some had to be wiped to do so.
Best wishes
Michael 
Hello again
this is crazy, i have tried to uninstall the instance following the instructions you gave me Keith but i couldn't , the uninstal process also froze !! can you believe that !
it stopped right at the "Deinstall Products" step of Universal installer with a message saying that i have to run "<ORALCE_HOME>\perl\5.6.1\bin\MSWin32-x86\perl.exe <ORALCE_HOME>\bin\deconfig.pl" before proceeding with the uninstallation in order to properly deconfigure the instance,and that after having this completed,i can continue.
When i ran the command i got (C:\BIToolsHome\ASPlus is my ORACLE_HOME)
C:/BIToolsHome/ASPlus/jdk/bin/java -classpath C:/BIToolsHome/ASPlus/jlib/DeconfigWrapper.jar;C:/BIToolsHome/ASPlus/jlib/ldapjclnt10.jar;C:/BIToolsHome/ASPlus/jlib/ojmisc.jar;C:/BIToolsHome/ASPlus/opmn
/lib/optic.jar;C:/BIToolsHome/ASPlus/dcm/lib/dcm.jar;C:/BIToolsHome/ASPlus/config/Queries.jar;C:/BIToolsHome/ASPlus/jdk/jre/lib/ext/sslqueries.jar oracle.ias.deconfigtool.DeconfigWrapper -o C:/BITools
Home/ASPlus -osso false
OIDhost not found in ias.properties
equired parameter OIDhost was not found in ias.properties. This means that this Oracle Home is not registered with Oracle Internet Directory. To deinstall this Oracle Home, you do not have to run this tool. Instead, you can just run Oracle Universal Installer (OUI) and select the "Deinstall" option.
so far so good, i returned to the OUI and sat their for an hour and nothing happened , it kept displaying the Remove window with the progressing bar stopped at "Synchronizing inventory" (actually the bar never moved it's always at 0)
and that's it !!
can you beat that ?!
and Michael believe me i will never install this software again 
This is very strange. Firstly I will check our support systems again on Monday to try and track down the latest error message.
As for the general issue - what can I say. As an ex-Product Manager I used to have countless versions of database, OWB, JDev, BII Beans on my laptop and never had a problem installing Discoverer 10g.
One suggestion before you give up completely. Have you tried using the Universal Installer from your database install? May be using that OUI rather than the on shipped with the Disco install might work slightly better?
Just a thought. I will try and update this some time on Monday.
Keith

ODBC Driver Download & Universal Installer

Hi,
I have a test machine running both Oracle database server (version 9.2) and client.
I have encountered some strange errors which looks ODBC related.
That is why I am now trying to upgrade my ODBC driver to the latest version 9.2.0.6.5.
However, during installation my Installer (ver. 2.2) gives me the following error : "The staging area needs Installer version 2.3.0.5.0a or later."
How do I get my Universal Installer upgraded?
It is virtually impossible to find it anywhere on the Oracle site, or anywhere else for that matter.
I can see a lot of people are having similar problems, and frankly I don't understand why this installer should cause so many problems - and why is it so hard to find it anywhere - is that intentional?
Thanks for your help in advance!
Kind regards,
Martin Rossell 
You must:
use Oracle Universal Installer shipped with 9.2.0.5 client
Ciao
Giovanni De Luca 
You must:
use Oracle Universal Installer shipped with 9.2.0.5
client
Ciao
Giovanni De LucaWell gee thanks for that answer. Very helpful. Also informative. Obviously you wokred on that one for a while.
I can't find that Client on the main site (only goes up to 9.2.0.4 for 9i) so obviously only on metalink then? Of course the link you privided in your response was a real help...
Also thanks for the 300Mb download to get a 50 cent bit of crap software working. An ODBC driver that can't tell the difference between +ve and -ve numbers was obviously tested to destruction before release. I mean how the hell could you have missed that. Did you have your eyes closed or is it just that you can't actually count?
And the funny thing is the MS ODBC drivers know how to to tell the difference.
Now I realise why I prefer Microsoft. At least the patches are easy to find and easy to get hold of, and usually install without requiring you to install this 100mb+ other thing over here.
Can you tell me how I get the universal installer without incurring a 100mb+ download and or without using metalink? I haven't got a login, only the bloody DBA's have those and getting hold of one of them is like trying to nail fog to a wall.
Surely it would be a good idea to make the universal Installer as widely available as possible all on its own to encourage people to use your software as opposed to what seems to be a deliberately obtuse methodology which you currently seem to be using.
Talk about making something simple close to impossible to do. 
Although formulated pretty harshly, I could not have described it better myself.
I think Oracle has failed miserably in the effort to make installations and updates simple via the Universal Installer. This is indeed one area (of many others) in which Oracle must improve to increase acceptance in the market.
I work as a consultant for a larger company with a central IT department managing the Oracle database - so I am in the same unfortunate situation that gaining access to MetaLink is almost impossible due to corporate policy.
But an updated ODBC driver is hardly a product needing the license protection of the MetaLink site - why not publish it on the support site?
I guess, I will simply have to tell my client that our product do not support Oracle.
Best regards,
Martin 
by the way, I am not holding it against you Giovanni.
Thank you for the answer.
But I sure hope that somebody at Oracle would think about it...
rgds,
Martin. 
Hmm. Downloaded the 9.2.0.5 patch and installed the oui that came with it. Funnily enough, it seems to be the same version... I'm probably missing something. Well, then I tried downloading the (220mb) 9.2.0.7 patch. Didn't have an oui to install. So i tried installing the odbc drivers, using the oui that the patches used to install themselves, but that was apparently too far advanced and wanted products.xml not products.jar. Maybe I'm missing something, but has anyone here ever heard of "backwards-compatibility"?
Anyway, before I endeavour to find out where I've gone wrong, I'm going to go and make my life more pleasant by flaying myself and enjoying a nice long bath in boiling lemon juice.
Thankyou Oracle. Sincerely. 
Hay guys,
Thanks a lot this article helped me a lot !!
About Oracle Installations & patches better to not to talk.
Thanks once again. 
Hi
Can anyone help get the 9.2.0.5 Client, so that i can get the right OUI installer and install the 9.2.0.6.5 ODBC driver for 9.2.0.7 database.
Thanks in advance.
You must:
use Oracle Universal Installer shipped with 9.2.0.5
client
Ciao
Giovanni De Luca 
http://www.oracle.com/technology/software/tech/windows/odpnet/install9207.html 
Here's the actual link to the installer/updater. The previous link was just the instructions, and they don't have any links to file downlaods.
http://www.oracle.com/technology/software/tech/windows/ole/htdocs/utilsoft.htm 
Hello everyone,
I am having a pretty much similar situation to the one described here. I patched Oracle 9.2.0.0 to 9.2.0.6 which I need to run Aircom Enterprise Suite 5.1. I need to install the ODBC driver and it asked for later version of the OUI. I see that I should patch to 9.2.0.7 to get it, but I am curious if I can get only the newer version of the OUI?
Thanks in advance for your help 
Guys this thread is hilarious!! Thanks for the advice and links. The process worked for the upgrade on my PC. It is the only way I can find to upgrade to the latest Oracle 9 ODBC driver.
Unfortunalty the upgrade itself did not fix my target issue like I had hoped but the upgrade itself was made possible by the information you all provided. 
Hi,
I have a test machine running both Oracle database server (version 9.2) and client.
I have encountered some strange errors which looks ODBC related.
However, during installation my Installer gives me the following error : "The staging area needs Installer version 2.3.0.5.0a or later."
How do I get my Universal Installer upgraded?
It is virtually impossible to find it anywhere on the Oracle site, or anywhere else for that matter.
I can see a lot of people are having similar problems, and frankly I don't understand why this installer should cause so many problems - and why is it so hard to find it anywhere - is that intentional?
Thanks for your help in advance! and waiting for prompt support
Kind regards,
Syed Ahsan Ali 
Hi,
I have a test machine running both Oracle database server (version 9.2) and client.
I have encountered some strange errors which looks ODBC related.
However, during installation my Installer gives me the following error : "The staging area needs Installer version 2.3.0.5.0a or later."
How do I get my Universal Installer upgraded?
It is virtually impossible to find it anywhere on the Oracle site, or anywhere else for that matter.
I can see a lot of people are having similar problems, and frankly I don't understand why this installer should cause so many problems - and why is it so hard to find it anywhere - is that intentional?
Thanks for your help in advance! and waiting for prompt support
Kind regards,
Syed Ahsan Ali 
Hi,
I have a test machine running both Oracle database server (version 9.2) and client.
I have encountered some strange errors which looks ODBC related.
However, during installation my Installer gives me the following error : "The staging area needs Installer version 2.3.0.5.0a or later."
How do I get my Universal Installer upgraded?
It is virtually impossible to find it anywhere on the Oracle site, or anywhere else for that matter.
I can see a lot of people are having similar problems, and frankly I don't understand why this installer should cause so many problems - and why is it so hard to find it anywhere - is that intentional?
Thanks for your help in advance! and waiting for prompt support
Kind regards,
Syed Ahsan Ali

Getting rid of an existing XE instance

XE installation failed towards the end--when installshield tries to create all the services. It just hung there.
I tried to repair or uninstall it, but that was not an available option in Add/Remove programs. I also didn't find any install script in the XE folders or option in the Start menu. So, I manually removed the services and dug into the registry to remove references to XE. Also deleted the oraclexe folder. I did all this after nothing else seemed to work.
Problem now is that I am unable to install XE again. I get an "Installer has detected and already existing XE instance on this system. Installation cannot proceed." At which point, the installer aborts. I can't imagine why it's detecting this, since I seem to have removed any traces of XE that I found.
Short of reformatting my hard drive and reinstalling everything--definitely not worth it, how can I recover from this installation problem?
Many thanks in advance.
Bob 
Hi,
Perhaps you can try the "Windows Installer Cleanup" from Microsoft :
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe
The Windows registry is a great mystery for much among us :-)
Henri 
Oracle makes a hugh number of entries in the windows registry - it would be a difficult job to remove them - they do all seem to start with Oracle though. Just be careful if you have other Oracle systems installed. 
Yes !
Some installations :
- 9iR2 Database
- 10gR1 Database
- 10gR1 Grid Console
- 10gR2 Database
Thanks four your post...
But it is user508298 who post a question ? No ? 
Yes. Thank you!
After using the Windows Installer Cleanup Utility I was able to get past the point of the error I mentioned, and complete the XE installation script.
However, even after installing XE, the Web interface to Oracle refused to connect me. I also had difficulty connecting using SQLPlus. I tried various solutions recommended on this forum, to no avail.
The ONLY thing that finally allowed for a successful XE installation was to remove Microsoft SQL Server Express Edition before I reinstalled XE once again. This time it worked flawlessly. Go figure!
Thanks for all the advice.
Bob 
The ONLY thing that finally allowed for a successful
XE installation was to remove Microsoft SQL Server
Express Edition before I reinstalled XE once again.
This time it worked flawlessly. Go figure!That's wierd - while I'm not unhappy with the result :-) it's a little strange that SQLServer conflicted with the XE install, and something I would like to understand. Any ideas as to why ? 
I'm clueless. I defer to anyone with expertise in these matters. 
Thanks for your feedback Bob.
XE is not really a bad solution ;-) It's very curious that you must remove SQL Server Express !
Good luck
Henri

Oracle 9.2 and PHP 5.1.x problems

Hello everyone.
I have an extremely frustrating dilemma, which has been a pain for quite a while now.
I have been working with Oracle and PHP since Oracle 8.x and PHP4 and everything has been running smoothly. After we upgraded from PHP4 to PHP5 and from Oracle 8 to Oracle 9 I had to switch from using the old php_oracle extension to the OCI-libraries, but otherwise there were no problems.
But now I am completely stumped. We are currently using Oracle version 9.2 and since our production enviroment is extremely large we are not going to upgrade to Oracle 10 or greater for many years.
PHP though keeps on going forward. I am currently using PHP 5.1.0. I have tried several times upgrading to anything beyond that. 5.1.2, 5.1.4 and recently 5.1.6. But the oracle extensions just don't want to play anymore.
I get the following error message everytime I start my apache 1.3:
The procedure entry point OCILobRead2 could not be located in .. OCI.dll
After reading this thread
(Re: "The procedure entry point OCILobRead2 could not bel located in .. OCI.dll"
I seem to know what the cause of the problem is. But how can I get past this? I would really like to upgrade our PHP version and still be able to use oracle. 5.1.0 is the last version which seems to work ok. Anything greater than that will not work at the moment.
Any help would be greatly appreciated. Thank you very much.
EDIT: I am using Windows 2000 and Windows 2003 Server. Unfortunately Linux is not an option where I work.
EDIT2: Another edit. Actually I can start the thing up with PHP 5.1.2, but then I get a weird apache crash whenever I try to run a simple select query. No error messages and the log is empty. I am completely stumped.
Message was edited by:
Gameon
Message was edited by:
Gameon 
You can use the Oracle 10 client (or instantclient) to get the 10g requirements and it will still be able to connect to the 9i server.
~Jer 
Hi there,
have you check your php.ini file? You should uncomment the extension for oci.dll in this file.
good luck 
Thanks for the answers. The oci8.dll is uncommented naturally. Otherwise it would start up just fine, but I couldn't use the database functions.
I got it working by installing 5.1.6, but replacing the oci8.dll with the one from the 5.1.0 -version. It's a very... desperate... solution, but at least it works.
I'm gonna have to try to sell the idea of using the 10g client to our DBA. I don't think though, that he'll be very enthusiastic to set it up on our production servers. We'll see. 
With instantclient there isn't anything to install and you can just unzip and use them. He might be happier about that since that way he can isolate the environment.
~Jer 
Interesting. This instantclient is completely new concept to me. I'll check it out. If what you say is true, that would actually be a solution for my problems. Thanks a bundle! 
Well it took a while before I got a chance to fix this.
The solution was simply to install the 10g client. Using the Oracle9i-database goes without any problems but the newer php-version start with less of a hassle now. Thanks for the tips everyone!
Now I'm running Apache 2.0.59 and PHP 5.1.6 with a Oracle10g client and everything is working smoothly so far.

Windows ME platform installation of Lite/Personal of any version?

How can I install 9iLite or previous versions of Oracle Lite/ Personal Oracle on a Windows ME box?? The error of --"jrew has caused an error in JAVAI.DLL displays and halts the installation. 
I opened an ITAR with Oracle Support and they told me that Oracle does not support Win ME. I saw where somebody did a workaround but you have to have the software on CD and change the staging area to the CD. Just like in the old days of Oracle 7.
I opened an ITAR with Oracle Support and they told me that Oracle does not support Win ME. I saw where somebody did a workaround but you have to have the software on CD and change the staging area to the CD. Just like in the old days of Oracle 7. 
All,
Normally I just help with pl/sql Q&A forum but being a Friday I thought I might check this forum to see what issues are happening here. I'm seeing this question ALLOT of what is the solution to get Oracle (oracle 7.x thru to 9.x) to both install and run on Windows ME (and even win950b). I have not tried this yet myself but I would have assumed that it would install no problem. From what I've been seeing it's the installer (now all java, NO idea why) that's bombing. So for you folks reading this and if you can help, what are the exact instructions to get Oracle to install on Windows ME/95? Thus far I've seen this some someone one ...
Common Error : Jrew has caused and error in JAVAI.DLL Jrew will now close.
Solution : Change/add in WIN.INI ... [compatiblity95] jrew=0x00080000
Some has said they tried this and it didn't work either. I would like to see a solution to this as I have no intention of doing win nt, 2k, or XP either. Even if someone can post the solution to above error, what are all the errors and all the work arounds to get Oracle (yes from 7.x thru 9.x) to install on Win ME/95? Please post some responses as I know allot of people out there have been asking for this.
Have a great weekend folks and thanks for helping on this one if you can !
Tyler

Categories

Resources