우분투에 sqldeveloper 설치하기

sqldeveloper 설치방법

 

1. Oracle.com 사이트에서 sql Developer 다운

 

2. rpm -> deb 파일 변형  

 $ sudo apt-get install alien (이미 alien 설치한 경우 생략)
 $ sudo alien -k --scripts sqldeveloper-4.1.1.19.59-1.noarch.rpm
 $ sudo dpkg -i sqldeveloper_4.1.1.19.59-1_all.deb

3. SQL developer 다운 후 실행

 $  sqldeveloper

---

문제

Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.sqldeveloper/jdk

 

해결방법 

 $  cd /opt/sqldeveloper/sqldeveloper/bin
 $  sudo gedit sqldeveloer.conf

 

설정중 SetJavaHome 을 각자 설치한 jdk 경로를 설정해줘야한다.

 

 SetJavaHome /usr/lib/jvm/java-7-openjdk-amd64

---

문제

Error: Java home /usr/lib/jvm/java-8-openjdk-amd64 is not a JDK,
either jre/bin/java OR lib/tools.jar OR lib/dt.jar is missing.
Running SQL Developer under a JRE is not supported.

If this Java VM is actually a full JDK installation, add  'SetSkipJ2SDKCheck true' to one of the following files.
Otherwise specify a different Java JDK location with a  SetJavaHome directive in one of the following files:
  /home/zuyo/.sqldeveloper/4.2.0/product.conf
  /opt/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf

 

해결 방법

/home/zuyo/.sqldeveloper/4.2.0/product.conf 의 끝에 SetSkipJ2SDKCheck true 을 추가해준다.