Difference between revisions of "Oracle"
Jump to navigation
Jump to search
(Created page with "===Post Installation Tasks=== Switching On/Off Options (11g-R2) **************************************************** After an Installatio...") |
|||
| Line 1: | Line 1: | ||
===Post Installation Tasks=== | ===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. | After an Installation of Oracle Software, you may wish to turn off certain features. | ||
Revision as of 21:39, 8 November 2019
Post Installation Tasks
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
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.
Shutdown the Database:
srvctl stop database -d DBNAME
Invoke the Change Option Utility. This essentially invokes the ins_rdbms.mk commands used by previous versions.
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
$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
Startup the Database
srvctl start database -d DBNAME
Check v$option again
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.
