{"id":841,"date":"2017-06-27T11:28:03","date_gmt":"2017-06-27T09:28:03","guid":{"rendered":"http:\/\/eiseler.de\/wordpress\/?p=841"},"modified":"2018-03-23T02:21:40","modified_gmt":"2018-03-23T01:21:40","slug":"how-to-use-docker-for-sqlplus-on-an-oracle-database","status":"publish","type":"post","link":"https:\/\/eiseler.de\/wordpress\/?p=841","title":{"rendered":"How to use Docker for sqlplus on an Oracle Database"},"content":{"rendered":"<p>You need a docker installation and a user\/password at store.docker.com.<\/p>\n<p>If you got this you can establish a sqlplus session with this docker command:<\/p>\n<p><code><br \/>\ndocker run -ti --rm store\/oracle\/database-instantclient:12.2.0.1 sqlplus \"user\/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=your.host.site)(Port=yourport))(CONNECT_DATA=(SID=yoursid)))\"<br \/>\n<\/code><\/p>\n<p>Keywords: docker, oracle, sqlplus, easy<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-841\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=841&amp;share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\"><span>Facebook<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-841\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=841&amp;share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-841\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=841&amp;share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-pocket\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-pocket sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=841&amp;share=pocket\" target=\"_blank\" title=\"Click to share on Pocket\"><span>Pocket<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>You need a docker installation and a user\/password at store.docker.com. If you got this you can establish a sqlplus session with this docker command: docker run -ti &#8211;rm store\/oracle\/database-instantclient:12.2.0.1 sqlplus &#8220;user\/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=your.host.site)(Port=yourport))(CONNECT_DATA=(SID=yoursid)))&#8221; Keywords: docker, oracle, sqlplus, easy<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-841\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=841&amp;share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\"><span>Facebook<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-841\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=841&amp;share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-841\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=841&amp;share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-pocket\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-pocket sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=841&amp;share=pocket\" target=\"_blank\" title=\"Click to share on Pocket\"><span>Pocket<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[44],"tags":[],"class_list":["post-841","post","type-post","status-publish","format-standard","hentry","category-docker"],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8zAuQ-dz","jetpack-related-posts":[{"id":844,"url":"https:\/\/eiseler.de\/wordpress\/?p=844","url_meta":{"origin":841,"position":0},"title":"A Dockerfile for Oracle and perl","date":"27\/06\/2017","format":false,"excerpt":"I didn'f find a dockerfile for oracle and perl. So I did one by myself. Quick Instructions: Create dir; Create Dockerfile (above); create oracle_test.pl (above), download the oracle files. Build it: docker build -t perl-oracle . Run it: docker run -it --rm perl-oracle I took http:\/\/www.ecliptik.com\/Containerizing-a-Perl-Script\/ as the base and\u2026","rel":"","context":"In &quot;Docker&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1333,"url":"https:\/\/eiseler.de\/wordpress\/?p=1333","url_meta":{"origin":841,"position":1},"title":"ioBroker with docker, docker-compose, Homematic, grafana some hints","date":"02\/11\/2020","format":false,"excerpt":"some hints which helped me: docker-compose.yml, some ports version: '2' services: iobroker: restart: always image: buanet\/iobroker:latest container_name: iobroker hostname: iobroker ports: - \"8081:8081\" - \"1880:1880\" #node-red - \"1883:1883\" #mqtt - \"2001:2001\" #homematic - \"2010:2010\" #homematic - \"8082:8082\" #iobroker admin - \"8282:8282\" #flot - \"8088:8088\" #terminal - \"8284:8284\" #socketIO - \"33980:33980\"\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"https:\/\/i1.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2020\/11\/image.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1011,"url":"https:\/\/eiseler.de\/wordpress\/?p=1011","url_meta":{"origin":841,"position":2},"title":"Docker: VM won't start, driver reinstalled","date":"18\/07\/2018","format":false,"excerpt":"Had the problem, that the VM didn't start. (After reinstalling). NtCreateFile(\\Device\\VBoxDrvStub) failed: 0xc0000034 STATUS_OBJECT_NAME_NOT_FOUND Solved by reinstalling C:\\Program Files\\Oracle\\VirtualBox\\drivers\\vboxdrv\\VBoxDrv.inf (right click, install). And reboot afterwards. \u00a0 \u00a0","rel":"","context":"In &quot;Docker&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1378,"url":"https:\/\/eiseler.de\/wordpress\/?p=1378","url_meta":{"origin":841,"position":3},"title":"RTL 433 links","date":"12\/04\/2021","format":false,"excerpt":"wie man mit einem DVB-T USB Empf\u00e4nger Flugzeuge, Autoreifendruck und Temperatursensoren (433 MHz und 868 MHz) lesen kann. Vorerst als Linksammlung: als docker: https:\/\/github.com\/hertzg\/rtl_433_docker https:\/\/triq.org\/rtl_433\/#building-installation https:\/\/osmocom.org\/projects\/rtl-sdr\/wiki\/Rtl-sdr https:\/\/github.com\/merbanan\/rtl_433 http:\/\/blog.wenzlaff.de\/?p=9492 http:\/\/blog.wenzlaff.de\/?p=8845 http:\/\/blog.wenzlaff.de\/?p=4005","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":528,"url":"https:\/\/eiseler.de\/wordpress\/?p=528","url_meta":{"origin":841,"position":4},"title":"Interesting Password App","date":"06\/10\/2014","format":false,"excerpt":"A new concept for passwords. No need to save passwords. Passwords will be generated using site name and a masterpassword. http:\/\/masterpasswordapp.com\/","rel":"","context":"In &quot;Test Review&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":954,"url":"https:\/\/eiseler.de\/wordpress\/?p=954","url_meta":{"origin":841,"position":5},"title":"Raspberry Pi as NAS with OpenMediaVault and Wifi","date":"28\/03\/2018","format":false,"excerpt":"Be warned, the Raspberry Pi with wlan is a slow nas. But I wanted to build one and there are no full instructions for it. So here are the steps to follow. I used this instruction, but some things are missing and so I put everything down in short form:\u2026","rel":"","context":"In &quot;Gadgets&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2018\/04\/img_5026.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=841"}],"version-history":[{"count":3,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/841\/revisions"}],"predecessor-version":[{"id":950,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/841\/revisions\/950"}],"wp:attachment":[{"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}