Hi all,

I would like to thank for those who had contributed their opinion,ideas, advice and support in order to make cx_Oracle runs alive on my machine.

At last, it works! And now my bos starts to smile again ... ;-p

Thank you all ... (including Anthonu Tuininga -- the developer of cx_Oracle !)

Regards,

Linuxnewbie888

so can you kindly share the solution with all of us?

Hi all,

sesiapa yg interested nak tau camner I settle this problem, please kindly email me at [email protected] and i'll give the full instruction/installation guide..

thanks..

:-)

Post je kat sini.

i see, when you got a problem, u share with us, when u have solve it, just keep it quite..

that's good..

Please share with us. If you are very kind person

If you share.. more knowledge you can get.

Okey ...

Edited November 26, 200718 yr by hairulfadly

Congratulation! Please share it. You will lost nothing by sharing it with other.

senyap terus thread starter.. mane boleh camtu..

Orang lain nak tau gak camner. Kalo camni, bukan kongsi maklumat.

Alamak bro, jgn la marah..

Sorry for the late reply, I was in holidays for few days ago... Almaklumla hati dah heppi..

I got few things to do , however, it such a great release when i've done with this cx_oracle. The thing is , I was faced with lot of difficulties in term of incompatibilities because my machine is 64-bit and there is lot of missing dependencies. Not sure why, maybe during the installation of linux.

So thanks for your responds, dun worry as I have nothing to hide and it is such an honour to share with you guys, And hopefully we can fully utilize this cx_Oracle.

First of all, let me make it clear , my os is Linux Enterprise Edition 5 (RHEL)X86_64 (64-bit) on my remote server and currently the database is Oracle 9i. I'm doing a test for new architecture of the new inhouse software, so we are about to migrate to 10g in future. So, I choose 10g R2 client to be installed on my box.

Ok, to fully utilize cx oracle , I advice you all to d/load this fully oracle client instead of instant client b'coz cx oracle is looking for oracle home and other shared libraries.

How to install oracle client ? I believe many of you who had performed oracle installation can do this installation. But for those who are new to oracle and linux (just like me :-p) let me give a brief on this topic -: (*macam lecturer lak ... kuikuikui)

Oracle 10g (R2) client installation

* you can d/load this oracle client release from www.oracle.com – you also can d/load the documentation for installation guide from the same site

-1- Software requirements

List of packages you will need for install Oracle 10g on RHEL include

binutils

compat-db

compat-libstdc++

control-center

gcc

gcc-c++

glibc

glibc-common

gnome-libs

libstdc++

libstdc++-devel

make

pdksh (RHEL 5 ships with ksh instead)

sysstat

xscreensaver

setarch

libXp (to start runInstaller)

or

rpm -qa --qf '%{name}-%{version}-%{release}.%{arch}\n'|egrep 'compat|glibc|gcc'|sort

Required packages(version must be these or higher).**Install required .rpm packages

-2- Setting System parameters

Edit the /etc/sysctl.conf and add following lines:

kernel.sem = 250 32000 100 128

kernel.shmmax = 2147483648

kernel.shmmni = 128

kernel.shmall = 2097152

kernel.msgmnb = 65536

kernel.msgmni = 2878

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

Note: You need execute "sysctl -p" or reboot system to apply above settings.

Edit the /etc/security/limits.conf file and add following lines:

* - nproc 16384

* - nofile 16384

-3- Preinstalation tasks

-i- Create oracle User Account

Login as root and create te user oracle which belongs to dba group.

su -

# groupadd dba

# groupadd oinstall

# useradd -g oinstall -G dba oracle

-ii- Set Oracle Enviroment

Edit the /home/oracle/.bash_profile file and add following lines:

ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE

ORACLE_HOME=${ORACLE_BASE}/product/Ora102;export ORACLE_HOME

TMPDIR=/u01/tmp;export TMPDIR

-iii- Create base directory for Oracle

Create Oracle base,Oracle home and tmp directory:

As root :

mkdir u01

chown oracle:dba u01

as oracle:

mkdir u01/app/oracle/product/102

mkdir u01/tmp

For oracle 10g installation on RHL5, you should change the redhat release name. Go to /etc/redhat-release file and change it to Red hat Enterprise 4 (something that refers to RHEL4 instead of RHEL 5)

-iv- If all required packages were installed successfully then login as root and switch the GCC 3.4 compiler binary with GCC 3.2 compiler binary as following:

su -

# cd /usr/bin

# mv ./gcc ./gcc34

# mv ./gcc32 ./gcc

extract the files using following command

# gunzip 10201_client_linux_x86_64.cpio.gz

#cpio -idmv <10201_client_linux32.zipcpio

4. Start the Oracle software installation process.

Now the system is prepared for Oracle software installation. To start the installation process execute the following commands (as oracle):

cd client

./runInstaller

• make sure the client directory is located under oracle_base/tmp directory

• before runs the runInstaller file, need to be change to oracle account and start the hummingbird and export DISPLAY=<localhostname>:0.0

5.Post-Instalation Tasks

-i- When the installation is done, switch back the GCC binaries

su -

# cd /usr/bin

# mv ./gcc ./gcc32

# mv ./gcc34 ./gcc

-ii- Change permissions of /u01/app/oracle/oraInventory to 770.

Cx_Oracle Installation

Now we can start the cx_oracle installation. Please get the installer from www.sourceforge.com . Choose the one that suites your application. As mine I choose cx_Oracle-4.3.3.tar.gz (platform independent).

1. untar the cx_oracle :

# tar xvfz cx_Oracle-4.3.3.tar.gz

2. #cd cx_Oracle-4.3.3

3. #python setup.py build

4. #python setup.py install

ITâ€S DONE…………………………… :-)

Jom nyanyi same2 -->> BERKOJO la KITO SEKUETNYO....

kui..kui..kui..

Sorry bro ada ralat skit :

-2- Setting System parameters

Edit the /etc/sysctl.conf and add following lines:

kernel.sem = 250 32000 100 128

kernel.shmmax = 2147483648

kernel.shmmni = 128

kernel.shmall = 2097152

kernel.msgmnb = 65536

kernel.msgmni = 2878

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

Note: You need execute "sysctl -p" or reboot system to apply above settings.

** if the value is higher, dont change

extract the files using following command

# gunzip 10201_client_linux_x86_64.cpio.gz

#cpio -idmv <10201_client_linux32.zipcpio -- silap nih , sepatutnye

extract the files using following command

# gunzip 10201_client_linux_x86_64.cpio.gz

#cpio -idmv <10201_client_linux_x86_64.cpio

errr.... ermmm... haaa

errr.... ermmm... haaa

ape yg haaa 2??

phm ke x??

hehehe

tp aku pn xphm coz aku pn br bk berjinak2 ngan open source ni..

good thread for users reference.. saya set as "sticky"

Camtu ke? Kalo installation ni saya biasa buat guna Oracle DB 10gR2. Siap buat guna RAC, pastu storage guna ASM. Data semua letak dalam SAN. Dah lama tak masuk sini. Hehehe..