Oracle 12cR1 | Database Components Removal | Non CDB Database Components Removal on 12 1 0 2 version

Описание: #OracleF1 #Database_Components #NonCDB

In this video, briefly demonstrated Oracle Database Components Removal on Non CDB environment on 12.1.0.2 version.

Remove and Clean Up Components from Oracle Database 11.2 – 12.2 - 19c:

Reasons to Clean Up:

There may be many reasons to clean up the option set in an Oracle database. A pre created seed databases from DBCA has all options configured by default. Therefore I did recommend to use your own templates instead and create always a custom database tailored for your environment and needs:

Always create databases as CUSTOM databases
Use your own templates in DBCA to create databases

Amongst the most common reasons to remove an option or a component from an Oracle Database are license topics, faster upgrades and less potential for issues. I don’t justify any of these. But it’s a fact that an Oracle upgrade will run faster in dependency of the number of installed components.

Things to consider - Please Be Aware before doing component Clean Up:

Components removal on database is considered as major surgery on your database, before proceeding with the components removal read the following topics carefully.

If you have no true reason to remove components on your databases, then ignore this clean up series topics

Remove the Oracle demo users SCOTT, SH, OE etc

Take a valid backup before – and ensure that you can restore and recover it

Test on a copy of your database first

Component dependencies exist – see: MOS Note: 2001512.1 for an example in Oracle Database 12.1.0.2

Workarounds are just recommendations – better workarounds may be available

Save your data – component removal may lead to loss of information if the component is in use

XDB is a mandatory component since Oracle Database 12c

Always spool into a file

Procedures work on Linux – on Windows some calls may vary

Finally check with Oracle Support if you have doubts and questions

Special requirements for CDBs:

If you plan to remove components from a Multitenant container database CDB then please consider the following recommendations:

All pluggable database must be opened:

catcon.pl must be used to execute removal scripts in many cases to clean up especially PDB$SEED.

You will find not much documented on component removal yet – therefore my blog posts are proposals only. Please double-check with Oracle Support.

Hope this helps!

Cheers,
Ramesh.

Follow Me On:

YouTube:    / oraclef1  
DBA Blog: https://www.oralgwr.com
LinkedIn:   / ramesh-kumar-krishnamoorthy-3a67ba69  
Twitter:   / sachinrameshdba  
Facebook:   / rameshkumar.krishnamoorthy.9  
Facebook Page:   / oraclef1  
Instagram:   / oraclef1_1