Oracle Autonomous Database CookBook

Written by Oracle Certified Master Skant Gupta and Oracle Certified Professional Mohit Sharma are diligently planned to direct the readers about the usage of Oracle Autonomous Database.  The primary target audience is Oracle DBAs and Oracle Cloud DBA’s. This book has been diligently planned for all levels of DBA experts. Coming right from the real-world […]

Read More

Terminating an Autonomous Transaction Processing (ATP) Instance

In this post, we are going to terminate the ATPdatabase on OCI. We assume that you must have OCI account with valid credentials and compartments. Terminating your ATP instance Go to the Cloud Console you used during the provisioning exercise and open the Instances screen. Click the Instance Name (NEWATP) Click Actions and Select “Terminate”. […]

Read More

Stopping/Starting your Autonomous Data Warehouse Cloud (ADWC) instance

In this post, we are going to stop & start the ADWC database on OCI. We assume that you must have OCI account with valid credentials and compartments. Stopping your ADWC instance Go to the Cloud Console you used during the provisioning exercise and open the Instances screen. Click the Instance Name (SKANTADWC). Click Stop. […]

Read More

Monitoring your ADWC instance

In this post, you will use the service console to monitor your ADWC instance. As ADWC only accepts secure connections to the database, you need to download a wallet file containing your credentials first. The wallet is downloaded from the ADWCservice console. On the Instances page, find your database and click “Service Console” in the actions […]

Read More

Loading a Data from csv into ADWC

In this post, you will load data from a csv file into ADWC. Note: we already have table.csv for our testing. Now, we open the SQL Developer and connect with NEWADW connection which is already save in SQL Developer. SQL Developer ADWC Right-click “Tables,” and then click “Import Data.” Click “Browse” and locate the channels.csv […]

Read More

Creating an Oracle Cloud Infrastructure (OCI) Object Storage Bucket

In this post, you will create a storage bucket using Oracle Cloud Infrastructure (OCI) Object Storage. We assume that you must have OCI account with valid credentials and compartments. Launch the web browser and Log into your assigned OCI account. Expand the Hamburger menu and select “Object Storage” or alternatively, click on “Object Storage” on […]

Read More