Aario's blog about life and technology

Archive for June, 2011

Eclipse SQl Explorer, Oracle 11g and Kubuntu 11.04

Hi Guys,
This is my long story about how I managed to connect my Kubuntu 11.04 to Oracle SQL to work with those tables in Oracle Database Server in our office. For accessing tables in the database and working with SQL queries, first I searched appdb.winehq.org to see whether TOAD is working on wine or not (As you may know, TOAD is a Tool for Oracle Advanced Database and Wine is a compatibility layer which enables Linux users run Windows applications). But I figured out that TOAD is not fully compatible with wine because all the scores there was gold or silver. Not platinium.
Then I decided to run Tora. An open-source alternative to TOAD. Tora for Kubuntu 11.04 won’t support Oracle. It’s only for mysql (And God knows how many hours I spend to try all ways of getting it to work with oracle but no success!).
Then I headed for SQL Explorer. But it needs several dependencies to run. As it needs oracle to connect to SQL databases, I downloaded these three packages:

  • oracle-instantclient11.2-basiclite-11.2.0.1.0-1.i386.rpm
  • oracle-instantclient11.2-devel-11.2.0.1.0-1.i386.rpm
  • oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.i386.rpm

For links, I searched the first name in google, and it took me to Oracle Client download page. In the opened page I searched names and I found links to download them. But downloading them was another story!
Oracle site asked me for accepting the term mentioned above of the download links page to be able to click on links themselves! Then it requested me a user name and password. Scince I do not have it, I tried to create one. It lead me to a form with several fields from my first name and last name to what my coligoues use to call me during launch in office! 😀 Unfurtunately some of combo lists in that form wasn’t compatible with linux. I mean in Firefox and Chromium I wan’t able to open them to select from. Thus I aksed the good guys in http://www.bugmenot.com to provide me a user name and password to download from http://www.oracle.com. Their first password worked just like a charm! 😀
After I went back to the oracle site I mentioned above and downloaded those three packages, I put them all in one folder (You say oracleclient), opened a terminal window and went to the folder and typed:

sudo su
apt-get install alien
alien -i oracle-instantclient11.2-*.rpm

It took a while for it to install them all. Then I ran:

apt-get install sun-java6-jre

Remember that the default-jre package which install open-source jre has problems with combo-boxes in SQLExplorer windows and that the program crashed several times with it for me. I prefered to install the sun proprietary version.
I downloaded SQL Explorer v3.6.1 from here. Then I extracted the downloaded the .tgz file to /opt/SQLExplorer. The folder which I created myself (You need to know how to create and extract into a system folder with root permissions).
The I just clicked and ran the sqlexplorer file in the extraction folder. And it started working.


For cunnecting to the database I clicked on Create new connection profil button on top left corner of work-space and it opened a new window.

In opened window I entered a name for the new connection. The combo-box there didn’t contain the work Oracle in it’s list. So to add the Oracle as a driver for this multi-purpose SQL software, I clicked on Add/Edit Drivers button. It opened a new window.
In the new window, on left column, I double clicked SQL Explorer and then JDBC Drivers under in. It opened a long list on right. For the first time, the work Oracle Thin Driver was with a x sign beffore it. So it was disabled. The only enabled option was JDBC ODBC Bridge. So I selected the Oracle Thin Driver and clicked on Edit button. It opened a new window.
In the new window, I went to Extra Class Path tab. Clicked on Add Jars and from the opened dialoge I searched the path “/usr/lib/oracle/11.2/client/lib” for “ojdbc6.jar” file and opened it. Then clicked on List Drivers and after many seconds it filled the Drvier Class Name edit box automatically with “oracle.jdbc.OracleDriver” (Actually I don’t think you can enter this text by hand. You must find the driver files installed by the rpm packages I told you about and then it will automatically fill that box for you). Then I clicked on Ok. On the window opened in background the Item Oracle Thin Driver was now with a tick before it just like in screen shot. So I selected it and clicked Ok. Back in the first window, I selected the Oracle Thin Driver from the Driver combo-box and it filled the URL edit box automatically with:

jdbc:oracle:thin:@<server>:1521:<database_name>

I entered IP address of our Oracle Database server in office as <server>. I held the port to 1521. I entered the TNS Name for <database_name>. Selected Auto Login and Entered my user name and password. And Finally I clicked Ok.
In the Connections List on left column I could see my created connection. So I Opened it and after a while it connected to the database. Hiewwwwwwwwwwh!;)
That wasn’t as easy as this. Actually I tried several ways to get it work for many hours! here I’m just told you the final solution.

