By: @SQLDaily Tables: Databases for Developers #1

Tables are the foundation of your database. There are several types of table available in Oracle Database.

In this episode, Chris gives an overview of the tables you can use.

Subscribe for more videos on database, SQL and magic: https://www.youtube.com/c/TheMagicofS...

For daily SQL tips follow SQLDaily on Twitter: https://twitter.com/sqldaily

============================

The Magic of SQL with Chris Saxon

Reminder: EBS 12.2 Minimum Patching Baselines and Dates

Oracle E-Business Suite 12.2 is now covered by Premier Support to September 30, 2023. This is documented here: Oracle Lifetime Support Policy: Oracle Applications (PDF) Premier Support includes new EBS 12.2 patches for: Individual product families (e.g. Oracle Financials) Quarterly security updates released via the Critical Patch Update process New technology stack certifications with server-based components New certifications for end-user desktops and mobile devices What are the minimum patching baselines for EBS 12.2? The minimum patching baselines for EBS 12.2 have not changed.  New EBS 12.2 patches are created and tested against the minimum patching baseline documented in Section 4.1, "E-Business Suite 12.2 Minimum Prerequisites" in this document: E-Business Suite Error Correction Support Policy (Note 1195034.1) All EBS 12.2 customers must apply the minimum patch prerequisites to be eligible for Premier Support. Those patches include the suite-wide EBS 12.2.3 Release Update Pack and a small number of technology stack infrastructure updates.  Instead of applying the minimum baseline  Many new updates have been released since that patching baseline was originally published. These new patches contain stability, performance, and security-related updates and are strongly recommended for all customers.  If you haven't applied any of those updates yet, the simplest solution would be to apply the latest suite-wide EBS 12.2.6 Release Update Pack (RUP). That way, you get all of the 12.2 minimum patching requirements and the latest updates simultaneously.  If you've reached this blog article via a search engine, it is possible that a new Release Update Pack has been released since this article was first published. Click on the "Certifications" link in the sidebar for a pointer to the latest EBS 12.2 RUP. Related Articles Reminder: EBS 12.1 Minimum Patching Baselines and Dates Reminder: Upgrade EBS 12.2 to FMW 11.1.1.7 Reminder: Upgrade Database 11.2.0.3 Before August 2015 Reminder: Upgrade Database 12.1.0.1 to 12.1.0.2 by July 2015

Oracle University: Webcast SOA-BPM Partner Community, 25 October 2016

Registro: https://goo.gl/nPOJQC

Oracle Hot Topics: Solaris: Process spins/ASM and DB Crash if RAC Instance Is Up For > 248 Days by LMHB with ORA-29770

Alerts

Alert	Product Area	Last Updated
Solaris: Process spins/ASM and DB Crash if RAC Instance Is Up For > 248 Days by LMHB with ORA-29770	Oracle Database - Enterprise Edition	Wed, 19 Oct 2016 02:55 GMT-06:00

Bugs

Bug	Product Area	Bug ID	Last Updated
READING BLOB CAUSES ORA-1013 OR ORA-3118 ON NON-BLOCKING MODE	Oracle Database - Enterprise Edition	24831792	Wed, 19 Oct 2016 02:27 GMT-06:00

Product News

News	Product Area	Last Updated
Oracle Premier Support - Oracle Database Support News - Issue October 2016, Volume 68	Oracle Database - Enterprise Edition	Tue, 18 Oct 2016 13:47 GMT-06:00

Knowledge Articles

Knowledge Article	Product Area	Last Updated
How To Configure Client Failover For Data Guard Connections Using Database Services	Oracle Database - Enterprise Edition	Wed, 19 Oct 2016 04:47 GMT-06:00

Crux Consultores presente en el WOW. World OF Watson

Oracle The Critical Patch Update (CPU) for October 2016

The Critical Patch Update (CPU) for October 2016 was released on October 18, 2016. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents. 
Supported products that are not listed in the "Supported Products and Components Affected" Section of the advisory do not require new patches to be applied.
The Critical Patch Update Advisory is available at the following location:

• Oracle Technology Network

It is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches.
The next four Critical Patch Update release dates are:

• January 17, 2017
• April 18, 2017
• July 18, 2017
• October 17, 2017

References

• Oracle E-Business Suite Release 12 Critical Patch Update (October 2016) (Doc ID 2181748.1)
• Secure Configuration Guide for Oracle E-Business Suite Release 12 (Doc ID 403537.1)
• Oracle E-Business Suite Security Guide, Release 12.2 - Secure Configuration

Oracle Hot Topics: ORA-7445 [RWSSTD+48]

Bugs

Bug	Product Area	Bug ID	Last Updated
ORA-7445 [RWSSTD+48]	Oracle Database - Enterprise Edition	18131659	Tue, 18 Oct 2016 02:26 GMT-06:00

