Thursday, October 31, 2019

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

In this Document
Purpose
Scope
Details
 DBCS Overview
 Database Create/Terminate
 Database Patching
 Database Connectivity
 Database Administration
 Dataguard Configuration
 Database Upgrade/Migrate
 Database Backup
 Database Scaleup
 Diagnostic Collection
References

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)
at No comments:

Frequently Asked Questions About Command Line Interface (CLI) For Oracle Cloud Infrastructure (OCI) (Doc ID 2433795.1)

Click to add to FavoritesTo BottomTo Bottom
In this Document
Purpose
Questions and Answers
 Required Inputs For Configuring Command Line Interface
 1. How to find Tenancy OCID
 2. How to find User OCID
 3. How to get compartment ID
 4. How to find namespace ID using command line
 5. Where to find documentation reference for using commands
 Examples of Using Command Line Interface
 1. How to get list of buckets in OCI console
 2. How to check the objects that can be deleted
 3. How to display database systems in a compartment
 4. How to list backups available for a database instance
 Errors during Installation/Usage of Command Line Interface
 1. Getting error "ZipImportError: can't decompress data" during installation of command line interface
 2. Getting error "ModuleNotFoundError: No module named '_ssl' during installation of command line interface
 3. Executing any oci command shows "The required information to complete authentication was not provided."
 4. Executing any oci command shows "RuntimeError: Click will abort further execution because Python 3 was configured to use ASCII as encoding for the environment... This system lists a couple of UTF-8 supporting locales that you can pick from.  The following suitable locales where discovered:"
References

APPLIES TO:

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

PURPOSE

 This document includes frequently asked questions related to usage of command line interface (CLI) for oracle cloud Interface (OCI)

QUESTIONS AND ANSWERS

Required Inputs For Configuring Command Line Interface

1. How to find Tenancy OCID

Login to OCI console. Tenancy OCID can be found at the bottom left side of every page in OCI console.

2. How to find User OCID

Login to OCI console
Expand the username menu in the top-right corner of the Console, and then click User Settings
OCID information is available under "User Information"

3. How to get compartment ID

Login to OCI console
Navigate to Identity --> Compartments
Look OCID under the compartment name
Example of compartment ID: ocid1.compartment.oc1..aaaaaaaax1afaargggggghhhhhhhhhhhhh2bbbbbbbbbbbbbb

4. How to find namespace ID using command line

$ oci os ns get

5. Where to find documentation reference for using commands

Refer the documentation link for usage on oci commands: OCI CLI Command Reference

Examples of Using Command Line Interface

1. How to get list of buckets in OCI console

$ oci os bucket list --compartment-id=<compartment ID>
Sample Output:
$ oci os bucket list --compartment-id=ocid1.compartment.oc1..aaaaaaaax1afaargggggghhhhhhhhhhhhh2bbbbbbbbbbbbbb
{
  "data": [
    {
      "compartment-id": "ocid1.compartment.oc1..aaaaaaaax1afaargggggghhhhhhhhhhhhh2bbbbbbbbbbbbbb",
      "created-by": "ocid1.user.oc1..aaaaaaaajbbbbbbbbbbbbbbbbbbbbjlzdy6xx6ha",
      "defined-tags": null,
      "etag": "84795fbf-1209-40e1-8db0-095403857532",
      "freeform-tags": null,
      "name": "<name>",
      "namespace": "<namespace>",
      "time-created": "2018-08-07T04:06:56.380000+00:00"
    }
  ]
}

2. How to check the objects that can be deleted

$ oci os object bulk-delete -ns <object_storage_namespace> -bn <bucket_name> --dry-run
Sample Output:
=============
$ oci os object bulk-delete -ns <namespace> -bn <bucketname> --dry-run
{
"delete-failures": {},
"deleted-objects": [
"test_delete_bucket.txt"
]
}
=============

3. How to display database systems in a compartment

