SQL Plus not runnning on Windows Containers

Question

I'm trying to run sqlplus on the following windows docker images :
mcr.microsoft.com/windows/servercore:ltsc2019
mcr.microsoft.com/windows:20H2

Tried to install it using the following files to complete the installation :

instantclient-basiclite-windows.x64-19.12.0.0.0dbru.zip
instantclient-sqlplus-windows.x64-19.12.0.0.0dbru.zip

Tired same for version 12 as well. [Main objective is to get sqlplus 12 working.]

Unzipped the file and added the path in environment variable.

While the same installation works fine on the windows system and the sqlplus command works. But in the container nothing is displayed on the console. It identifies the sqlplus commands but does nothing. The process is not getting started.
Attaching screenshots for the same. [on mcr.microsoft.com/windows/servercore:ltsc2019]

• For SQLPLUS 19
  Here the PATH is added for the installation. But SQLPLUS command returns nothing. Same output with :
  sqlplus -v or sqlplus {logincred}.
  .
• For SQLPLUS 12
  • Systeminfo for the windows docker container.

Same issue is seen with msi installer method.
Compared all dll files with the ones on the system. msvcr100.dll was missing on the container that was added, but it didn't seem to help.

Can't seem to debug the issue as there are no logs getting generated, no process is created for sqlplus.exe.

Answer 1

Closing this. Required to install Microsoft Visual C++ 2010 x64 Redistributable in the image to make it work.

Answer 2

SQLPlus (or SQL+) is a tool from/for Oracle database; this is a forum for Microsoft products
So wrong forum => https://community.oracle.com/hub/

Answer 3

Hello @Bhavya Pandey

Do you have any hardening in your Docker image also please check event logs by using PowerShell cmd

Get-Eventlog -newest 20 application  

Also , check C:\Windows\Temp and C:\WinNT\Temp folder for any logs related to SQLPlus.

If the reply was helpful, please don’t forget to upvote or accept as answer.