Pages

Advertisement

Thursday, December 20, 2018

Oracle Database - 12c/18c - Enabling/Disabling Database Options (chopt)

 
In this blog I am going to cover on how to enable and disable database options in 12c/18c of Database.
You can get help by running the utility without any options
(Set the environment prior)

 Ensure that all databases and listeners running from Oracle Home are stopped before running this. 
$ORACLE_HOME/bin/chopt

 usage:

 chopt <enable|disable> <option>

 options:
                 oaa = Oracle Advanced Analytics
                olap = Oracle OLAP
        partitioning = Oracle Partitioning
                 rat = Oracle Real Application Testing
e.g. chopt enable rat


 To Disable an option use as below 

 $chopt disable rat

 Writing to /opt/oracle/product/180/db/install/disable_rat_2018-12-20_05-15-13AM.log...
/usr/bin/make -f /opt/oracle/product/180/db/rdbms/lib/ins_rdbms.mk rat_off ORACLE_HOME=/opt/oracle/product/180/db
/usr/bin/make -f /opt/oracle/product/180/db/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/opt/oracle/product/180/db


 Note - you can run the utility twice and it will not tell you if the option is enabled or not. 

 $ chopt disable oaa

 Writing to /opt/oracle/product/180/db/install/disable_oaa_2018-12-20_05-16-24AM.log...
/usr/bin/make -f /opt/oracle/product/180/db/rdbms/lib/ins_rdbms.mk dm_off ORACLE_HOME=/opt/oracle/product/180/db

/usr/bin/make -f /opt/oracle/product/180/db/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/opt/oracle/product/180/db
Finally start a instance in no-mount / mount mode to ensure your changes are applied

 set lines 500 pages 500
col parameter for a50

col value for a50

   1* select * from V$option where parameter like '%Real%' or parameter like '%Analytics%'

 PARAMETER                                          VALUE                                                  CON_ID
-------------------------------------------------- -------------------------------------------------- ----------
Real Application Clusters                          FALSE                                                       0
Advanced Analytics                                 FALSE                                                       0
Real Application Testing                           FALSE                                                       0
Real Application Security                          TRUE                                                        0

Similarly to enable use
$chopt enable oaa

 Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ssdbi/chopt-tool.html#GUID-057E4EFC-74ED-43B3-B03B-C83C5A5D3C7F

Tuesday, December 18, 2018

Oracle Database - Exadata and Exadata Cloud - Important MoS Doc ID's

 
In this blog  I will write on all the important links for Exadata which will be useful to you. 
This are very helpful links, which can help you keep updated with Exadata DB Machine in premise or if you are servicing one for a customer. 

 So keep them handy.. :)

  1. Exadata Database Machine and Exadata Storage Server Supported Versions (Doc ID 888828.1)
  2. Engineered Systems Resource Center - Doc ID 1392174.1 
  3. Information Center: Oracle Exadata Database Machine - Doc ID 1306791.1  
  4. Information Center: Using Oracle Exadata Database Machine - Doc ID 1460198.2 
  5. Information Center: Upgrading Oracle Exadata Database Machine - Doc ID 1364356.2
  6. Exadata System Software Certification - Doc ID 2075007.1 
  7. Exadata Storage Software Versions Supported by the Oracle Enterprise Manager Exadata Plug-in - Doc ID 1626579.1 
  8. Exadata Software and Hardware Support Lifecycle- Doc ID 1570460.1 
  9. Oracle Exadata Best Practices – Doc ID 757552.1 
  10. Oracle Exadata Database Machine Setup/Configuration Best Practices - Doc ID 1274318.1
  11. Exadata Critial Issues - Doc ID 1270094.1
  12.  How To Collect Diagpack Diagnostic Package In Exadata - Doc ID 2226173.1
  13. Oracle Exadata Database Machine exachk or HealthCheck – Doc ID 1070954.1

    Exadata Cloud
  14. Information Center: Oracle Database Exadata Cloud - Doc ID 2334729.2
  15. Information Center: Patching and Maintaining Oracle Database Exadata Cloud - Doc ID 2334779.2
  16. Known Issues for Oracle Database Exadata Cloud Service - Doc ID 2249093.1
  17. Exadata Cloud Service Software Versions - Doc ID 2333222.1
  18. Known Issues for Oracle Database Exadata Cloud Machine - Doc ID 2252305.1
  19. Technology Cloud Services (PaaS and IaaS) Maintenance Schedule - Doc ID 2131053.2

Oracle Database - 18c Important Documentation and Patch Information

 
In this blog I discuss important documentation on Database 18c. 
It lists the important links which you require when thinking of Database 18c. 
This list is quite handy for Database Administrators of 18c when planning new installation, upgrade or finding about new features of 18c.

 The Patch information in the end is a quick link to find and download the Patches for this release. 

  1. Oracle Database 18c Documentation
  2. Oracle Database 18c Tutorials
  3. Information Center: Oracle Database 18c - Doc ID 2446877.2
  4. Oracle 18c - Complete Checklist for Upgrading to Oracle Database 18c (18.x) using DBUA - Doc ID 2418576.1
  5. Oracle Database Install 18c FAQ : Changes,New Features(RPM Based Install & Read Only Oracle Home & Other Features) - Doc ID 2438532.1
  6. Oracle Warehouse Management Cloud - Documentation for Update 18C - Doc ID 2438264.1
  7. Database 18 Release Updates and Revisions Bugs Fixed Lists - Doc ID 2369471.1
  8. How To Configure Authentication For The Centrally Managed Users In An 18c Database - Doc ID 2462012.1
  9. Updated - Database 18 Proactive Patch Information - Doc ID 2369376.1
  10. Updated - Oracle Database / Grid Infrastructure / OJVM Release Update and Release Update Revision R18 Oct 2018 Known Issues - Doc ID 2433586.1
  11. Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)


Oracle Database - Release Support Summary and Alert Status

 
In this blog, I am writing about important MoS DoC ID's which help you in good navigation to better understand the support and status of different release starting from Oracle 9i. 

 It also lists a lot of other information as you browse through. 

 The key document is the Release support summary which helps you to know the supported dates of different releases.

 It is a good idea to follow these documents time to time as per the release you are working on.
  1. Oracle Server (RDBMS) Releases Support Status Summary – Doc ID 161818.1
  2. ALERT: Oracle 9i Release 2 (9.2) Support Status and Alerts – Doc ID 189908.1
  3. ALERT: Oracle 10g Release1 (10.1) Support Status and Alerts - Doc ID 263719.1
  4. ALERT: Oracle 10g Release 2 (10.2) Support Status and Alerts - Doc ID 316900.1
  5. ALERT: Oracle 11g Release 1 (11.1) Support Status and Alerts - Doc ID 454507.1
  6. ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts - Doc ID 880782.1
  7. ALERT: Oracle 12c Release1 (12.1) Support Status and Alerts - Doc ID 1565065.1
  8. ALERT: Oracle 12c Release 2 (12.2) Support Status and Alerts - Doc ID 2239821.1




Popular Posts

© Copyright 2019 DBA to DA. . Powered by Blogger.