Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Install Error [DBT-50000] Unable to check for available memory.

SBiedrzyckiMar 21 2019 — edited Sep 2 2019

I'm following up on similar installation troubles from ORA-12560: TNS:protocol adapter error after successful installation of 18 xe where I get the same ORA-12560 error due to missing services after "successful" installation.

Installation completes with the successful screen however the only Oracle service running following installation is OracleOraDB18Home1TNSListener.  I completely uninstalled and tried again with full logging with the same results.  From the logs I noted the DBT-50000 error after finding "SEVERE: Oracle XE Database configuration was not successful. Verify the corresponding logs under cfgtoollogs\dbca and try again" in the MSI log on line 128905.

Installation was performed by running as administrator from my user account which is part of the administrators group.  I had previously tried manually configuring through the provided java apps but ran into the same DBT-50000 error.  Other reading indicated this could be bypassed with a command option for linux installations but I could not find an equivalent work around for Windows although I'm unsure this alone would fix the problem as I'm not sure what else might have been skipped during installation due to this error.  Any guidance on a work around is appreciated.

I've uploaded the install and related error logs:

https://netorg244579-my.sharepoint.com/:u:/g/personal/sbiedrzycki_akoustis_com/Ec-mcvMHj9hCmKEjVQ9gksYBis0kIbhZ4KwzVudiH…

Stack Trace:

ID: oracle.install.commons.util.exception.AbstractErrorAdvisor:4654

oracle.assistants.common.base.exception.CVUException: [DBT-50000] Unable to check for available memory.

at oracle.assistants.common.lib.CVUHelper.checkAvailableMemory(CVUHelper.java:86)

at oracle.assistants.dbca.validator.extsupport.MemoryMgmtCheck.validateAvailableMemory(MemoryMgmtCheck.java:210)

at oracle.assistants.dbca.validator.MemoryMgmtValidator.validate(MemoryMgmtValidator.java:130)

at oracle.assistants.dbca.validator.ConfigurationParamValidator.validate(ConfigurationParamValidator.java:55)

at oracle.install.commons.flow.validation.ValidationHelper.validateState(ValidationHelper.java:194)

at oracle.install.commons.flow.AbstractFlowExecutor.validate(AbstractFlowExecutor.java:521)

at oracle.install.commons.flow.AbstractFlowExecutor.leaveVertex(AbstractFlowExecutor.java:820)

at oracle.install.commons.flow.AbstractFlowExecutor.transition(AbstractFlowExecutor.java:428)

at oracle.install.commons.flow.AbstractFlowExecutor.nextState(AbstractFlowExecutor.java:354)

at oracle.install.commons.flow.SilentFlowExecutor.execute(SilentFlowExecutor.java:67)

at oracle.install.commons.flow.AbstractFlowExecutor.execute(AbstractFlowExecutor.java:294)

at oracle.install.commons.flow.FlowApplication.executeFlow(FlowApplication.java:161)

at oracle.assistants.common.base.driver.AssistantApplication.executeFlow(AssistantApplication.java:176)

at oracle.install.commons.flow.FlowApplication.run(FlowApplication.java:167)

at oracle.assistants.common.base.driver.AssistantApplication.run(AssistantApplication.java:279)

at oracle.install.commons.util.Application.startup(Application.java:1095)

at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)

at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:198)

at oracle.assistants.common.base.driver.AssistantApplication.startup(AssistantApplication.java:328)

at oracle.assistants.dbca.driver.DBConfigurator.startup(DBConfigurator.java:378)

at oracle.assistants.dbca.driver.DBConfigurator.main(DBConfigurator.java:513)

Thanks,

Steve

This post has been answered by clcarter on Apr 5 2019
Jump to Answer

Comments

Birthe Gebhardt

Hi Shubham,
depend if you have APEX installed on your database or not.
If APEX is installed, you can use APEX.WEB_SERVICE.make_request. Otherwise you can use UTL_HTTP.
Further you need access to the URL from inside the database. Please check your ACE/L configuration. For this check you need the PLS/SQL packages DBMS_NETWORK_ACL_ADMIN.

For you REST call you need to clarify which kind of authentification is used. Befoer I transfer the REST call into the database I ceck the connection and the calls using POSTMAN.
To post a working snippet is difficulty, because of the missing information:
Database Version
APEX Installation
REST authentification
Wallets
Here is an example for an REST call: https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6121/index-en.html

Bye,
Birthe

Bilal

Hi Shubham,
Try out the following PLSQL code. Pls, note it is for calling HTTP request to make it simple but not HTTPS which will require you to do some extra work. Also to call the URL you need to register it DBMS_NETWORK_ACL_ADMIN as suggested above.

procedure call_rest_from_plsql_with_params(p$company_name varchar2) as
 l$request utl_http.req;
 l$response utl_http.resp;
 l$crawler_url varchar2(4000) := 'http://localhost:5000/get_company_data'; --Change to suit yours
 l$buffer varchar2(4000); 
 l$response_text varchar2(4000);
 l$params varchar2(4000) := '{"companyname":"'||p$company_name||'"}'; -- Pass your parameter here  as JSON
 begin
 -- Setting up the request and response objects
  l$request := utl_http.begin_request(l$crawler_url, 'GET',' HTTP/1.1');
  utl_http.set_header(l$request, 'user-agent', 'mozilla/4.0'); 
  utl_http.set_header(l$request, 'Content-Type', 'application/json'); 
  utl_http.set_header(l$request, 'Content-Length', length(l$params));
     -- Passing parameteres to GET call
  utl_http.write_text(l$request, l$params);
  -- Getting the response object
  l$response := utl_http.get_response(l$request);
  -- Reading the data from response object
  begin
    loop
     utl_http.read_line(l$response, l$buffer);  
     l$response_text := l$response_text || l$buffer;
    end loop;
    utl_http.end_response(l$response);

  exception
    when utl_http.end_of_body then
     utl_http.end_response(l$response);
  end;
  -- Print the l$response or do whatever you want to using Oracle SQL JSON functions
end;

I hope this will be useful for what you seek.
Wish you the best of luck.
Take care and best Regards
Bilal

User_A8XLF

Thanks you for the response. I have to use utl_http package. Is it possible to use utl_http in case some user authentication is required. If yes how we do that?

Billy Verreynne

UTL_HTTP supports Basic Authentication.
Other types of authentication like NTLM needs to be implemented by the developer.

Bilal
Answer

You can find basic authentication examples on this link: https://oracle-base.com/articles/misc/utl_http-and-ssl

Marked as Answer by User_A8XLF · Feb 4 2021
1 - 5

Post Details

Added on Mar 21 2019
21 comments
32,921 views