Working with Jobs in Oracle Machine Learning

Jobs allow your to create schedules to run notebooks. Jobs page lists all the jobs created ,along with the job name,notebook,owner of the job, last start date,next run date, status and the schedule. Following tasks cane be done with Jobs. Edit jobs :- Metadata of any job can be edited listed in Job page by …

SSH Passwordless Login between linux servers using SSH Keygen

Assumptions :- SSH Client Source (goldengate1) :- 192.168.56.5 oracle SSH Remote Host Target (goldengate2) :- 192.168.56.6 redhat 1.. login to your server SSH Client Source (goldengate1 - 192.168.56.5 ) generate a pair of public keys using following command. 2… Once you execute given above ssh-keygen then under user home directory hidden file .ssh is created …

Setting up an Output Format in Oracle Machine Learning’s Notebook

Oracle Machine Learning allows preformat query output in Notebooks. Syntax:- %script SET SQLFORMAT format_option Note: - This format is available for the script interpreter and must add prefix %script 1.. ANSICONSOLE format resizes the columns to the width of the data to save space and underlines the columns, instead of separate line of output. %script …

Creating Dynamic Forms Text input,Selection and Checkbox in Oracle Machine Learning’s Notebook

Text Input Forms: -  The text input form allows you to dynamically retrieve values as defined in the notebook. To create a text input form: In a SQL statement, define the text input form by using the syntax: '${formName}' For example, run the SQL statement: select * from all_objects where object_type = '${OBJ}'; where OBJ …

Enabling Oracle Database Flashback and rewinding your Database to restore point…

Assumption :- Oracle Database should be in archive log mode and flashback should be enabled If not enabled then shutdown your database, start up in mount mode and enabled it. 1.. In given below scenario :- archivelog  is enabled but not flashback 2.. Shutdown Oracle Database and start up in mount mode. 3.. Enabaling flashback …

Creating and Running Notebooks in Oracle Machine Learning

A notebook is a web-based interface for data analysis, data discovery, data visualization and collaboration similarly OML notebook is based upon Apache Zeppelin technology. 1.. Login into Oracle Machine Learning 2.. Once login click on tab notebooks 3.. Once clicked on Tab notebook click on create tab And fill the information as given below Name: …

Connection Group Global and Oracle Database Connection in Oracle Machine Learning

A connection group also known as a Zeppelin interpreter set, is a collection of database connections. 1.. Connection Groups: - In the connection group page, you can manage your connections that constitute the connection group. You can edit stop one or more connections that are listed under a connections group. Click left most top corner …

Creating SQL Scripts and Running SQL Statements in Oracle Machine Learning

SQL Scratchpad is a low-overhead tool that simplifies SQL and PL/SQL development and this tool uses a direct JDBC connection to a database. Features Include :- 1.. SQL editing with color coding of SQL 2.. Execution plan access graphical and tabular form 3.. Access to history of all ran SQL statements 4.. Visibility of SQL …

Collaborating with different user geographically distributed in OML, workspace permission and permission type

To collaborate with different user geographically distributed, workspace permission can be granted to different user. Types of Permission and action based on Permission types: - 1.. Login with user you have created in OML and created workspace that you want to collaborate . 2… Navigate to right top corner, select Workspace that you have created …

Creating user account for Oracle Machine Learning #Autonomous

1.. Select an Autonomous Data Warehouse or Autonomous Transaction Processing instance. 2.. On instance detail page Click on Service Console page 3.. Click on Administration tab and then Manage Oracle ML Users page 4.. Click on Create tab and enter user detail as follows   Note: - If you select the option, Generate password and …