Creation of basic networking components of Virtual Cloud Network in OCI and provisioning Compute Instance

1.. Login to OCI Cloud account click on hamburger menu and again click on Networking Tab. Once You are on the Networking page, select compartment where you want to create your VCN. 2.. Give name for VCN and enter CIDR block and select CREATE VIRTUAL CLOUD NETWORK ONLY to create all other basic networking components … Continue reading Creation of basic networking components of Virtual Cloud Network in OCI and provisioning Compute Instance

Creating User in Oracle Cloud Infrastructure in simple way

What is user in Oracle Cloud Infrastructure ? An individual employee or system that needs to manage or use company's Oracle Cloud Infrastructure resources. Users might need to launch instances, manage remote disks, work with your virtual cloud network, etc. End users of your application are not typically IAM users. Users have one or more … Continue reading Creating User in Oracle Cloud Infrastructure in simple way

Pluggable Database Rename in Oracle Container Database 12cR1

1.. Connect to root container as sysdba then show pdbs 2.. First shutdown pluggable database and then open in restricted mode for e.g NONPDB4 3.. Now connect to Pluggable database NONPDB4 that you want to change the name. 4.. execute alter pluggable database rename global_name to DEMO; Note :- There will be change in name … Continue reading Pluggable Database Rename in Oracle Container Database 12cR1

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 … Continue reading Working with Jobs in Oracle Machine Learning

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 … Continue reading Setting up an Output Format in Oracle Machine Learning’s Notebook

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 … Continue reading Creating Dynamic Forms Text input,Selection and Checkbox in Oracle Machine Learning’s Notebook

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: … Continue reading Creating and Running Notebooks in Oracle Machine Learning

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 … Continue reading Connection Group Global and Oracle Database Connection in Oracle Machine Learning

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 … Continue reading Creating SQL Scripts and Running SQL Statements in Oracle Machine Learning

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 … Continue reading Collaborating with different user geographically distributed in OML, workspace permission and permission type