$ oci db system list --compartment-id <compartment id>
[root@anandu ~]# oci db system list --compartment-id ocid1.compartment.oc1..aaaaaaaax1afaargggggghhhhhhhhhhhhh2bbbbbbbbbbbbbb
{
  "data": [
    {
      "availability-domain": "LBYW:US-ASHBURN-AD-1",
      "backup-subnet-id": null,
      "cluster-name": null,
      "compartment-id": "ocid1.compartment.oc1..aaaaaaaax1afaargggggghhhhhhhhhhhhh2bbbbbbbbbbbbbb",
      "cpu-core-count": 1,
      "data-storage-percentage": 80,
      "data-storage-size-in-gbs": 256,
      "database-edition": "ENTERPRISE_EDITION",
      "defined-tags": {},
      "disk-redundancy": "HIGH",
      "display-name": "<DBSystem>",
      "domain": "sub12191026110.vcndemonetwork.oraclevcn.com",
      "freeform-tags": {},
      "hostname": "<host>",
      "id": "ocid1.dbsystem.oc1.iad.aaaaaaaaaaaaaaaaaaxxxxxxxxxxxwx2y67oewa",
      "last-patch-history-entry-id": null,
      "license-model": "LICENSE_INCLUDED",
      "lifecycle-details": null,
      "lifecycle-state": "AVAILABLE",
      "listener-port": 1521,
      "node-count": 1,
      "reco-storage-size-in-gb": 256,
      "scan-dns-record-id": "ocid1.vcndnsrecord.oc1.iad.aaaaaaaaaaaaaaaaaaaaaxxxxxxxxxxxxxxxxrqiwqlggq",
      "scan-ip-ids": null,
      "shape": "VM.Standard1.1",
      "ssh-public-keys": [
        "<key>"
      ],
      "subnet-id": "ocid1.subnet.oc1.iad.aaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbb12222222222223taivq",
      "time-created": "2018-08-01T06:32:17.477000+00:00",
      "version": "12.2.0.1.180417",
      "vip-ids": null
    }
.
.
   ]
}

4. How to list backups available for a database instance

$ oci db backup list --database-id <database id>
[root@anandu ~]# oci db backup list --database-id ocid1.database.oc1.iad.abuwcljrhciytqvuqijiu2i3xnv2lxufcjh67zk4jkus2hbxxvj3bj67zloa
{
  "data": [
    {
      "availability-domain": "LBYW:US-ASHBURN-AD-1",
      "compartment-id": "ocid1.compartment.oc1..aaaaaaaax1afaargggggghhhhhhhhhhhhh2bbbbbbbbbbbbbb",
      "database-edition": "ENTERPRISE_EDITION",
      "database-id": "ocid1.database.oc1.iad.awewfewfqqqqqqqqqqqaaaaaaaaaaacjh67zk4jkus2hbxxvj3bj67zloa",
      "db-data-size-in-mbs": null,
      "display-name": "Automatic Backup",
      "id": "ocid1.dbbackup.oc1.iad.aadssafadvsdfgwervaaaaaaaaaaaaaapy4tm3d2lijuqofjq",
      "lifecycle-details": null,
      "lifecycle-state": "ACTIVE",
      "time-ended": "2018-08-28T06:11:08.086000+00:00",
      "time-started": "2018-08-28T06:05:59.637000+00:00",
      "type": "INCREMENTAL"
    }
.
.
  ]
}

Errors during Installation/Usage of Command Line Interface

1. Getting error "ZipImportError: can't decompress data" during installation of command line interface

File "/root/Python-3.6.0/Lib/ensurepip/__init__.py", line 27, in _run_pip
    import pip
zipimport.ZipImportError: can't decompress data; zlib not available
make: *** [install] Error 1
 Zlib-devel package is missing. Ensure required rpm packages are installed on the machine.
Note 2444552.1 - How to configure yum Repository in OCI  Instance

2. Getting error "ModuleNotFoundError: No module named '_ssl' during installation of command line interface

Running install script.
Traceback (most recent call last):
  File "/tmp/oci_cli_install_tmp_sXFq", line 21, in <module>
    import ssl
  File "/usr/local/lib/python3.6/ssl.py", line 101, in <module>
    import _ssl             # if we can't import it, let the error propagate
ModuleNotFoundError: No module named '_ssl'
openssl-devel package is missing. Ensure required rpm packages are installed on the machine.
Note 2444552.1 - How to configure yum Repository in OCI  Instance

3. Executing any oci command shows "The required information to complete authentication was not provided."

Refer the following note for issue with executing oci command:
Note 2444284.1 - Executing Any OCI Commands Using Command Line Interface (CLI) Fails With "The required information to complete authentication was not provided"

4. Executing any oci command shows "RuntimeError: Click will abort further execution because Python 3 was configured to use ASCII as encoding for the environment... This system lists a couple of UTF-8 supporting locales that you can pick from.  The following suitable locales where discovered:"

Set the following parameters and run the oci command:
$ export LANG=en_US.utf8
$ export LC_ALL=en_US.utf8
$ ./oci --version

REFERENCES

NOTE:2432759.1 - [OCI]: How to Install and Configure Command Line Interface For Oracle Cloud Infrastructure In Linux
NOTE:2444552.1 - OCI : How to Configure yum Repository in OCI Instance
at No comments:

