Feed aggregator

Max PDBs in Standard Edition

Yann Neuhaus - Thu, 2017-10-26 14:26

Here is a small warning. In Standard Edition, you may expect that the features that are not available for your edition are blocked, but in 12.2 you can create more than one PDB in Standard Edition, and you should set MAX_PDBS to prevent that.

12cR1

In 12.1 Standard Edition, when you try to create more than one PDB (i.e with CON>ID > 3) you get an error:

ORA-65010: maximum number of pluggable databases created

12cR2

But it seems that this has been lost in 12.2:


oracle@SE122 ~$ sqlplus / as sysdba
 
SQL*Plus: Release 12.2.0.1.0 Production on Thu Oct 10 11:41:56 2017
 
Copyright (c) 1982, 2016, Oracle. All rights reserved.
 
 
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
 
SQL> show pdbs
 
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
 
SQL> create pluggable database PDB2 admin user admin identified by me;
 
Pluggable database created.
 
SQL> show pdbs
 
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 MOUNTED
SQL> alter pluggable database PDB2 open;
 
Pluggable database altered.

So, if you are in Standard Edition, don’t forget to set MAX_PDBS to 1:

SQL> alter pluggable database PDB2 close immediate;
 
Pluggable database altered.
 
SQL> drop pluggable database PDB2 including datafiles;
 
Pluggable database dropped.
 
SQL> alter system set max_pdbs=1;
 
System altered.
 
SQL> show pdbs
 
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
 
12:18:28 SQL> create pluggable database PDB2 admin user pdbadmin identified by oracle;
create pluggable database PDB2 admin user pdbadmin identified by oracle
*
ERROR at line 1:
ORA-65010: maximum number of pluggable databases created

 

Cet article Max PDBs in Standard Edition est apparu en premier sur Blog dbi services.

Oracle Instant Client 12.2 for macOS is Available

Christopher Jones - Thu, 2017-10-26 01:12

Oracle Instant Client 12.2 for macOS can now be downloaded for free from OTN.

This release is for 64 bit only. It supports:

  • MAC OS X 10.13, High Sierra
  • MAC OS X 10.12, Sierra
  • MAC OS X 10.11, El-Capitan

Install instructions are at the end of the download page.

Instant Client contains libraries and tools allowing applications to connect to a local or remote Oracle Database for development and production deployment.

And if you haven't caught up with the news, Instant Client 12.2 now includes tools like SQL*Loader and Data Pump.

ORA-27103: internal error

Tom Kyte - Wed, 2017-10-25 22:46
Hello; could you help me with problem of memory, I try describe it. I have application under tomcat on application server, application generates select to database server, after few secconds application logs error ORA-27103: internal error A...
Categories: DBA Blogs

trigger, to get an audit

Tom Kyte - Wed, 2017-10-25 22:46
I have a table, where there is a column which is updated from multiple sources. I would like to find out the source which is updating this column. for example, it can be a SP or direct application. So is there a possibility of having a trigger, to...
Categories: DBA Blogs

Regarding the Complex Hierarchical Query

