cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle

[cx-oracle-users] cx-oracle 5.1.2 "externalized" from PyPI?

[Shai B. <sh...@pl...>]

It appears you cannot now install cx-oracle via pip without
allowing "insecure and unverifiable" files:

$ pip install cx_Oracle 
Downloading/unpacking cx-Oracle
  Could not find any downloads that satisfy the requirement cx-Oracle
  Some externally hosted files were ignored (use --allow-external cx-Oracle to allow).
Cleaning up...
No distributions at all found for cx-Oracle
Storing debug log for failure in /home/heal/.pip/pip.log   

$ pip install cx_Oracle --allow-external cx_Oracle 
Downloading/unpacking cx-Oracle
  Could not find any downloads that satisfy the requirement cx-Oracle
  Some insecure and unverifiable files were ignored (use --allow-unverified cx-Oracle to allow).
Cleaning up...
No distributions at all found for cx-Oracle
Storing debug log for failure in /home/heal/.pip/pip.log 

$ pip install cx_Oracle --allow-external cx_Oracle --allow-unverified cx-Oracle
Downloading/unpacking cx-Oracle
  cx-Oracle is potentially insecure and unverifiable.
  Downloading cx_Oracle-5.1.2.tar.gz (208kB): 208kB downloaded
  Running setup.py (path:/home/heal/VirtEnvs/tester/build/cx-Oracle/setup.py) egg_info for package cx-Oracle
  ...

That "cx-Oracle is potentially insecure and unverifiable." line, as well
as the previous hints to add the flags, are orange. Messages about
cx-Oracle not being found are red. For users who are asked to install
dependencies of a project/product, this all seems very scary.

Anthony, is this your doing? Assuming not, can you do anything about it?

Thanks,
	Shai.

Re: [cx-oracle-users] How to insert a Blob or Clob using cx_oracle?

[oug gn <lig...@gm...>]

Thank you so much! I was confused about the message. 

> The semicolon is not part of the SQL language; it is used by sq

Re: [cx-oracle-users] cx_Oracle on OSX

[Christopher J. <chr...@or...>]

On 12/13/13 6:48 PM, Dwayne King wrote:

> Is there something else required for the build process to work?  From the error, it looks like it's looking for a full set of header files, which
> wouldn't only exist in a full server install wouldn't they?

There's an Instant Client SDK or devel package containing the header files.  Unzip it to the same directory as the 'basic' package.

Chris

-- 
chr...@or...  http://twitter.com/ghrd
Free PHP & Oracle book:
http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html

[cx-oracle-users] cx_Oracle on OSX

[Dwayne K. <dw...@kr...>]

I promise....I really have looked online and in forums for clues here, but
I'm out of ideas.

I'm an Oracle DBA and I'm also familiar with python, having used it with
cx_Oracle on Windows for years.  I've never had a problem getting things
set up until now.

I'm setting up my new mac (OSX Maverick), and I have the Oracle instant
client installed and working:

Dwaynes-iMac:instantclient_11_2 dwayne$ sqlplus sys/oracle@ora11 as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 13 21:39:02 2013

Copyright (c) 1982, 2012, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing
options

SQL>

I have both python 2.7 installed (came with OSX) and 3.2

Since I couldn't find an OSX specific port of cx_Oracle on sourceforge to
download, I downloaded the source, and tried to build, but I keep running
into this:

Dwaynes-iMac:cx_Oracle-5.1.2 dwayne$ python setup.py build

running build

running build_ext

building 'cx_Oracle' extension

cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os
-pipe -fno-common -fno-strict-aliasing -fwrapv -mno-fused-madd
-DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes
-Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes
-DENABLE_DTRACE -arch x86_64 -arch i386 -pipe
-I/Users/dwayne/dev/instantclient_11_2
-I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7
-c cx_Oracle.c -o build/temp.macosx-10.9-intel-2.7-11g/cx_Oracle.o
-DBUILD_VERSION=5.1.2

clang: warning: argument unused during compilation: '-mno-fused-madd'

*cx_Oracle.c:10:10: **fatal error: **'oci.h' file not found*

#include <oci.h>

*         ^*

1 error generated.

My profile has the following variables set (which I think must be fine
since SQL*Plus works)