Friday, October 25, 2019

FAQ: Oracle E-Business Suite and the Oracle Multitenant Architecture (Doc ID 2567105.1)

Overview

Introduced with Oracle Database 12c, the multitenant architecture enables an Oracle database to function as a container database (CDB). A pluggable database (PDB) is a portable collection of schemas, schema objects, and non-schema objects, contained within a CDB.
This document presents a series of commonly asked questions and answers about using Oracle E-Business Suite with the multitenant architecture: for example, how many PDBs are currently supported within a CDB.
The topics are grouped in the order they are most likely to be needed by those new to this area, but can be referred to in any desired order or combination.
There is a change log at the end of this document.

General Questions

How does Oracle E-Business Suite support the multitenant architecture?

Oracle E-Business Suite supports the multitenant architecture with a single CDB containing a single pluggable Oracle E-Business Suite database (PDB) in the following combinations:
  • Oracle E-Business Suite 12.2.3 and later with Oracle Database 19c on-premises
  • Oracle E-Business Suite 12.2.3 and later with Oracle Database 12cR1 VM DB Systems or Oracle Database 12cR1 in an Exadata DB System
  • Oracle E-Business Suite 12.1.3 with Oracle Database 19c on-premises
  • Oracle E-Business Suite 12.1.3 with Oracle Database 12cR1 VM DB Systems or Oracle Database 12cR1 in an Exadata DB System

How many PDBs are supported in a CDB that is running Oracle E-Business Suite?

At present, Oracle E-Business Suite supports a single PDB (single tenant) in a CDB.

Are there additional licensing requirements?

Oracle E-Business Suite currently supports a single pluggable database (single tenant) with a CDB architecture (see previous question). A single PDB in a CDB does not require licensing the Oracle Multitenant database option.

For more information, refer to the following resources:

Do I need to make any Oracle E-Business Suite Infrastructure changes?

Whether you need to make changes to your Oracle E-Business Suite environment depends on where your environment resides:
  • For on-premises Oracle E-Business Suite environments:
    • As part of the upgrade of your Oracle E-Business Suite Database to 19c you will convert your database to the CDB architecture with a single pluggable database (PDB). For more information, refer to the following My Oracle Support knowledge documents:
      • Document 2552181.1, Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c
      • Document 2580629.1, Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c
  • For Oracle E-Business Suite environments on Oracle Cloud Infrastructure (OCI):
    • If you are moving to a database service (1-node or 2-node VM DB System, or Exadata DB System) as part of the migration of an Oracle E-Business Suite 12c database, you will need to convert the database to the CDB architecture.
      • For more information, refer to Section 3, Certifications and Automations, of My Oracle Support Knowledge Document 2517025.1, Getting Started with Oracle E-Business Suite and Oracle Cloud Infrastructure.

Oracle E-Business Suite Container Database (CDB)

Note: Except for cloning, the questions and answers in this section apply both to on-premises and OCI environments.

How do I source the Oracle E-Business Suite CDB environment?

Oracle E-Business Suite database CDB environment files are located in the database ORACLE_HOME. Run the following commands:
$ cd $ORACLE_HOME
$ source <CDB_NAME>_<NODE_NAME>.env

How do I connect to the Oracle E-Business Suite CDB as SYSDBA?

Source the CDB environment file in the ORACLE_HOME and then use SQL*Plus to connect to the CDB as SYSDBA:
$ cd $ORACLE_HOME
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"

How do I start the CDB that hosts the Oracle E-Business suite PDB?

You will use either SQL*Plus or srvctl, depending on whether you are using a single-node instance or Oracle RAC system.
  • On a single-node instance, run the following commands:
    $ source <CDB_NAME>_<NODE_NAME>.env
    $ sqlplus "/ as sysdba"
    SQL> startup;
  • On an Oracle RAC system, run the following commands:
    $ source <CDB_NAME>_<NODE_NAME>.env$ srvctl start database -d <CDB name>

How do I shut down the CDB that hosts the Oracle E-Business Suite PDB?

You will use either SQL*Plus or srvctl, depending on whether you are using a single-node instance or Oracle RAC system.
  • On a single-node instance, run the following commands:
    $ source <CDB_NAME>_<NODE_NAME>.env
    $ sqlplus "/ as sysdba"
    SQL> shutdown normal;
  • On an Oracle RAC system, run the following commands:
    $ source <CDB_NAME>_<NODE_NAME>.env$ srvctl stop database -d <CDB name>

How do I clone an Oracle E-Business Suite environment with a CDB?

In on-premises environments, the Oracle E-Business Suite Rapid Clone utility can be used to clone both the CDB and PDB together.

