4 Replies Latest reply: Apr 18, 2013 6:09 AM by david lozano RSS

    How to uninstall Oracle 11g Database Options?

    david lozano
      I've come across a problem. A company that developed an application, installed Oracle 11g EE.

      I guess they would use all default options. Some of them are licensed separately, and are not used. So I need to uninstall them.

      For example, I see that it is installed "Advanced Compression". I tried to uninstall it from the Universal Installer, but there isn't an option.
        • 1. Re: How to uninstall Oracle 11g Database Options?
          FreddieEssex
          In Oracle 11g you can not uninstall options by running the runInstaller as you could in previous releases.

          With specific regards to Advanced Compression the answer is : You can't uninstall. Check out *Can The Advanced Compression Option (ACO) Be Disabled Or Uninstalled? [ID 1459216.1].*

          Check out MOS for any other options you may wish to de-install as there may possibly be a way to do it.

          For example: *How To Remove the Data Mining Option from the Database [ID 297551.1]*

          Another option is to re-install the Oracle Home using the Custom install and don't install some options you don't require. Advanced Compression isn't one of them but Partitioning and Label Security are amongst others.

          If you're not using the feature. then there shouldn't be an issue really.
          • 2. Re: How to uninstall Oracle 11g Database Options?
            david lozano
            Thank you very much Freddie,

            That answers my question.

            My concern is that Oracle will do an audit in the coming days, and if we are not using this option it is possible that they want us to pay it.
            • 3. Re: How to uninstall Oracle 11g Database Options?
              FreddieEssex
              Possible?? I would say it's probable :-)

              You can run the following code to see what is/has been used:
              select name, version, DETECTED_USAGES, CURRENTLY_USED, LAST_USAGE_DATE from dba_feature_usage_statistics order by 3,1,2;
              • 4. Re: How to uninstall Oracle 11g Database Options?
                david lozano
                Good news for my company.

                There has never been used "Advanced Compression" and for everything else we are licensed.


                NAME                                                     VERSION     DETECTED_USAGES CURRENTLY_USED LAST_USAGE_DATE
                -------------------------------------------------------- ----------- --------------- -------------- ---------------
                Active Data Guard - Real-Time Query on Physical Standby  11.2.0.2.0                0 FALSE                          
                ADDM                                                     11.2.0.2.0                0 FALSE                          
                Advanced Replication                                     11.2.0.2.0                0 FALSE                          
                Application Express                                      11.2.0.2.0                0 FALSE                          
                Automatic SGA Tuning                                     11.2.0.2.0                0 FALSE                          
                Automatic Storage Management                             11.2.0.2.0                0 FALSE                          
                Automatic Workload Repository                            11.2.0.2.0                0 FALSE                          
                AWR Baseline                                             11.2.0.2.0                0 FALSE                          
                AWR Baseline Template                                    11.2.0.2.0                0 FALSE                          
                Backup BASIC Compression                                 11.2.0.2.0                0 FALSE                          
                Backup BZIP2 Compression                                 11.2.0.2.0                0 FALSE                          
                Backup Encryption                                        11.2.0.2.0                0 FALSE                          
                Backup HIGH Compression                                  11.2.0.2.0                0 FALSE                          
                Backup LOW Compression                                   11.2.0.2.0                0 FALSE                          
                Backup MEDIUM Compression                                11.2.0.2.0                0 FALSE                          
                Backup Rollforward                                       11.2.0.2.0                0 FALSE                          
                Backup ZLIB Compression                                  11.2.0.2.0                0 FALSE                          
                Baseline Adaptive Thresholds                             11.2.0.2.0                0 FALSE                          
                Baseline Static Computations                             11.2.0.2.0                0 FALSE                          
                Bigfile Tablespace                                       11.2.0.2.0                0 FALSE                          
                Block Media Recovery                                     11.2.0.2.0                0 FALSE                          
                Change Data Capture                                      11.2.0.2.0                0 FALSE                          
                Change-Aware Incremental Backup                          11.2.0.2.0                0 FALSE                          
                Character Semantics                                      11.2.0.2.0                0 FALSE                          
                Client Identifier                                        11.2.0.2.0                0 FALSE                          
                Clusterwide Global Transactions                          11.2.0.2.0                0 FALSE                          
                Compression Advisor                                      11.2.0.2.0                0 FALSE                          
                Crossedition Triggers                                    11.2.0.2.0                0 FALSE                          
                CSSCAN                                                   11.2.0.2.0                0 FALSE                          
                Data Guard                                               11.2.0.2.0                0 FALSE                          
                Data Mining                                              11.2.0.2.0                0 FALSE                          
                Data Recovery Advisor                                    11.2.0.2.0                0 FALSE                          
                Database Replay: Workload Capture                        11.2.0.2.0                0 FALSE                          
                Database Replay: Workload Replay                         11.2.0.2.0                0 FALSE                          
                Deferred Open Read Only                                  11.2.0.2.0                0 FALSE                          
                Direct NFS                                               11.2.0.2.0                0 FALSE                          
                Dynamic SGA                                              11.2.0.2.0                0 FALSE                          
                Editioning Views                                         11.2.0.2.0                0 FALSE                          
                Editions                                                 11.2.0.2.0                0 FALSE                          
                EM Database Control                                      11.2.0.2.0                0 FALSE                          
                Encrypted Tablespaces                                    11.2.0.2.0                0 FALSE                          
                Exadata                                                  11.2.0.2.0                0 FALSE                          
                Extensibility                                            11.2.0.2.0                0 FALSE                          
                File Mapping                                             11.2.0.2.0                0 FALSE                          
                Flashback Data Archive                                   11.2.0.2.0                0 FALSE                          
                Flashback Database                                       11.2.0.2.0                0 FALSE                          
                GoldenGate                                               11.2.0.2.0                0 FALSE                          
                HeapCompression                                          11.2.0.2.0                0 FALSE                          
                Hybrid Columnar Compression                              11.2.0.2.0                0 FALSE                          
                Instance Caging                                          11.2.0.2.0                0 FALSE                          
                Internode Parallel Execution                             11.2.0.2.0                0 FALSE                          
                Label Security                                           11.2.0.2.0                0 FALSE                          
                Locator                                                  11.2.0.2.0                0 FALSE                          
                Long-term Archival Backup                                11.2.0.2.0                0 FALSE                          
                Materialized Views (User)                                11.2.0.2.0                0 FALSE                          
                Messaging Gateway                                        11.2.0.2.0                0 FALSE                          
                Multi Section Backup                                     11.2.0.2.0                0 FALSE                          
                Multiple Block Sizes                                     11.2.0.2.0                0 FALSE                          
                Object                                                   11.2.0.2.0                0 FALSE                          
                OLAP - Analytic Workspaces                               11.2.0.2.0                0 FALSE                          
                OLAP - Cubes                                             11.2.0.2.0                0 FALSE                          
                Oracle Database Vault                                    11.2.0.2.0                0 FALSE                          
                Oracle Java Virtual Machine (user)                       11.2.0.2.0                0 FALSE                          
                Oracle Managed Files                                     11.2.0.2.0                0 FALSE                          
                Oracle Multimedia                                        11.2.0.2.0                0 FALSE                          
                Oracle Multimedia DICOM                                  11.2.0.2.0                0 FALSE                          
                Oracle Secure Backup                                     11.2.0.2.0                0 FALSE                          
                Oracle Text                                              11.2.0.2.0                0 FALSE                          
                Oracle Utility External Table                            11.2.0.2.0                0 FALSE                          
                Oracle Utility SQL Loader (Direct Path Load)             11.2.0.2.0                0 FALSE                          
                PL/SQL Native Compilation                                11.2.0.2.0                0 FALSE                          
                Read Only Tablespace                                     11.2.0.2.0                0 FALSE                          
                Real Application Clusters (RAC)                          11.2.0.2.0                0 FALSE                          
                Real-Time SQL Monitoring                                 11.2.0.2.0                0 FALSE                          
                Recovery Area                                            11.2.0.2.0                0 FALSE                          
                Recovery Manager (RMAN)                                  11.2.0.2.0                0 FALSE                          
                Resource Manager                                         11.2.0.2.0                0 FALSE                          
                Restore Point                                            11.2.0.2.0                0 FALSE                          
                Result Cache                                             11.2.0.2.0                0 FALSE                          
                RMAN - Disk Backup                                       11.2.0.2.0                0 FALSE                          
                RMAN - Tape Backup                                       11.2.0.2.0                0 FALSE                          
                Rules Manager                                            11.2.0.2.0                0 FALSE                          
                SecureFile Compression (system)                          11.2.0.2.0                0 FALSE                          
                SecureFile Compression (user)                            11.2.0.2.0                0 FALSE                          
                SecureFile Deduplication (system)                        11.2.0.2.0                0 FALSE                          
                SecureFile Deduplication (user)                          11.2.0.2.0                0 FALSE                          
                SecureFile Encryption (system)                           11.2.0.2.0                0 FALSE                          
                SecureFile Encryption (user)                             11.2.0.2.0                0 FALSE                          
                Semantics/RDF                                            11.2.0.2.0                0 FALSE                          
                Server Flash Cache                                       11.2.0.2.0                0 FALSE                          
                Services                                                 11.2.0.2.0                0 FALSE                          
                Shared Server                                            11.2.0.2.0                0 FALSE                          
                Spatial                                                  11.2.0.2.0                0 FALSE                          
                SQL Access Advisor                                       11.2.0.2.0                0 FALSE                          
                SQL Performance Analyzer                                 11.2.0.2.0                0 FALSE                          
                SQL Plan Management                                      11.2.0.2.0                0 FALSE                          
                SQL Profile                                              11.2.0.2.0                0 FALSE                          
                SQL Repair Advisor                                       11.2.0.2.0                0 FALSE                          
                SQL Tuning Set (system)                                  11.2.0.2.0                0 FALSE                          
                SQL Tuning Set (user)                                    11.2.0.2.0                0 FALSE                          
                SQL Workload Manager                                     11.2.0.2.0                0 FALSE                          
                Streams (system)                                         11.2.0.2.0                0 FALSE                          
                Streams (user)                                           11.2.0.2.0                0 FALSE                          
                Transparent Data Encryption                              11.2.0.2.0                0 FALSE                          
                Transparent Gateway                                      11.2.0.2.0                0 FALSE                          
                Transportable Tablespace                                 11.2.0.2.0                0 FALSE                          
                Tune MView                                               11.2.0.2.0                0 FALSE                          
                Undo Advisor                                             11.2.0.2.0                0 FALSE                          
                Very Large Memory                                        11.2.0.2.0                0 FALSE                          
                Workspace Manager                                        11.2.0.2.0                0 FALSE                          
                XDB                                                      11.2.0.2.0                0 FALSE                          
                XStream In                                               11.2.0.2.0                0 FALSE                          
                XStream Out                                              11.2.0.2.0                0 FALSE                          
                XStream Streams                                          11.2.0.2.0                0 FALSE                          
                ASO native encryption and checksumming                   11.2.0.2.0                1 FALSE          20/10/12        
                Segment Advisor (user)                                   11.2.0.2.0                1 FALSE          08/03/13        
                SQL Tuning Advisor                                       11.2.0.2.0                2 FALSE          09/02/13        
                AWR Report                                               11.2.0.2.0                3 FALSE          09/02/13        
                Oracle Utility Datapump (Import)                         11.2.0.2.0                3 FALSE          26/05/12        
                EM Performance Page                                      11.2.0.2.0                5 FALSE          20/10/12        
                SQL Monitoring and Tuning pages                          11.2.0.2.0                5 FALSE          20/10/12        
                Job Scheduler                                            11.2.0.2.0                6 TRUE           13/04/13        
                Segment Shrink                                           11.2.0.2.0                6 TRUE           13/04/13        
                EM Grid Control                                          11.2.0.2.0               27 FALSE          15/03/13        
                Automatic SQL Execution Memory                           11.2.0.2.0               35 TRUE           13/04/13        
                MTTR Advisor                                             11.2.0.2.0               41 TRUE           13/04/13        
                Parallel SQL DDL Execution                               11.2.0.2.0               56 TRUE           13/04/13        
                Parallel SQL DML Execution                               11.2.0.2.0               56 TRUE           13/04/13        
                Parallel SQL Query Execution                             11.2.0.2.0               61 TRUE           13/04/13        
                Oracle Utility Datapump (Export)                         11.2.0.2.0               93 TRUE           13/04/13        
                Oracle Utility Metadata API                              11.2.0.2.0               93 TRUE           13/04/13        
                Automatic Segment Space Management (user)                11.2.0.2.0               95 TRUE           13/04/13        
                Automatic SQL Tuning Advisor                             11.2.0.2.0               95 TRUE           13/04/13        
                LOB                                                      11.2.0.2.0               95 TRUE           13/04/13        
                Partitioning (user)                                      11.2.0.2.0               95 TRUE           13/04/13        
                Audit Options                                            11.2.0.2.0               96 TRUE           13/04/13        
                Automatic Maintenance - Optimizer Statistics Gathering   11.2.0.2.0               96 TRUE           13/04/13        
                Automatic Maintenance - Space Advisor                    11.2.0.2.0               96 TRUE           13/04/13        
                Automatic Maintenance - SQL Tuning Advisor               11.2.0.2.0               96 TRUE           13/04/13        
                Automatic Memory Tuning                                  11.2.0.2.0               96 TRUE           13/04/13        
                Automatic Segment Space Management (system)              11.2.0.2.0               96 TRUE           13/04/13        
                Automatic Undo Management                                11.2.0.2.0               96 TRUE           13/04/13        
                Character Set                                            11.2.0.2.0               96 TRUE           13/04/13        
                Deferred Segment Creation                                11.2.0.2.0               96 TRUE           13/04/13        
                Locally Managed Tablespaces (system)                     11.2.0.2.0               96 TRUE           13/04/13        
                Locally Managed Tablespaces (user)                       11.2.0.2.0               96 TRUE           13/04/13        
                Logfile Multiplexing                                     11.2.0.2.0               96 TRUE           13/04/13        
                Oracle Java Virtual Machine (system)                     11.2.0.2.0               96 TRUE           13/04/13        
                Partitioning (system)                                    11.2.0.2.0               96 TRUE           13/04/13        
                SecureFiles (system)                                     11.2.0.2.0               96 TRUE           13/04/13        
                SecureFiles (user)                                       11.2.0.2.0               96 TRUE           13/04/13        
                Server Parameter File                                    11.2.0.2.0               96 TRUE           13/04/13        
                Virtual Private Database (VPD)                           11.2.0.2.0               96 TRUE           13/04/13 
                thanks again