Database (Oracle)

맥에서 Oracle19c 구동하기 (도커, sql developer)

Jenny Noh 2024. 3. 7. 13:56

1. docker hub에서 rollernaut oracle19c pull

https://hub.docker.com/r/rollernaut/oracle19c

 

Docker

 

hub.docker.com

 

2. 컨테이너 생성

docker run -d --name oracle19 -p 1521:1521 rollernaut/oracle19c

 

3. 초기설정

docker exec -it oracle19 bash

 

bash:

sys as sysdba
sqlplus

 

Enter user-name:

sys as sysdba

 

Enter password: (미입력 & 엔터)

 

SQL>

show user
alter user system identified by oracle;

 

 

4. oracle19c 컨테이너 구동


sql developer에서 hr계정으로 connect

 

 

Springboot에서 db 연결시: