Wednesday, May 23, 2007

Oracle SQL Developer on Ubuntu

This is for Ubuntu 7.04 (Feisty) desktop and hasn't been throughly tested (i.e. I got connected to our Oracle boxes, queried some data, did a happy dance, then disconnected). This assumes you are installing from a CDROM with the .rpm in a directory called Oracle and all of your SQLNet .ora files in Oracle/network/admin (tnsnames.ora and possibly others):

sudo -s
aptitude install rpm sun-java6-sdk
rpm -i --nodeps /media/cdrom/Oracle/sqldeveloper-1.1.3.27.66-1.noarch.rpm
tr -d '\r' < /media/cdrom/Oracle/network/admin/tnsnames.ora > /etc/tnsnames.ora
tr -d '\r' < /media/cdrom/Oracle/network/admin/sqlnet.ora > /etc/sqlnet.ora

Note that rpm will issue a warning about Application not being a valid desktop category but that can be ignored, SQL Developer will be in Programming on the Gnome desktop menu. The 'tr' is used just in case your tnsnames.ora and sqlnet.ora came from a Windows environment (which will cause SQLPlus and SQL Developer to not recognize entires in them).

No comments: