DBMS

[DBMS/Oracle] Oracle, Oracle Client, SQL Developer 설치

elog 2023. 3. 12. 18:00

[DBMS/Oracle] Oracle, SQL Developer 설치
[DBMS/Oracle] Oracle, SQL Developer 설치

1. Oracle Database 설치

 

Database Software Downloads | Oracle

Oracle Database Express Edition Previous Database Release Software Oracle Database 10.2, 11.x, 12.x, and 18c are available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition. To request access to t

www.oracle.com

 

- SYSTEM 계정 비밀번호 설정

[DBMS/Oracle] Oracle Databae 11g SYSTEM
[DBMS/Oracle] Oracle Databae 11g SYSTEM

 

2. Oracle Client 설치

[DBMS/Oracle] Oracle Client setup.exe
[DBMS/Oracle] Oracle Client setup.exe

관리자 권한으로 실행

[DBMS/Oracle] Oracle Client setup.exe
[DBMS/Oracle] Oracle Client setup.exe

 

3. SQL Developer 설치

 

Oracle SQL Developer Downloads

This archive. will work on a 32 or 64 bit Windows OS. The bit level of the JDK you install will determine if it runs as a 32 or 64 bit application. This download does not include the required Oracle Java JDK. You will need to install it if it's not already

www.oracle.com

C:\Program Files\Java\jdk1.8.0_202

[DBMS/Oracle] Java JDK 경로 설정
[DBMS/Oracle] Java JDK 경로 설정

 

3. SQL developer System 계정 접속하기

1) 명령 프롬프트(cmd)에서 system 계정 확인하기

sqlplus

-- 계정명
system

-- 설치 시 설정한 비밀번호
java

[DBMS/Oracle] cmd - sqlplus
[DBMS/Oracle] cmd - sqlplus

2) System 계정 접속

새접속

>> 접속이름 : system

>> 사용자 이름 : SYSTEM

>> 비밀번호 : Oracle Database 설치시 설정한 비밀번호

[DBMS/Oracle] system 접속
[DBMS/Oracle] system 접속
[DBMS/Oracle] system 접속
[DBMS/Oracle] system 접속