Tag : oracle

This is the way how to setup a custom JupyterHub Environment "oracle-minimal", under adaption of the Dockerfile from here https://github.com/jupyter/docker-stacks/blob/master/minimal-notebook/Dockerfile, to use an ORACLE Wallet to connect to an ORACLE DB. Create the following files… Dockerfile (Location: C:oracle_minimal; UNIX (LF); UTF-8): # Copyright (c) Jupyter Development Team. # Distributed under the terms of the Modified ..

Read more

I get this Error everytime i try to connect to the Oracle DB: DPI-1047: Cannot locate a 64-bit Oracle Client library: "Error loading shared library libresolv.so.2 : No such file or directory (needed by /lib/libclntsh.so)". See https://oracle.github.io/node-oracledb/INSTALL.html for help Node-oracledb installation instructions: https://oracle.github.io/node-oracledb/INSTALL.html You must have 64-bit Oracle client libraries in LD_LIBRARY_PATH, or configured with ..

Read more

I have build an Oracle Database 19 docker image (tagged as oracle:19) as described in the oracle official documentation https://github.com/oracle/docker-images/tree/main/OracleDatabase/SingleInstance. then I run it using a docker-compose among other services : oracle-19: image: oracle:19 ports: – "1521:1521" – "5500:5500" environment: ORACLE_SID: MY_SID ORACLE_PWD: [email protected] ORACLE_EDITION: ee ORACLE_PDB: SERVICE_NAME volumes: – .ora19data:/opt/oracle/oradata The database started well, ..

Read more

I have issue with uploading files to my database through an external table: I can create, read, drop directories, tables by anton_gridushko user, but have no idea why I have troubles when I try to load data to created table. I used this tutorial but did everything in an SQL Developer worksheet. Could you give ..

Read more

I installed Oracle 11g xe on my Mac in docker: docker run -h "oraclehost" –name "oracle" -d -p 1521:1521 carloscastillo/rgt-oracle-xe-11g In docker terminal (CLI, not the normal Mac terminal), everything seems fine and I can execute queries: The default interactive shell is now zsh. To update your account to use zsh, please run `chsh -s ..

Read more

I use this image: image: sflyr/sqlplus:latest and this script (gitlab-ci): script: – | /instantclient_11_2/sqlplus login/[email protected]//myserveur.prod:1521/sid.mysid<<EOF @myscript.sql EOF myscript.sql: select ‘é’ from dual; Result: SQL> SQL> ‘? — ?? There is an encoding problem… I try to had this to the script to fix it, but it doesnt work: script: – apt-get update && apt-get install ..

Read more

I follow this video https://www.youtube.com/watch?v=3BAsKnfRHwI&t=205s so i can open sql developer and install docker preview version for M1 mac here is the link where i downloaded https://docs.docker.com/docker-for-mac/apple-m1/ and i tried so many things to connect those two things but i falied for 3 days.. I’m trying to install oracle 11g with docker but i falied ..

Read more