LD_LIBRARY_PATH=:/Users/dwayne/dev/instantclient_11_2

PATH=/Library/Frameworks/Python.framework/Versions/3.3/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/Applications/Server.app/Contents/ServerRoot/usr/bin:/Applications/Server.app/Contents/ServerRoot/usr/sbin:/Users/dwayne/dev/instantclient_11_2

DYLD_LIBRARY_PATH=:/Users/dwayne/dev/instantclient_11_2

Is there something else required for the build process to work?  From the
error, it looks like it's looking for a full set of header files, which
wouldn't only exist in a full server install wouldn't they?

Any help appreciated.

Dwayne

[cx-oracle-users] ORA-01008: not all variables bound

[Tamás G. <gt...@gt...>]

Hi,

I've thought that dict params are for named variables, and the
placeholders can appear any order, anytime, any frequency. But with
the code below I get the following traceback:

Traceback (most recent call last):
  File "<stdin>", line 21, in <module>
cx_Oracle_dbg.DatabaseError: ORA-01008: not all variables bound



import cx_Oracle
import sys
cx = cx_Oracle.connect('$DSN')
cu = cx.cursor()
params = {'inp': [1, 2], 'out': cu.arrayvar(cx_Oracle.STRING, ['']*1000)}
#cu.execute("ALTER SESSION SET cursor_sharing='EXACT'")
cu.execute("""DECLARE
    TYPE in_tabTyp IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
        in_tab in_tabTyp := :inp;
        TYPE out_tabTyp IS TABLE OF VARCHAR2(1000) INDEX BY PLS_INTEGER;
        out_tab out_tabTyp;
        v_idx PLS_INTEGER;
BEGIN
        v_idx := in_tab.FIRST;
        WHILE v_idx IS NOT NULL LOOP
            SELECT SUBSTR(DUMP(in_tab(v_idx)), 1, 1000) INTO
out_tab(v_idx) FROM DUAL;
                v_idx := in_tab.NEXT(v_idx);
        END LOOP;
        :out := out_tab;
    DBMS_OUTPUT.PUT_LINE(:out.COUNT);
END;""", params)
out = params['out'].getvalue()
print repr(out)


I've tried setting the cursor_sharing option
(http://www.fuadarshad.com/2011/02/grid-control-targets-losing-config.html),
to no avail.

If I delete the one-before-last line
(DBMS_OUTPUT.PUT_LINE(:out.COUNT);) or change :out in it to out_tab,
then the script runs fine.

Any ideas?

Thanks in advance,
Tamás Gulácsi

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

Kristian,

I'm doing it again for this tutorial [1] of his own.

I have questions.

gdbm-1.10-1.aix5.1.ppc.rpm
> gdbm-1.8.3-5.aix5.2.ppc.rpm                 * It will cause conflict
> gdbm-devel-1.10-1.aix5.1.ppc.rpm
> freetype2-2.5.0-1.aix5.1.ppc.rpm          * I have not found this version
> online Perzl


Note:

The url is wrong:
> http://github.com/kriberg/6351551/raw/27a8cf905468fd08a5ae619b9c73fa5ffcc334c2/python-2.7.5-2.spec


Correct:

>
> http://gisthub.com/kriberg/6351551/raw/27a8cf905468fd08a5ae619b9c73fa5ffcc334c2/python-2.7.5-2.spec


The path is wrong:

> rpm-bb / opt/freeware/src/packages/spec/python-2.7.5-2.spec


Correct:

> rpm-bb / opt/freeware/src/packages/SPECS/python-2.7.5-2.spec


Thank you very much!

[1]
https://github.com/kriberg/blaagposts/blob/master/setting-up-salt-dev-aix.md

@ivanelson
[]s


2013/11/28 Kristian Berg <kr...@ti...>

> On 11/28/2013 09:00 PM, Ivanelson Nunes wrote:
> > I think I get this error. Actually, I did not install the * devel *
> > rpm. I'll install it now, because the requirements are spec file.
> >
>
> You also need to use the spec file in the gist from github that I linked
> you, not the spec from perzl.
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

Hello,

installed all dependencies for python-2.7.5-1 in perzl site. Then I did:

> bash-4.2# rpm -bb --target ppc-ibm-aix6.1
> /opt/freeware/src/packages/SPECS/python-2.7.5-2.spec
> Building target platforms: ppc-ibm-aix6.1
> Building for target ppc-ibm-aix6.1
> error: failed build dependencies:
>         patch is needed by python-2.7.5-2



How do I make a spec file to version 2.7.5-1?

Thanks

@ivanelson
[]s


2013/11/28 Kristian Berg <kr...@ti...>

> On 11/28/2013 09:00 PM, Ivanelson Nunes wrote:
> > I think I get this error. Actually, I did not install the * devel *
> > rpm. I'll install it now, because the requirements are spec file.
> >
>
> You also need to use the spec file in the gist from github that I linked
> you, not the spec from perzl.
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

Its gist is the spec file for python-2.7.5-2. My python is 2.7.5-1.

bash-4.2 # python
> Python 2.7.5 (default, Aug 2 2013, 23:28:11) [C] on aix6
> Type "help", "copyright", "credits" or "license" for more information.


?!


@ivanelson
[]s


2013/11/28 Kristian Berg <kr...@ti...>

> On 11/28/2013 09:00 PM, Ivanelson Nunes wrote:
> > I think I get this error. Actually, I did not install the * devel *
> > rpm. I'll install it now, because the requirements are spec file.
> >
>
> You also need to use the spec file in the gist from github that I linked
> you, not the spec from perzl.
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Kristian B. <kr...@ti...>]

