“Oracle *daily* TidBits” (#oratidbit) published newly at https://www.facebook.com/oraclenotes on weekdays in December 2014. 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 Advanced Network Compress in #DB12c is enabled by setting SQLNET.COMPRESSION=ON in server SQLNET.ORA file and in client SQLNET.ORA or TNSNAMES.ORA file. SQLNET.COMPRESSION_LEVELS and SQLNET.COMPRESSION_THRESHOLD can be set to fine tune compression. |
| 2-Dec | #oratidbit In #OracleEBS #R12 autoconfig can be invoked in parallel using the -parallel option. “perl $AD_TOP/bin/adconfig.pl contextfile= [product=] –parallel” |
| 3-Dec | #oratidbit Starting with Oracle #DB12c, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has changed from 8 to 11. The use of this parameter has been deprecated, and is replaced with the SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameters. Pay attention to this if you plan to use older client versions to connect to 12c database. |
| 4-Dec | #oratidbit When (manually) upgrading RAC database to #DB12c, set the CLUSTER_DATABASE parameter to FALSE before upgrade, and after upgrade set the parameter value back to TRUE. |
| 5-Dec | #oratidbit In #EBS 11i and R12, the Patch Wizard tool built into Oracle Applications Manager can recommend patches for your Oracle E-Business Suite system. The wizard takes patch data downloaded from Oracle, analyzes that data against the Oracle E-Business Suite system, and recommends patches based on criteria you specify. The wizard can also analyze individual patches, identify any prerequisites missing on the system, and show the impact that the patches would have on the system in terms of affected applications, files, and other areas. Additionally, the wizard can download multiple patches from Oracle and merge them into a single patch. |
| 9-Dec | #oratidbit In #EBSR12 by default, Forms services are provided by the Forms listener servlet, which facilitates the use of firewalls, load balancing, proxies, and other networking options. However, socket mode is still supported, and may be useful in high-latency, bandwidth-constrained WAN environments. |
| 10-Dec | #oratidbit The catupgrd.sql upgrade script is deprecated in Oracle #DB12c. The Parallel Upgrade Utility, catctl.pl replaces catupgrd.sql. |
| 15-Dec | Best practice: Run DBMS_VERIFIER.EXPIRE_ACCOUNTS_WITHOUT_LATEST_VERIFIER after upgrading database to #DB12c to force users whose accounts do not yet have the latest verifier to change their passwords the next time they log in. This is to enforce case sensitivity for passwords. |
| 16-Dec | In #EBSR12, the AutoConfig log files are stored under /admin/log/ on the Application tier, and /appsutil/log// on the Database tier. |
| 17-Dec | #oratidbit In #DB12c the In-Memory area size is controlled by the initialization parameter INMEMORY_SIZE (default 0), which is a static pool within the SGA.Database In-Memory uses an In-Memory column store (IM column store), which is a new component of the Oracle Database System Global Area (SGA), called the In-Memory Area. Data in the IM column store does not reside in the traditional row format used by the Oracle Database; instead it uses a new column format. The In-Memory area does not replace the buffer cache, but acts as a supplement, so that data can now be stored in memory in both a row and a column format. |
| 18-Dec | #oratidbit In #DB12c, the In-Memory area is sub-divided into two pools: a 1MB pool used to store the actual column formatted data populated into memory, and a 64K pool used to store metadata about the objects that are populated into the IM column store. The amount of available memory in each pool is visible in the V$INMEMORY_AREA view. |
| 19-Dec | #oratidbit In #DB12c, Only objects with the INMEMORY attribute are populated into the IM column store. The INMEMORY attribute can be specified on a tablespace, table, partition, sub-partition or materialized view. If it is enabled at the tablespace Oracle Database In-Memory option level, then all new tables and materialized views in the tablespace will be enabled for the IM column store by default. |
| 22-Dec | #oratidbit #EM12c The EM CLI OMS is automatically installed with the OMS, but you must download and set up the EM CLI client portion. Obtain the standard EM CLI client kit emclikit.jar from any 12.1.0.3 or later Cloud Control installation by going to the Setup menu in OEM 12c CC, select Command Line Interface and click the Download the EM CLI Standard Kit to your workstation link. |
| 23-Dec | #oratidbit #EM12c EMCLI offers three modes of operation – Command, Script and Interactive. Script mode is effective when performing tasks in bulk mode or many tasks at once. |
| 31-Dec | #oratidbit In #Db12c, DBA_OPTSTAT_OPERATIONS view contains history of statistics operations performed or currently in progress at the table, schema, and database level using the DBMS_STATS package. |