Have a nice day and don’t hesitate to tell me about your opinions and questions in comments:)

Advertisements

Problems contributing to the Linux

I’m an Electronic engineer. I did several embedded projects with hardware and software interworking. So, I am somehow experienced in programming. I also had several projects in Windows in Delphi language. As I became familiar with Linux, it was always one of my wishes to contribute in this huge project. I even wrote some open source projects myself. Which are stored in Sourceforge.net site (autoppp, blackwar and jalaliapplet).
Actually I have some problems contributing to already started projects. To describe you my problems, I bring here Blur effect in KDE as an example and If you know answers of my questions, please do not hesitate to leave me a comment how to solve my problems.
Recently I installed Kubuntu 11.04 with KDE 4.6 on my laptop. Blur effect is enabled on Panel as is working there without any problem. But the problem is that transparent windows are not blurred. The scenario is always like this:

  • I searched Internet forums to find a solution for this problem. No joy.
  • I searched bug reports to find a solution for this problem. No joy.
  • I now want to go to KDE website to find out how can I contribute to this project because I want to solve this problem myself. Regardless of long texts about how to pay donations or introducing KDE to friends(!), It’s a little hard to find how to start developing the code.

I want to know:

  1. Which source codes I must download to solve my problem with blue effect as I described above. How can I find which source file or which group of source files I must work on?
  2. Which packages I need to download and Install to be able to compile the sources I downloaded?
  3. After compiling the source code how can I installed the compiled code on my system?
  4. How can I uninstall it to bring my system back to the previously installed KED?
  5. What is SVN?

Thanks a lot people:)


How to install ATI Catalyst Driver 11.6 on Ubuntu Linux 11.04 Natty Narwal

Finally I installed ati catalyst 11.6 on my Ubuntu 11.04. I just want to tell you how to install this thingy. Because it’s very tricky!
First of all, spend several days to download it! Because every time I tried the link seemed to be broken and suddenly it worked and I was able to download it with my firefox browser.

They I copied it into my root home folder /root.After that, I used commands below to install it:

sudo su
cd ~
apt-get install debhelper devscripts execstack dh-modaliases
chmod +x ./ati-driver-installer-11-6-x86.x86_64.run
./ati-driver-installer-11-6-x86.x86_64.run
…………………………………………………….
Do you agree with the license? [Y/n] Y
Please enter the installation path [/] (Just hit enter here)
Option: ‘RedHat Packages’ ? [Y/n] n
Option: ‘SuSE Packages’ ? [N/y] N
Option: ‘Build package for detected OS: Ubuntu/natty’ ? [N/y] y

dpkg -i *.deb

That was all. Remember that I spend several minutes running the installer, answering questions, seeing it’s error message, reading it’s log file, understanding that some command is not found, finding related package, installing it using apt-get, and running the installer again and again! What can I say to AMD developers? :-w


Evite ETV-7131 TV & Video Capture Card on 10.04

I recently bought an Evite ETV-7131 TV & Video Capture card based on Philips 7130 Chipset. The card wasn’t working on Windows 7 with it’s provided Windows Vista driver. I mean the quality was too bad (I needed to fine tune a lot of brightness and contrast controls in the provided software with the driver to see the picture) and it used to crash and thus restart the whole system every 5 to 10 minutes!
On Linux (Ubuntu 10.04) it detected but the dmesg output, the saa7134 module told me that it can’t detect the card number automatically and suggested me to select a card number from a list it contained in its output.
I ran:

sudo su

rmmod saa7134_alsa
rmmod saa7134
modprobe saa7134 card=17
modprobe saa7134_alsa card=17

It’s a little hard to me to describe you how I selected the number 17 but anyway, for making those two last commands permanently, run:

nano /etc/modprobe.d/alsa-base.conf

Find the line “options saa7134-alsa index=-2” and if you sure that it isn’t exist, add one, then change it to:

options saa7134-alsa card=17 index=-2

Also add the line below before previous line:

options saa7134 card=17

Close file using Ctrl+O then Enter, then Ctrl+X and install tvtime using:

aptget install tvtime

I then restarted my system completely. Ran tvtime, right-clicked on the black screen of tvtime and from Input Cofiguration menu selected “Change Video Source” to Television to see the Video Input! (I don’t know why but Television works as Video Input and Video works as the Television!). Also disabled Audo-detect signal or something somewhere in menus! This will force tvtime to show input signal whatever it is.
Powered on my satellite receiver (You say any kind of video player device) and it was all there!