cx-oracle-users

[cx-oracle-users] python 2.3 + cx_oracle on HP-UX Itanium

[<bd...@ad...>]

Hello,

I am a very satisfied user of cx_oracle on windows and HP-UX
where Anthony once kindly helped me sort out installation
problems. Thanks again for your patience.

Because we will be moving to Oracle 10g on Itanium,
I will shortly need to compile python 2.3 and cx_oracle
on that platform. I seem to recall people having problem
compiling python on HP-UX in general, and am interested
in opinions about which compiler to use. Should I require
the HP compiler, or is gcc known to work for this purpose ?

A binary build of gcc is provided by HP at
http://hpux.connect.org.uk/hppd/hpux/Gnu/gcc-3.4.3/

"uname -a" reports the following, in case it helps:
HP-UX prisme20 B.11.23 U ia64 1530408444 unlimited-user license


Thanks for any hint,


Bernard.

Re: [cx-oracle-users] python 2.3 + cx_oracle on HP-UX Itanium

[Anthony T. <ant...@gm...>]

We don't use HP-UX much but the few times that I have used it gcc
seemed to work the best -- at least for the past year or so. Prior to
that gcc had all sorts of issues compiling Python but everything was
smooth sailing the last time I tried it with gcc 3.2.

On 5/18/05, Bernard Delm=E9e <bd...@ad...> wrote:
> Hello,
>=20
> I am a very satisfied user of cx_oracle on windows and HP-UX
> where Anthony once kindly helped me sort out installation
> problems. Thanks again for your patience.
>=20
> Because we will be moving to Oracle 10g on Itanium,
> I will shortly need to compile python 2.3 and cx_oracle
> on that platform. I seem to recall people having problem
> compiling python on HP-UX in general, and am interested
> in opinions about which compiler to use. Should I require
> the HP compiler, or is gcc known to work for this purpose ?
>=20
> A binary build of gcc is provided by HP at
> http://hpux.connect.org.uk/hppd/hpux/Gnu/gcc-3.4.3/
>=20
> "uname -a" reports the following, in case it helps:
> HP-UX prisme20 B.11.23 U ia64 1530408444 unlimited-user license
>=20
> Thanks for any hint,
>=20
> Bernard.
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Re: python 2.3 + cx_oracle on HP-UX Itanium

[<bd...@ad...>]

I had no (serious ;-) trouble building python 2.3.5
using gcc 3.4.3. Cx_oracle 4.1 compiles alright, but
then I get the following at link stage:

$ ld -b build/temp.hp-ux-B.11.23-ia64-2.3/cx_Oracle.o
	-L/app/oracle/product/10.1.0.2/lib -lclntsh
	-o build/lib.hp-ux-B.11.23-ia64-2.3/cx_Oracle.sl -s

ld: Can't find library or mismatched ABI for -lclntsh
Fatal error.
error: command 'ld' failed with exit status 1


Under $ORACLE_HOME, i am seeing both a lib and a lib32
directory. If I substitute lib32 to lib, the above ld
invocation works; but then python fails to load the
resulting shared lib:

[acars@prisme20] cx_Oracle-4.1 $ python
Python 2.3.5 (#8, May 20 2005, 20:55:11)
[GCC 3.4.3] on hp-ux11
Type "help", "copyright", "credits" or "license" for more information.

 >>>>>> import cx_Oracle

Traceback (most recent call last):
   File "<stdin>", line 1, in ?
ImportError: Failed to load
/usr/local/lib/python2.3/site-packages/cx_Oracle.sl

 >>>>>>

I am puzzled; could it be that gcc by default generates 32-bit
code on Itanium? I wouldn't mind actually, but then why won't
the module built against the 32-bit oracle libraries load?

Any suggestion welcome,

Cheers,

Bernard.

Re: [cx-oracle-users] Re: python 2.3 + cx_oracle on HP-UX Itanium

[Anthony T. <ant...@gm...>]

I have no access to a HP-UX Itanium box so I can't try this for
myself. I know that on other platforms you can specify -m64 to
indicate you want a 64-bit build when there is an option. You could
try that, I suppose. Does the import give you no other errors? Usually
there is a system error message that is displayed. You can also try
the "type <filename>" command to determine whether the types of the
files are compatible (on Solaris at least this displays whether or not
the files are 32-bit or 64-bit). You can also try the ldd command to
see if that generates additional errors that might help you track down
the problem. Hope some of these help anyway!

On 5/20/05, Bernard Delm=E9e <bd...@ad...> wrote:
>=20
> I had no (serious ;-) trouble building python 2.3.5
> using gcc 3.4.3. Cx_oracle 4.1 compiles alright, but
> then I get the following at link stage:
>=20
> $ ld -b build/temp.hp-ux-B.11.23-ia64-2.3/cx_Oracle.o
>         -L/app/oracle/product/10.1.0.2/lib -lclntsh
>         -o build/lib.hp-ux-B.11.23-ia64-2.3/cx_Oracle.sl -s
>=20
> ld: Can't find library or mismatched ABI for -lclntsh
> Fatal error.
> error: command 'ld' failed with exit status 1
>=20
>=20
> Under $ORACLE_HOME, i am seeing both a lib and a lib32
> directory. If I substitute lib32 to lib, the above ld
> invocation works; but then python fails to load the
> resulting shared lib:
>=20
> [acars@prisme20] cx_Oracle-4.1 $ python
> Python 2.3.5 (#8, May 20 2005, 20:55:11)
> [GCC 3.4.3] on hp-ux11
> Type "help", "copyright", "credits" or "license" for more information.
>=20
>  >>>>>> import cx_Oracle
>=20
> Traceback (most recent call last):
>    File "<stdin>", line 1, in ?
> ImportError: Failed to load
> /usr/local/lib/python2.3/site-packages/cx_Oracle.sl
>=20
>  >>>>>>
>=20
> I am puzzled; could it be that gcc by default generates 32-bit
> code on Itanium? I wouldn't mind actually, but then why won't
> the module built against the 32-bit oracle libraries load?
>=20
> Any suggestion welcome,
>=20
> Cheers,
>=20
> Bernard.
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Re: python 2.3 + cx_oracle on HP-UX Itanium

[Harri P. <har...@tr...>]

On Tuesday 24 May 2005 20:29, Anthony Tuininga wrote:
> >
> > I am puzzled; could it be that gcc by default generates 32-bit
> > code on Itanium? I wouldn't mind actually, but then why won't
> > the module built against the 32-bit oracle libraries load?
> >

Yes, on HP-UX Itanium gcc defaults to generating 32 bit binaries.  I 
believe on Linux Itanium it is 64 bit.

Some tips:

On HP-UX, the flag for 64 bits is -mlp64

Remember that HP-UX Itanium is ELF, so it behaves like Linux and rest 
of the world in may respects. (unlike HP-UX PA-RISC).

Use ldd to check what is loaded.  Did you build your own python?

-bash-3.00$ file /usr/local/bin/python
/usr/local/bin/python:  ELF-64 executable object file - IA64


Hopefully you'll get this sorted out.

-Harri


This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.