In this Document

APPLIES TO:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

PURPOSE

This document helps with troubleshooting issues with databases in OCI (Oracle Cloud Infrastructure) Environment

SCOPE

This document is intended for database administrators working with database in OCI (Oracle Cloud Infrastructure) Environment

DETAILS

DBCS Overview

Oracle Cloud Infrastructure (OCI) offers 1-node DB systems on either bare metal or virtual machines, and 2-node RAC DB systems on virtual machines. These database systems can be managed by using the Console, the API, the Oracle Cloud Infrastructure CLI, the Database CLI (DBCLI), Enterprise Manager, Enterprise Manager Express, or SQL Developer.

All 1- and 2-node RAC DB systems support the following Oracle Database editions:
- Standard Edition
- Enterprise Edition
- Enterprise Edition - High Performance
- Enterprise Edition - Extreme Performance (required for 2-node RAC DB systems)

The supported database versions are:
- Oracle Database 18c Release 1 (18.1)
- Oracle Database 12c Release 2 (12.2)
- Oracle Database 12c Release 1 (12.1)
- Oracle Database 11g Release 2 (11.2)

For more details on database cloud service in OCI, refer the following document:
https://docs.cloud.oracle.com/iaas/Content/Database/Concepts/databaseoverview.htm

Database Create/Terminate

Note 2428269.1 - Is It Possible To Create Additional Databases On OCI Database Cloud Service Hosts?
Note 2416630.1 - DBCS: In OCI, Create Database using Standalone Backups failed for VMDB shape
Note 2358078.1 - Can't Create Database From Backup from OCI
Note 2447063.1 - Supported Format for "Display Name" Field While launching DBCS (OCI) DB system
Note 2427290.1 - 'Forbidden - Forbidden' error while creating DB service in OCI(Oracle Cloud Infrastructure)
Note 2432451.1 - OCI : Instance Creation Using PSM Fails With "Could not connect to Object Storage Cloud Service using the given username and password"

Database Patching

Note 2450482.1 - Database Patch Is Not Working 'DCS-10001:Internal error encountered: Fail to start hand shake to localhost:7070'
Note 2450198.1 - Patching OCI Instance Fails With "DCS-10001:Internal error encountered: Fail to run SSH keygen"
Note 2450486.1 - DCS-10001:Internal error encountered: Failed to download latest patch metadata on node
Note 2386701.1 - DBCS: In OCI/Bare Metal VM, patching on the RDBMS HOME failed with DCS-10001
Note 2448976.1 - [OCI]: Applying Patch to 18.2 GI Home From OCI Console Fails With "DCS-10001:Internal error encountered: Failure : failed to apply 28090523 on /u01/app/18.0/grid."

Database Connectivity

Note 2382283.1 - How to setup SQL Developer connection to Database Cloud Service on OCI (Bare Metal)?
Note 2453454.1 - DBCS: How To Setup EM Express in Bare Metal and Virtual Machine DB Systems(OCI)
Note 2459869.1 - OCI: SQL Performance Analyzer Not Available In EM Express
Note 2409609.1 - OCI Cannot connect with 'oracle' user "Server refused our key" or "Permission denied (publickey,gssapi-keyex,gssapi-with-mic)"
Note 2392398.1 - While selecting data from table got ORA-28365 Wallet Is Not Open in DBaaS Cloud (OCI)
Note 2470556.1 - [OCI]: How To Change The Timezone Setting Of Oracle Cloud Database In Oracle Cloud Infrastructure (OCI)

Database Administration

Note 2465085.1 - Manage Temporary Storage in OCI For Temporary Data Management
Note 2469398.1 - Creating and Activating a Master Encryption Key for a PDB (in OCI and OCI-Classic)

Dataguard Configuration

Note 2326853.1 - Data Guard Performance Issues On Oracle Cloud Infrastructure (OCI)
Note 2442840.1 - The Data Guard association setup in OCI - Bare Metal Failed on task Enable force logging and archivelog mode in primary env
Note 2439602.1 - Steps to Implement Standby / Data Guard setup in OCI (Bare Metal) and how to gather diagnostic information for any failure.

Database Upgrade/Migrate

Note 2455363.1 - OCI: Cloning a PDB from 12.2 CDB to migrate to 18.2 CDB failed
Note 2468956.1 - How to copy PDB through Database Link from one OCI Database to another OCI Database

Database Backup

Note 2410027.1 - OCI : DCS-10001:Internal error encountered: failed to validate container
Note 2427715.1 - OCI DBCS : Backup to Object Storage Fails With "The backup failed due to an object store connectivity issue"
Note 2416467.1 - Backup Fail On OCI Database with dbcli describe-job error: DCS-10001:Internal error encountered: Wallet Status not found as OPEN-AUTOLOGIN/OPEN-UNKNOWN
Note 2418134.1 - RMAN Backup in OCI Failing with ORA-28365: wallet is not open
Note 2365411.1 - Troubleshooting Managed Database Backups on OCI

Database Scaleup

Note 2448309.1 - How to add disk to DBCS instance in OCI

Diagnostic Collection

For database issues in OCI environment, provide the following diagnostic data when raising the service request with Oracle Support:
Note 2397481.1 - Diagnostic Data Collection For Oracle Database Cloud Service Instance (OCI)

OracleAppsDBAKK1

Thursday, October 31, 2019

[OCI]: Master Note For Oracle Database Cloud Service In OCI (Oracle Cloud Infrastructure) Environment (Doc ID 2468507.1)