On 11/28/2013 09:00 PM, Ivanelson Nunes wrote:
> I think I get this error. Actually, I did not install the * devel * 
> rpm. I'll install it now, because the requirements are spec file.
>

You also need to use the spec file in the gist from github that I linked 
you, not the spec from perzl.

-- 
[Kristian Berg]

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

I think I get this error. Actually, I did not install the * devel * rpm.
I'll install it now, because the requirements are spec file.

@ivanelson
[]s


2013/11/28 Ivanelson Nunes <iva...@gm...>

> I downloaded this spec:
>
> wget ftp://www.oss4aix.org/SPECS/python-2.7.5-1.spec
>
>
> and saved on:
>
> rcp /tmp/python-2.7.5-1.spec scobtez:/opt/freeware/src/packages/SPECS
>
> I do:
>
> rpm-bb - target ppc-ibm-aix6.1
>> /opt/freeware/src/packages/SPECS/python-2.7.5-1.spec
>
>
> I got error:
>
> Building target platforms: ppc-ibm-aix6.1
>> Building for target ppc-ibm-aix6.1
>> error: failed build dependencies:
>>         patch is needed by python-2.7.5-1
>>         db4-devel >= 4.7.25-2 is needed by python-2.7.5-1
>>         gdbm-devel >= 1.8.3-1 is needed by python-2.7.5-1
>>         libffi-devel >= 3.0.13-1 is needed by python-2.7.5-1
>>         openssl-devel >= 1.0.1 is needed by python-2.7.5-1
>>         pkg-config is needed by python-2.7.5-1
>>         readline-devel >= 5.2-3 is needed by python-2.7.5-1
>>         tcl-devel >= 8.5.8-2 is needed by python-2.7.5-1
>>         tk-devel >= 8.5.8-1 is needed by python-2.7.5-1
>>         sqlite-devel >= 3.7.3-1 is needed by python-2.7.5-1
>
>
> What suffering!
>
> @ivanelson
> []s
>
>
> 2013/11/28 Kristian Berg <kr...@ti...>
>
>>  On 11/28/2013 08:01 PM, Ivanelson Nunes wrote:
>>
>> rpm -bb --target ibm_ppc=aix6.1
>> /opt/freeware/src/packages/SPECS/python-2.7.5.2.spec
>>
>> rpm -bb --target ppc-ibm-aix6.1
>> /opt/freeware/src/packages/SPECS/python-2.7.5.2.spec
>>
>> --
>> [Kristian Berg]
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Rapidly troubleshoot problems before they affect your business. Most IT
>> organizations don't have a clear picture of how application performance
>> affects their revenue. With AppDynamics, you get 100% visibility into your
>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
>> Pro!
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

I downloaded this spec:

wget ftp://www.oss4aix.org/SPECS/python-2.7.5-1.spec


and saved on:

rcp /tmp/python-2.7.5-1.spec scobtez:/opt/freeware/src/packages/SPECS

I do:

rpm-bb - target ppc-ibm-aix6.1
> /opt/freeware/src/packages/SPECS/python-2.7.5-1.spec


I got error:

Building target platforms: ppc-ibm-aix6.1
> Building for target ppc-ibm-aix6.1
> error: failed build dependencies:
>         patch is needed by python-2.7.5-1
>         db4-devel >= 4.7.25-2 is needed by python-2.7.5-1
>         gdbm-devel >= 1.8.3-1 is needed by python-2.7.5-1
>         libffi-devel >= 3.0.13-1 is needed by python-2.7.5-1
>         openssl-devel >= 1.0.1 is needed by python-2.7.5-1
>         pkg-config is needed by python-2.7.5-1
>         readline-devel >= 5.2-3 is needed by python-2.7.5-1
>         tcl-devel >= 8.5.8-2 is needed by python-2.7.5-1
>         tk-devel >= 8.5.8-1 is needed by python-2.7.5-1
>         sqlite-devel >= 3.7.3-1 is needed by python-2.7.5-1


What suffering!

@ivanelson
[]s


2013/11/28 Kristian Berg <kr...@ti...>

>  On 11/28/2013 08:01 PM, Ivanelson Nunes wrote:
>
> rpm -bb --target ibm_ppc=aix6.1
> /opt/freeware/src/packages/SPECS/python-2.7.5.2.spec
>
> rpm -bb --target ppc-ibm-aix6.1
> /opt/freeware/src/packages/SPECS/python-2.7.5.2.spec
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Kristian B. <kr...@ti...>]

On 11/28/2013 08:01 PM, Ivanelson Nunes wrote:
> rpm -bb --target ibm_ppc=aix6.1 
> /opt/freeware/src/packages/SPECS/python-2.7.5.2.spec 
rpm -bb --target ppc-ibm-aix6.1 
/opt/freeware/src/packages/SPECS/python-2.7.5.2.spec

-- 
[Kristian Berg]

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

Done! Installed
bash-4.2# rpm -ivh python-2.7.5-1.src.rpm
python
 ##################################################

What the next step?!


@ivanelson
[]s


2013/11/28 Kristian Berg <kr...@ti...>

>  On 11/28/2013 07:41 PM, Ivanelson Nunes wrote:
>
>
> bash-4.2# rpm -bb --target ibm_ppc=aix6.1
>> /opt/freeware/src/packages/SPECS/python-2.7.5.2.spec
>> Building target platforms: ibm_ppc=aix6.1
>> Building for target ibm_ppc=aix6.1
>> File /opt/freeware/src/packages/SOURCES/Python-2.7.5.tar.bz2: A file or
>> directory in the path name does not exist.
>
>
>
>
>  You need to install the source rpm for python from prezl to get the
> source and various patches etc.
> http://www.oss4aix.org/download/SRPMS/python/python-2.7.5-1.src.rpm
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Kristian B. <kr...@ti...>]

On 11/28/2013 07:41 PM, Ivanelson Nunes wrote:
>
>     bash-4.2# rpm -bb --target ibm_ppc=aix6.1
>     /opt/freeware/src/packages/SPECS/python-2.7.5.2.spec
>     Building target platforms: ibm_ppc=aix6.1
>     Building for target ibm_ppc=aix6.1
>     File /opt/freeware/src/packages/SOURCES/Python-2.7.5.tar.bz2: A
>     file or directory in the path name does not exist.
>
>
>
>
You need to install the source rpm for python from prezl to get the 
source and various patches etc.
http://www.oss4aix.org/download/SRPMS/python/python-2.7.5-1.src.rpm

-- 
[Kristian Berg]

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

When I installed the rpm's python for perzl, I downloaded all of these:

