• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

ORA-65208: Lockdown profile P1 does not exist

by admin

The Problem

The following error is generated when creating a lockdown profile in application container of a PDB database.

ORA-65208: Lockdown profile P1 does not exist.

The Solution

When pdb_lockdown parameter is set in an application container using a CDB common user(e.g SYS), we look up lockdown profile defined in the CDB ROOT. In this test case, clearly, there is a lockdown profile name p1 defined in CDB$ROOT which doesn’t have OS_ACCESS disabled. If there was no lockdown profile named p1 in CDB$ROOT, the setting would have failed as below:

SQL> alter system set pdb_lockdown=p1;
alter system set pdb_lockdown=p1
*
ERROR at line 1:
ORA-65208: Lockdown profile P1 does not exist.

To test lockdown profiles created in APP ROOT, please use an application common user with appropriate privileges to set pdb_lockdown in the application container. (I understand that SYS can create lockdown profiles in APP ROOT but he can only set pdb_lockdown to a lockdown profile defined in CDB$ROOT)

SQL> alter system set pdb_lockdown=c##p2;

System altered.

Filed Under: oracle, oracle 12c

Some more articles you might also be interested in …

  1. Oracle RAC Interview Questions – Coherence and Split-Brain
  2. How to switch roles in Oracle Data Guard
  3. Understanding Transparent Data Encryption and Keystores in RAC
  4. Oracle ASM 12c – New Features with examples
  5. Oracle Database 12c New Feature: Transaction Guard and Application Continuity
  6. RMAN ‘Duplicate From Active Database’ Feature in Oracle 11g
  7. List of Operating System Processes Started by the OMS
  8. How to Enable or Disable Automated Statistics Collection in Oracle Database
  9. What users and roles are created during Oracle SQLT installation
  10. Oracle 12c: Migrate non-CDB and Convert to a PDB using 12c RMAN Active Database Duplication

You May Also Like

Primary Sidebar

Recent Posts

  • qemu-system-x86_64: command not found
  • timedatectl: command not found
  • mpirun.openmpi: command not found
  • startkde: command not found

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright