Oracle TidBits – December 2015

Oracle *daily* TidBits” (#oratidbit) published at on weekdays in December 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
1-Dec #oratidbit After software only Oracle cluster install, configure the cluster using $ORACLE_HOME/crs/config/ wizard. The wizard can configure one node, multiple nodes or upgrade Oracle Grid Infrastructure.
2-Dec #oratidbit Oracle Cluster Registry is managed using the ocrconfig utility. Use ocrconfig to add, remove, replace, repair, backup, restore Oracle Cluster Registry Location.
3-Dec #oratidbit In Oracle Clusterware, each node in a cluster has a local registry for node-specific resources called Oracle Local Registry (OLR), that is installed and configured when Oracle Clusterware installs OCR.
4-Dec #oratidbit olsnodes command provides the list of nodes participating in the cluster. Use olsnodes to quickly check cluster is operational, and all nodes are registered as members of the cluster.
7-Dec #oratidbit V$OBSOLETE_PARAMETER displays information about obsolete initialization parameters. If any row of the view contains TRUE in theISSPECIFIED column, then you should examine why.
8-Dec #oratidbit V$PATCHES shows the patches applied on an Oracle ASM instance and the list of patches applied to an Oracle Grid infrastructure home directory.
9-Dec #oratidbit V$RESERVED_WORDS displays a list of all SQL keywords. To determine whether a particular keyword is reserved in any way, check theRESERVED, RES_TYPE, RES_ATTR, and RES_SEMI columns.
10-Dec #oratidbit V$SESSION_BLOCKERS displays the blocker sessions for each blocked session. Each row represents a blocked and blocker session pair. If a session is blocked by multiple sessions there will be multiple rows for that blocked session.
11-Dec #oratidbit In #DB12c, V$BACKUP_NONLOGGED view displays information about nonlogged block ranges in data file backups recorded in the control file.
14-Dec #oratidbit DBMS_ROLLING PL/SQL package is used to implement 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.
16-Dec #oratidbit DBA_PDB_SAVED_STATES dictionary view shows information about the current saved PDB states in the CDB.
#oratidbit Set NONCDB_COMPATIBLE=TRUE parameter if have a single PDB in CDB configuration and have legacy code that causes ORA-65040 when you run it in the PDB.
21-Dec #oratidbit In CDB 12c architecture, standby recovery is always at the CDB level. ALTER PLUGGABLE DATABASE RECOVER statement is not supported on the standby.
22-Dec #oratidbit in CDB 12c standby architecture, redo from primary must always shipped to the service defined on the root container (CON_ID=1).
23-Dec #oratidbit #OEM13c Brownouts: monitoring continues during planned maintenance of targets but no notifications are sent.
24-Dec #oratidbit DB12c is the only supported database for #OEM13c 13.1 install.
25-Dec #oratidbit In #OEM13c BI Publisher is integrated. You have option to enable BIP during OEM 13c install.
28-Dec #oratidbit When installing #OEM13c, AL32UTF8 is the strongly recommended character set for EM repository.
29-Dec #oratidbit #OEM13c install distribution comes with database template with core sysman schema and predefined repository parameters.
30-Dec #oratidbit V$PARAMETER_VALID_VALUES displays a list of valid values for list initialization parameters.
31-Dec #oratidbit V$CON_SYSSTAT displays system statistics, including OLAP kernel statistics for the container from which it is queried.

Leave a Reply

%d bloggers like this: