Showing posts with label Debian. Show all posts
Showing posts with label Debian. Show all posts

Wednesday, August 27, 2014

Debian (wheezy) Eclipse error: GLib-GObject-WARNING libgdk-x11-2.0.so

Do you have a problem to run Eclipse or STS (Spring Tool Suite) on Debian Wheezy? Is your error message when you start Eclipse, like this:


user@comp:~$ eclipse/eclipse
GLib-GObject-WARNING **: crashing aplications
...
Problematic frame: C [libgdk-x11-2.0.so.0+0x5173f]
...


The problem is that glibc library is older than Eclipse needs. The default version of the library is glibc-2.13-1 and Eclipse need version glibc-2.14 or higher, but these versions glibc libraries are missing in Debian stable repository.
My solution is to add the official unstable/testing repository to APT, and then install the newer version glibc library.

Add the official unstable/testing repository in the "/etc/apt/sources.list":

deb http://http.us.debian.org/debian/ testing non-free contrib main
deb http://http.us.debian.org/debian/ unstable non-free contrib main
deb http://http.us.debian.org/debian/ wheezy non-free contrib main

Search for a newer version glibc Library in the repository:


user@comp:~$ sudo aptitude search glibc
...
v   glibc-2.13-1
v   glibc-2.19-1  
...


Install a newer version glibc library:


user@comp:~$ sudo aptitude install glibc-2.19-1


You can now successfully run Eclipse.

Wednesday, March 6, 2013

Oracle XE on Debian

This is short introduction how to install and use Oracle XE database on Debian. Oracle web page offer only two version of XE database for download (for Windows x32 and Linux x64), but on "Oracle Open Source Software" is available i386 version of Debian package: https://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/

Installation:


After download package, we can start install package:
  • $ sudo dpkg -i oracle-xe-universal_10.2.0.1-1.1_i386.deb
Next we execute "after installation" configuration. We can keep parameters that are as default in configuration process, except "user password" and maybe number of port for web manager (8080 replace by for example 8180):
  • $ sudo /etc/init.d/oracle-xe configure

Default username is: 
  • system

Oracle web manager:

Oracle web manager is running on "localhost" address:


Oracle SQL Developer:

Quote: "Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database." This tool is available on Oracle home page, but if you want to download, you must register (horror). Another solution is to find this package on "One-click hosting" (for example: sqldeveloper-3.2.20.09.87-no-jre.zip).

After download and unpack, we must change file mode:
  • $ chmod 755 /sqldeveloper/sqldeveloper.sh 

And then we can run tool. For first start we must setting path to JVM (in my case: JAVA_HOME=/usr/lib/jvm/java-6-sun):
  • $ /sqldeveloper/sqldeveloper.sh


SQLplus:

Oracle command-line interface "sqlplus" is good hiding. The file path is following in my installation:
  • /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/runsqlplus.sh


SQL commands:

And finally, several examples of SQL commands (sqlplus):

login:
  • SQL> connect  system/oracle
view all users:
  • SQL> select * from all_users;
view all tables:
  • SQL> select * from dict;
execute an SQL script from file:
  • SQL > @/oracle/scripts/script.sql