Use the same credentials as for the container registry login page in Figure 2-3. If the login succeeds, then copy the docker pull command from the Pull Command for Latest section in the lower right of Figure 2-4. The command is shown here for version 19: docker pull container-registry.oracle.com/database/enterprise:19.3.0.0 Figure 2-4. Oracle container registry page […]
Posts
Getting Started with Docker – Installation of a Containerized Oracle Database Instance and SQL Developer
Getting Started with Docker The very first step is to install Docker on your local machine. It’s relatively straightforward to download and install Docker if it isn’t installed already. To install Docker Desktop on Windows, click the Docker Desktop for Windows button. Once the download is complete, remember to do your usual checks: “Verifying Downloaded […]
Configuring Your Oracle Database – Installation of a Containerized Oracle Database Instance and SQL Developer
Configuring Your Oracle Database In order to get the containerized Oracle Database instance to work with SQL Developer, you now need to make a few changes to the configuration. Run the following (rather complicated-looking) command to modify your database. As usual, please ensure that you supply the container ID that matches your own setup: docker exec –it <container_id> bash \–c “source […]
Updating the User Password 2 – Installation of a Containerized Oracle Database Instance and SQL Developer
The next step is to extract the zipped file and follow the installation steps on the website. Let’s now finally configure SQL Developer to use our Docker-containerized Oracle Database. Launch the newly installed SQL Developer application and click the plus sign at the top left of the main window shown in Figure 2-5. Figure 2-5. […]
Updating the User Password – Installation of a Containerized Oracle Database Instance and SQL Developer
Updating the User Password There may come a point in the future where you will need to change your Oracle Database password. For example, if you don’t use the Docker image for a long time, the user password may expire. If this happens, then it’s simple enough to update the password using a very similar […]
Recap of the Basic Docker Workflow – Installation of a Containerized Oracle Database Instance and SQL Developer
Recap of the Basic Docker Workflow Let’s assume you’ve just switched your machine on and you want to do some work with your containerized Oracle Database instance and SQL Developer. The following is the set of steps required along with the necessary commands. Check the running Docker containers and look specifically for the Oracle container […]
Running SQL Developer – Installation of a Containerized Oracle Database Instance and SQL Developer
Running SQL Developer At this point, you can use SQL Developer to interact with the database. If SQL Developer is open, right-click the Oracle connection you created earlier. In the case of Figure 2-9, the connection is called OracleDockerNew. This name is just text, so you can use whatever name you configured for your database. […]
Running Some PL/SQL Code – Installation of a Containerized Oracle Database Instance and SQL Developer
Running Some PL/SQL Code Let’s now review one of the earlier PL/SQL examples, as shown in Example 2-8. Example 2-8. Cursor use in PL/SQL DECLARECURSOR c1 isSELECT ename,empno,salFROMemp ORDER BY sal DESC;— start with highest paid employeemy_ename VARCHAR2(10);my_empno NUMBER(4);my_sal NUMBER(7,2); BEGINOPEN c1; FOR i IN 1..5 LOOPFETCH c1 INTOmy_ename,my_empno,my_sal;EXIT WHEN c1%NOTFOUND; /* in case the number requested *//* is more than the total *//* number of employees */ INSERTINTOtempVALUES(my_sal,my_empno, my_ename);COMMIT;END LOOP;CLOSE c1;END; To run the code in […]
Three Docker Gotchas – Installation of a Containerized Oracle Database Instance and SQL Developer
Three Docker Gotchas As we’re on the topic of errors, when you’re using Docker commands, make sure not to enter the wrong parameter string. 1. Docker Case-Sensitivity For example, here in Example 2-10, the user incorrectly supplies an uppercase letter in the Container parameter. Example 2-10. Docker is case-sensitive C:\Users\Stephen>docker Container ls -aunknown shorthand flag: […]
An Alternative to the Command-Line Use of Docker – Installation of a Containerized Oracle Database Instance and SQL Developer
An Alternative to the Command-Line Use of Docker The Docker-based setup we’re using has a number of merits. One is that it’s quite quick to get it working and it requires a minimal amount of installed software. I mentioned that there are a range of options to choose from if using Docker from the command […]