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 qui_qoeq888@yahoo.com 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 ...

Kiriman ini telah diubahsuai oleh hairulfadly: Nov 26 2007, 04:03 PM

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

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"