Exciting news, the long awaited
has been announced and will run this October and November. Oracle Enterprise and Cloud Manageability Virtual Classroom Series
The series will include:
7 sessions running weekly from October 13 2020 12+ Oracle experts Live presentations Demos Q&A
During the virtual classes, you will get to explore the latest and greatest innovations
Enterprise Manager has to offer.
This is a great opportunity for you to learn and benefit from using
Enterprise Manager to manage on-premise and cloud deployments for:
Databases Middleware Oracle apps (eg. EBS) Engineered Systems (eg. Exadata, ZDLRA, PCA)
To register please visit:
Oracle Enterprise and Cloud Manageability Virtual Classroom Series
I recently had a requirement where the Common User in a Multitenant DB environment wanted to access
application tables across Pluggable Databases (PDBs) but at the same time access dictionary views across all PDBs without the need to manually switch between containers.
This was because I had to setup a monitoring user account to monitor all PDBs performance as well as application workload.
In this example I will show you how the Common User (created at CDB level) can be configured to access the application tables (create at PDB level)
Continue reading “Multitenant Common Users Accessing Application Tables in PDBs”
In this post I will show you how you can setup Autonomous DB monitoring in Oracle Management Cloud (OMC) in under 5 minutes.
STEP 1 You will need to obtain your OCI User Information associated with your Autonomous Database (ADB) instances from the OCI Console.
Click on the user icon in top right hand corner of OCI console. Select User Settings On the User Details page, make a copy of the User OCID In addition to this, make a copy of the API Key Fingerprint.
STEP 2 You will need to obtain your OCI Tenant Information associated with your Autonomous Database instances from the OCI Console.
Navigate to Administration > Tenancy Details On the Tenancy Information page, make a Copy of the Tenancy OCID.
HINT: If OCID is hidden, you can click on Show to display entire value if you wish.
STEP 3 In another browser session, launch the OMC Console.
HINT: If the side menu does not appear, click on menu icon
STEP 4 From the side menu, navigate to:
Select Administration Select Discovery Select Cloud Discovery Profile
STEP 5 On the Cloud Discovery Profiles Page: Click on + Add Profile
The Add Discovery Profile Page will appear.
Specify a Profile Name (eg. ADWPROFILE1) Choose Cloud Service Provider Oracle Cloud Infrastructure Click + Add Select Region (eg. Frankfurt) Select Services (eg. Autonomous Data Warehouse) Enter Credential Name (eg. ADWCRED) Enter User OCID (eg. ocid1.user.oc1.xxxxx) Enter Tenancy OCID (eg. ocid1.tenancy.oc1.xxxxx) Enter the associated Private key with user API Key Enter the Fingerprint (eg. nn:nn:nn:nn:nn:nn:nn) Click on Start Discovery
STEP 6 On the Cloud Discovery Profiles Page, wait for discovery to complete.
Click on the Job Status Count Verify that the Service was completed successfully
This completes the setup. Now you are ready to start monitoring and managing your Autonomous Database in OMC.
Click here here for more.
You probably heard that
Oracle Autonomous Database (ADB) leverages machine learning to automate with traditional infrastructure related database administration tasks such as security, backups and patching.
No matter how well designed your database infrastructure is, performance and issues relating application or external components which make up the application ecosystem can still have an impact on end user response time or availability.
Continue reading “Why Would you Monitor an Autonomous Database?”