Installation Procedure for SQLDeveloper

Oracle's SQL Developer installation instructions are provided for:

• Linux Mint 12 (Lisa),
• Linux Mint 13 (Maya),
• Linux Mint 14 (Nadia)

Installation Instructions for  Linux Mint 14: (KDE)

1. Install the Install Maker
   • sudo apt-get install sqldeveloper-package
2. Fix Error: chmod: missing operand after `755'. Apply the sql-developer Magic Patch
   • kdesudo kate /usr/bin/make-sqldeveloper-package
   1. Edit Line 381 with comment # Set Executable bit
   2. Find and Replace in file /usr/bin/make-sqldeveloper
   • ${FIND} "${OPTDIR}" ! \( -type d -o -name "*.jar" \) |${XARGS} ${XARGS_OPTS} ${FILE} ${FILE_OPTS} |${GREP} ${GREP_OPTS} "shell script" | ${GREP} ${GREP_OPTS} "text executable" |${CUT} ${CUT_OPTS_FUNC_CLEAN} |${XARGS} ${XARGS_OPTS} ${CHMOD} ${CHMOD_OPTS}
   1. The diff file can be found at https://launchpadlibrarian.net/102939658/sqldeveloper-magic.diff
3. Create an account, download sql developer package in zip format (at the bottom)
   • http://www.oracle.com/technology/software/products/sql/index.html
   • //The filename in my case was sqldeveloper-3.2.20.09.87-no-jre.zip
4. Install and configure tofrodos
   • sudo apt-get install tofrodos
   • sudo ln -s /usr/bin/fromdos /usr/bin/dos2unix
   • sudo ln -s /usr/bin/todos /usr/bin/unix2dos
5. Install some Installation Tools
   • sudo apt-get install debhelper
6. Convert the ZIp into a deb package
   • mkdir ~/Downloads/bin
   • make-sqldeveloper-package -b ~/Downloads/bin ~/Downloads/sqldeveloper-3.2.20.09.87-no-jre.zip
7. Install the newly created package and java-6
   • sudo dpkg -i /home/`whoami`/Downloads/sqldeveloper_3.2.20.09.87+0.2.3-1_all.deb
   • sudo apt-get install openjdk-6-jdk openjdk-6-jre
8. Run sqldeveloper. In Terminal Type
   • sqldeveloper
   1. Enter the following as path when prompted.
      • /usr/lib/jvm/java-6-openjdk-i386
   2. Alternativly, one could run the command...
      • echo "/usr/lib/jvm/java-6-openjdk-i386" > ~/.sqldeveloper/jdk

Installation Instructions for Linux Mint 13:

1. Install the Install Maker
   • sudo apt-get install sqldeveloper-package
2. Fix Error: chmod: missing operand after `755'. Apply the sql-developer Magic Patch
   • gksudo gedit /usr/bin/make-sqldeveloper
   1. Edit Line 381 with comment # Set Executable bit
   2. Find and Replace in file /usr/bin/make-sqldeveloper
   • ${FIND} "${OPTDIR}" ! \( -type d -o -name "*.jar" \) |${XARGS} ${XARGS_OPTS} ${FILE} ${FILE_OPTS} |${GREP} ${GREP_OPTS} "shell script" | ${GREP} ${GREP_OPTS} "text executable" |${CUT} ${CUT_OPTS_FUNC_CLEAN} |${XARGS} ${XARGS_OPTS} ${CHMOD} ${CHMOD_OPTS}
   1. The diff file can be found at https://launchpadlibrarian.net/102939658/sqldeveloper-magic.diff
3. Create an account, download sql developer package in zip format (at the bottom)
   • http://www.oracle.com/technology/software/products/sql/index.html
   • //The filename in my case was sqldeveloper-3.1.07.42-no-jre.zip
4. Install and configure tofrodos
   • sudo apt-get install tofrodos
   • sudo ln -s /usr/bin/fromdos /usr/bin/dos2unix
   • sudo ln -s /usr/bin/todos /usr/bin/unix2dos
5. Install some Installation Tools
   • sudo apt-get install debhelper
6. Convert the ZIp into a deb package
   • mkdir ~/Downloads/bin
   • make-sqldeveloper-package -b ~/Downloads/bin ~/Downloads/sqldeveloper-3.1.07.42-no-jre.zip
7. Install the newly created package
   • sudo dpkg -i /home/username/Downloads/sqldeveloper_3.1.07.42+0.2.3-1_all.deb
8. Run sqldeveloper. In Terminal Type
   • sqldeveloper
   1. Enter the following as path when prompted.
      • /usr/lib/jvm/default-java
   2. Alternativly, one could run the command...
      • echo "/usr/lib/jvm/default-java" > ~/.sqldeveloper/jdk

Installation Instructions for Linux Mint 12:

1. Install the compiler package for sql developer
   • sudo apt-get install sqldeveloper-package
   • sudo apt-get install sun-java6-jsk sun-java6-jre
2. Create an account, download sql developer package in zip format (at the bottom)
   • http://www.oracle.com/technology/software/products/sql/index.html
   • //The filename in my case was sqldeveloper-3.1.07.42-no-jre.zip
3. Install and configure tofrodos
   • sudo apt-get install tofrodos
   • sudo ln -s /usr/bin/fromdos /usr/bin/dos2unix
   • sudo ln -s /usr/bin/todos /usr/bin/unix2dos
4. Install some Installation Tools
   • sudo apt-get install debhelper
5. Convert the ZIp into a deb package
   • make-sqldeveloper-package -b BUILDLOCATION LOCATION_OF_ZIP_FILE
6. Install the newly created package
   • sudo dpkg -i BUILDLOCATION/FILENAME
   1. //in my case this was: sudo dpkg -i /home/username/bin/sqldeveloper_3.1.07.42+0.2.3-1_all.deb
7. Run sqldeveloper. In Terminal Type
   • sqldeveloper
   1. Enter the following as path when prompted.
      • /usr/lib/jvm/java-6-sun
   2. Alternativly, one could run the command...
      • echo "/usr/lib/jvm/java-6-sun" > ~/.sqldeveloper/jdk