Posts

Showing posts from February, 2010

Oracle 9.0.1.1 exp bug

I tried to run an intranet app from home, with a database connection from my laptop tunneled to Telkom HQ Data Center. Seems that the application tooks too many queries and data volume were bit too much (OK, maybe I should profile the data volume & query counts...), it took me an hour of trial and error so that I realized : it is impossible to run the app without timing out while in tunneled connection. OK, then proceed to think.. If this is were my usual application, what would I do ? I would fire up MySQL Administrator and backup the externally located database in my system, then restore it to my local MySQL database. For oracle database, the tool alternatives were: - use TOAD to move the database (which, I think would be tedious, and also I have no TOAD installed in my system) - use Oracle Datapump, which we cannot use because the database are 9.0.1.1, where such technology haven't exist yet, and also .. I have no experience at this moment on Datapump. - migrate to MySQL,

saprfc installation on centos 5

Image
After hesitating for a while, I struggled to bring saprfc to live on a Centos 5 installation. Ok, first, the people I'm helping already installed rfc sdk in /usr/sap/rfcsdk. I am using RFC SDK extracted from RFC_45-20000055.SAR that I've downloaded from SAP Service Marketplace Support links (http://service.sap.com/). The SAR file is suitable for Linux i386 architecture, you might want to use RFC_45-10003377.SAR for Linux x86_64 architecture. Now i need to compile sap:rfc extension. I used saprfc-1.4.1 downloaded from http://saprfc.sourceforge.net/ . But, no phpize in path, so i must install php-devel first > yum install php-devel but, because the proxy setup is not done (our server lives outside the DMZ), I must edit yum.conf : > vi /etc/yum.conf and add one line : > proxy=http://.... Then I'm ready to try php-devel again. > yum install php-devel OK. now try to compile sap:rfc. R the INSTALL file in a flash, and tries these steps (the part b in the INSTALL file)