-
How to set up single sign-on between multiple Oracle Cloud Infrastructure tenancies
Oracle Identity Cloud service (IDCS) provides an innovative, fully integrated service that delivers all the core Identity and Access Management (IAM) capabilities through a multitenant cloud platform. Identity Cloud service manages user access and entitlements across a wide range of cloud and on-premises applications and services using a cloud native identity-as-a-service (IDaaS) platform. Organizations can… Continue Reading
-
How to execute sql tuning advisor for SQL ID in 19c
Description: – SQL Tuning Advisor is a program provided by sql that comes along with oracle installation. This advisor can be executed against a sql id and it generates a report with recommendations which generally includes · Collection of object statistics · Creation of indexes · Rewriting SQL statements · Creation of SQL profiles · Creation of SQL plan baselines… Continue Reading
-
Manage and move on premise backup to Oracle Cloud Infrastructure (OCI) Object Storage
Oracle Cloud Infrastructure (OCI) Object Storage enables customers to securely store any type of data in its native format. With built-in redundancy, OCI Object Storage is ideal for building modern applications that require scale and flexibility, as it can be used to consolidate multiple data sources for analytics, backup, or archive purposes.Oracle Cloud Infrastructure offers… Continue Reading
-
Unexpected error occurred during authentication in ODA
Issue:- oda-admin credential is not working So, few days ago while trying to login ODA management url using its credential, it gave me following message Solution:- This issue happens when there is some problem with the credential of the user or maybe the password is expired. To reset the password, Login to oda compute node… Continue Reading
-
A Simple Guide to Connect OCI Data Science with ADB
Background OCI Data Science is a fully managed service for data science team to build, train and manage machine learning models in Oracle Cloud Infrastructure. It can be integrated with other OCI stack such as ADB, Functions, Data Flow and Object Storage. In this guide we will see how to connect OCI Data Science with… Continue Reading
-
Handy Oracle Data guard Broker Commands Part-I
Handy Oracle Data guard Broker Commands: – Here, Primary database is : ORCL Standby Database is : ORCLDR Login DGMGRL utility dgmgrl / [Here connection happens through os authentication]ordgmgrl sys/<sys_password>@<connect dentifier> To check current status and configuration DGMGRL> show configuration; Configuration – my_dg_config Protection Mode: MaxPerformance Members: orcl – Primary database orcldr – Physical standby database Fast-Start Failover: Disabled Configuration Status:SUCCESS (status updated 16 seconds ago)… Continue Reading
-
How to backup block volume using OCI CLI and why would I want it?
Block volume backup allow you to make a point in time snapshot of the data on a block volume. It can be backed up anytime whether it is attached or detached from an instance. Backing up block volume can be achieved easily using the OCI web console. You can select from 3 oracle defined backup… Continue Reading
-
List of Oracle 19c specific parameters
Following are Oracle 19c specific parameter which can be added in a pfile for a database running 19.x.x ########### Compatibility parameter.## Compatibility should be set to the current release.########## compatible = 19.0.0 #MP ########### Optimizer parameters.## In Oracle Database 12.2 or higher, the Parameter optimizer_adaptive_features has been obsoleted,# replaced and controlled by two new parameters,… Continue Reading
-
Simple steps to manage Autonomous Database from OCI Cloud Shell
Oracle Cloud Infrastructure (OCI) Cloud Shell is a web browser-based terminal available from the Oracle Cloud Console. OCI Cloud Shell provides access to a Linux shell with a preauthenticated OCI CLI and several useful development tools and utilities preinstalled. Cloud Shell is a feature available to all OCI users, accessible from the Console. Cloud Shell… Continue Reading
-
Host your Microsoft .NET based application on Oracle Linux
This blog demonstrates .Net installation and how to build a .Net based application on Oracle Linux in Oracle Cloud Infrastructure (OCI). .NET is an open source software framework for building cross-platform applications on Oracle Linux. With .Net, you can build various applications in supported languages such as C#, F#, and Visual basic. Use the following… Continue Reading

