The Database is not accessible after creating Always On Availability Group

 Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS.

Upon trying to expand the database, I get this message: "The database [...] is not accessible (Object Explorer).

The stack trace mentions get_CanGetChildren().

File this one under "sometimes, our lives are meant to serve as a warning to others."

I was connecting to the Windows Server Failover Cluster, rather than the SQL Server listener. SSMS / SQL Server is happy to let you do this, but then you're not able to expand the database.

When I connected via the listener, it worked without issue.

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%