QuickStart: The fastest and easiest way to run an Instance of Oracle Database on Mac OS

Run Oracle Database on your Mac.

Connect from your Mac to an Oracle Database container through TCPS (TCP/IP with SSL and TLS / Certificates) connection instead of TCP.

Need an instance of Oracle Database Server running on your Mac for your testing or development purpose?
-> Via Docker and Oracle Database Enterprise Edition Image with few steps in minutes.

Install Docker CE for Mac and log in to Docker Hub.

- Register a Docker ID if you don't have.

- Skip this step if Docker already installed on your Mac and you already logged in Docker Hub.

Pull and run Oracle Database Enterprise Edition Image from Docker Hub.

- Search for "Oracle Database Enterprise Edition" in Docker Hub and Checkout the document for more details.

- Run the command below to starting an Oracle Database Server Instance as a Docker container named "Oracle-DB" and mapping port 1521 from the container to port 1521 on your Docker host (your Mac). This will take you a few minutes to download the image and Starting the container.

docker run -d -it --name Oracle-DB -p 1521:1521/tcp  store/oracle/database-enterprise:12.2.0.1

- After the download is done and the container started, you can check the image already pulled and the container running as below:

- Now you can connect to the Oracle Instance via Oracle SQL Developer Tool with username: "sys as sysdba", password: Oradoc_db1 as below:

- Ok, So now you already have an instance of Oracle Database server in your Mac for testing or development. When you don't want the instance running and saving your Mac performance, you can stop the container or want to start the instance again as below:

- If your project is done and you don't want to use the instance any more, you should stop the container and delete the image as below:

- And remove unused volume:

docker volume prune

Error Notes: When you connect from Oracle SQL Developer Tool to the Oracle Database Server Instance, if you get a message "Status: Failure -Test failed: IO Error: Got minus one from a read call" or "Status: Failure -Test failed: Listener refused the connection with the following error:

ORA-12505, TNS: listener does not currently know of SID given in connect descriptor" -> So please wait in moments, the instance is preparing in the container, you can connect success very soon after that, don't worry :). Good luck and fun.

References:
- https://docs.docker.com
- https://hub.docker.com/_/oracle-database-enterprise-edition?tab=resources

QuickStart: How to connect to Oracle Database through TCPS (TCP/IP with SSL and TLS / Certificates) connection instead of TCP from Mac host to Oracle Database container.

How to Install and use the Linux Ubuntu Bash Shell on Windows 10

Ubuntu-based Bash shell that can run Linux software directly on Windows. Ofcourse, only softwares based on Bash Shel. This isn’t a virtual machine, a container, or Linux software compiled for Windows (like Cygwin).

This is the version of Windows 10 I'm using to install Linux Ubuntu Bash Shell.

Please make sure your Windows 10 is up to date.

Open the Settings app and head to Update & Security > For Developers. Activate the “Developer Mode” switch here to enable Developer Mode.

Next, open the Control Panel, click “Programs,” and click “Turn Windows Features On or Off” under Programs and Features. Enable the “Windows Subsystem for Linux (Beta)” option in the list here and click “OK.”

After you do, you’ll be prompted to reboot your computer. Click “Restart Now” to reboot your computer and Windows 10 will install the new feature.

After your computer restarts, click the Start button (or press the Windows key), type “bash”, and press “Enter.”

You’ll be prompted to accept the terms of service. You’ll be asked to create a user account and password for use in the Bash environment.

Open your Start menu and search for “bash” or “Ubuntu.” You’ll see a “Bash on Ubuntu on Windows” application.

So now you can using your Linux favorite commands and install bash tools on Windows 10 as you familiar on your Linux.

Please refer to get more info about Linux Ubuntu Bash Shell on Windows 10.

Get error: fatal error C1034: "stdio.h: no include path set" when you compile a C/C++ source code file.

1 2 3 4 5 6 7

F:\ "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.10.25017\bin\HostX64\x64\cl.exe" chrAprMax_byAdd.c Microsoft (R) C/C++ Optimizing Compiler Version 19.10.25019 for x64 Copyright (C) Microsoft Corporation. All rights reserved. chrAprMax_byAdd.c chrAprMax_byAdd.c(1): fatal error C1034: stdio.h: no include path set

- Please make sure you run "Developer Command Prompt for VS 20xx" or set Path variable includes "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.10.25017\bin\HostX64\x64\" before that and run cl.exe in the window opened by "Developer Command Prompt for VS 20xx".

or

-> So now you can compile C/C++ source file without error: "fatal error C1034: stdio.h: no include path set" :)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

F:\>cl chrAprMax.c Microsoft (R) C/C++ Optimizing Compiler Version 19.10.25019 for x86 Copyright (C) Microsoft Corporation. All rights reserved. chrAprMax.c Microsoft (R) Incremental Linker Version 14.10.25019.0 Copyright (C) Microsoft Corporation. All rights reserved. /out:chrAprMax.exe chrAprMax.obj F:\>chrAprMax Enter a string: just for fun The character that appears the most frequently is "u" with 2 matched. F:\>cl chrAprMax.cpp -o chrAprMaxpp Microsoft (R) C/C++ Optimizing Compiler Version 19.10.25019 for x86 Copyright (C) Microsoft Corporation. All rights reserved. cl : Command line warning D9035 : option 'o' has been deprecated and will be rem oved in a future release chrAprMax.cpp Microsoft (R) Incremental Linker Version 14.10.25019.0 Copyright (C) Microsoft Corporation. All rights reserved. /out:chrAprMax.exe /out:chrAprMaxpp.exe chrAprMax.obj F:\>chrAprMaxpp Enter a string: just for fun The character that appears the most frequently is "u" with 2 matched.