/opt/freeware/pythonppc
> # ls -tg
> total 234160
> -rw-r--r--    1 system     10022361 Nov 22 00:20
> libstdc++-4.8.2-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system      2667103 Nov 22 00:20
> libstdc++-devel-4.8.2-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system     18117699 Nov 22 00:20
> openssl-1.0.1e-2.aix5.1.ppc.rpm
> -rw-r--r--    1 system      2621760 Nov 22 00:20
> tcl-8.5.15-1.aix5.1.ppc.rpm
> -rw-r--r--    1 system      9934241 Nov 22 00:20
> gcc-gfortran-4.8.2-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system       130215 Nov 22 00:20
> libffi-3.0.13-1.aix5.1.ppc.rpm
> -rw-r--r--    1 system       886300 Nov 22 00:20
> libgcc-4.8.2-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system       517814 Nov 22 00:20
> libgomp-4.8.2-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system     18087017 Nov 22 00:20 gcc-4.8.2-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system      6571520 Nov 22 00:20
> gcc-c++-4.8.2-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system      5866258 Nov 22 00:20
> gcc-cpp-4.8.2-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system       122731 Nov 22 00:20
> bzip2-1.0.6-1.aix5.1.ppc.rpm
> -rw-r--r--    1 system      3054640 Nov 22 00:20
> db4-4.7.25-2.aix5.1.ppc.rpm
> -rw-r--r--    1 system      3030360 Nov 22 00:20
> db4-cxx-4.7.25-2.aix5.1.ppc.rpm
> -rw-r--r--    1 system      1488021 Nov 22 00:20
> db4-devel-4.7.25-2.aix5.1.ppc.rpm
> -rw-r--r--    1 system      3439979 Nov 22 00:20
> db4-tcl-4.7.25-2.aix5.1.ppc.rpm
> -rw-r--r--    1 system       274950 Nov 22 00:20
> db4-utils-4.7.25-2.aix5.1.ppc.rpm
> -rw-r--r--    1 system       389811 Nov 22 00:20
> expat-2.1.0-1.aix5.1.ppc.rpm
> -rw-r--r--    1 system        57732 Nov 22 00:20
> expat-devel-2.1.0-1.aix5.1.ppc.rpm
> -rw-r--r--    1 system     12077202 Nov 21 23:52
> python-test-2.7.5-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system         9137 Nov 21 23:52
> python-tools-2.7.5-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system       996973 Nov 21 23:52
> tkinter-2.7.5-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system       222491 Nov 21 23:52
> python-devel-2.7.5-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system      4101564 Nov 21 23:52
> python-libs-2.7.5-1.aix6.1.ppc.rpm
> -rw-r--r--    1 system     15140204 Nov 21 23:52
> python-2.7.5-1.aix6.1.ppc.rpm


So I have to download all those again, but in tar format and then install
all?

I got errors:

bash-4.2# rpm -bb --target ibm_ppc=aix6.1
> /opt/freeware/src/packages/SPECS/python-2.7.5.2.spec
> Building target platforms: ibm_ppc=aix6.1
> Building for target ibm_ppc=aix6.1
> File /opt/freeware/src/packages/SOURCES/Python-2.7.5.tar.bz2: A file or
> directory in the path name does not exist.




@ivanelson
[]s


2013/11/28 Kristian Berg <kr...@ti...>

>  On 28.11.2013 02:28, Ivanelson Nunes wrote:
>
> Is this the spec file?
> ftp://www.oss4aix.org/SPECS/python-2.7.5-1.spec
>
> Because I need to install the dependencies again? I have already installed
> all the RPM's perzl site. I think I just need the Python tarfile. Right or
> Error?
>
> A version of cx_Oracle on aix_ppc rpm would be easier for everyone. : (
>
>  This is the spec-file I created for using gcc:
> https://gist.github.com/kriberg/6351551
>
>
> You need the build dependencies for Python too, in addition to the runtime dependencies.
>
> I'm not sure you even can distribute a rpm of cx_Oracle, as it links with the instant client.
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Kristian B. <kr...@ti...>]

 

On 28.11.2013 02:28, Ivanelson Nunes wrote: 

