Saturday 24 February 2024

A Guide to Installing Oracle HR Schema on an Existing Docker Container

 Hi Reader,

Today I want to share my learning on how to install Oracle HR schema on a existing docker container.


Step 1: Download the verified schema from GitHub.
            Hyperlink: GitHub Link
                            Oracle Docs

Step 2: Unzip the file and copy the files to the docker container.

            the copy command for docker is docker cp srcPath                                            <containerId>:targetPath

docker cp db-sample-schemas-23.2 b1c7120d77b5:/home/oracle/


Step 3: enter the docker container using docker exec -it <containerId> bash 
            and check & navigate to the path.


Step 4: login to sql using sqlplus / as sysdba

Step 5: set container to your pluggable database using  
            alter session set container = custompdb;


Step 6: Install HR schema using @hr_install.sql









No comments:

Post a Comment

A Guide to Installing Oracle HR Schema on an Existing Docker Container

  Hi Reader, Today I want to share my learning on how to install Oracle HR schema on a existing docker container. Step 1: Download the verif...