|
|
| Line 1: |
Line 1: |
| − | ===Post Installation Tasks===
| |
| | [[Oracle_Switching_OnOff_Options|Switching On/Off Options (11g-R2)]] | | [[Oracle_Switching_OnOff_Options|Switching On/Off Options (11g-R2)]] |
| − |
| |
| − | After an Installation of Oracle Software, you may wish to turn off certain features.
| |
| − |
| |
| − | These are the steps.
| |
| − |
| |
| − | Check v$option to see what options are turned on/off
| |
| − | <blockquote><pre>
| |
| − | Connected.
| |
| − | SQL> set lines 1000
| |
| − | SQL> select * from v$option;
| |
| − |
| |
| − | PARAMETER VALUE
| |
| − | ---------------------------------------------------------------- ----------------------------------------------------------------
| |
| − | Real Application Clusters FALSE
| |
| − | Oracle Label Security FALSE
| |
| − | Oracle Database Vault FALSE
| |
| − |
| |
| − | SQL> select * from v$option;
| |
| − |
| |
| − | PARAMETER VALUE
| |
| − | ---------------------------------------------------------------- ----------------------------------------------------------------
| |
| − | Partitioning TRUE
| |
| − | Objects TRUE
| |
| − | Real Application Clusters FALSE
| |
| − | Advanced replication TRUE
| |
| − | Bit-mapped indexes TRUE
| |
| − | Connection multiplexing TRUE
| |
| − | Connection pooling TRUE
| |
| − | Database queuing TRUE
| |
| − | Incremental backup and recovery TRUE
| |
| − | Instead-of triggers TRUE
| |
| − | Parallel backup and recovery TRUE
| |
| − |
| |
| − | PARAMETER VALUE
| |
| − | ---------------------------------------------------------------- ----------------------------------------------------------------
| |
| − | Parallel execution TRUE
| |
| − | Parallel load TRUE
| |
| − | Point-in-time tablespace recovery TRUE
| |
| − | Fine-grained access control TRUE
| |
| − | Proxy authentication/authorization TRUE
| |
| − | Change Data Capture TRUE
| |
| − | Plan Stability TRUE
| |
| − | Online Index Build TRUE
| |
| − | Coalesce Index TRUE
| |
| − | Managed Standby TRUE
| |
| − | Materialized view rewrite TRUE
| |
| − |
| |
| − | PARAMETER VALUE
| |
| − | ---------------------------------------------------------------- ----------------------------------------------------------------
| |
| − | Database resource manager TRUE
| |
| − | Spatial TRUE
| |
| − | Automatic Storage Management TRUE
| |
| − | Export transportable tablespaces TRUE
| |
| − | Transparent Application Failover TRUE
| |
| − | Fast-Start Fault Recovery TRUE
| |
| − | Sample Scan TRUE
| |
| − | Duplexed backups TRUE
| |
| − | Java TRUE
| |
| − | OLAP Window Functions TRUE
| |
| − | Block Media Recovery TRUE
| |
| − |
| |
| − | PARAMETER VALUE
| |
| − | ---------------------------------------------------------------- ----------------------------------------------------------------
| |
| − | Fine-grained Auditing TRUE
| |
| − | Application Role TRUE
| |
| − | Enterprise User Security TRUE
| |
| − | Oracle Data Guard TRUE
| |
| − | Oracle Label Security FALSE
| |
| − | OLAP FALSE
| |
| − | Basic Compression TRUE
| |
| − | Join index TRUE
| |
| − | Trial Recovery TRUE
| |
| − | Data Mining FALSE
| |
| − | Online Redefinition TRUE
| |
| − |
| |
| − | PARAMETER VALUE
| |
| − | ---------------------------------------------------------------- ----------------------------------------------------------------
| |
| − | Streams Capture TRUE
| |
| − | File Mapping TRUE
| |
| − | Block Change Tracking TRUE
| |
| − | Flashback Table TRUE
| |
| − | Flashback Database TRUE
| |
| − | Transparent Data Encryption TRUE
| |
| − | Backup Encryption TRUE
| |
| − | Unused Block Compression TRUE
| |
| − | Oracle Database Vault FALSE
| |
| − | Result Cache TRUE
| |
| − | SQL Plan Management TRUE
| |
| − |
| |
| − | PARAMETER VALUE
| |
| − | ---------------------------------------------------------------- ----------------------------------------------------------------
| |
| − | SecureFiles Encryption TRUE
| |
| − | Real Application Testing TRUE
| |
| − | Flashback Data Archive TRUE
| |
| − | DICOM TRUE
| |
| − | Active Data Guard TRUE
| |
| − | Server Flash Cache TRUE
| |
| − | Advanced Compression TRUE
| |
| − | XStream TRUE
| |
| − | Deferred Segment Creation TRUE
| |
| − |
| |
| − | 64 rows selected.
| |
| − | </pre></blockquote>
| |
| − |
| |
| − |
| |
| − | Shutdown the Database:
| |
| − | <blockquote><pre>
| |
| − | srvctl stop database -d DBNAME
| |
| − | </pre></blockquote>
| |
| − |
| |
| − |
| |
| − | Invoke the Change Option Utility. This essentially invokes the ins_rdbms.mk commands used by previous versions.
| |
| − | <blockquote><pre>
| |
| − | oracle:DBNAME> $ORACLE_HOME/bin/chopt
| |
| − |
| |
| − | usage:
| |
| − |
| |
| − | chopt <enable|disable> <option>
| |
| − |
| |
| − | options:
| |
| − | dm = Oracle Data Mining RDBMS Files
| |
| − | dv = Oracle Database Vault option
| |
| − | lbac = Oracle Label Security
| |
| − | olap = Oracle OLAP
| |
| − | partitioning = Oracle Partitioning
| |
| − | rat = Oracle Real Application Testing
| |
| − |
| |
| − | e.g. chopt enable rat
| |
| − | </pre></blockquote>
| |
| − |
| |
| − | <blockquote><pre>
| |
| − | $ORACLE_HOME/bin/chopt disable rat
| |
| − |
| |
| − | Writing to /oracle/11.2.0.3.0/dbhome_1/install/disable_rat.log...
| |
| − | /usr/ccs/bin/make -f /oracle/11.2.0.3.0/dbhome_1/rdbms/lib/ins_rdbms.mk rat_off ORACLE_HOME=/oracle/11.2.0.3.0/dbhome_1
| |
| − | /usr/ccs/bin/make -f /oracle/11.2.0.3.0/dbhome_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/oracle/11.2.0.3.0/dbhome_1
| |
| − | </pre></blockquote>
| |
| − |
| |
| − |
| |
| − |
| |
| − | Startup the Database
| |
| − | <blockquote><pre>
| |
| − | srvctl start database -d DBNAME
| |
| − | </pre></blockquote>
| |
| − |
| |
| − | Check v$option again
| |
| − | <blockquote><pre>
| |
| − | Connected.
| |
| − | SQL> set lines 1000
| |
| − | SQL> select * from v$option where value='FALSE';
| |
| − |
| |
| − | PARAMETER VALUE
| |
| − | ---------------------------------------------------------------- ----------------------------------------------------------------
| |
| − | Real Application Clusters FALSE
| |
| − | Oracle Label Security FALSE
| |
| − | OLAP FALSE
| |
| − | Data Mining FALSE
| |
| − | Oracle Database Vault FALSE
| |
| − | Real Application Testing FALSE
| |
| − |
| |
| − | 6 rows selected.
| |
| − | </pre></blockquote>
| |
