question

BhavyaPandey-1012 avatar image
0 Votes"
BhavyaPandey-1012 asked BhavyaPandey-1012 answered

SQL Plus not runnning on Windows Containers

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.



windows-serverdotnet-ad
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BhavyaPandey-1012 avatar image
0 Votes"
BhavyaPandey-1012 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered BhavyaPandey-1012 commented

Hello @BhavyaPandey-1012

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

No Hardening on the container. Can't find any logs in TEMP.
Attaching outputs

130644-image.png

no process id for sqlplus

130654-image.png


0 Votes 0 ·
image.png (254.5 KiB)
image.png (165.3 KiB)