CODEWITHSUNDEEP
javadatabaseoracle18coracle-enterprise-managerdbca
Yusuf Ibrahim
Yusuf Ibrahim

Reputation: 1619

Getting "Unable to check for available memory." on Oracle DB 18c

I am trying to create a database in order to complete my self learning, but unfortunately I got unexpected error "Unable to check for available memory.", I am doing it using Database Configuration Assistant (DBCA).

enter image description here

My Oracle Database Version

enter image description here

Upvotes: 6

Views: 34157

Answers (10)

Josef Panerio
Josef Panerio

Reputation: 61

just run using elevated administrator privilege

Upvotes: 1

Ashish168
Ashish168

Reputation: 172

For Me i was facing this issue while doing normal setup for Oracle Database 19c , and renaming your PC name did work for me . the issue can be understand as below -

In my case this was a permissions issue on the Oracle Home directory. If your Windows PC name is >= 16 characters in length, the name of the administrators group is affected, because only the first 15 characters are included. The mismatch between that first part of the name and the full name is what was causing the issue. DESKTOP-ASUS-ROG vs. DESKTOP-ASUS-RO in my case (notice the missing G). I renamed the PC to DESKTOPASUS, restarted the machine, and it worked without issue. The name discrepancy was apparent when looking at the security configuration of the folder when my system name was over max.

You can get your PC name by running hostname from the command line. If it's >= 16 characters, rename the PC to be <= 15 characters, and restart.

The underlying issue is indirectly discussed here in a different context: https://learn.microsoft.com/en-us/troubleshoot/windows-server/identity/naming-conventions-for-computer-domain-site-ou

Maximum name length: 15 characters.

Upvotes: -1

yahyadalir
yahyadalir

Reputation: 1

I also had this problem. I had previously installed Java 18.0.1.1 X64 bits By removing it and restarting the system, the problem was solved. Apparently, Java should not be installed on the machine before creating the database.

Upvotes: -1

David Lipschitz
David Lipschitz

Reputation: 152

On Windows 10, Oracle 19 setup. I installed Oracle without creating a database, because of this memory error.

Then

I ran cmd as administrator

I added "dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false &" to the dbca.bat first if statement at the bottom of the file

I switched off all options.

Upvotes: 0

Rahul Vishwakarma
Rahul Vishwakarma

Reputation: 19

Steps: Rename your PC Name Restart and again start installation

Upvotes: -1

robwill
robwill

Reputation: 91

If anyone reading is running into the above issue and find that

dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false &

didn't fix it for them, consider launching the advanced configuration setup for a database. (There's a radio button listed on the "Creation Mode" step). Its pretty straight forward and avoids the validation steps. That's how I got around the issue

Upvotes: 1

Iromannar
Iromannar

Reputation: 1

I had the same problem, but when on the second stage of creating a database I select option "pluggable" and enter the name, it works correctly.

Upvotes: -1

slittlefield
slittlefield

Reputation: 21

Bypass via advanced setup

Run DBCA as admin and work your way through the advanced setup. I think this issue is avoided because it lets you manually enter, or use recommended defaults, for the memory section.

Upvotes: 1

Hossein Chamani
Hossein Chamani

Reputation: 140

This error as it says, indicate that the "DBCA" can not check for available memory. This happens when "DBCA" does not have permission to check.

To bypass this error, run your Command Prompt as Administrator before lunching "DBCA".

Upvotes: 6

0xdb
0xdb

Reputation: 3697

Add the following parameter to bypass the error:

dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false &

Upvotes: 8

Related Questions