newlibra

어찌어찌...연결까지..oracle linux 9document 대로 따라해봄... tns까지 잘되네요. (oracle 계정) 리스너체크# systemctl start oracle-free-23ai$ cd $ORACLE_HOME/bin$ lsnrctl status $ sqlplus / as sysdbaSQL> SHUTDOWN IMMEDIATE SQL> STARTUPSQL> ALTER PLUGGABLE DATABASE ALL OPEN;

--listener.oraLISTENER = (ADDRESS_LIST=  (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))  (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))SID_LIST_LISTENER= (SID_LIST=  (SID_DESC=         (SID_NAME=ORCL)         (ORACLE_HOME=C:\app\homes\OraDB21Home1)  ) ) --tnsnames.oraORCL =(DESCRIPTION =    (ADDRESS_LIST =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    )(CONNECT_DATA =    (SERVER ..

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 ..

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..

주의: 사용자계정: 대문자로 생성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, 비번입력하고 ,컨테이너는 디폴트로 빈칸)