1. Download cx_Oracle-4.1.tar.gz from here.
2. Become root on the target system.
3. Make sure you have the ORACLE_HOME environment variable defined for user root and pointing to the correct Oracle installation directory on your server. This step is necessary because the cx_Oracle installation process looks for headers and libraries under ORACLE_HOME.
4. Install cx_Oracle by running 'python setup.py install'.
5. Become user oracle, since this is the user you'll most likely want to run python scripts as when interacting with Oracle databases. Make sure you have the following line in oracle user's .bash_profile (or similar for other shells):
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libIf you don't add ORACLE_HOME/lib to your LD_LIBRARY_PATH, you'll get an error such as:
Now you're ready to use the cx_Oracle module. Here's a bit of code that shows how to connect to an Oracle database and run a SELECT query:
>>> import cx_Oracle
Traceback (most recent call last):
", line 1, in ?
ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No such file or directory
from pprint import pprint
connection = cx_Oracle.Connection("%s/%s@%s" % (dbuser, dbpasswd, oracle_sid))
cursor = cx_Oracle.Cursor(connection)
sql = "SELECT * FROM your_table"
data = cursor.fetchall()
print "(name, type_code, display_size, internal_size, precision, scale, null_ok)"
What/where is the RSS link to subsribe this great blog?
There's an Atom link at http://agiletesting.blospot.com/atom.xml. Blogger doesn't offer RSS, so I'll probably use FeedBurner to syndicate my blog via RSS. In the mean time, you can subscribe to it via bloglines.com. And thamks for the kind words!
thanks for writing what you do. i ran into this exact problem installing cx_Oracle on Solaris and found your blog via google; your comments were helpful. also had to change the lib dir to lib32, in setup.py
Very useful. Like the previous commentator, I had to make some changes in order to install cx_Oracle on Solaris. (1) I had to change "lib" to "lib32" in setup.py. Also, (2) I had to change my ORACLE_HOME environment setting from "lib" to "lib32".
I'm getting this error when installing:
/usr/ucb/cc: language optional software package not installed
error: command 'cc' failed with exit status 1
I'm new to solaris so I have no clue what to do.
I also have no root access so I can't install anything out of my home dir. Maybe you could point me a link with binaries.
Hi can someone help me in installing cx_oracle on the Unix machine. I did as per the previoulsy posted blogs but still find this message.
Traceback (most recent call last):
File "stdin", line 1, in ?
ImportError: No module named cx_oracle
Anykind of help would be appreciated.
Building on solaris 9 sparc. Got the clntsh error, however my LD_LIBRARY_PATH did indeed include ORACLE_HOME/lib. Just to see what I could get away with, I commented out libs = ["clntsh"] in setup.py and the compile completed. Question now is what is clntsh?
gcc -shared build/temp.solaris-2.9-sun4u-2.5/cx_Oracle.o -L/nordic/apps/oracle/ora920/lib -lclntsh -o build/lib.solaris-2.9-sun4u-2.5/cx_Oracle.so -s
ld: fatal: library -lclntsh: not found
ld: fatal: File processing errors. No output written to build/lib.solaris-2.9-sun4u-2.5/cx_Oracle.so
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1
>/usr/ucb/cc: language optional software package not installed
> error: command 'cc' failed with exit status 1
Try this before compiling (if using gcc)
on hp-ux 11:
change "libPath" in cx_Oracle's setup.py to point to lib32 (line 72).
Also make sure SHLIB_PATH points to lib32 rather than lib.
setenv LD_PRELOAD /usr/lib/libcl.2
that was painful.
When you say that Oracle has to already be installed (because the script looks for environment variables for the Oracle home, etc), are you referring to the client?
Anonymous -- when I say that Oracle needs to be installed, I am referring to header files and library files. They are used by the cx_Oracle module to connect to the Oracle server.
Where can I get the header and libraries used by cx_Oracle, if Oracle is not running on my machine ?
Anonymous -- for Oracle headers and libraries, install the Oracle Instant Client from here:
Thank you for the quick guide!
i have the next error
ImportError: Failed to load cx_Oracle.so
i have install python and cx_Oracle on the hp-ux11 x64, i do the Leon say:
"change "libPath" in cx_Oracle's setup.py"
libPath = os.path.join(oracleHome, "lib32")
160 if struct.calcsize("P") == 4:
161 alternatePath = os.path.join(oracleHome, "lib32")
163 alternatePath = os.path.join(oracleHome, "lib32")
but, don't work.
Help Me pls.
Post a Comment