![[DBMS/Oracle] Oracle, SQL Developer 설치](https://blog.kakaocdn.net/dna/cHSnGP/btr3ccrmlCq/AAAAAAAAAAAAAAAAAAAAAPVsrr6MX2WIM-B-csCVRkT3Swx7b_OwIhIDYldkhJl4/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&expires=1764514799&allow_ip=&allow_referer=&signature=BZywvWwJ1tfqOmvIN7SQ39l5tcM%3D)
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](https://blog.kakaocdn.net/dna/chLqQZ/btr3dD2QAQN/AAAAAAAAAAAAAAAAAAAAAEhKj8yy4U6Fvc2Ae7gZZ593wKUTbuln7F1bi7T0E8lo/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&expires=1764514799&allow_ip=&allow_referer=&signature=PxUoYHJ%2FWH336qS8Rf6ToQr1bU4%3D)
2. Oracle Client 설치
![[DBMS/Oracle] Oracle Client setup.exe](https://blog.kakaocdn.net/dna/G8J2D/btr3ftSUb9t/AAAAAAAAAAAAAAAAAAAAAJib2F_7Vtpam8qGfXegnESie8WEn00TM_dtYZWQx4CA/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&expires=1764514799&allow_ip=&allow_referer=&signature=8ZKVVx%2FEz0lGsyP3xi6kz76OaQM%3D)
관리자 권한으로 실행
![[DBMS/Oracle] Oracle Client setup.exe](https://blog.kakaocdn.net/dna/6o7Zi/btr3psyRs2G/AAAAAAAAAAAAAAAAAAAAAMeCGsVmvjcp9Z5rOWtqUzYARq8d9hdrxwYdm-jpeqxu/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&expires=1764514799&allow_ip=&allow_referer=&signature=4ubszrLXtJRURers%2F0KdYaplHfg%3D)
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 경로 설정](https://blog.kakaocdn.net/dna/kQnZE/btr3gNwSnCk/AAAAAAAAAAAAAAAAAAAAAP69cUulGem7YJRaZGVEUuEGSG0s-o6_H9tc-vPoM18P/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&expires=1764514799&allow_ip=&allow_referer=&signature=26w31HCqZiYsoybHGNBdL2txrJM%3D)
3. SQL developer System 계정 접속하기
1) 명령 프롬프트(cmd)에서 system 계정 확인하기
sqlplus
-- 계정명
system
-- 설치 시 설정한 비밀번호
java![[DBMS/Oracle] cmd - sqlplus](https://blog.kakaocdn.net/dna/dMrYid/btr3gPIbBzX/AAAAAAAAAAAAAAAAAAAAAJNd_tzDM9Bf7KREBrfRYxD7cwmf0nnH7VbtlL5djAEm/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&expires=1764514799&allow_ip=&allow_referer=&signature=Pzf8HhFpoU2QfLwoXnpP7%2FOGzjs%3D)
2) System 계정 접속
새접속
>> 접속이름 : system
>> 사용자 이름 : SYSTEM
>> 비밀번호 : Oracle Database 설치시 설정한 비밀번호
![[DBMS/Oracle] system 접속](https://blog.kakaocdn.net/dna/bSEN2e/btr3cdDL3DX/AAAAAAAAAAAAAAAAAAAAAAoW9JGn_TQ24RricGOg6B9zBDR2fZxI7lTMryAP3x4H/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&expires=1764514799&allow_ip=&allow_referer=&signature=wAwsiIjJ0P%2FaOh06VD1%2FlHLtTPg%3D)
![[DBMS/Oracle] system 접속](https://blog.kakaocdn.net/dna/boOcwM/btr3lEsMtoQ/AAAAAAAAAAAAAAAAAAAAAPHBNYf3R_VEIBCCxkQAsOR-2XuPdJIk9v1IpUnH0ya4/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&expires=1764514799&allow_ip=&allow_referer=&signature=ij%2BZYjBMaN3Lp6oAl31Mdpquq4I%3D)
'DBMS' 카테고리의 다른 글
| [DBMS/Oracle] 데이터 검색 명령(SELECT) (0) | 2023.03.14 |
|---|---|
| [DBMS/Oracle] 데이터 타입 (0) | 2023.03.14 |
| [DBMS/Oracle] 데이터 삽입 (0) | 2023.03.14 |
| [DBMS/Oracle] 테이블 생성 및 삭제 (0) | 2023.03.14 |
| [DBMS/Oracle] 데이터베이스 계정 및 권한 설정 (0) | 2023.03.11 |