Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Python module cx_Oracle ld installation issue on Solaris11U3 SPARC: fatal: file /oracle/database/lib

3470200May 24 2017 — edited May 31 2017

Trying to install cx_Oracle on Solaris11U3 but getting ld: fatal: file /oracle/database/lib/libclntsh.so: wrong ELF class: ELFCLASS64 error

# python setup.py build

running build

running build_ext

building 'cx_Oracle' extension

cc -DNDEBUG -KPIC -DPIC -I/oracle/database/rdbms/demo -I/oracle/database/rdbms/public -I/usr/include/python2.7 -c cx_Oracle.c -o build/temp.solaris-2.11-sun4v.32bit-2.7-11g/cx_Oracle.o -DBUILD_VERSION=5.2.1

"SessionPool.c", line 202: warning: integer overflow detected: op "<<"

cc -G build/temp.solaris-2.11-sun4v.32bit-2.7-11g/cx_Oracle.o -L/oracle/database/lib -L/usr/lib -lclntsh -lpython2.7 -o build/lib.solaris-2.11-sun4v.32bit-2.7-11g/cx_Oracle.so

ld: fatal: file /oracle/database/lib/libclntsh.so: wrong ELF class: ELFCLASS64

error: command 'cc' failed with exit status 2

Tried all available information on the internet:

Installed gcc

Installed solarisstudio12.4

Installed instantclient-basic-solaris.sparc64-12.2.0.1.0, instantclient-odbc-solaris.sparc64-12.2.0.1.0

Set LD_LIBRARY_PATH to oracle home directory:instantclient_12_2/

Same issue seen while installing DBD:Oracle perl module.
This post has been answered by jmcp-Oracle on May 24 2017
Jump to Answer

Comments

Billy Verreynne

A session is the logical entity that services a specific db client connection.
A process is the physical entity that executes a session.
With dedicated server, each session has its own physical process for execution. 1:1 relationship. A 100 sessions mean a 100 processes.
With shared server, sessions share a pool of processes, where any idle process can be tasked to execute any shared server session. A 100 processes in the pool can service a 1000 shared sessions. However, if all 100 processes are busy, then 900 sessions need to wait for an idle process in order to to be serviced.

sol-danesh

And What is the method of setting these two parameters in Oracle architectures?

sol-danesh

Thank you dear Billy Verreynne.
As a result, it can be said that dedicated architecture is better for projects with a large number of users?

Billy Verreynne

Basic parameters for shared server are DISPATCHERS and SHARED_SERVERS.
Shared Server is ideal for supporting a large number of OLTP type users, servicing 1000s of user requests that are of short duration to service. Note that UGA memory is stored in the SGA.
Dedicated Server is ideal for supporting OLAP type users, servicing 100s of user requests that are of long duration to service. Note that UGA memory is stored in the PGA.
The Oracle database can use both architectures at the same time.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 22 2017
Added on May 24 2017
#python
6 comments
1,789 views