[macOS] mac m1에 oracle 설치하기 오류들과 결론

정리는 맨 아래 있습니다

 

---

시도한 것들 ..

1. 초심으로 돌아가자 느낌으로 docker 삭제 진행 (밑 블로그 참고)

https://velog.io/@chayezo/Mac%EC%97%90%EC%84%9C-Docker-%EC%82%AD%EC%A0%9C%ED%95%98%EA%B8%B0

Mac에서 Docker 삭제하기

 

2. 근데 docker가 완벽하게 삭제가 된 것 같지 않아서 

find ./Library -name "*docker*" 2> /dev/null

로 docker 관련 파일을 하나하나 다 수동으로 삭제 ..

 => appcleaner 라는 프로그램이 어플 삭제할 때 좋다고 함

 

3. colima 부터 혹시 몰라서 reinstall..

brew reinstall colima

 

4.  docker brew로 설치하려고 했는데 뭔가 자꾸 안 돼서 ㅋㅋㅋㅋㅋ ㅜ 그냥 사이트에서 docker.dmg 받아서 설치..

 

5. docker container 생성

1) oracle 18c 이미지인 vitorfec/oracle-xe-18c로 컨테이너 생성

docker run --restart unless-stopped --name oracle -e ORACLE_PASSWORD=pass -p 1521:1521 vitorfec/oracle-xe-18c

하지만  자꾸 DATABASE SETUP WAS NOT SUCCESSFUL 이라고 떠서 .. 한 번 더 해봐도 여전히 동일한 오류 메세지가 뜸

로그 확인 명령어

docker logs -f 컨테이너 이름

2) oracle 19c 이미지인 doctorkirk/oracle-19c로 컨테이너 생성

☁  ~  docker run --restart unless-stopped --name oracle-19c -p 1521:1521 -e ORACLE_PASSWORD=pass -e TZ=Asia/Seoul -d doctorkirk/oracle-19c

컨테이너 생성 완료 => f3480cd2d647ab94d6a80b00748d2bf95dcff9fd5be6cdb51df78ff5c64fea00

진짜 한참 있다가 로그파일 열어보니까 DATABASE is ready to use!가 뜨는 것을 확인함

log 파일 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                02-JUN-2023 15:07:24
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/f3480cd2d647/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
The listener supports no services
The command completed successfully
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 2 15:24:20 2023
Version 19.9.1.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.1.0.0

SQL> 
System altered.

SQL> 
System altered.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.1.0.0
The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:
AQPC started with pid=43, OS id=1845 
2023-06-02T15:24:18.715032+09:00
Starting background process CJQ0
Completed: ALTER DATABASE OPEN

 

그래서 sqlplus로 로그인 시도를 해보았지만 여전히 막히는 상태

☁  ~  docker exec -it --user=oracle oracle-19c sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 5 12:01:19 2023
Version 19.9.1.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Enter user-name: system
Enter password: 
ERROR:
ORA-12162: TNS:net service name is incorrectly specified

sysdba 권한으로 접속하면 원래 바로 접속이 되어야 하는데 net service name is incorrect 에러가 뜨면서 바로 접속이 안됨

☁  ~  docker exec -it -u oracle oracle-19c sqlplus / as sysdba 

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 5 12:26:51 2023
Version 19.9.1.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:

검색을 해보니 bash profile 파일을 고쳐야 하나 봤는데.. 이건 아마 리눅스 해결법인 것 같았다

☁  ~  docker exec -it oracle-19c /bin/bash
[oracle@f3480cd2d647 ~]$ ls 
core  hs_err_pid29.log  setPassword.sh
[oracle@f3480cd2d647 ~]$ ls -al
total 137680
drwx------ 1 oracle oinstall      4096 Jun  2 15:07 .
drwxr-xr-x 1 root   root          4096 Mar 25  2021 ..
-rw-r--r-- 1 oracle oinstall        18 Jun 14  2019 .bash_logout
-rw-r--r-- 1 oracle oinstall       193 Jun 14  2019 .bash_profile
-rw-r--r-- 1 oracle oinstall       231 Jun 14  2019 .bashrc
-rw-r--r-- 1 oracle oinstall       172 Apr  1  2020 .kshrc
-rw------- 1 oracle oinstall      1024 Jun  2 15:07 .rnd
-rw------- 1 oracle oinstall 320499712 Jun  2 15:07 core
-rw-r----- 1 oracle oinstall     66934 Jun  2 14:56 hs_err_pid29.log
lrwxrwxrwx 1 root   root            26 Mar 25  2021 setPassword.sh -> /opt/oracle/setPassword.sh
[oracle@f3480cd2d647 ~]$ sudo cat .bash_profile 
bash: sudo: command not found
[oracle@f3480cd2d647 ~]$ cat .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

 

3) oracle 18c 이미지인 vitorfec/oracle-xe-18c로 컨테이너 다시 생성

진짜 마지막 생각으로 18c로 다시 만들자 하고 colima docker 모두 다 재시작을 하고 생성해 보았다.

colima restart

colima 재시작을 해주고

docker context ls
docker context use colima

docker context를 colima를 쓰도록 설정해 준다.

오류를 반복하다 보니까 난 colima를 재시작할 때마다 desktop context를 쓰던데, (그래서 매번 colima를 쓰도록 바꿔줘야 한다) 아마 첫 번째 container 때는 이 부분을 제대로 확인하지 않은 것 같다.

