sqlcl 21.3 won't run

bazzza

C:\sqlcl-21.3\sqlcl\bin>sql.exe

Error occurred during initialization of VM

Could not reserve enough space for 2097152KB object heap

I have lots of spare ram, running java 1.8.252.

Had the same issue with 21.2 initially until they patched it:

https://community.oracle.com/tech/developers/discussion/4486331/sqlcl-21-2-on-windows-wont-load/p1?new=1

user9540031

Hello,

Could not reserve enough space for 2097152KB object heap

I have lots of spare ram, running java 1.8.252.

2 Gb is a huge starting point for the heap, but that shouldn't be a blocking issue if you have plenty of RAM, unless this is a 32-bit JVM of course. Are you certain the right JDK was picked?

Also, make sure you have the very latest release (21.3.2.287.1503) from https://www.oracle.com/tools/downloads/sqlcl-downloads.html

Meanwhile, in case sql.exe would not pick the right JDK on your system for whatever reason, you could still craft your own starting script or use someone else's, e.g. https://gist.github.com/PaulNeumann/d541b251e160038412b02d471a3f4704, as a starting point.

Paul Neumann's comments on the above page link back to https://community.oracle.com/tech/developers/discussion/4139916/unable-to-launch-sqlcl-18-1, which is worth reading for complementary information.

Regards,