Tom Kyte - Wed, 2017-10-25 22:46
Hi Tom, Could you please help me to develop a Query. My requirement is given below. I have a following table called PRODUCT and the structure is given below. CREATE TABLE PRODUCT(ID NUMBER, NAME VARCHAR2(50), PARENT_ID NUMBER, PRODUCT_TYPE V...
Categories: DBA Blogs

apply archive logs through OPEN RESETLOGS

Tom Kyte - Wed, 2017-10-25 22:46
Hello Tom I am a little confused about following excerpt from "Backup and Recovery User's Guide": Because the database does not apply an archived redo log to a data file unless the RESETLOGS SCN and time stamps match, the RESETLOGS requirement ...
Categories: DBA Blogs

Downloading the Database for the Oracle SQL developer / VMware fusion

Tom Kyte - Wed, 2017-10-25 22:46
Hi Tom, I have followed the instruction provided on the how to download data base for OracleSql developer. I am using Mac, so i was not a able to use XE without linux/Microsoft etc..Therefore I have chosen the 3rd step to download the DeveloperDay...
Categories: DBA Blogs

Can Oracle allocate more PGA than PGA_AGGREGATE_TARGET parameter ?

Tom Kyte - Wed, 2017-10-25 22:46
Hi Tom, Can Oracle allocate more PGA memory than PGA_AGGREGATE_TARGET parameter ? If yes, is there a rule for that ? Thanks, Pierre
Categories: DBA Blogs

Using dbms_metadata.get_ddl - getting rid of carriage returns

Tom Kyte - Wed, 2017-10-25 22:46
I am currently using dbms_metadata to get VIEWS DDLs (in order to re-create them following a FROMUSER-TOUSER import; compilation errors due to in-text schema names). However, the generated file (spool) is full of carriage-returns which makes mandator...
Categories: DBA Blogs

#GoldenGate/#Database Patches

DBASolved - Wed, 2017-10-25 16:35

In searching for patches for Oracle GoldenGate you have to also look for Oracle Database patches. To make this search a bit easier, some of the great guys on the Oracle GoldenGate team has created a My Oracle Support (MOS) note or two. These notes should be upkept over time. For now, just know these are reference points for you to find out what patches are required for your Oracle GoldenGate environments!

Doc Id: 2193391.1 – Latest GoldenGate/Database (OGG/RDBMS) Patch recommendations

Doc Id: 1557031.1 – Oracle GoldenGate — Oracle RDBMS Server Recommended Patches

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

nVision Performance Tuning: 3. Indexing of Ledger, Budget, and Summary Ledger Tables on Non-Engineered Oracle Systems

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

If you are on a conventional non-engineered Oracle system, then it is not going to be viable to full scan the ledger tables for every query.  You are going to have to use indexes to find your data.  Every customer's nVision reports are unique to that customer and the nature of their business.  Different customers will analyse their data by different combinations of attributes.  Indexes will be needed to match those analysis criteria.
A survey of the nVision reports and the SQL they produce will reveal the various sets of columns by which ledger data is queried. The heaviest SQL statements can be identified from Active Session History (ASH) or the Automatic Workload Repository (AWR) (or Statspack if the Diagnostics pack is not licenced).   As an example, let's take the following two statements as examples, and consider the indexes that would be needed to support them.
SELECT L4.TREE_NODE_NUM,SUM(A.POSTED_TOTAL_AMT) 
FROM PS_LEDGER A, PSTREESELECT10 L4, PSTREESELECT10 L2, PSTREESELECT10 L
WHERE A.LEDGER='ACTUALS'
AND A.FISCAL_YEAR=2017
AND A.ACCOUNTING_PERIOD=1
AND L4.SELECTOR_NUM=78948
AND A.CHARTFIELD3>= L4.RANGE_FROM_10 AND A.CHARTFIELD3 <= L4.RANGE_TO_10
AND L4.TREE_NODE_NUM BETWEEN 1000000000 AND 2000000000
AND L2.SELECTOR_NUM=92481 AND A.ACCOUNT=L2.RANGE_FROM_10
AND (A.DEPTID BETWEEN '10000' AND '18999'

OR A.DEPTID='29150'
OR A.DEPTID=' ')
AND L.SELECTOR_NUM=92469 AND A.CHARTFIELD1=L.RANGE_FROM_10
AND A.CURRENCY_CD='USD'
GROUP BY L4.TREE_NODE_NUM
  • nVision queries will always contain single value predicates on LEDGER and FISCAL_YEAR.
  • You may see some queries on a single ACCOUNTING_PERIOD, as in the query above, usually the current period.  Otherwise, they might be on a range of ACCOUNTING_PERIODs, usually the year to date as in the example below.
  • Then there will predicates on the other analysis columns, in this case, DEPTID, ACCOUNT, CHARTFIELD1, CHARTFIELD3.
  • You may see criteria on CURRENCY_CD, however, this may not be very selective.  Generally, most of the queries will be on the base currency, and most of the data will be in the base currency.
  • Sometimes you may see a criterion on STATISTICS_CODE=' '.  Normally, only a very few ledger rows have statistics code, so there is no benefit in adding STATISTICS_ CODE to any index.
  • Generally, single value predicate columns should be placed at the front of the index, followed by the other analysis criteria.
  • However, I would not attempt to overload the index with additional non-selective columns because unless you index all the referenced columns, including the amount columns, you will not be able to satisfy the query from the index only, and you will still have to visit the table.
  • So for this query, you might build an index on the following columns: LEDGER, FISCAL_YEAR, ACCOUNTING_PERIOD, DEPTID, ACCOUNT, CHARTFIELD1, CHARTFIELD3, CURRENCY_CD
This query, from the same system, is on a different combination of columns
SELECT L2.TREE_NODE_NUM,L3.TREE_NODE_NUM,L4.TREE_NODE_NUM,SUM(A.POSTED_BASE_AMT) 
FROM PS_LEDGER A, PSTREESELECT05 L1, PSTREESELECT10, L2, PSTREESELECT10 L3, PSTREESELECT10 L4, PSTREESELECT10 L
WHERE A.LEDGER='ACTUALS' AND A.FISCAL_YEAR=2015
AND A.ACCOUNTING_PERIOD BETWEEN 1 AND 11
AND L1.SELECTOR_NUM=30369 AND A.BUSINESS_UNIT=L1.RANGE_FROM_05
AND L2.SELECTOR_NUM=30374 AND A.CHARTFIELD1=L2.RANGE_FROM_10
AND L3.SELECTOR_NUM=30375 AND A.ACCOUNT=L3.RANGE_FROM_10
AND L4.SELECTOR_NUM=30376 AND A.CHARTFIELD2=L4.RANGE_FROM_10
AND L.SELECTOR_NUM=30372 AND A.CHARTFIELD1=L.RANGE_FROM_10
AND A.CURRENCY_CD='USD'
GROUP BY L2.TREE_NODE_NUM,L3.TREE_NODE_NUM,L4.TREE_NODE_NUM
  • In this case, the above query is part of a fiscal year-to-date report, returning the same period in a previous fiscal year.  The system is currently in period 11, so this report is looking at accounting periods 1 to 11.  ACCOUNTING_PERIOD is a much less selective criterion in this case.  If partitioning option were not available, I might be tempted to demote ACCOUNTING_PERIOD to further down the list of indexed columns if the criterion on the next column is more selective.
  • This query uses 5 trees.  A cartesian join of all 5 is likely to produce a product so large that it will not be effective to do index lookups for each member of the product.  The columns with the most selective criteria should be earlier in the index.  It might not even be worth including columns with non-selective criteria in the index.
  • So you might build an index on the following columns: LEDGER, FISCAL_YEAR,  BUSINESS_UNIT, ACCOUNT, CHARTFIELD1, CHARTFIELD2, CURRENCY_CD, ACCOUNTING_PERIOD.
RecommendationsIt is easy to see how you might build up a large number of indexes on the ledger and summary ledger tables.  You might have pairs of indexes, one for single accounting periods and perhaps another similar one for year-to-date for each set of analysis criteria.
However, as you add indexes the overhead of index maintenance experienced by any processes that post to the ledger, or by the summary ledger build process will increase.  There is a balance to be struck. You will have to build as many indexes with as many columns as are necessary, but as few as possible.
If you partition the tables on FISCAL_YEAR and ACCOUNTING_PERIOD and locally partition the indexes, you will only need one of the indexes.
Index leaf block dictionary compression can significantly reduce the size of the index.  Any increase in the CPU overhead of using and maintaining the index will be more than offset by the reduction in I/O overhead.  The optimal prefix length can be calculated using the command ANALYZE INDEX … VALIDATE STRUCTURE.  This feature does not require the Advanced Compression licence.

Recent EBS Workflow Blog Articles

Steven Chan - Wed, 2017-10-25 11:26

The Oracle E-Business Suite Workflow team has a technically-focussed blog that is recommended reading for all EBS system administrators. This blog provides tips and insights into Workflow best practices.  "Workflow" includes the Mobile Approvals app, too.

In case you missed them, here are some recent articles:

Categories: APPS Blogs

Oracle Hospitality Ushers Sports and Entertainment Marketplace to the Cloud

Oracle Press Releases - Wed, 2017-10-25 08:00
Press Release
Oracle Hospitality Ushers Sports and Entertainment Marketplace to the Cloud Fan Experience Taken to a Whole New Level Thanks to Next Generation Point-of-Sale, Venue Management Software and Strategic Relationships and Integrations

Redwood Shores, Calif.—Oct 25, 2017

With advanced and powerful new products and services ranging from next generation POS technology to integrated loss prevention and data science cloud services, major companies across the sports and entertainment marketplace continue to find a foundation for innovation with Oracle Hospitality.

The combination of cloud-based food and beverage management software and ruggedized mobile POS from Oracle Hospitality enables sports and entertainment venues, such as stadiums and theme parks, to increase speed of service, maximize operational efficiency, and manage loyalty and season-ticket holder programs—all while receiving detailed real-time reporting and analytics.

“Oracle Hospitality’s proven track record and commitment to the sports and entertainment marketplace is evident by our progress in product innovation,” said Dan Bell, Vice President, Sports & Entertainment, Oracle Hospitality. “Oracle is investing millions in R&D and support to enable venue operators to deliver the service that fans want and expect. Our food and beverage platform scales to support the largest sporting and entertainment venues and offers the ability to conduct iterative innovation through cloud deployment to improve the overall fan experience.”

Research conducted by Oracle Hospitality makes it abundantly clear what fans want: speed and reliability. Forty-five percent of fans around the world had abandoned lines at events because the wait was too long. The Simphony Cloud platform can reduce waiting time with high-performance cloud POS delivered on integrated hardware for kiosks and mobility. Oracle Hospitality’s flexible Gift & Loyalty solution integrates with the POS to support fan recognition and personalization. An integrated back office suite offers cloud solutions designed to minimize costs, waste, and theft while delivering extensive reporting capabilities.  

In addition to driving more personalized fan experiences, Oracle Hospitality also provides stadiums with tools to optimize event-day operations from beginning to end through Simphony Venue Management, which can track inventory and food costs, and Simphony Suites Management, which can help streamline production of advance food orders, pantries and the timed distribution of orders to event suites.

Product and Service Innovation

Oracle Hospitality also continues to release significant new products and services to support ongoing customer innovation and fan engagement, including:

  • The launch of the Oracle MICROS 720 tablets—durable and rugged mobile POS engineered for hospitality and large venue environments;
  • The launch and integration of Oracle Hospitality Data Science Cloud Services—on-demand data mining services that give operators access to the latest machine-learning tools to help improve forecasting and deliver up- and cross-selling insights directly on the POS terminals;
  • Powerful new reporting capabilities with Oracle Hospitality Reporting and Analytics 9.0 – operators can take advantage of an extended reporting platform, from KPIs via dashboards on mobile devices to comprehensive pivot tables and drill-down analysis. Reporting and Analytics offers the power of Oracle Business Intelligence at no charge for users of Simphony Premium;
  • The launch of Oracle Hospitality Simphony Cloud 2.9—extending the core functionality of the Simphony food and beverage management platform with new events management enhanced functionality that is optimized for the sports and entertainment industry.

Industry-wide Domain Expertise and Insight

With more than 35 years of experience in the sports and entertainment space, Oracle Hospitality understands the complexities that comprise this unique environment. We share this insight through providing original research to our customers, partners and the industry, to shed light on fan and guest trends and opportunities. Recent reports include the Oracle Hospitality Fan Experience Report, which details how consumers want technology to fuel their experience at sporting and concert venues, and the Oracle Hospitality Restaurant 2025 Report which outlines how consumers expect new and innovative technologies to reinvent their hospitality experience by the year 2025.

From stadiums to theme parks, the cloud-based delivery of the Simphony platform combined with extensibility and integration capabilities, allow the sports and entertainment industry to continuously innovate the experience for fans and guests at events and concerts. The inclusion of new apps and trends is key. In the past 12 months, Oracle Hospitality has added additional value to the Simphony platform through a variety of strategic relationships and integrations, including with QikServe and FreedomPay.

Contact Info
Judi Palmer
Oracle PR
+1.650.784.7901
judi.palmer@oracle.com
Patty Oien
Blanc & Otus
+1.510.303.7289
patty.oien@blancandotus.com
About Oracle Hospitality

Oracle Hospitality brings 35 years of experience in providing technology solutions to food and beverage operators. We provide hardware, software, and services that allow our customers to deliver exceptional guest experiences while maximizing profitability. Our solutions include integrated point-of-sale, loyalty, reporting and analytics, inventory and labor management, all delivered from the cloud to lower IT cost and maximize business agility.

For more information about Oracle Hospitality, please visit www.Oracle.com/Hospitality About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Judi Palmer

  • +1.650.784.7901

Patty Oien

  • +1.510.303.7289

First steps with Istio on Kubernetes on Minikube on Windows 10

Amis Blog - Wed, 2017-10-25 07:53

In this article, I discuss my steps to get going with Istio [service mesh]on Kubernetes running on Minikube on Windows 10. Unfortunately, I have ran into an issue with Istio. This article describes the steps leading up to the issue. I will continue with the article once the issue is resolved. For now, it is a dead end street.

Note: my preparations – install Minikube and Kubernetes on Windows 10 are described in this previous article: https://technology.amis.nl/2017/10/24/installing-minikube-and-kubernetes-on-windows-10/.

Clone Git repository with samples

git clone https://github.com/istio/istio

Start minikube

set MINIKUBE_HOME=C:\Users\lucas_j\.minikube

minikube start

image

Run Bookinfo

cd c:\data\bookinfo\istio\samples\bookinfo\kube

kubectl apply -f bookinfo.yaml

image

Show productpage. First find port on which product page is exposed:

image

productpage is a service of type ClusterIP, which is only available inside the cluster – which is not good for me.

So to expose the service to outside the cluster:

kubectl edit svc productpage

and in the editor that pops up, change the type from ClusterIP to NodePort:

image

After changing the type and saving the change, get services indicates the port on which the productpage service is now exposed:

image

So now we can go to URL:  http://192.168.99.100:9080/productpage

image

Installing Istio into the Kubernetes Cluster

Now that we’ve seen the app, we’ll adjust our deployment slightly to make it work with Istio. We first need to install Istio in our cluster. To see all of the metrics and tracing features in action, we also install the optional Prometheus, Grafana, and Zipkin addons.

First, download Istio for Windows from https://github.com/istio/istio/releases and extract the contents of the zip file.

image

Add the directory that contains the client binary istioctl.exe to the PATH variable.

image

Open a new command line window. Navigate to the installation location of Istio.

To install Istio to the minikube Kubernetes cluster:

kubectl apply -f install/kubernetes/istio.yaml

SNAGHTML3324bb4

ending with:

image

To verify the success of the installation:

kubectl get svc -n istio-system

image

On Minikube – that does not support services of type LoadBalancer – the external IP for the istio-ingress will stay on pending. You must access the application using the service NodePort, or use port-forwarding instead.

Check on the pods:

kubectl get pods -n istio-system

image

On the dashboard, when I switch to the istio-system Namespace, I can see more details 

image

When I try to run istio commands, I run into issues:

istio version

image

panic: runtime error: invalid memory address or nil pointer dereference
[signal 0xc0000005 code=0x0 addr=0x30 pc=0x121513f]

goroutine 1 [running]:
main.getDefaultNamespace(0x14b878a, 0xd, 0x0, 0x0)

I am not sure yet what is the underlying cause and if there is a solution. The issue report https://github.com/istio/pilot/issues/1336 seems related – perhaps.

I do not know where to get more detailed logging about what happens prior to the exception.

Install Book Info Application and inject Istio

The next command I tried was:

kubectl apply -f <(istioctl kube-inject -f samples/bookinfo/kube/bookinfo.yaml)

this one fails with: the system cannot find the file specified

image

Resources

Git Repository for Istio – with samples: https://github.com/istio/istio 

Guide for Istio introduction – Managing microservices with the Istio service mesh – http://blog.kubernetes.io/2017/05/managing-microservices-with-istio-service-mesh.html?m=1 

Installation of Istio into Kubernetes Cluster – https://istio.io/docs/setup/kubernetes/index.html

Tutorial  Istio is not just for microservices  – https://developer.ibm.com/recipes/tutorials/istio-is-not-just-for-microservices

Istio: Traffic Management for your Microservices – https://github.com/IBM/microservices-traffic-management-using-istio/blob/master/README.md

Istio Guide – getting started with sample application Bookinfo – https://istio.io/docs/guides/bookinfo.html

The post First steps with Istio on Kubernetes on Minikube on Windows 10 appeared first on AMIS Oracle and Java Blog.

Oracle Recognized as a Leader in Sales Force Automation Solutions by Gartner

Oracle Press Releases - Wed, 2017-10-25 07:00
Press Release
Oracle Recognized as a Leader in Sales Force Automation Solutions by Gartner Positioned as a leader for its ability to execute and completeness of vision

Redwood Shores, Calif.—Oct 25, 2017

Oracle today announced it has been named a leader in Gartner’s 2017 Magic Quadrant for Sales Force Automation. The company was recognized for its ability to execute and completeness of vision.

Sales force automation has long been viewed as a sales management tool, with features and functionality designed primarily around the needs of sales professionals. However, as customer behavior evolves, legacy sales technology has grown outdated and less effective. Designed to serve the needs of today’s empowered customer, Oracle Sales Cloud enables sales professionals to engage customers earlier and accelerate and close deals using a complete, innovative and proven sales solution.

“Customers today have information at their fingertips and require real-time support and service. As such, delivering a responsive customer experience is more important than ever,” said Stephen Fioretti, vice president, CX Engagement Solutions at Oracle. “Oracle Sales Cloud helps businesses thrive in this modern sales environment by leveraging innovative technologies, such as artificial intelligence (AI) and data to create a smarter sales experiences for sales teams and customers. We believe Gartner’s recognition of Oracle’s position as a leader in this space showcases our commitment to helping our customers achieve measurable sales results.”

According to Gartner, vendors positioned as leaders have the ability to execute their vision through products, services and demonstrate solid business results in the form of revenue and earnings. Leaders have significant successful customer deployments in North America, EMEA and Asia/Pacific in a wide variety of industries, and with multiple proof points for deployments above 500 users. They also consistently demonstrate above-average customer experience satisfaction.

Oracle Sales Cloud is part of Oracle CX Cloud Suite. Oracle CX Cloud Suite empowers organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences and achieve predictable and tangible business results. The Oracle CX Cloud Suite includes Oracle Commerce Cloud, Oracle Marketing Cloud, Oracle Sales Cloud and Oracle Service Cloud.

Download the Gartner’s 2017 Magic Quadrant for Sales Force Automation report here: http://bit.ly/2xMdoww

Gartner Disclaimer
Gartner does not endorse any vendor, product, or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Contact Info
Simon Jones
PR for Oracle
+1.415.856.5155
sjones@blancandotus.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Simon Jones

  • +1.415.856.5155

Oracle Recognized as a Leader in Independent Analyst Report on Sales Force Automation

Oracle Press Releases - Wed, 2017-10-25 07:00
Press Release
Oracle Recognized as a Leader in Independent Analyst Report on Sales Force Automation Oracle Sales Cloud positioned as a leader and cited for its broad portfolio of selling applications all on a common platform

Redwood Shores, Calif.—Oct 25, 2017

Oracle today announced it has been named a leader in sales force automation solutions in a report from Forrester Research. The Forrester Wave™: Sales Force Automation Solutions, Q2 2017 recognized Oracle for its “broad portfolio of selling apps on a common platform”—the report also noted that “Oracle extends the platform for a wide array of verticals, allowing AD&D professionals to shorten their time-to-value across these applications.”

According to Forrester, the biggest pain point around legacy sales force automation has been its negative impact on productivity, primarily due to the amount of manual data entry required by end users. Oracle Sales Cloud, available via any device and integrated directly with key applications, eliminates these legacy challenges by enabling sales professionals to easily input and access all the information they need to engage customers earlier and accelerate and close deals using a complete, innovative and proven sales solution.

“Sales professionals across industries and business models are faced with the heightened needs of empowered buyers, who require responsive, engaging and intelligent customer experiences,” said Stephen Fioretti, vice president, CX Engagement Solutions at Oracle. “Integrating cutting edge technology such as AI, Oracle Sales Cloud helps sales professionals address these needs to elevate customer engagements and drive competitive differentiation. I believe that being positioned by Forrester as a leader in this space further demonstrates Oracle’s commitment to helping our customers achieve superior sales results.”

Of the 10 vendors Forrester evaluated for sales force automation, Oracle Sales Cloud was among three companies recognized as a leader across 35 criteria, which were grouped into three categories of current offering, strategy and market presence. Oracle was cited for the strength of its balance of solution breadth, horizontal innovation and industry specialization.

Oracle Sales Cloud is part of Oracle CX Cloud Suite. Oracle CX Cloud Suite empowers organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences and achieve predictable and tangible business results. The Oracle CX Cloud Suite includes Oracle Commerce Cloud, Oracle Marketing Cloud, Oracle Sales Cloud and Oracle Service Cloud.

Download The Forrester Wave™: Sales Force Automation Solutions, Q2 2017 report here: http://bit.ly/2yQgLrb

Contact Info
Simon Jones
PR for Oracle
+1.415.856.5155
sjones@blancandotus.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Simon Jones

  • +1.415.856.5155

SORT AGGREGATE resets the cost

Tom Kyte - Wed, 2017-10-25 04:26
<code> SET lines 777 SET pages 10000 SET trimspool ON --Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production CREATE TABLE t(ID INTEGER PRIMARY KEY,flag VARCHAR2(4000)); INSERT /*+append*/ INTO t SELECT LEVEL,LPAD(...
Categories: DBA Blogs

Join the Oracle Intelligent Bot Webcast on Oct 26th

    Chatbots are the fastest growing market in mobile application development and extend mobile opportunities to the conversational channel. Oracle Intelligent Bots is a new...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Manufacturer Replaces the Google Search Appliance with Mindbreeze for Intranet and Website Search: From Racking to Go-Live in 37 Days

In today’s post I’m excited to share the story of a recent Mindbreeze deployment. One of our long-time customers, a global leader in the field of industrial automation, needed a replacement for their expiring Google Search Appliances (GSAs). They had used the GSA to power the search on their public-facing website as well as their employee intranet. When Google announced the GSA’s end of life, they were left in a need of a replacement. Due to its similar feature set and architecture, Mindbreeze offered an easy migration from GSA and allowed existing customizations to be reused.
Working with Fishbowl to implement Mindbreeze went very well. The expertise they brought enabled us to meet our aggressive timeline to remove the Google Search Appliances. Fishbowl’s knowledge allowed them to be flexible to our needs during implementation while still covering all the necessary material. We appreciated that.

Application Development and Support Manager

Google Search Appliance (GSA) Replacement, Alternatives, and Migration
GSA Migration Requirements

Google Search ApplianceIn order to provide comprehensive website search, this organization needed to index content from three different sources. First, they needed to crawl the HTML pages on the site itself. Second, they needed to index records in their parts and products database. And third, they needed to index PDFs and other supporting product documentation stored in Oracle WebCenter Content (their document management system). In order to serve their sales and distribution partners, they needed the option to restrict a subset of this content to only logged-in partners. This organization had previously integrated GSA search results into their website using a custom-built search interface which consumed the GSA’s XML response. They planned to reuse the front-end components of that integration while replacing the backend with Mindbreeze.

For the intranet search, they needed to index secure documents from Oracle WebCenter Content. WebCenter Content was also the platform through which the secure results would be served to employees. The search results on the intranet needed to include both the access-controlled internet documents, as well as the customer and partner-facing documents that would also be accessible from the website.

Mindbreeze Implementation

We began the implementation by configuring Mindbreeze to index the necessary data sources. Each of their three content sources required different indexing tools. The approach was similar to how the same data had been previously indexed using the GSA. First the Mindbreeze web crawler was configured to crawl the site. We were able to reuse the crawl patterns already defined when configuring the GSA. Next, content from their parts and products database was indexed using the Mindbreeze Data Integration connector. This connector uses the Talend ETL platform to create jobs that extract, transform, and load structured data into Mindbreeze without a custom connector. In this case the data integration job was configured to connect to the same tables they had previously indexed with the GSA Connector for Databases. Finally, indexing was configured for the documents stored in Oracle WebCenter Content. In order to index WebCenter Content, the customer purchased Fishbowl’s Oracle WebCenter Content Connector for Mindbreeze. Unlike GSA, Mindbreeze connectors can run directly on the appliance and do not require any off-board connector servers. The connector is deployed via a Mindbreeze plugin and corresponding WebCenter Content component and leverages the Mindbreeze connector framework. The indexing criteria had already been determined during the GSA integration and was able to be copied directly into Mindbreeze. Items from Oracle WebCenter Content were separated into three groups—public content, partner-only content, and secure intranet content. These content groups could then be restricted based on the various serving configurations.

The Mindbreeze application was a step up from our previous search application. We had no problems crawling multiple data sources (website, database, WebCenter) and serving that content to multiple front ends. Although there was an initial learning curve, it is easy to edit configurations and rebuild indexes with very little or no downtime. And the onboard analytics make troubleshooting issues a breeze.

Web Developer

Once indexing was configured, the results needed to be integrated into the website and intranet. Mindbreeze provides a REST API which returns results in JSON format. This integration is comparably easier than working with the GSAs XML or XSLT responses. Because this customer had already written an integration to facilitate communication between the GSA and their website, built using Adobe Experience Manager, they were able reuse their existing site’s search interface. Search requests to the GSA were replaced with calls to the Mindbreeze search API. This integration also controlled the scope of the search based whether or not a user was allowed to access partner-only content.

For the intranet, the results were embedded directly into the Oracle WebCenter Content web application. The customer leveraged the default Mindbreeze search interface, but customized the look and feel using their own style sheet. This gave them the look of a tightly integrated search page but required less than an hour of development to implement. In order to provide secure search, the Mindbreeze authentication mechanism included with the connector was configured. This mechanism passes the identity of a WebCenter user to the Mindbreeze appliance at serve time in much the same way as security search was previously configured with GSA. The Mindbreeze appliance then uses this identity to resolve the access control lists (ACLs) placed on the documents during indexing. This approach is similar to the early-binding options available with the GSA and allows granular access controls to perform well at scale.

Results

The entire project from racking the Mindbreeze appliance to releasing the solution in production took 37 days—although the total days of work effort was considerably less. This project focused on one-to-one replacement of GSA functionality to ensure completion in time for the customer’s upcoming Google Search Appliance expiration. Initial user feedback indicates improved relevancy compared to the previous GSA integration. Future enhancements include implementing rich search suggestions and document previews to further enrich search capabilities.

If you have a GSA approaching expiration, we believe Mindbreeze offers the quickest and most reliable search replacement path. As a Mindbreeze partner, we offer both resale and implementation services, and as a long-time GSA partner, we’re familiar with the functionality of both platforms. 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 Manufacturer Replaces the Google Search Appliance with Mindbreeze for Intranet and Website Search: From Racking to Go-Live in 37 Days appeared first on Fishbowl Solutions.

Categories: Fusion Middleware, Other

Updated: Minimizing EBS 12.2.7 Upgrade Downtimes

Steven Chan - Tue, 2017-10-24 15:24

We have updated our recommendations for minimizing downtimes when upgrading to EBS 12.2.7:

Written by Jim Machin, a senior member of our Applications Performance group, this white paper contains a wealth of detailed technical recommendations for reducing the amount of time needed for an
EBS 12.2.7 upgrade. 

Events vs. sessions bottlenecks diagram

It covers:

  • Technical preparation and planning activities
  • Diagnostics for monitoring and troubleshooting performance issues
  • Common solutions to performance issues
  • Oracle Applications Tablespace Model (OATM) considerations
  • Methods for purging old data
  • Gathering statistics
  • Detailed recommendations for improving resource management, sizing, and workloads

Latest updates to this whitepaper

This white paper is updated regularly with new tips and recommendations based upon our Application Performance group's work with actual EBS 12.2 customers and their Service Requests.  All EBS 12.2
sysadmins should monitor this white paper regularly.  This latest version includes the following updates:

  • It is updated for 12.2.7, CUP8, AD/TXK Delta 10.
  • It includes new sections on optimizer_adaptive_features, parallel_degree_policy, SQLHC, Long running class, xdf, xml and other files (dev/random, dev/urandom), Automation of display cursor.
  • There are significant changes to the sections  on Downtime Mode, Planning, Diagnostic and  Disabling DBMS Scheduler.
  • There are changes in the recommendations for AD Parallel workers, parallel_max_servers and job_queue_processes
  • The section on adxplain.sql has been removed
  • Out of date references have been removed.

Related Articles

 

Categories: APPS Blogs

Pages

Subscribe to Oracle FAQ aggregator