OracleNotes

Blog

  • Oracle Tidbits – January 2015

    “Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in January 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use…

    Publish Date TidBit
    2-Jan #oratidbit the SCHEMA_EXPORT_OBJECTS view shows the valid values you can use with EXCLUDE and INCLUDE parameters when using schema level export/import. DATABASE_EXPORT_OBJECTS and TABLE_EXPORT_OBJECTS are views for full database  and table level export/import respectively.
    5-Jan #oratidbit The tables beginning with ROLLING$ owned by SYSTEM are internal system tables used by the DBMS_ROLLING PL/SQL package used to implement the Rolling Upgrade Using Active Data Guard feature, which streamlines the process of upgrading Oracle Database software in a Data Guard configuration in a rolling fashion.
    6-Jan #oratidbit The SYSTEM_PRIVILEGE_MAP table lists all system privileges in the Oracle database. Similar table is STMT_AUDIT_OPTION_MAP.
    7-Jan #oratidbit The EXPTIME column in SYS.USER$ shows the actual password expiration time of the user. The LTIME column shows time when account is locked.
    8-Jan #oratidbit Transparent sensitive data protection (TSDP) is a new feature in #DB12c that enables you to quickly find all table columns in a database that hold sensitive data.
    9-Jan #oratidbit Starting with 11g, the $ORACLE_HOME/rdbms/admin/sql.bsq script is modularized, and calls multiple *.bsq scripts. In #DB12c 12.1.0, there are 25 *.bsq scripts called in sql.bsq.
    14-Jan #oratidbit In #DB12c when Unified Auditing is enabled, audit records are queried from UNIFIED_AUDIT_TRAIL view. For better efficiency, audit records are written to SGA first and not written to disk until the in-memory queues are full. You may force a flush using SYS.DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL procedure.
    15-Jan #oratidbit AUDIT_SYSLOG_LEVEL init parameter enables SYS and standard OS audit records to be written to the system audit log using the SYSLOG utility.
    16-Jan #oratidbit To enable unified auditing in #DB12c, relink the oracle executable using the uniaud_on option.
    cd $ORACLE_HOME /rdbms/lib
    make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
    19-Jan #ortidbit Per MOS DOC 161818.1 Oracle Database (RDBMS) Releases Support Status Summary, 12.1.0.2 is the terminal 12.1 Patch Set and is currently only available for Enterprise Edition.
    20-Jan #oratidbit RAC and DB Support Tools Bundle MOS in Doc 1594347.1. Tools include
    ORAchk (formerly RACcheck)
    Trace File Analyzer Collector (TFA)
    OSWatcher
    Procwatcher
    ORATOP
    SQLT
    Remote Diagnostic Agent (RDA)
    Diagnostic Assistant (DA)
    21-Jan #oratidbit Check out the Databsae Diagnostic tools in MOS DOC 559339.1. Tools include
    ORA-600 Troubleshooting Tool
    ORA-1578 Troubleshooting Tool
    ORA-2730x Troubleshooting Tool
    ORA-3137 Troubleshooting Tool
    ORA-4030 Troubleshooting Tool
    ORA-4031 Troubleshooting Tool
    ORA-7445 Troubleshooting Tool
    ORA-600/ORA-7445 Error Look-up Tool
    Database Upgrade Troubleshooting Tool
    RAC Node Eviction Troubleshooting Tool
    EMDIAG Troubleshooting Tool
    22-Jan #oratidbit Oracle Database Recommended Pathces in MOS DOC 756671.1. Be proactive!
    23-Jan #oratidbit Check out MOS Doc 1555012.2 Troubleshooting Assistant: Oracle Database – Client / Install / Deinstall / Cloning
    26-Jan #oratidbit Use the DBMS_PDB.DESCRIBE procedure on the non-CDB to generate the XML file, which you can use to plug in the non-CDB as PDB to a CDB.
    27-Jan #oratidbit According to MOS Note 742060.1, Oracle Database 12c Release 2 is expected in First Half 2016.
    29-Jan #oratidbit If Oracle Restart is installed, you can manage ASM instance, database instance, ASM diskgroup, listener, database service and Oracle Notification Services (ONS) using SRVCTL.
    30-Jan #oratidbit “srvctl start home” starts all of the components that are managed by Oracle Restart in the specified Oracle home.

  • Pre-Built Oracle Database 12.1.0.2 on VirtualBox

    Step by step screenshots showing the installation of Virtual box and configuring pre-built Oracle Database 12.1.0.2 (including in-memory option). A quick way to get started on Oracle Database 12c. This is a very easy setup, though many do not know how easy it is to get started and playing with Oracle Database 12c on Linux platform using VirtualBox. Hopefully these screens will convince you to download and setup, and start playing with Database 12c and its various options. There are not many complicated steps to get this done, the screens are pretty much self-explanatory!

    First download and Install VirtualBox. Always download the latest and greatest version.

    Then download the pre-built Oracle Database 12c (12.1.0.2) Virtual Host Image file, and import to VirtualBox.

    By default the VM is configured to use only 1GB RAM. This is very low. If your computer has memory, 4G or more for the VM would be really beneficial.

    Good Luck learning Oracle Database 12c!

    [slideshare id=43847027&doc=oracledatabase12cpre-builtonvirtualbox-150124003837-conversion-gate02&type=d]