> Is this the spec file? 
> ftp://www.oss4aix.org/SPECS/python-2.7.5-1.spec [1]
> 
> Because I need to install the dependencies again? I have already installed all the RPM's perzl site. I think I just need the Python tarfile. Right or Error? 
> 
> A version of cx_Oracle on aix_ppc rpm would be easier for everyone. : (

This is the spec-file I created for using gcc:
https://gist.github.com/kriberg/6351551

You need the build dependencies for Python too, in addition to the
runtime dependencies.

I'm not sure you even can distribute a rpm of cx_Oracle, as it links
with the instant client.

-- 
[Kristian Berg]
 

Links:
------
[1] ftp://www.oss4aix.org/SPECS/python-2.7.5-1.spec

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

Is this the spec file?
ftp://www.oss4aix.org/SPECS/python-2.7.5-1.spec

Because I need to install the dependencies again? I have already installed
all the RPM's perzl site. I think I just need the Python tarfile. Right or
Error?


A version of cx_Oracle on aix_ppc rpm would be easier for everyone. : (

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Kristian B. <kr...@ti...>]

On 11/27/2013 09:57 PM, Ivanelson Nunes wrote:
> Problems and more problems. I am installing a new instance of Python, 
> but when I do make, I get an error.
>
> # ./configure --prefix=/usr/lib/python-2.7.6
> # make
>
>     rt.o  Modules/symtablemodule.o  Modules/xxsubtype.o
>             ranlib libpython2.7.a
>             ./Modules/makexp_aix Modules/python.exp . libpython2.7.a;
>      gcc -pthread -L/opt/freeware/lib
>     -Wl,-blibpath:/opt/freeware/lib:/usr/lib:/lib
>     -Wl,-bmaxdata:0x80000000 -Wl,-bE:Modules/python.exp -lld -o python
>      Modules/python.o  libpython2.7.a -ldl    -lm
>     *collect2: fatal error: library libm not found*
>     compilation terminated.
>     make: 1254-004 The error code from the last command is 1.
>
>
You need to install the dependencies for compiling Python first. Check 
out the python page on perzl for a complete list. You dont need 
everything, but most of them. I'd recommend using the rpm spec-file i 
linked you though. Install the srpm for python on perzl first, then drop 
my spec-file into /opt/freeware/src/packages/SPECS/ and compile it with 
"rpm -bb --target ibm-ppc-aix6.1 foo.spec"

-- 
[Kristian Berg]

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

Problems and more problems. I am installing a new instance of Python, but
when I do make, I get an error.

# ./configure --prefix=/usr/lib/python-2.7.6
# make

rt.o  Modules/symtablemodule.o  Modules/xxsubtype.o
>         ranlib libpython2.7.a
>         ./Modules/makexp_aix Modules/python.exp . libpython2.7.a;  gcc
> -pthread -L/opt/freeware/lib -Wl,-blibpath:/opt/freeware/lib:/usr/lib:/lib
> -Wl,-bmaxdata:0x80000000 -Wl,-bE:Modules/python.exp -lld -o python
>  Modules/python.o  libpython2.7.a -ldl    -lm
> *collect2: fatal error: library libm not found*
> compilation terminated.
> make: 1254-004 The error code from the last command is 1.


:(


@ivanelson
[]s


2013/11/27 Kristian Berg <kr...@ti...>

>  On 27.11.2013 14:26, Ivanelson Nunes wrote:
>
>
>  unable to execute ./Modules/ld_so_aix: No such file or directory
>> error: command './Modules/ld_so_aix' failed with exit status 1
>
>
>
>  You're getting this because compiling python directly on aix doesn't setup the target path for ld_so_aix correctly. You need to change some parameters in _sysconfigdata.py. If you compiled and installed manually, it is probably located in /usr/local/lib/python2.7/. Find the instances of "./Modules/ld_so_aix" and change it to the absolute path of ld_so_aix, usually located under config/ld_so_aix in that same installation directory. I.E., /usr/local/lib/python2.7/config/ld_so_aix.
>
> If anybody else has a good suggestion on how to fix the linker issue with python on aix other than search and replace in ld_so_aix, I'm very interested as it's a hack.
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Kristian B. <kr...@ti...>]

 

On 27.11.2013 14:26, Ivanelson Nunes wrote: 

>> unable to execute ./Modules/ld_so_aix: No such file or directory
>> error: command './Modules/ld_so_aix' failed with exit status 1

You're getting this because compiling python directly on aix doesn't
setup the target path for ld_so_aix correctly. You need to change some
parameters in _sysconfigdata.py. If you compiled and installed manually,
it is probably located in /usr/local/lib/python2.7/. Find the instances
of "./Modules/ld_so_aix" and change it to the absolute path of
ld_so_aix, usually located under config/ld_so_aix in that same
installation directory. I.E., /usr/local/lib/python2.7/config/ld_so_aix.


If anybody else has a good suggestion on how to fix the linker issue
with python on aix other than search and replace in ld_so_aix, I'm very
interested as it's a hack.

-- 
[Kristian Berg]
 

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

I did a test on another server with AIX as well. Python-2.7.6.tgz
downloaded a version compiled and manual.

./configure --prefix=/usr/lib/Python-2.7.6
> make
> make install
> chmod -R 777 /opt/local/


Python it works:

bash-4.2$ /usr/lib/Python-2.7.3/bin/python
> Python 2.7.6 (default, Nov 27 2013, 09:49:44)
> [GCC 4.2.3] on aix6
> Type "help", "copyright", "credits" or "license" for more information.
> >>>


But installing cx_Oracle continues on failure:

bash-4.2$ /usr/lib/Python-2.7.3/bin/python setup.py install
> running install
> running build
> running build_ext
> building 'cx_Oracle' extension
> gcc -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DSYSV -D_AIX
> -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -D_AIX52 -D_AIX53 -D_AIX61
> -D_ALL_SOURCE -DFUNCPROTO=15 -O -I/opt/freeware/include
> -I/u1/oratez/app/oracle/product/11.2.0/dbhome_1/rdbms/demo
> -I/u1/oratez/app/oracle/product/11.2.0/dbhome_1/rdbms/public
> -I/usr/lib/Python-2.7.3/include/python2.7 -c cx_Oracle.c -o
> build/temp.aix-6.1-2.7-10g/cx_Oracle.o -DBUILD_VERSION=5.1.2
> In file included from
> /u1/oratez/app/oracle/product/11.2.0/dbhome_1/rdbms/public/oci.h:3024,
>                  from cx_Oracle.c:10:
> /u1/oratez/app/oracle/product/11.2.0/dbhome_1/rdbms/public/ociap.h:10788:
> warning: function declaration isn't a prototype
> /u1/oratez/app/oracle/product/11.2.0/dbhome_1/rdbms/public/ociap.h:10794:
> warning: function declaration isn't a prototype
> ./Modules/ld_so_aix gcc -pthread -bI:./Modules/python.exp
> -L/opt/freeware/lib64 -L/opt/freeware/lib
> -Wl,-blibpath:/opt/freeware/lib64:/opt/freeware/lib:/usr/lib:/lib
> -Wl,-bmaxdata:0x80000000 -L/opt/freeware/lib64 -L/opt/freeware/lib
> -Wl,-blibpath:/opt/freeware/lib64:/opt/freeware/lib:/usr/lib:/lib
> -Wl,-bmaxdata:0x80000000 -DSYSV -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51
> -D_AIX52 -D_AIX53 -D_AIX61 -D_ALL_SOURCE -DFUNCPROTO=15 -O
> -I/opt/freeware/include build/temp.aix-6.1-2.7-10g/cx_Oracle.o
> -L/u1/oratez/app/oracle/product/11.2.0/dbhome_1/lib -lclntsh -o
> build/lib.aix-6.1-2.7-10g/cx_Oracle.so
> unable to execute ./Modules/ld_so_aix: No such file or directory
> error: command './Modules/ld_so_aix' failed with exit status 1



@ivanelson
[]s


2013/11/27 Kristian Berg <kr...@ti...>

>  On 27.11.2013 12:13, Ivanelson Nunes wrote:
>
> My only way out is to buy the xlc? If someone to build and compiled in the
> format aix_ppc cx_Oracle?
>
>
> No, you can compile cx_Oracle with gcc, but you have to use a Python binary compiled with gcc to achieve that. When Python is built on aix, it also creates a wrapper for compiling C modules that can be called from Python. This is the ld_so_aix program. If you compile python with xlc, the wrapper will be created with xlc as the compiler and linker. If you compile python with gcc, it will create a wrapper using gcc. You can't use a xlc-compiled python to create gcc-compiled modules. So you either have to rebuild python with gcc and then compile cx_oracle or you have to get xlc to compile cx_oracle. Now, you can get a free trial of xlc for aix on ibm's website. Maybe that's sufficient to create a rpm you can reuse, but make sure to check the licensing terms of the trial before doing so.
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Kristian B. <kr...@ti...>]

 

