Oracle Database

This is a collection of notes related to database issues.

Multitenant

Cloning a remote-PDB as a PDB
Cloning a non-CDB as a PDB
PDB plugin violations
PDB Needs to import keys from source error

ADW

ADP: dbms_cloud/copy_data and record delimiter
CMAN Connection manager 18c setup for ATP/ADW

HA

Manual standby setup
Rman setup with DG
Standby recreation fails with ORA-19870 ORA-19573
DG: How to fix inconsistencies
DG: Registering a farsync instance in the clusterware

 

DBaaS and dbsystems on OCI and

DBSystems: Issues with upgrading to 19.6.0.190416
DBaaS: patching issues upgrading 180116
DBaaS: prereq check and patching on oci-c

Misc

ORA-1017 troubleshooting
TNS-12537 TNS-12560 TNS-00507
ORA-15041 Troubleeshooting At least one disk in the diskgroup is out of space
Support for varchar2 32k
dbaas_monitor password change
ORACLE_HOME cloning
How to upgrade the javavm after a database upgrade
How to configure the wallet before making outbound https calls.
Handy tools to convert gifs files into base64 encoding for utl_http
How to delete obsolete snapshot controlfile copy
Stats: Occupancy, retention and purge