oracle-databaseimpdp

dump file oracle 11 docker


I used docker oracle database Oracle Database 11g Express Edition Release 11.2.0.2.0 I tried to import a file dmp, but i have the bellow error

docker-compose.yml

version: '3'

services:

  oracle:
    image: jaspeen/oracle-xe-11g
    container_name: oracle11g
    volumes:
      - ~/docker/data:/u01/app/oracle jaspeen/oracle-xe-11g
    ports:
      - "1529:1521"
      - "8081:8080"
      - "2222:22"

command

docker exec -it oracle11g sqlplus
Enter user-name: SYS as SYSDBA
Enter password: oracle

SQL> CREATE TABLESPACE DEV_SPACE DATAFILE 'dev_space.dat' SIZE 500M AUTOEXTEND ON NEXT 10M;
SQL> DEFINE NEW_USER = 'scoemploi';
SQL> CREATE USER &NEW_USER. IDENTIFIED BY "1234";
SQL> GRANT CONNECT, RESOURCE, CREATE JOB, CREATE VIEW, CREATE ANY CONTEXT TO &NEW_USER;
SQL> ALTER USER &NEW_USER QUOTA UNLIMITED ON USERS;
SQL> ALTER USER &NEW_USER DEFAULT TABLESPACE DEV_SPACE;


SQL> CREATE OR REPLACE DIRECTORY docker_vol AS '/u01/app/oracle';
SQL> GRANT READ, WRITE ON DIRECTORY docker_vol TO scoemploi;

sudo docker exec -it oracle11g impdp scoemploi/1234 DUMPFILE=docker_vol:scoemploi2020.DMP FULL=Y


ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/u01/app/oracle/scoemploi2020.DMP" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Solution

  • you need to have scoemploi2020.DMP inside your docker

    docker cp /hostpath/scoemploi2020.DMP demo1:/u01/app/oracle

    docker exec -it demo1 chmod +rxw /u01/app/oracle/scoemploi2020.DMP