Oracle E-Business Suite Pluggable Database (PDB)

How do I source the Oracle E-Business Suite PDB environment?

The Oracle E-Business Suite database PDB environment files are located in the database ORACLE_HOME:
$ cd $ORACLE_HOME
$ source <PDB_NAME>_<NODE_NAME>.env

How do I connect to the Oracle E-Business Suite PDB as SYSDBA?

Source the CDB environment file, export the Oracle E-Business Suite PDB name, then use SQL*Plus to connect to the PDB as SYSDBA:
$ source <CDB_NAME>_<NODE_NAME>.env
$ export ORACLE_PDB_SID=<PDB NAME>;
$ sqlplus "/ as sysdba"

How do I open the Oracle E-Business Suite PDB?

Source the CDB environment file, connect to the CDB as SYSDBA, then execute the SQL shown in the example to start the PDB:
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database <EBS PDB Name> open read write services=all;

How do I close the Oracle E-Business Suite PDB?

Source the CDB environment, connect to the CDB as SYSDBA, then execute the SQL shown in the example to close the PDB:
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database <EBS PDB Name> close immediate;
There is also the option to save the state of the PDB. Oracle will then preserve the mode when you restart the CDB. You can find the current saved state by querying DBA_PDB_SAVED_STATES:
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database <EBS PDB Name> save state;
SQL> alter pluggable database <EBS PDB Name> close immediate;

How do I find Oracle E-Business Suite PDB information and status?

The following SQL returns the values for the con_id, con_name, open mode, restricted values of all your PDBs.
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> show pdbs;
Alternatively, you could use the following SQL to return only the values for name and open mode:
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> select name, open_mode from v$pdbs;

How do I access the Oracle E-Business Suite PDB while logged into the CDB?

Use the following command to set the environment, show the PDB name, and then connect to that PDB:
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> show pdbs;
SQL> alter session set container=”PDBNAME”;

Where do I look for PDB errors if I encounter a problem?

Source the environment and then review any plugin violations, as shown in the following example:
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> select name, cause, message, status from PDB_PLUG_IN_VIOLATIONS;

Can I unplug an Oracle E-Business Suite PDB from one CDB and plug it into another CDB?

Currently, it is not supported to unplug (relocate or clone) an Oracle E-Business Suite PDB to another CDB.

What parameters in the Oracle E-Business Suite database context file support the multitenant architecture?

Context variables used to support the multitenant architecture are as follows:
  • s_pluggable_database: This variable is set to TRUE in a multitenant database.
  • s_pdb_name: This variable is set to PDB name.
  • s_cdb_name: This variable is set to CDB SID.
  • s_cdb_unique_name: This variable is set to the DB unique name for the CDB.
  • s_dbService: This variable is set to ebs_<PDB name> in a multitenant database.
  • s_db_tenancy: This variable is set to multi-tenant in a multitenant database.
  • s_cdb_tnsadmin: This variable is set to $ORACLE_HOME/network/admin.

Before running AutoConfig on the database tier, do I source the PDB environment or CDB environment?

You should always source the Oracle E-Business Suite PDB environment before running AutoConfig. You can do so by running the following commands:
$ cd $ORACLE_HOME
$ source <PDB_NAME>_<NODE_NAME>.env

Can I export an Oracle 12c non-CDB database and import it into an Oracle 19c PDB?

Data from a non-CDB database can be directly imported into a PDB using the Data Pump export/import commands. Refer to My Oracle Support Knowledge Document 2554156.1, Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19c.

Oracle E-Business Suite Multitenant Database SQL and Scripts

How do I set up the environment to run an Oracle E-Business Suite Script or SQL session?

Source the Oracle Home <CDB_NAME>_<HOSTNAME>.env and set the PDB environment variable ORACLE_PDB_SID=<PDB_NAME> before running Oracle E-Business Suite programs such as adgrants.sql.
$ source <CDB_NAME>_<NODE_NAME>.env
$ export ORACLE_PDB_SID=<PDB_NAME>
$ sqlplus "/ as sysdba"

Oracle E-Business Suite Multitenant Database Patching

How do I run the EBS Technology Codelevel Checker (ETCC) against my Oracle E-Business Suite PDB?

