SQL Plus not runnning on Windows Containers

Bhavya Pandey 96 Reputation points
2021-09-08T06:57:50.29+00:00

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}.
    130048-windows-sqplpus.png.
  • For SQLPLUS 12 130080-windows-sqplpus12.png
    • Systeminfo for the windows docker container.

130112-windows-container-systeminfo.png

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.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
1,156 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
9,476 questions
0 comments No comments
{count} votes

2 additional answers

Sort by: Most helpful
  1. Olaf Helper 28,936 Reputation points
    2021-09-08T07:11:31.18+00:00

    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/

    0 comments No comments

  2. Limitless Technology 37,751 Reputation points
    2021-09-08T15:38:04.797+00:00

    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.