Product News

News	Product Area	Last Updated
Oracle Premier Support - Oracle Database Support News Archive	Oracle Database - Enterprise Edition	Mon, 17 Oct 2016 14:52 GMT-06:00

Knowledge Articles

Knowledge Article	Product Area	Last Updated
The root.sh Fails with ORA-29783:GPnP Attribute SET Failed With Error [CLSGPNP_NOT_FOUND]	Oracle Database - Enterprise Edition	Tue, 18 Oct 2016 03:35 GMT-06:00

MySQL Cluster 7.5 Is Now GA!

By Matt Lord-Oracle on Oct 18, 2016

The MySQL team at Oracle are excited to announce the immediate availability of the MySQL Cluster 7.5.4 GA release!

The development focus has been on improving overall performance and ease of use, combined with improved SQL support and the introduction of read optimized and fully replicated tables, all of which allow for better support of a variety of use cases.

Use Case: Hadoop Performance Records Smashed by Hops and MySQL Cluster--delivers over 1.2 million operations per second The key enhancements delivered by MySQL Cluster 7.5 are summarized below:
Improved Performance: Improvements in index/range scan performance and internal thread handling will allow for better use of existing hardware and a better overall user experience.

Improved Ease-of-Use: Improved logging and SQL views offer greater insight into the current configuration, state, and general database operations, all of which helps to decrease maintenance and support costs, increasing your ability to resolve issues early enough that they don't become bigger user impacting problems.

MySQL 5.7 Support: Developers can combine the InnoDB and MySQL Cluster NDB storage engines within a single database, using the very latest MySQL 5.7 release. This includes NDB support for the new native JSON data type, Generated Columns, and more!

Increased Capacity: With support for 128TB+ data set sizes per data node you can better utilize the much bigger commodity machines available today, which increases your ability to scale-up, in addition to scaling out.

Improved Read Scalability: You can mark all or individual tables as being read-optimized, thus effectively doubling your read throughput at the cost of slightly slower writes--a feature that is ideal for read-mostly tables. You can also declare some tables as being "global" or fully replicated--a feature that is ideal for lookup or fact tables which are relatively small, static, and often joined against (e.g. City, State, Product Type, etc.). These two features can greatly improve overall data locality--meaning that the data used for more complex queries (e.g. scans and joins) is local to a given data node, allowing you to avoid costly overhead associated with cross-node/cross-shard network communication and transaction management.

You can see the full MySQL Cluster 7.5 changelogs here, and the online manual here. If you're considering MySQL Cluster for a new application, please also see the Evaluation Guide.

Download the source and binaries today and get started now!

Configuring Reverse Proxies and DMZs for EBS 12.2

Source: Oracle Blog´s

You may have end-users outside of your organization's firewall who need access to E-Business Suite.  One way of doing that is to set up a reverse proxy server and a series of network segments separated by firewalls. 

The outermost network segment that lies between the internet and an organization's intranet is often called a Demilitarized Zone (DMZ).  DMZs are enforced by firewalls and other networking security devices.
Setting up a DMZ
Instructions for deploying EBS 12.2 in a DMZ-based architecture are published here:

• Oracle E-Business Suite Release 12.2 Configuration in a DMZ (Note 1375670.1)

Externally-facing EBS products
A subset of EBS products can be deployed for external use, including iSupplier, iRecruitment, iSupport, and others.  Many of these products have special rules that must be enabled in the URL Firewall to work properly in external deployments.  For a complete list of E-Business Suite products certified for external use, see Section 6 in Note 1375670.1.
Related Articles

• Enhance E-Business Suite Security By Switching to TLS
  
• TLS 1.2 Certified with E-Business Suite 12.1
  
• TLS 1.2 Certified with E-Business Suite 12.2
  
• Configuring Oracle XML Gateway for TLS
  
• Frequently Asked Questions about EBS Security

Oracle Hot Topics; PARTITION ORDER IN INDEX DEFINITION IS DIFFERENT THAN TABLE PARTITION

Bugs

Bug	Product Area	Bug ID	Last Updated
PARTITION ORDER IN INDEX DEFINITION IS DIFFERENT THAN TABLE PARTITION	Oracle Database - Enterprise Edition	14013094	Mon, 17 Oct 2016 04:22 GMT-06:00

Knowledge Articles

Knowledge Article	Product Area	Last Updated
Master Note For Transparent Data Encryption ( TDE )	Oracle Database - Enterprise Edition Advanced Networking Option	Mon, 17 Oct 2016 03:34 GMT-06:00

Oracle Hot Topics: Product Area Bug ID Last Updated CORE CONCURRENT PROCESSING TARGET IS PENDING CAUSING OTHERS TO BE PENDING TOO

Bugs

