DB15 with DOCKER/PODMAN podman run -d --name 23ai -p :1521 -e ORACLE_PWD=oracle container-registry.oracle.com/database/free:latest#echo "oracle" | podman secret create oracle_pwd -#podman exec 23ai ./setPassword.sh oraclepodman start 23ai포트 설정필요podman exec -it 23ai sqlplus sys/oracle@FREE as sysdbapodman exec -it 23ai sqlplus / as sysdba SQL>startup podman ps -apodman rm 23aipodman stop 23ai ------docker-----# Add .. 2024. 6. 19. 23c oraclelinux8 sudo -s dnf install -y oraclelinux-developer-release-el8 dnf config-manager --set-enabled ol8_developer dnf -y install oracle-database-preinstall-23c dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm sudo -s /etc/init.d/oracle-free-23c configure export ORACLE_SID=FREE export ORAENV_ASK=NO . /opt/oracle/product/23c/dbhomeFree/bin/oraenv ORACLE_HOME = /opt/oracle/product/23c/dbhome.. 2023. 4. 30. oracle21c 설치 및 계정 주의: 사용자계정: 대문자로 생성sqlplus sys as sysdbaALTER SESSION SET "_ORACLE_SCRIPT" = TRUE;CREATE USER ADMIN IDENTIFIED BY ADMIN;GRANT CONNECT, RESOURCE to ADMIN;테이블스페이스는 developer에서 sys 계정으로 만들고새로 생성한 계정에 디폴트 스페이스를 변경. --만들고나서 dba권한 (cdb,pdb)>grant dba to ##### container=all; 설치후 모니터링:https://localhost:5500/em(연결에서 사용자이름system, 비번입력하고 ,컨테이너는 디폴트로 빈칸) 2023. 4. 17. 이전 1 2 3 다음