{"id":825,"date":"2022-11-25T18:53:49","date_gmt":"2022-11-25T18:53:49","guid":{"rendered":"http:\/\/wp.chaoyu.nl\/?p=825"},"modified":"2023-07-25T00:20:15","modified_gmt":"2023-07-24T22:20:15","slug":"docker-learning-notes","status":"publish","type":"post","link":"https:\/\/chaoyu.nl\/?p=825","title":{"rendered":"Docker learning notes: By Dockerise Oracle Database + APEX instance"},"content":{"rendered":"\n

How to fix docker: Got permission denied while trying to connect to the Docker daemon socket. Read more here<\/a>.<\/p>\n\n\n\n

# To create the docker group and add your user:\nsudo groupadd docker\n# Add your user to the docker group\nsudo usermod -aG docker ${USER}\n#after, you most likely needs a reboot<\/code><\/pre>\n\n\n\n
Images<\/strong><\/h2>\n\n\n\n
# to list all images\ndocker images\n# to romve an image\ndocker image rm ${image id}\n# to build an image with at current direct (the . at the end )\ndocker build -t ${tagname} . <\/code><\/pre>\n\n\n\n
Volumes<\/h2>\n\n\n\n
# to create \ndocker volume create MY_VOLUME\n# to remove \ndocker volume rm MY_VOLUME\n# to list \ndocker volume ls\n# to inspect\ndocker volume inspect MY_VOLUME\n<\/code><\/pre>\n\n\n\n
Container<\/h2>\n\n\n\n
#list all container \ndocker ps -a\n#start bash from an running container \ndocker exec -it ${container id} \/bin\/bash\n#stop a container \ndocker stop ${container id}\n\n#start a container and run bash by adding bash at the end of the command\ndocker run -it -p 1521:1521 --name c01 with_data_pump:1.0.0 bash<\/code><\/pre>\n\n\n\n
Tab into a running container’s cli<\/h2>\n\n\n\n
docker attach ${container id}\ndocker exec -it ${container id} \/bin\/bash<\/code><\/pre>\n\n\n\n
Leave container Bash session without killing the container<\/strong><\/h2>\n\n\n\n
Ctrl<\/code> + P<\/code> then Ctrl<\/code> + Q<\/code> <\/p>\n\n\n\n
#its called escape sequence<\/code><\/pre>\n\n\n\n
Start a status ‘exited’ container and tab into the bash<\/h2>\n\n\n\n
docker start ${container id}\ndocker attach  ${container id}<\/code><\/pre>\n\n\n\n
start a container with port mapping<\/h2>\n\n\n\n
# start a container detached and map host port 80 to container port 8080, give the container a custom name with image id \ndocker run -d -p 80:8080 --name ${container_name} ${image_id}<\/code><\/pre>\n\n\n\n
Create a new image with a running container where configuration are made <\/h2>\n\n\n\n
# list all containers\ndocker ps -a\n# find the one you are in and do a commit on its name or id , here i use the container name !!! the commit process can take a bit depends on the size of your container \ndocker commit practical_montalcini\n# or docker commit ${container_id} ${tag}:${version}\ndocker commit 857338c4ccf4 operation_image:3.0.0\n\n# after commit , find your newly created image and give it name \ndocker images # to show all images\n# tag to change the name \ndocker tag 3e70341ac6d9 oracle18_apex22_2_ords22\n# add tags to image\ndocker image tag oracle18_apex22_2_ords22:latest oracle18_apex22_2_ords22:1.0\n# remove latest tag\ndocker image remove oracle18_apex22_2_ords22:latest<\/code><\/pre>\n\n\n\n
Create Oracle APEX Docker <\/h1>\n\n\n\n
– Dockerfile to take the oraclelinux7 <\/p>\n\n\n\n
– Copy files into linux or use wget in oracle linux 7 <\/p>\n\n\n\n
– apex , ords, xe18 , java11, xe preinstall<\/p>\n\n\n\n
– install XE pre install<\/p>\n\n\n\n
– write export ORACLE_DOCKER_INSTALL=true<\/em><\/strong><\/code><\/p>\n\n\n\n
– install XE<\/p>\n\n\n\n
– Follow this official guide <\/a><\/p>\n\n\n\n
– Remeber to run the following comands on user oralce, read more here <\/a><\/p>\n\n\n\n
su - oracle \nexport ORACLE_SID=XE \nexport ORAENV_ASK=NO \n. \/opt\/oracle\/product\/18c\/dbhomeXE\/bin\/oraenv<\/code><\/pre>\n\n\n\n
For 21xe, do a \/etc\/init.d\/oracle-xe-21c start  <\/code> , this will trigger generate listener.ora and display its location. for 21xe , it is at \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/listener.ora<\/code><\/p>\n\n\n\n
update with nano \/opt\/oracle\/product\/18c\/dbhomeXE\/network\/admin\/listener.ora<\/code><\/em><\/strong><\/p>\n\n\n\n
# listener.ora Network Configuration File: \/opt\/oracle\/product\/18c\/dbhomeXE\/network\/admin\/listener.ora\n# Generated by Oracle configuration tools.\n\nDEFAULT_SERVICE_LISTENER = XE\n\nLISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )<\/code><\/pre>\n\n\n\n
update \/opt\/oracle\/product\/18c\/dbhomeXE\/network\/admin\/tnsnames.ora. Here <\/a>are some explainations. Addtionally, here are two line of sql need to be remember <\/p>\n\n\n\n
HOST = 0.0.0.0 # as well <\/code><\/pre>\n\n\n\n
SQL> alter session set container=XEPDB1; # to switch pdb;\nSQL> show con_name  # to check current pdb;<\/code><\/pre>\n\n\n\n
Database wallet for Make Rest Calls <\/p>\n\n\n\n