My Oracle Support Banner

ZDLRA - Container Database - Redo_Transport_User - How to create common user on CDB and Recovery Catalog (Doc ID 2148774.1)

Last updated on DECEMBER 22, 2019

Applies to:

Oracle Database Cloud Service - Version N/A and later
Zero Data Loss Recovery Appliance Software - Version 12.1.1.1.1 to 12.1.1.1.1
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Goal

While using ZDLRA as Backup solution, If the customer would like to use a dedicated user account for REDO TRANSPORTATION to implement "Real Time Redo Shipping", we need to create a user with same name on the PROTECTED DATABASE and the ZDLRA Recovery Catalog..

However, while creating user on 12c Protected Database with CDB Option, common user must have C## prepended. But on Recovery catalog which is NOT CREATED with CDB option ( by design ), doesn't allow us to create user with C## prepended..

IMPORTANT : If the protected database is not configured with physical standby, then we no need to create a REDO TRANSPORT USER for real time redo shipping. Only VPC( Virtual Private Catalog ) user has to be created on the Recovery catalog. 

ON ZDLRA RECOVERY CATALOG
===========================
SQL> create user c##rauser identified by ********;
create user c##rauser identified by ********
*
ERROR at line 1:
ORA-65094: invalid local user or role name

ON PROTECTED DATABASE
======================

SQL> create user rauser identified by ********;
create user rauser identified by ********
*
ERROR at line 1:
ORA-65096: invalid common user or role name

 


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.