Bug	Product Area	Bug ID	Last Updated
CORE CONCURRENT PROCESSING TARGET IS PENDING CAUSING OTHERS TO BE PENDING TOO	Oracle Database - Enterprise Edition	18513891	Sat, 15 Oct 2016 02:24 GMT-06:00

Bug	Product Area	Bug ID	Last Updated
ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KKOGFP:NO START TABLE]	Oracle Database - Enterprise Edition	22097349	Sun, 16 Oct 2016 02:26 GMT-06:00

Knowledge Articles

Knowledge Article	Product Area	Last Updated
How to Resize Grid Disks in Exadata	Oracle Database - Enterprise Edition	Fri, 14 Oct 2016 17:24 GMT-06:00

Knowledge Article	Product Area	Last Updated
How to Resize Grid Disks in Exadata	Oracle Database - Enterprise Edition	Fri, 14 Oct 2016 17:24 GMT-06:00

"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support

Oracle Hot Topics: ORA-600 [RWOROFPRFASTUNPACKROWSETS:OOBP] OCCURRENCE

Bugs

Bug	Product Area	Bug ID	Last Updated
ORA-600 [RWOROFPRFASTUNPACKROWSETS:OOBP] OCCURRENCE	Oracle Database - Enterprise Edition	24706134	Fri, 14 Oct 2016 02:31 GMT-06:00

Knowledge Articles

Knowledge Article	Product Area	Last Updated
Datapatch Failed - PLS-00201: identifier 'SYS.UTL_INADDR' Must be Declared	Oracle Database - Enterprise Edition	Thu, 13 Oct 2016 23:02 GMT-06:00

"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support

E-Business Suite on Oracle Cloud Regional Seminars

Do you want to learn how running Oracle E-Business Suite and other Oracle applications (such as PeopleSoft, JD Edwards, and Siebel) on Oracle Cloud fits into your company's strategy? Join us at a free, half-day regional workshop where Oracle Cloud experts will explain how we can help you move to the enterprise cloud that is right for you. 
Learn how Oracle Cloud helps organizations drive innovation and business transformation while maximizing the value of their Oracle investments by:

• Lowering Cost: Increase resource utilization, lower ongoing management costs.
• Increasing Agility: Scale up or down as business needs change, off-load daily systems management tasks.
• Maintaining Flexibility: Move back on-premise as needed, integrate with on-prem apps, tools and assets.
• Reducing Risk: Never run out of capacity, stay up to date, minimize security risks and meet compliance requirements.

More information regarding the seminar series is available here:

• Shifting Workloads from On-Premises to the Cloud Seminar Series

Click on the city below to register for the upcoming event:

• New York City, NY, October 18, 2016
• Philadelphia, PA, October 20, 2016
• Miami, FL, October 25, 2016
• Reston, VA, October 27, 2016
• Newport Beach, CA, November 9, 2016
• Santa Monica, CA, November 15, 2016
• Dallas, TX, December 6, 2016
  
• Houston, TX, December 8, 2016
• Boston, MA, December 13, 2016

References 

• Getting Started with Oracle E-Business Suite on Oracle Cloud (Note 2066260.1)
• Oracle E-Business Suite on Oracle Cloud Landing Page
• Oracle E-Business Suite on Oracle Cloud Channel

Oracle E-Business Suite on Oracle Cloud Whitepaper

Oracle Hot Topics: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KKOGFP:NO START TABLE]

Bugs

Bug	Product Area	Bug ID	Last Updated
ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KKOGFP:NO START TABLE]	Oracle Database - Enterprise Edition	22097349	Thu, 13 Oct 2016 02:30 GMT-06:00

Knowledge Articles

Knowledge Article	Product Area	Last Updated
12c DBCA could not see ASM disk groups in 'Select Disk Group' Tab.	Oracle Database - Enterprise Edition	Thu, 13 Oct 2016 05:37 GMT-06:00

"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support

LIVE EVENT III - DESARROLLO DE APLICACIONES EMPRESARIALES

Evento que se celebrará a la hora y en la fecha y ubicación siguientes: Jueves, 20 de octubre de 2016 desde las 18:30 hasta las 21:00 (Hora estándar central Hora de Costa Rica) Multicentro Desamparados 7mo Piso, Oficinas EX² Outcoding Desamparados Costa Rica Ver mapa

Participar en el evento

- Cóctel de Bienvenida - Coffee Break  ¡Registrate Hoy Mismo Aquí!   ENTRADA GRATUITA - CUPO LIMITADO Compartí este evento con colegas y amigos a través de Facebook y Twitter.     ¡Esperamos contar con tu asistencia! Departamento de Eventos EX² Outcoding Solutions  EX² Outcoding Solutions SRL Desamparados, Costa Rica Dirección en Waze: http://bit.ly/1ZD3G86