Connect to RMAN using OS authentication and take a full backup using the following command. You have to provide DB name, admin user name i.e. ALTER SESSION SET container=CDB$ROOT; You can then run the SQL that you want to on the container you're connected to. John demonstrates plugging in a 12c database into a mutlitenant Container Database (CDB). In this way, we successfully fix the ORA-01033 error, to unlock th HR schema object. How to Install and Configure Oracle RAC 12c - The Geek Search We have found the alert log for container database. Check Oracle Label Security and DB Vault Options are installed. What i am trying do is check connection to a oracle db using a perl script running in another container using the following code #!/usr/bin/perl u. Click next SET LINES 132 PAGES 100 COL con_name FORM A15 HEAD "Container|Name" COL tablespace_name FORM A15 COL fsm FORM 999,999,999,999 HEAD "Free|Space Meg." COL apm FORM 999,999,999,999 […] Non CDB is similar database present in old oracle version like 11g ,10g ,9i etc. SQL> alter session set container=icapdb1; ORACLE-BASE - Multitenant : Create and Configure a Container Database ... 65096, 00000, "invalid common user or role name". You can query the CDB column in the V$DATABASE view to determine whether a database is a CDB or a non-CDB. Starting with Oracle 12.1, you can now use the command ALTER DATABASE MOVE DATAFILE in order to rename, relocate, or copy a datafile when the datafiles or the database are online. 1. Step 15. show user; When you hit the Enter key, it shows USER is "HR". I have an oracle db 12c running in a container. The Select Database Options step appears. Some additional environment variables are required to be set for proper functioning. Because of this sharing of memory resources, it would be desirable to . Using an Oracle 12c Database with WebLogic Server 12.1.1 and 10.3.6