☁  oradata  docker run --restart unless-stopped --name oracle-18 -e ORACLE_PASSWORD=pass -p 1521:1521 -e TZ=Asia/Seoul vitorfec/oracle-xe-18c
docker: Error response from daemon: Conflict. The container name "/oracle-18" is already in use by container "cd0e6bee0135d1254c7cf8a6c16f87468fcccb7dda0ef539b378b1fd8adb2cf4". You have to remove (or rename) that container to be able to reuse that name.
See 'docker run --help'.
☁  oradata  docker ps -al
CONTAINER ID   IMAGE                    COMMAND                   CREATED              STATUS    PORTS     NAMES
cd0e6bee0135   vitorfec/oracle-xe-18c   "/bin/sh -c 'exec $O…"   About a minute ago   Created             oracle-18
☁  oradata  docker ps
CONTAINER ID   IMAGE     COMMAND   CREATED   STATUS    PORTS     NAMES
☁  oradata  docker start oracle-18                                                                                                           
oracle-18
☁  oradata  docker logs -f oracle-18
ORACLE PASSWORD FOR SYS AND SYSTEM: d4217805da8e9e44
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database XE.
Enter SYS user password: 
****
Enter SYSTEM user password: 
*****
Enter PDBADMIN User Password: 
****
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
31% complete
34% complete
38% complete
41% complete
43% complete
Completing Database Creation
47% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/XE.
Database Information:
Global Database Name:XE
System Identifier(SID):XE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.

Connect to Oracle Database using one of the connect strings:
     Pluggable database: cd0e6bee0135/XEPDB1
     Multitenant container database: cd0e6bee0135
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE
The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:
Pluggable database XEPDB1 opened read write
Completed: alter pluggable database XEPDB1 open
2023-06-05T14:17:43.279696+09:00
XEPDB1(3):CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  '/opt/oracle/oradata/XE/XEPDB1/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL  SEGMENT SPACE MANAGEMENT  AUTO
XEPDB1(3):Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  '/opt/oracle/oradata/XE/XEPDB1/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL  SEGMENT SPACE MANAGEMENT  AUTO
XEPDB1(3):ALTER DATABASE DEFAULT TABLESPACE "USERS"
XEPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
2023-06-05T14:17:52.812946+09:00
ALTER PLUGGABLE DATABASE XEPDB1 SAVE STATE
Completed: ALTER PLUGGABLE DATABASE XEPDB1 SAVE STATE
2023-06-05T14:26:17.207530+09:00
XEPDB1(3):Resize operation completed for file# 10, old size 368640K, new size 389120K

(oradata는 그냥 폴더)

근데 아까랑 다르게 갑자기 DATABASE IS READY TO USE! 가 떠버렸다 !!

 

6. sqlplus 시도하기 전에 먼저 sql developer에서 접속이 되는지 테스트

sql developer 에 system / pass / oracle_sid = xe로 접속을 했더니 접속이 됐다 !!

 

7. 터미널에서도 접속이 되는지 시도

1) sys 권한으로 들어가기 시도

☁  ~  docker exec -it -u oracle oracle-18 sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Jun 5 22:16:11 2023
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL> show user
USER is "SYS"
SQL>

바로 접속 완료

2) 그냥 일반 권한으로 들어가기 시도

☁  ~  docker exec -it -u oracle oracle-18 sqlplus

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Jun 5 22:38:59 2023
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Enter user-name: system
Enter password: 
Last Successful login time: Mon Jun 05 2023 20:53:15 +09:00

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL>

며칠 동안 그렇게 안되던 로그인이 된다 대박 ...

---

 

정리하자면..

Mac M1 Oracle 설치 (2023 06 06 기준)

1. colima 설치 (Homebrew가 설치되어 있어야 함)

brew install colima

2. docker 설치

https://www.docker.com/products/docker-desktop/

Download Docker Desktop | Docker

여기서 Apple Chip으로 다운로드 (.dmg 파일)

3. colima 실행

colima start --memory 4 --arch x86_64

4. docker context 변경

docker context ls
//목록이 쭉 뜨고 현재 사용중인 context는 앞에 *이 붙어있음
//colima가 사용중이 아니라면
docker context use colima

5. docker container 생성

docker run --restart unless-stopped --name oracle-18 -e ORACLE_PASSWORD=pass -p 1521:1521 -e TZ=Asia/Seoul vitorfec/oracle-xe-18c

6. log 파일 열어두고 좀 오래 기다려야 함. 데이터 베이스 셋업이 완료될 때까지 시간이 좀 소요됨

docker logs -f 컨테이너 이름

7.  아래의 메세지가 log파일에 보이면 sql developer 에서 접속 시도

#########################
DATABASE IS READY TO USE!
#########################

sql developer에서 사용자 이름=system, 비밀번호는 컨테이너 생성할 때 만든 비밀번호, 포트 1521, SID는 xe(기본값)

테스트해서 성공 뜨면 접속

8. 터미널에서도 sqlplus로 접속하기

☁  ~  docker exec -it -u oracle oracle-18 sqlplus

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Jun 5 22:38:59 2023
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Enter user-name: system
Enter password: 
Last Successful login time: Mon Jun 05 2023 20:53:15 +09:00

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL>

9. 클래식 모드로 전환 (이거 안 하면 user 생성할 때 이름 앞에 계속 뭐 붙여야 함)

//sql문
alter session set "_ORACLE_SCRIPT"=true;

10. 필요한 유저 생성해서 sql developer 접속

//sql문
//유저 생성
create user 유저이름 identified by "비밀번호";

//유저에게 권한 부여
grant resource, connect, dba to 유저이름;