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%

 

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

Cursor won't move easily from screen to screen on Multiple Displays (Windows 10)

While using 3 displays on a Windows 10 laptop, I noticed a problem wherein the cursor would get stuck on the edge of a screen at the border between that screen and another. 

(You'll have to forgive me; I'm having trouble capturing a screenshot that includes my cursor :-/ ) 

I traced this back to a gap between the displays in the Display settings.        

Removing this gap removes the issue with the cursor getting hung or stuck between screens.

This is completely reproducible on my system. 

I hope you're right.

 I hope you're right.

I hope it's just overblown, breathless nonsense concocted by the liberal media.

I hope this is all a hoax that the libtards cooked up when they got bored with peddling climate change.

I hope it's a Machiavellian plot by the DNC to get the mighty Trump out of office.

I hope that it's no worse than the flu.

I hope that Biden goes to jail and the world acknowledges that the election was stolen and Trump gets back in office and can can put everything right with the world again.

I hope that Obama was born in Kenya.

I hope he's a Muslim and a terrorist and a radical.

I hope that the 2008 bailout really was a government takeover of the auto industry and we've all just failed to see it.

I hope that Sharia law takes over. No, wait. I hope that it was really going to, but then was somehow thwarted by Rush Limbaugh as his last, heroic, dying act. Or something.

I hope that Fox News announces an investigative report of all the people that were killed by the death panels in the healthcare bill.

I hope that Elvis is still alive, that he's happily married to a mermaid, and that they're living in the sound studio that was used to film the moon landings.

Honestly, I'm not even joking. I really hope that, because it's the last hope we have.

You'd better be right. You have to be right. Because there is no opportunity for any other course than the one we're on.

I've never wanted more to be wrong, because it looks to me like people are lying to you and laughing all the way to the bank.

... Again ...

It looks to me like the vaccine is way < 100% effective.

It looks to me like ain't nobody gonna be wearing no goddam masks to make sure they don't give a deadly respiratory infection to their friends and neighbors - a respiratory infection that is even more serious than last year; that took at least 6 people I knew in 2020, and that hospitalized four others. (2 of which still haven't "bounced back")

You guys are in charge. Seriously. You on the right. You run the world, or at least the part I live in.

You'd better be right.

You'd better be right, or this is going to get really ugly really fast.

Edit: Nope. You were wrong, and people I love died. Because what else could possibly have happened? Oh, well. At least you're Pwning the libs.

Finding SQL Statements in an Oracle Trc File

It often comes to pass that I have received an oracle alert file indicating deadlocks along with a .trc file from one of our customers.

As we all know, deadlocks are an *APPLICATION* problem, not a database problem.
Still, the developers are my team, my posse, my *PEOPLE*, yo, and imma help 'em out. ;-)

So, to make their analysis easier, one of the things I like to do is give them a consolidated list of SQL Statements from the .trc file. This helps them to understand what the application is doing when the deadlock  occurrs.

To find any lines that contain select, insert, update, or delete, you can do the following search. (NOTE: This could easily be expanded to include Merge, etc.  )


Using Notepad ++ ,  I search for

\b(?:select|insert|update|delete)\b .*?$

I then use Notepad++'s bookmark feature to bookmark each line that matches the search.

Finally, I use Search -> Bookmark -> Remove Unmarked Lines

This will remove everything but the Select, Insert, Update, and Delete statements.

Change font for "Connections", "Reports", etc in Oracle SQL Developer

NOTE: These instruction apply to the connections, reports, menus, etc in Oracle SQL Developer. If you are looking to change the font of your PL/SQL Code, these instructions in StackOverflow are for you.

I found instructions here for changing fonts in Oracle SQL Developer (OSD) menus and trees, but being sloppy caused me to struggled a bit.

 (Story of my life ¯\_(ツ)_/¯ ) 

A couples things that should probably have been obvious, but were cheerfully ignored by the idiot with a laptop (Dr. Who Reference) :
1) Before making any changes, shut down Oracle SQL Developer.
    This is important because the file gets overwritten when OSD is closed.
2) Make the recommended changes to the file at:

C:\Users\\AppData*\Roaming\SQL Developer\system19.2.1.247.2212\o.sqldeveloper\ide.properties

NOTE*: AppData is a hidden file.
      In Windows Explorer, go to view and make sure hidden files are enabled.
     
NOTE: This was true for OSD  Version 19.2.1.247, Build 247.2212
      The system19* folder details may change for previous or subsequent releases

3) Start OSD and enjoy not having to squint at your connection data ;-)

Another quick note: If Oracle would open-source OSD, I would be happy to add a menu item that would set this font. This is an example of the ways in which OSD, which is a FANTASTIC TOOL all things considered, nonetheless feels just sort of unfinished.

Big thanks to Jeff Smith for publishing instructions on this topic. :-D

WebSphere Application Server - DB2 RS Transaction Isolation Level is Default

In WebSphere, the default transaction level is set to something very restrictive.

It’s likely that they haven’t changed this in their app server configuration.

Have them check the webSphereDefaultIsolationLevel custom property on their data sources.

https://www.ibm.com/support/pages/determining-and-changing-isolation-level

“If the database connection is obtained in a servlet, JSP, or session bean, TRANSACTION_REPEATABLE_READ is used by default.”

JDBC Isolation Level

              

DB2 Isolation Level

TRANSACTION_SERIALIZABLE      Repeatable Read (RR)

TRANSACTION_REPEATABLE_READ           Read Stability (RS)  ← Deafult

TRANSACTION_READ_COMMITTED          Cursor Stability (CS) ← What we want

TRANSACTION_READ_UNCOMMITTED    Uncommitted Read (UR)

“In WebSphere Application Server V6.1 and above, the webSphereDefaultIsolationLevel custom property can be set on a data source to change the default isolation level that is used even if indirect JNDI lookups and resource references are not used by the application.”

Procedure for changing this setting in WAS 8.5.5 can be found here:
https://www.ibm.com/support/knowledgecenter/en/SSWLGF_8.5.6/com.ibm.sr.doc/twsr_setwebspheredefaultisolationlevelproperty.html