SQL Developer - (Installation|Configuration)

Metadata Backup

backup metadata such as connection, report, …

The best way is to search in the documentation of SQL Developer the section “Location of User-Related Information” in the concept chapter. This section gives you a detailed procedure on how to proceed in order to relocate the metadata directory of SQL Developer.

Example for the version 3, you have to set the environment variable IDE_USER_DIR. You can do it by creating a SQLDeveloper.bat file such as this one in the Sql Developer home directory

SET IDE_USER_DIR=C:\dropbox\Config\SqlDeveloper
sqldeveloper.exe

TNS_ADMIN environment variable

Oracle Database - TNS_ADMIN environement variable

JDK Path

The conf file contains the Java Home option:

# SetJavaHome ../../jdk
SetJavaHome C:\Program Files\Java\jdk1.8.0_45\bin

The start configuration file of SQL Developer is :

• Before 4.0: sqldeveloper_home\bin\sqldeveloper.conf
• Since version 4:
  • For Windows: %APPDATA%\sqldeveloper\<version>\product.conf
  • For Linux: $HOME/./sqldeveloper/version/product.conf