sudo mkdir -p /your/custom/path/oracle-19c/oradata/ sudo chmod -R 777 /your/custom/path/ docker run -d --name oracle19db \ -p 1521:1521 \ -e ORACLE_SID=ORCL \ -e ORACLE_PDB=ORCLDB \ -e ORACLE_PWD=Oracle123 \ -e ORACLE_CHARSET=AL32UTF8 \ -v /your/custom/path/oracle-19c/oradata:/opt/oracle/oradata \ banglamon/oracle193db:19.3.0-ee # Charset Value: WE8MSWIN1252, AL16UTF8 # ALTER SESSION SET NLS_DATE_FORMAT = 'RRRR-MM-DD'; # ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS'; # ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'RRRR-MM-DD HH24:MI:SS'; # ALTER SESSION SET NLS_TIME_TZ_FORMAT = 'HH24:MI:SS TZR'; # ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'RRRR-MM-DD HH24:MI:SS TZR'; # docker exec -it oracle19db bash -c "source /home/oracle/.bashrc; sqlplus /nolog” # connect sys as sysdba; # alter session set "_ORACLE_SCRIPT"=true; # create user sistemas identified by las36horas; # GRANT CONNECT, RESOURCE, DBA TO sistemas; # GRANT UNLIMITED TABLESPACE TO sistemas;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter