Month: March 2018

Migrate Database to CDB environment with different DB_BLOCK_SIZE

arcsdegeoLeave a comment

If you face a situation where you need to plugin a database that has a different block size than the destination CDB then you need perform the following:

Let us assume that the source database that will be plugged is configured with 16k block size , but the destination CDB environment is configured for 8k as shown below:

SQL> show parameter db_block_size

P1

In the CDB$root container execute the following:

SQL> alter system set db_16k_cache_size=200M scope=spfile;

//note i am using db_nk_cache_size parameter

Restart your CDB instance. And then try to plug-in the database.

Always check pdb_plug_in_violations view for any issues:

SQL> select message,time from pdb_plug_in_violations;

If I try to create a tablespace with 16K size ….. you will be able to create a tablespace successfully  with no issues:

P2

 

 

 

 

 

 

 

 

 

 

 

 

 

ORACLE_MAINTAINED column in Oracle 12c dictionary

arcsdegeoLeave a comment

Lets say someone asked you what are the Oracle database built-in accounts (Oracle internal) in your current database ?

Most oracle database dictionary views have a column called ORACLE_MAINTAINED that was introduced in Oracle 12c release.

https://docs.oracle.com/database/121/REFRN/GUID-309FCCB2-2E8D-4371-9FC5-7F3B10E2A8C0.htm#REFRN23302

 

SQL> select username,last_login,oracle_maintained from dba_users where oracle_maintained=’Y’;

Picture1

Finding Oracle built-in roles:

 

SQL> select role,oracle_maintained from dba_roles where oracle_maintained=’Y’;

Picture22