Feed aggregator

October 2017 Critical Patch Update Released

Oracle Security Team - Tue, 2017-10-17 14:58

Oracle today released the October 2017 Critical Patch Update.

This Critical Patch Update provides fixes for a wide range of product families including: Oracle Database Server, Oracle Enterprise Manager, Oracle Fusion Middleware, Oracle E-Business Suite, Oracle Hyperion, Oracle Industry Applications (Communications, Health Sciences, Construction, Financial Services, Retail, and Hospitality), Oracle Sun Products, Oracle Java SE, and Oracle MySQL.

Oracle recommends this Critical Patch Update be applied as soon as possible. A summary and analysis of this Critical Patch Update has been published on My Oracle Support (Doc ID 2310031.1)

For More Information:

The Critical Patch Update Advisory is located at http://www.oracle.com/technetwork/security-advisory/cpuoct2017-3236626.html

My Oracle Support Note 2282980.1 is located at https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2310031.1(MOS account required).

DBMS_CRYPTO.HASH HASH_SH256 does not match openssl

Tom Kyte - Tue, 2017-10-17 13:06
OM - I need to create a (large) hash both inside the database and outside of it that yields the same result. Everything I am reading says SHA256 will satisfy the requirement, but I am not able to write SQL that achieves the same answer as the Li...
Categories: DBA Blogs

Hidden parameters

Tom Kyte - Tue, 2017-10-17 13:06
Will the below hidden parameter have any issues. Database version : _always_anti_join off _always_semi_join off _disk_sector_size_override TRUE _hash_join_enabled FALSE _kgl_large_heap_warning_threshold 20485760...
Categories: DBA Blogs

Contains operator with "not" or "no" query terms does not work

Tom Kyte - Tue, 2017-10-17 13:06
I have a large free-text field that I am trying to query for specific occurrences. I have three query terms that need to be near each other, so I want to use the contains near operator. But one of the query terms is either "no" or "not". When I t...
Categories: DBA Blogs

Getting word count from context text index by joining to indexed rows

Tom Kyte - Tue, 2017-10-17 13:06
Hello Tom, I would like to be able to roll up a word count (for a WordCloud control in a UI) based on a query ( a spatial query in this case). I have a table as such <code> create table items (id raw(16), text clob, geom sdo_geometry ) </code...
Categories: DBA Blogs

end loop commit; on the same line gives no error

Tom Kyte - Tue, 2017-10-17 13:06
Hello, I created a simple table. <code>create table test(t number);</code> I tried to insert values in it. I created o simple PLSQL block to insert values. <code>declare i integer; begin for me in 1..2 loop insert into test(t) va...
Categories: DBA Blogs

Replacing the Google Search Appliance: 5 Reasons Fishbowl Chose Mindbreeze

Google Search Appliance (GSA) Replacement, Alternatives, and Migration
When Google said so long to the Google Search Appliance, we went to the market to find a replacement. We chose Mindbreeze. Here’s why.
If you’re reading this, you’ve likely heard the news that Google has discontinued the Google Search Appliance (GSA). As a long-time Google partner and search appliance implementer, this news left Fishbowl and all of our customers in need of a new search solution. We first looked to Google but determined Google Cloud search wouldn’t be a viable replacement in time for the GSA cut-off. We then went to the market to select the product we felt was best suited to meeting the ongoing search needs of our customers. The following key requirements ultimately drove the selection criteria that led us to Mindbreeze:
  • Options for searching on-premise content
  • Connectors and connector frameworks for indexing non-web data sources
  • Support for public and secure use cases
  • Tools and APIs for search interface integration
  • Minimal development efforts or ongoing administration required
Options for searching on-premise content

While it’s true that more content moves to the cloud each year, the majority of our GSA customers still keep most of their enterprise content on premise. Several of the search vendors in the market, including Google, have set a very cloud-heavy product direction. While there’s nothing wrong with that, the reality is that most almost all of our GSA customers need to index on-premise content. Some customers, although a smaller portion, also have requirements that the search solution itself must be on premise. Even those who are open to putting their search index in the cloud must still overcome the bandwidth challenges of indexing large volumes of content across the internet. Mindbreeze, like the GSA, is a search appliance installed on premise and is well suited to indexing both on-premise and cloud content. While Mindbreeze does offer a hosted version of their Mindbreeze InSpire search product, we typically recommend customers with mostly on-premise content run Mindbreeze on premise. A hybrid architecture is also available where customers can index on-premise content on-premise and cloud content in the cloud, then federate the results at serve time. Reason #1: Even as Mindbreeze expands to index and serve more content in the cloud, they are committed to long-term support for their on-premise search appliance.

Connectors and indexing frameworks

mindbreeze connectorsAn essential requirement for all but a few of our customers is the ability to connect to non-web-crawlable data sources using connectors. This includes SharePoint, file shares, databases, and many others. This also includes Oracle WebCenter Content and PTC Windchill, both specialized content management systems around which Fishbowl has dedicated implementation practices and which are used by many of our customers. To index these systems, Fishbowl developed highly specialized connectors tailored to these sources. We’ve also written GSA connectors for YouTube, Oracle Documents Cloud Service, and Liferay portal. As we evaluated possible GSA replacements, two things were very clear. First, we needed a solution with a strong suite of off-the-shelf connectors, and second, we needed a solid framework for building custom connectors. Mindbreeze has one of the best collections of pre-built connectors on the market, something they have been commended for by both Forrester and Gartner in their respective search vendor reports. Off-the-shelf connectors for Mindbreeze include SharePoint, file shares, LDAP, databases, Salesforce, Confluence, and dozens more. The Mindbreeze Data Integration connector leverages the Talend ETL platform to create integration jobs that extract, transform, and load data from proprietary sources into Mindbreeze without requiring a source-specific connector. Mindbreeze also has a mature SDK available for developing custom connectors to any data source. Fishbowl has already released a connector for Oracle WebCenter Content built on this framework. Last but not least, Mindbreeze supports existing GSA version 4.0 adapters and GSA feeds allowing customers to reuse existing integrations leveraging these frameworks. Reason #2: Mindbreeze has one of the best collections of pre-built connectors on the market plus a mature SDK for custom connector development and support for ingesting GSA feeds.

Strong support for public and secure use cases

Some of our customers use GSA for only public content, but for most customers, at least some of the content is secured. In certain cases, specifically when dealing with SharePoint, Oracle WebCenter, or PTC Windchill, complex security models with layers of inheritance must be enforced. Mindbreeze offers multiple options for implementing secure search. Their internal principal cache and authorization mechanisms allow for fast, document-level authorization checks at serve time using access control lists (ACLs). Mindbreeze also supports ACL inheritance from container objects to further improve performance. For example, if permissions change on a Windchill folder containing 50,000 items, only one item, the folder container, must be reindexed for the new permissions to be reflected within Mindbreeze. This was also possible with GSA, but is not possible with many of the search products on the market because permissions can only be assigned to individual content items. Mindbreeze also supports multiple user authentication mechanisms including Kerberos, Trusted Peer, SAML, and cookie cracking. Existing cookie-based GSA authentication mechanisms can be re-used with Mindbreeze making that transition even easier. Several of our customers use a single GSA to serve both internal (secure) and external (public) use cases. This is also common with Mindbreeze due to their client service architecture which allows configuration of both authentication requirements and data sources for each client service. Reason #3: The Mindbreeze architecture provides one of the most flexible, well-performing secure search implementations we’ve seen, while also allowing segmentation to serve public and secure results on a single deployment.

Tools and APIs for search interface integration

Once data is indexed, it is also necessary that the search technology offer both a built-in search interface and options for integrating search functionality into other websites and applications. Mindbreeze provides a nice combination of pre-built search apps and APIs for creating your own. Customers looking for the easiest path to value can leverage the default Mindbreeze search client which offers a feature rich, mobile friendly, search interface out of the box. You can add your own CSS file for a customized feel with very little development required. Mindbreeze also includes a Search App Designer which provides drag and drop tools for creating use-case specific search apps without coding. The Designer library includes widgets for adding filters, charts, grids, and galleries to various search apps. Mindbreeze also includes an export option which provides all the code needed to embed a search app into a website or application. For customers seeking a more customized integration, the Mindbreeze REST API allows search results to be returned as JSON giving you full control over their presentation. In many cases, customers with custom-built GSA results pages can keep the look of their existing frontend and swap out GSA for Mindbreeze on the backend. In fact, we recently had a customer do exactly this. They went from racking to go-live in less than a month.  Reason #4: Mindbreeze offers a solid combination of UI tools including a no-coding-required UI builder and a REST API for fully customized search applications.

Minimal development efforts or ongoing administration required

Coming from the easy deployment world of GSA, it was important we select a replacement that didn’t require complicated server farms, lengthy IT projects, or significant resource allocation. While we don’t encourage customers to completely forget about their search appliance, the set-it-and-forget-it mindset was prevalent among GSA customers for good reason. Once configured, it just worked. We needed a solution that offered comparably easy setup and maintenance. We didn’t set to out with a requirement to find another physical appliance, but the nature of our requirements made the Mindbreeze search appliance a natural choice. As a productized hardware-software package Mindbreeze setup is comparable to GSA and is considerably quicker than most other search solutions on the market. Even connectors can be run directly on the search appliance eliminating the need for additional application servers. High-availability and disaster-recovery architectures which automatically synchronize data between multiple appliances are also available similar to the mirroring options available with the GSA. And while we have found Mindbreeze to be more configurable than GSA in many ways, customers don’t need to understand indexing pipelines, relevancy algorithms, or machine learning to see great results. Adding connectors, configuring search apps, mapping synonyms, and viewing search analytics can all be done from the web-based Mindbreeze Management Center. Reason #5: The self-contained nature of Mindbreeze allows customers to get search up and running quickly and minimizes ongoing administration activities.

What about relevancy?

You might have noticed a few things conspicuously missing from our list of key requirements. These included strong relevancy, custom synonym dictionaries, search filters, and type-ahead suggestions. Mindbreeze offers all of these features. And so does everyone else. While these features can be critically important to a good search experience, they didn’t end up being important selection criteria because all the leading search tools have them. In many cases, Mindbreeze makes it quicker or easier to implement these features (see Reason #5) but the features themselves are not unique. I should also mention that these capabilities can be huge differentiators when comparing Mindbreeze to search options that come “built in” to content management systems or line of business applications, but those products are not the search tools we were comparing in this evaluation.


In the past seven years we’ve helped numerous customers buy, implement, and maintain their GSAs. Despite the disruption caused by the GSA’s end of life, we’re excited about the possibilities Mindbreeze has to offer. If your requirements are similar to ours, we believe that Mindbreeze offers the quickest, most mature, and smoothest migration path from GSA. As a Mindbreeze partner, we offer both resale and implementation services. If you have questions or would like to know more, please contact us or leave a comment below.

Time running out on your GSA?

Our expert team knows both GSA and Mindbreeze. We’ll help you understand your options and design a migration plan to fit your needs.

Contact Us

The post Replacing the Google Search Appliance: 5 Reasons Fishbowl Chose Mindbreeze appeared first on Fishbowl Solutions.

Categories: Fusion Middleware, Other

K21 Technologies - Upcoming Oracle trainings

Syed Jaffar - Tue, 2017-10-17 08:46
Atual's K21 technologies offering some quality of Oracle training. Below are the upcoming Oracle training:

Apps DBA : Install | Patch | Clone | Maintain :

Apps DBA Webinar: 

Oracle GoldenGate Training

Ribeiro Selects Oracle Retail to Anticipate Demand and Gain More Omnichannel Agility

Oracle Press Releases - Tue, 2017-10-17 08:00
Press Release
Ribeiro Selects Oracle Retail to Anticipate Demand and Gain More Omnichannel Agility Argentinean Hardline Retailer Improves Pricing, Replenishment and Centralized Management Capabilities

Redwood Shores, Calif.—Oct 17, 2017

Today, Oracle announced that Argentinian hardline retailer Ribeiro has selected Oracle Retail Merchandising, Planning & Optimization and Supply Chain solutions to empower operational discipline to attract, retain and serve their Omnichannel customers. Ribeiro is a family owned company offering household items and electronics that established operations in 1910. Today Ribeiro is managed by the third family generation that operates over 82 stores, the call center and a robust online presence. To stay relevant to the changing consumer, the company decided to modernize and incorporate more technology to anticipate consumer demand.

In this journey, Ribeiro realized the need to adopt worldwide best practices by replacing its’ proprietary legacy software, to allow the company to structure its Omnichannel operations, and integrate physical stores with e-commerce and the back office. After analyzing several market solutions, the company chose to extend its’ relationship with Oracle Retail. Ribeiro will implement Oracle Retail Allocation, Oracle Retail Replenishment Optimization, Oracle Retail Regular Price Optimization and Oracle Retail Store Inventory Management in a staged approach. In 2012 Ribeiro partnered with Oracle to drive growth in the online channel. Ribeiro implemented Oracle Commerce in less than 5 months with great results.

“We were looking for a tool that would allow us to act faster instead of building design interfaces with legacy systems. We needed to improve pricing, replenishment and centralized management to accelerate our response to customer demands. We considered Oracle Retail as the best solution in the market to help Ribeiro to address this challenge.” says Dan Attie, Commercial Director at Ribeiro.

The modernization of Ribeiro with Oracle Retail solutions is planned to simplify the reorganization of internal processes, allowing for the definition of pricing goals, commercial action planning and logistics management organization. The implementation will be delivered in stages by Oracle PartnerNetwork Gold Level Partners SkillNet and Veltio. The staged implementation will follow a prescriptive plan to minimize the impact on the company’s operations and maximize the return on their investment with Oracle.

“With this implementation, we will gain real-time control of our stores and we will ensure that the same information is shared throughout the company, giving us better decision-making process,” explains Attie.

“Our global consumer research, Retail in 4 Dimensions, shows that consumers are open to personalized shopping experiences, communications and tailored offers. We believe that inventory is fundamental to a personalized shopping experience,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “With this investment, Ribeiro will gain a single view of inventory to fully support the connected shopper experience.”

About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Whats new in Exadata X7

Syed Jaffar - Tue, 2017-10-17 07:58
Oracle announced its new Exadata Database Machine X7 during OOW 2017.  Lets walk through quickly about the key features of X7.

Key features
  • Up to 912 CPU core and 28.5TB memory per rack
  • 2 to 19 DB servers per rack
  • 3 to 18 Storage servers per rack
  • Maximum of 920TB flash capacity
  • 2.1PB of disk capacity
  • Delivers 20% faster throughput from earlier models
  • 50% more memory capacity from earlier models
  • 10TB size disk. (10TB x 12 = 120TB RAW per storage server). The only system in the market today with 10TB disk capacity
  • Increased OLTP performance : about 4.8 million reads and about 4.3 million writes per second
  • Featuring an Intel Skylake processor with 24 cores 
  • Enhanced Ethernet connectivity: supports over 25GbE
  • Delivers in-memory performance from Shared Storage 
  • OEDA CML interface
  • New Exadata Smart Software : Exadata 18c

DB Starts with SQLPlus not SRVCTL

Michael Dinh - Mon, 2017-10-16 20:25

Reason why DB was able to be started using SQL*Plus and not srvctl because DB was configured incorrectly with srvctl.

$ srvctl start database -d DB01
PRCR-1079 : Failed to start resource ora.db01.db
CRS-5017: The resource action "ora.db01.db start" encountered the following error:
ORA-01078: failure in processing system parameters. 
For details refer to "(:CLSN00107:)" in "/u01/app/oracle/product/11.2.0/grid_2/log/host01/agent/ohasd/oraagent_oracle//oraagent_log".

CRS-2674: Start of 'ora.db01.db' on 'host01' failed

--- Spfile pointing to non-existing pfile.
$ srvctl config database -d DB01
Database unique name: DB01
Database name:
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_2
Oracle user: oracle
Spfile: /oracle/product/11.2.0/dbhome_2/dbs/initDB01.ora
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: DB01
Disk Groups: DATA,FRA

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/db01/spfiledb01.ora

cat: /oracle/product/11.2.0/dbhome_2/dbs/initDB01.ora: No such file or directory

$ srvctl modify database -d DB01 -p +DATA/db01/spfiledb01.ora
$ srvctl config database -d DB01
Database unique name: DB01
Database name:
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_2
Oracle user: oracle
Spfile: +DATA/db01/spfiledb01.ora
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: DB01
Disk Groups: DATA,FRA

Parallel DML Update without any parallel hint or parallel degree

Tom Kyte - Mon, 2017-10-16 18:46
Hello All, In our production environment, one DML update is running in parallel and which is sporadic in nature. Please note the session is enabled for parallel dml. Find below one pseudo code of that update statement. --------------- <co...
Categories: DBA Blogs

Getting ORA-01861 literal does not match format string error in stored procedure

Tom Kyte - Mon, 2017-10-16 18:46
Hi, We have a requirement to get the date in 'yyyy-mm-dd' format but unable to do using below procedure, <code>create table emp_test (emp_id number, customer_due_date date) / create table dep_test (due_days number) / <Insert>, insert...
Categories: DBA Blogs

How to replace sqlloader control file with external table

Tom Kyte - Mon, 2017-10-16 18:46
Hello, I have a flat file structured like this: HH00001 0000000048JZFRV288SNGAA814 DD11111111 desc1 000000000000000000012 100002 DD02324234 desc2 000001200000000000000 00 300012 100002 DD5453...
Categories: DBA Blogs

Move lob index to a different tablespace

Tom Kyte - Mon, 2017-10-16 18:46
Hello, I have a table which contains one CLOB column and there is an Index on that CLOB Column , this table is on TEST tablespace. My question is: how to move CLOB Index only on TEST_IDX tablespace without moving the column along with the Index??? ...
Categories: DBA Blogs

dbms_ldap.bind_s vs dbms_ldap.simple_bind_s

Tom Kyte - Mon, 2017-10-16 18:46
Hello Tom, I will need your help in understanding the difference between DBMS_LDAP.BIND_S and DBMS_LDAP.SIMPLE_BIND_S ( DB version is ). Thank you!
Categories: DBA Blogs

Memory_target or sga_target+pga_aggregate_target for dw databases.

Tom Kyte - Mon, 2017-10-16 18:46
Hi I don't know but I have been told, that "12c db creation wizard doesn't even allow AMM (MEMORY_* parameters) anymore for databases with more memory than... 4 G if memory serves me" So what is the current wisdom for big (?) dw databases ? S...
Categories: DBA Blogs


Tom Kyte - Mon, 2017-10-16 18:46
Hi Tom, Can you pls explain the diff between IN and EXISTS and NOT IN and NOT EXISTS. Because I have read that EXISTS will work better than IN and NOT EXISTS will work better than NOT IN (read this is Oracle server tunning). Regard...
Categories: DBA Blogs

Setting up Optach environment variable

Learn DB Concepts with me... - Mon, 2017-10-16 17:22

Setting up Optach environment variable :

For Korn / Bourne shell:

For C Shell:
Categories: DBA Blogs

nVision Performance Tuning: 1. nVision Performance Options

David Kurtz - Mon, 2017-10-16 14:26
This blog post is part of a series that discusses how to get optimal performance from PeopleSoft nVision reporting as used in General Ledger.

At no point when defining a nVision report does the developer directly specify a SQL statement, all the SQL is generated by nVision from the report definition.  That also means that it is not possible to directly intervene and change the SQL statement, for example, to add an optimizer hint.

However, the way that the SQL is generated can be controlled via the nVision performance options. Setting this appropriately can make a significant difference to nVision performance, but the optimal settings will differ from system to system, from tree to tree and sometimes even report to report.
Specification of Performance OptionsnVision performance options are specified for named trees.  Since PeopleTools 8, they are defined in the tree definition.
Tree Performance Options in PIA
They are stored in the database in PeopleTools table PSTREEDEFN.
Field Name
Field Value
Use Application Defaults
Join to Tree Selector
Use Literal Values
Sub-SELECT Tree Selector
Dynamic Selectors
Static Selectors
Range of Values (BETWEEN)
Range of Values (>=…<=)
Single Values

Performance options can also be specified in individual layouts, and the specific definition in the layout overrides the generic definition in the tree.
Add-Ins->nVision->Layout Options
You can also see the trees defined in a layout file in the Name Manager in Excel.  The performance options are converted into a string of 5 characters.  Below you can see a tree called OPERATING_UNIT. The easiest way to determine whether performance options are set in a layout is to look in the Name Manager, and the only reliable way to delete a performance option from a layout is to delete them from the Name Manager.
Formulas -> Name Manager

The string of flags in the NvsTree formula can be decoded with this table.
Dynamic Selector
Static Selector

Join to tree selector
Supress join; use literal values
Sub-SELECT tree selector
Range of values (BETWEEN)
Range of values (>= … <=)

Single Value
(overrides position 3)

Non-specific node criteria (above 2 billion)

RecommendationsIt is rare to need to set different performance options for the same tree in different layouts. Therefore, it is easiest to set performance options at tree level and not at all in layouts unless absolutely necessary.
Tree performance options can even be updated in bulk by SQL script, though it is essential to maintain the versions numbers correctly.  Care should be taken when migrating trees from other environments to ensure that the performance options are still correctly set, as the performance options are part of the tree being migrated
It is now possible to give clear advice to developers and especially business users who create nVision reports:
  • Don't use them.
  • If you have specified them in layouts in the past, then remove them unless you really do need to use a different option in a particular report.
Some customers have written Visual Basic macros to work through all their layouts and remove all tree performance options settings.


Subscribe to Oracle FAQ aggregator