Start Oracle on macOS (intel) via Docker

create_graph.sql

# source: https://docs.oracle.com/en/database/oracle/property-graph/24.2/spgdg/getting-started-pgql.html
# source: https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/CREATE-TABLE.html

# list databases
# SELECT ora_database_name from dual;

# show table cols
# DESC all_tables;

# create a graph
CREATE PROPERTY GRAPH g1 VERTEX TABLES ( all_tables LABEL tabs PROPERTIES ARE ALL COLUMNS ) ;
  

install-start-oracle.sh

# source: https://ronekins.com/2023/10/24/how-to-to-run-oracle-database-23c-free-on-m1-m2-apple-mac/

# download the image
docker pull container-registry.oracle.com/database/free

# check which version we got
docker image inspect container-registry.oracle.com/database/free | grep INSTALL_FILE_1

# start oracle
docker run -d --name ora \
  -p 1522:1521 \
  --mount source=oradata,target=/opt/oracle/oradata \
  container-registry.oracle.com/database/free  

# show logs
docker logs ora

# set all passwords to "oracle"
docker exec -it ora ./setPassword.sh oracle

# connect as a client 
docker exec -it ora sqlplus / as sysdba