On 27.11.2013 12:13, Ivanelson Nunes wrote: 

> My only way out is to buy the xlc? If someone to build and compiled in the format aix_ppc cx_Oracle?

No, you can compile cx_Oracle with gcc, but you have to use a Python
binary compiled with gcc to achieve that. When Python is built on aix,
it also creates a wrapper for compiling C modules that can be called
from Python. This is the ld_so_aix program. If you compile python with
xlc, the wrapper will be created with xlc as the compiler and linker. If
you compile python with gcc, it will create a wrapper using gcc. You
can't use a xlc-compiled python to create gcc-compiled modules. So you
either have to rebuild python with gcc and then compile cx_oracle or you
have to get xlc to compile cx_oracle. Now, you can get a free trial of
xlc for aix on ibm's website. Maybe that's sufficient to create a rpm
you can reuse, but make sure to check the licensing terms of the trial
before doing so.

-- 
[Kristian Berg]
 

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Ivanelson N. <iva...@gm...>]

My only way out is to buy the xlc? If someone to build and compiled in the
format aix_ppc cx_Oracle?


@ivanelson
[]s


2013/11/27 Kristian Berg <kr...@ti...>

>  On 27.11.2013 05:14, Ivanelson Nunes wrote:
>
> I decided to reinstall gcc. I installed version 4.8.2. After that I tried
> again to install cx_Oracle.
>
> unable to execute ./Modules/ld_so_aix: No such file or directory
>> error: command './Modules/ld_so_aix' failed with exit status 1
>
>
>
>
> The perzl python binaries have been compiled with xlc, so you won't be able to compile python extensions without xlc, if you use it.
> I adapted perzl rpm spec to work with gcc:
> https://gist.github.com/kriberg/6351551
>
> You can use that to compile python and then compile cx_Oracle. Your mileage may vary, as perzl is much more competent at making srpms for AIX than me.
>
> --
> [Kristian Berg]
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Kristian B. <kr...@ti...>]

 