The EBS Technology Codelevel Checker (ETCC) utility provides two scripts to help ensure you have the necessary database and application tier patches installed on your Oracle E-Business Suite Release 12.2 instance.
ETCC extracts environment-related information from the context file (using the location defined in $CONTEXT_FILE), so you need to source the Oracle E-Business Suite PDB environment before you run the database checker script. For OCI-based environments, you also need to add the cloud=y parameter.
Download ETCC as Patch 17537119 from My Oracle Support and unzip it into a working directory. Then proceed with whichever of the following steps applies to you:
  • For an on-premises environment, run the commands:
    $ source <EBS PDB Name>_<NODE_NAME>.env
    $ ./checkDBpatch.sh
  • For an environment in Oracle Cloud Infrastructure, run the commands:
    $ source <EBS PDB Name>_<NODE_NAME>.env
    $ ./checkDBpatch.sh cloud=y

How do I list the OPatch inventory for a multitenant database?

You can list the OPatch inventory of a multitenant database in the same way as for non-CDB. Run the following commands:
$ source <CDB_NAME>_<NODE_NAME>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ opatch lsinventory -detail

How do I set up the environment to install a database patch in an Oracle E-Business Suite multitenant database?

Source the CDB environment and add the OPatch directory to the path, as shown in the following example:
$ source <CDB_NAME>_<NODE_NAME>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch
Note: Before running datapatch, ensure that the Oracle E-Business Suite PDB is open as datapatch will only apply or roll back SQL fixes for open PDBs. For more information, refer to My Oracle Support Knowledge Document 1585822.1, Datapatch: Database 12c Post Patch SQL Automation.

Oracle E-Business Suite Performance Recommendations

How do I achieve optimal performance with Oracle E-Business Suite?

Refer to My Oracle Support Knowledge Document 2125596.1, Achieving Optimal Performance with Oracle E-Business Suite.

Where do I find the recommended performance patches for Oracle E-Business Suite?

Refer to My Oracle Support Knowledge Document 244040.1, Oracle E-Business Suite Recommended Performance Patches.

Where do I find the recommended initialization parameters for Oracle E-Business Suite?

Refer to My Oracle Support Knowledge Document 396009.1, Database Initialization Parameters for Oracle E-Business Suite Release 12. This document includes two main sections:
  • A common set of database initialization parameters that are applicable to all releases of the Oracle Database
  • An Oracle Database release-specific section
These two sections combine to provide a complete list of release-specific database initialization parameters.

For Oracle E-Business Suite Release 12.1 on Oracle Database 19c, refer to the following:
  • Document 396009.1 - Section 1: Common Database Initialization Parameters For All Releases
  • Document 396009.1 - Section 4: Release-Specific Database Initialization Parameters for Oracle 19c
For Oracle E-Business Suite Release 12.2 on Oracle Database 19c, also refer to the following:
  • Document 396009.1 - Section 5: Additional Database Initialization Parameters For Oracle E-Business Suite Release 12.2
Note: Each database section has a list of parameters in a removal list. These must be removed because they are obsolete or else the default database value is mandatory and no other value may be set.

Oracle E-Business Suite Multitenant Database Diagnostics

How do I find the location of the alert log and trace files for my multitenant database?

Each CDB has an associated alert log, which is used to record log information, warnings and alerts about the Oracle E-Business Suite PDB. It is located in the "Diag Trace" of the container database. Also, all PDBs plugged in a given CDB write trace data to the "Diag Trace" of the container database, which can be found by querying v$diag_info dynamic view as in the following example:
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> select value from v$diag_info where name = 'Diag Trace';

How do I generate an AWR snapshot report for my pluggable database?

In Oracle Database 12c Release 1, AWR snapshots are only created at the CDB-level (CDB root). This AWR snapshot is for the whole database system in that it contains the statistical information about the CDB as well as all the PDBs in a multitenant environment.
Oracle 19c multitenant supports AWRs at the CDB and PDB level. There are two new views:
  • AWR_ROOT view: This shows the AWR data stored only on a CDB root, which are generally equivalent to the DBA_HIST views.
  • AWR_PDB view: There are a few PDB-level metrics, but the vast majority are instance-wide statistics that are not shown at this level for security reasons. Hence these will not be flushed in AWR, and will always be shown as 0 in the AWR report.
Use the following commands as a basis to create a snapshot and specify AWR_ROOT or AWR_PDB as appropriate:
$ source <CDB_NAME>_<NODE_NAME>.env
$ export ORACLE_PDB_SID=<PDB NAME>;
$ sqlplus "/ as sysdba"
# Run awrrpt.sql file
SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql
...
...
Specify the location of AWR Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
AWR_ROOT - Use AWR data from root (default)
AWR_PDB - Use AWR data from PDB
...

Change Log

DateDescription
2019-10-11
  • Made some minor updates.
2019-10-10
  • Initial publication.
at 2 comments:
Subscribe to: Posts (Atom)

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

  Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...