Thursday, April 28, 2022

DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)

I’ve been having some trouble getting DBCA to run in order to create databases.

Thought I’d share it with you, and thus document it for later 😉

 

The error I get is:

 

[FATAL] [DBT-50000] Unable to check available system memory.

   CAUSE: An exception occured while checking kernel parameter.

*ADDITIONAL INFORMATION:*

Exception details

- PRVG-1901 : failed to setup CVU remote execution framework directory "C:\Users\TheUserName\AppData\Local\Temp\CVU_19.0.0.0.0_TheUserName\" on nodes "TheServerName" Please select a different work area for the framework PRVH-0516 : failed to retrieve CVU remote execution framework version from node "TheServerName" during an attempt to setup remote execution framework directory "C:\Users\TheUserName\AppData\Local\Temp\CVU_19.0.0.0.0_TheUserName\" TheServerName : PRKN-1014 : Failed to execute remote command "C:\Users\TheUserName\AppData\Local\Temp\CVU_19.0.0.0.0_TheUserName\\exectask.exe" on node "TheServerName".Cannot run program "C:\Users\TheUserName\AppData\Local\Temp\CVU_19.0.0.0.0_TheUserName\\exectask.exe": CreateProcess error=2, The system cannot find the file specified TheServerName : Cannot run program "C:\Users\TheUserName\AppData\Local\Temp\CVU_19.0.0.0.0_TheUserName\\exectask.exe": CreateProcess error=2, The system cannot find the file specified

 

I couldn’t find an exact match in Oracle support, but I found my way to this Oracle support document citing a known defect when attempting to create a new db for RAC on Win 64, part of bug 29686671, which was supposed to be resolved in Oracle 19.4.  

This isn’t exactly that bug, but the work-around works for this as well. ¯\_(ツ)_/¯

 

NOTE: This seems to be a java problem, since simply adding -ignoreprereqs on dbca command line didn’t resolve it.

Issue was fixed by changing the part of dbca.bat that actually runs the java to ignore configuration parameters by adding this (-Doracle.assistants.dbca.validate.ConfigurationParams=false) to dbca.bat

 

I changed DBCA.bat

FROM

[…]

 

if [%CUSTOM_JRE%]==[] (

    "%ORACLE_HOME%\jdk\jre\BIN\JAVA" -DORACLE_HOME="%OH%" -DCV_HOME="%OH%" -Doracle.installer.not_bootstrap=true -DJDBC_PROTOCOL=thin -mx512m  -XX:-OmitStackTraceInFastThrow -XX:CompileCommand=quiet -XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot oracle.assistants.dbca.driver.DBConfigurator  %*

) else (

    "%CUSTOM_JRE%\BIN\JAVA" -DORACLE_HOME="%OH%" -DCV_HOME="%OH%" -Doracle.installer.not_bootstrap=true -DJDBC_PROTOCOL=thin -mx512m -XX:-OmitStackTraceInFastThrow -XX:CompileCommand=quiet -XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot oracle.assistants.dbca.driver.DBConfigurator  %*

)

 

 

TO

[…]

 

if [%CUSTOM_JRE%]==[] (

    "%ORACLE_HOME%\jdk\jre\BIN\JAVA" -Doracle.assistants.dbca.validate.ConfigurationParams=false -DORACLE_HOME="%OH%" -DCV_HOME="%OH%" -Doracle.installer.not_bootstrap=true -DJDBC_PROTOCOL=thin -mx512m  -XX:-OmitStackTraceInFastThrow -XX:CompileCommand=quiet -XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot oracle.assistants.dbca.driver.DBConfigurator  %*

) else (

    "%CUSTOM_JRE%\BIN\JAVA" -DORACLE_HOME="%OH%" -DCV_HOME="%OH%" -Doracle.installer.not_bootstrap=true -DJDBC_PROTOCOL=thin -mx512m -XX:-OmitStackTraceInFastThrow -XX:CompileCommand=quiet -XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot oracle.assistants.dbca.driver.DBConfigurator  %*

)

 

exit /B %ERRORLEVEL%

 

 


Tuesday, January 11, 2022

Reading Windows Event Log for Oracle Databases

Mythological creatures take many forms. Some have horns and hooves. Some have bodies combined from the union of different species. Some have scales and wings and breath fire.

I'm that rarest of all mythological creatures: The sort who runs production Oracle databases on Windows :-D

DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)

I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...