On 27.11.2013 05:14, Ivanelson Nunes wrote: 

> I decided to reinstall gcc. I installed version 4.8.2. After that I tried again to install cx_Oracle.
> 
>> unable to execute ./Modules/ld_so_aix: No such file or directory
>> error: command './Modules/ld_so_aix' failed with exit status 1

The perzl python binaries have been compiled with xlc, so you won't be
able to compile python extensions without xlc, if you use it.
I adapted perzl rpm spec to work with gcc:
https://gist.github.com/kriberg/6351551

You can use that to compile python and then compile cx_Oracle. Your
mileage may vary, as perzl is much more competent at making srpms for
AIX than me.

-- 
[Kristian Berg]
 

Re: [cx-oracle-users] Installing cx_Oracle on AIX without using "xlc_r"

[Tamás G. <gt...@gt...>]

> Date: Tue, 26 Nov 2013 21:13:11 -0200
> From: Ivanelson Nunes <iva...@gm...>
> Subject: Re: [cx-oracle-users] Installing cx_Oracle on AIX without
>         using   "xlc_r"
> To: cx-...@li...
> Message-ID:
>         <CAA...@ma...>
> Content-Type: text/plain; charset="utf-8"
>
> In my AIX 6.1 I have not installed xlc/xlc_r. I think the xlc is purchased
> separately.
>
> I get the Python-2.7.5 RPM's for the Perzl [1].
>
> And've tried installing cx_Oracle and I can not.
>
> I have also tried via gcc (export CC = gcc).
>
> Any tips please?
>
> [1] http://www.perzl.org/aix/
>
> @ivanelson
> []s
>
>

You HAVE to use the same compiler and flags as what with your Python
has been compiled.
Download the python srpm, and spec files, and see what has to be
used/modified to compile it with your compiler. Then you can use
python setup.py to have cx_Oracle been compiled.

Tamás Gulácsi