Sign inSign up

ejadagb/ejada-database

By ejadagb

•Updated over 6 years ago

Developed By Mhalawa

Image
0

238

ejadagb/ejada-database repository overview

⁠Make Directory

      mkdir /home/ejada/docker/oradata

⁠To run container use this command

 docker run --name db \
-p 1521:1521 -p 5500:5500 \
-e ORACLE_SID=ORCLCDB \
-e ORACLE_PDB=ORCLPDB1 \
-e ORACLE_PWD=Passw0rd \
-e ORACLE_CHARACTERSET=AL32UTF8 \
-v /home/ejada/docker/oradata:/opt/oracle/oradata \
ejadagb/ejada-database:12.1.0.2-ee

⁠To Export Dump

 docker exec -ti db sqlplus system/Passw0rd@ORCLCDB

!mkdir -p /opt/oracle/oradata/backup

create directory bdir as '/opt/oracle/oradata/backup';

exit

docker exec db expdp system/Passw0rd@ORCLCDB dumpfile=hr.dmp directory=bdir logfile=hr.log schemas=hr

# dmp will be in /home/ejada/docker/oradata/backup

⁠To Import Dump

   # add dmp in /home/ejada/docker/oradata/backup and create user hr

  docker exec db impdp system/Passw0rd@ORCLCDB dumpfile=hr.dmp directory=bdir logfile=hr.log schemas=hr

Tag summary

Content type

Image

Digest

Size

2.3 GB

Last updated

over 6 years ago

docker pull ejadagb/ejada-database:12.1.0.2-ee