Oracle Autonomous Database: Oracle Machine Learning, APEX, SQL Developer Web

This post is part of a series of blog posts on the Oracle Autonomous Database.

Oracle Machine Learning

Workflow Tasks for using Oracle Machine Learning:

  1. Create Oracle Machine Learning user
  2. Create workspaces
  3. Create projects
  4. Create notebooks
  5. Run SQL scripts/statements

Please note: Oracle Machine Learning users can also be created using SQL Developer.

Oracle Application Express (APEX)

  • APEX is automatically enabled in the autonomous database
  • Access is through the Service Console
  • The initial access is through the “admin” user (in the Internal workspace)

APEX and SQL Developer Web Access Requirements with ADB-D:

  • Must be inside customer VCN
  • Service user Database Admin is automatically granted use of tooling
  • Database users must be enabled to use tooling using ORDS.ENABLE_SCHEMA
BEGIN
ORDS.ENABLE_SCHEMA (p_enabled=> TRUE,
p_schema=> 'HRUSER', -- the database user name
p_url_mapping_type=> 'BASE_PATH',
p_url_mapping_pattern=> 'hr_alias', -- determines URI template for RESTful Services
p_auto_rest_auth=> TRUE ); -- authenticate request before any request can be serviced
END;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s