Feed aggregator

Does update query returns affected row(s) value in key holder ?

Tom Kyte - Mon, 2017-10-30 12:46
Hi TOM, Does Oracle returns affected rows for update SQL statement in key holder? For insert query we supposed to receive the auto generated key. Such a way update query returns the affected rows id ?
Categories: DBA Blogs

Partner Webcast – IoT in Action on Oracle Cloud Platform

Oracle Internet of Things (IoT) Cloud Service is a managed Platform as a Service (PaaS) cloud-based offering that helps you make critical business decisions and strategies by allowing you to connect...

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

Oracle Delivers Industry’s Only Cloud-Based SaaS Solution for Core Administration and Digital Engagement with Healthx

Oracle Press Releases - Mon, 2017-10-30 08:00
Press Release
Oracle Delivers Industry’s Only Cloud-Based SaaS Solution for Core Administration and Digital Engagement with Healthx

Redwood Shores Calif—Oct 30, 2017

Today Oracle announced a global collaboration with Healthx Inc., a leader in cloud-based digital engagement solutions for healthcare payers and other stakeholders. The collaboration offers health plans and other healthcare payers the industry’s first and only 100 percent cloud-based software-as-a-service (SaaS) solution for core administration and digital engagement.
Designed from the ground up to be a SaaS, cloud-powered solution, the combination of Oracle and Healthx’s technology expertise provide functionality, scalability and security at a level previously unavailable to the market.
“The combination of Oracle health insurance cloud services and Healthx capabilities creates a unique offering for healthcare payers,” said Sean Downs, CEO for Healthx. “For the first time ever, healthcare payers can now power their entire enterprise operations through the cloud on a SaaS platform. This integrated solution will drive both administrative and medical cost savings for payers while providing the industry’s best digital experience for their members and providers.”
This solution covers end-to-end core administration capabilities including membership management, enrollment, authorizations, claims adjudication, value-based payments, claims analytics, digital self-service, digital payer/provider/patient collaboration and mobile member engagement.
“Healthx’s digital engagement platform combines the configurability and proven scalability that our customers demand,” said Vice President of Oracle Financial Services Global Business Unit, Srini Venkat. “When combined with Oracle Health Insurance Cloud Services, health plans can seamlessly connect, activate and engage their members and providers.”
Contact Information
Alex Moriconi
Oracle Corporation
About Oracle PartnerNetwork
Oracle PartnerNetwork (OPN) Specialized is the latest version of Oracle’s partner program that provides partners with tools to better develop, sell and implement Oracle solutions. OPN Specialized offers resources to train and support specialized knowledge of Oracle products and solutions and has evolved to recognize Oracle’s growing product portfolio, partner base and business opportunity. Key to the latest enhancements to OPN is the ability for partners to differentiate through Specializations. Specializations are achieved through competency development, business results, expertise and proven success. To find out more visit http://www.oracle.com/partners.
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 oracle.com.
About Healthx, Inc.
At Healthx, we put our nearly 20 years of industry experience and best practices to work to serve the needs of more than 190 healthcare payers representing 25 million members and 700,000 providers. We develop and implement secure, cloud-based member-centric digital portals that connect payers with members and providers. We partner with health plans and third-party administrators to build comprehensive, configurable solutions that improve clinical, operational and financial performance. Through our platform, our customers can engage members and providers, close gaps in care, achieve regulatory compliance, improve quality ratings and reduce costs. Our customers achieve a rapid return on investment by moving more transactions from costly channels to efficient online portals. For more information, visit www.healthx.com. Follow Healthx on Twitter, LinkedIn and Facebook.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Safe Harbor
The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle Corporation.

How to Configure the Top 4 GSA Features in Mindbreeze – Plus 6 New Favorites

In the past few weeks, we’ve looked at why fishbowl chose Mindbreeze as a GSA replacement and how one of our GSA customers transitioned to Mindbreeze. Today I’ll share how to set up the most-used GSA functionality within the Mindbreeze InSpire enterprise search appliance.

Dynamic Navigation

The GSA’s Dynamic navigation enables users to refine a search using metadata attributes as filters. Within Mindbreeze this functionality is called Filter Facets. A default set of filters can be defined for each Mindbreeze client service based on the metadata available from the various indexed content sources. The client service is roughly equivalent to the GSA’s client frontend parameter (as opposed to the proxystylesheet which also references a frontend but is more comparable to a search app in Mindbreeze). In addition to the filters defined for a client service, you can also define filters within custom search apps by explicitly adding the desired filters. This is true for both the GUI-based Mindbreeze Search App Designer, and for search apps built using the Mindbreeze API.

What’s New: Mindbreeze offers a multi-select interface for search facets. This was a much-requested GSA enhancement and allows you to refine your search by selecting among several facet options rather than a single option as available with GSA. Mindbreeze also allows configuration of whether multiple selections should apply AND or OR constraints across the multiple selected values.

Configuring Mindbreeze Search Filters

From the Client Services tab in the Mindbreeze Management Center expand the desired client service and navigate to the Filters heading. Check the box next to each metadata field you want to include as a filter. Any searches performed against this client service will return these filters unless overridden in an individual search app.

Document Previews

The GSA’s document preview engine creates image renditions of Word, PowerPoint, and PDF files for up to 30 pages of a document; previews or thumbnails are not available for other file types out of the box. The Mindbreeze preview engine supports preview settings for 91 different file types. For many files, the preview engine can be configured to create both a document thumbnail, for use on results pages, and a content preview which is typically displayed as a modal popup. For example, Mindbreeze can display a thumbnail of a Word document next to the result title, and a preview link which displays a full-context PDF rendition as the document preview.

What’s New: In addition supporting more files types and creating thumbnails, the Mindbreeze previews highlight all instances of your query terms in the preview rendition making it easy to see where in the document the relevant keywords occur. Mindbreeze previews are controlled by the Mindbreeze filter service which controls many aspects of how document contents are processed and extracted for indexing. The Mindbreeze SDK provides an interface for creating custom filter plugins which can alter or add to the standard preview generation capabilities.

Configuring Mindbreeze Previews

From the Filters tab in the Mindbreeze Management Center, expand the desired Filter Service. For each applicable file type, select the desired filter plugin. For example, to create PDF previews of Excel files, navigate to xlsx and select FilterPlugin.OfficeDocumentToPDFContentFilter. Like GSA, Mindbreeze previews are generated during indexing. Any existing documents will need to be reindexed for preview configuration changes to appear in search results.

Mindbreeze Preview Config

Custom Synonyms

The GSA and Mindbreeze search appliances both provide query transformation services for automatic modification of search queries. Synonym transformation allows you to find search results by looking for different synonyms of a word, therefore the query is transformed to search for every term listed in the synonyms list. For example, if a user searches for “FAQ,” the appliance could also look for documents containing “frequently asked questions”.

What’s New: Although a shared synonyms file is included with Mindbreeze out of the box, unique synonyms may optionally be defined for individual content sources. This means if you use different terms in your ERP system than on your customer extranet, you can define synonymous terms for their respective sources. Mindbreeze also offers two additional query transformation engines that address specific use cases often handled with synonyms in the GSA. The first is Replacements, which completely replace a defined term with an alternative term or terms. The second is Vocabulary, which specifies preferred and alternative versions of defined search terms. Vocabulary entries are treated as synonyms; however, the preferred label is given more weight than the alternate label when determining relevancy.

Configuring Mindbreeze Synonyms

Select Synonyms from the Search Experience menu in the Mindbreeze Management Center. In the table displayed, enter synonymous terms with one term per column and one term group per row as shown.

Mindbreeze query transformation can be applied globally or to a specific data source. To apply the Synonyms to all content, navigate to the Indices tab and locate Query Transformation Services at the bottom of the page. Add the SynonymTransformer from the picklist. Expand the configuration and add the following configuration: Property: SYNONYM_CSV_FILE_PATH and Value: /data/resources/synonyms.csv. To configure synonyms for an individual index perform these same steps within the Query Transformation Services section of an individual index. You can optionally specify a path to a different synonyms file than the default show here.


Both GSA and Mindbreeze can provide query suggestions within the search box that complete a user’s query as they type. The GSA used popular search queries from the past 90 days to determine the top suggestions. Mindbreeze offers a similar option called Similar Queries along with four other possible data sources from which to generate suggestions. Like Filter Facets, suggestions can be defined for each Mindbreeze client service.  Suggestion data is also available using the Mindbreeze Suggest API (api.v2.suggest). This API is useful when adding Mindbreeze suggestions to an existing search box on a website or application. The Mindbreeze Suggest API is similar to the GSA’s Query Suggestion Service /suggest Protocol.

What’s New: Unlike the GSA, Mindbreeze suggestions can be provided from a number of different data sources. Suggestions can even be displayed when a user places their cursor in the search box before entering any characters; this is called Initial Suggest. The following suggestion options are available in Mindbreeze:

  • Similar queries (this is comparable to the GSA’s suggestions feature)
  • Suggestions from a CSV file
  • Mindbreeze tabs to search for the current search term
  • Document properties from indexed metadata (e.g. Document Titles)
  • Recent queries from the last searches performed by a user

The ability to load suggestions from a CSV file provides an easy way to pre-populate suggestions and ensures they remain in the suggestion pool even if they are not frequently used. This was a common enhancement request from GSA customers.

Configuring Mindbreeze Suggestions

From the Client Services tab in the Mindbreeze Management Center expand the desired client service and navigate to the Suggest Settings and Initial Suggest Settings headings, respectively. Check the box next to each suggestion source you want to enable for this client service. Any searches performed against this client service will return these suggestions unless overridden in a direct API request. If suggestions from a CSV file are desired, the path to the CSV file must be defined under the heading Suggest Settings (Concept CSV) also located on the client service configuration page.

Beyond GSA – 6 New Things We Love About Mindbreeze

While Mindbreeze offers GSA parity in many ways, there are plenty of upgrades to be found. Here are a few of our favorites:

  • Mindbreeze lets you boost (i.e. bias) the overall weight of a metadata field enabling you to increase (or decrease) the general importance of fields like title, subject, or keywords.
  • Mindbreeze provides built-in search analytics and application performance monitoring via the integrated App Telemetry platform.
  • Mindbreeze offers a native user feedback mechanism including screenshots from the users’ search results.
  • Mindbreeze provides access to the appliance OS and filesystem. You can upload your own files to support advanced configurations or create custom interfaces. This also allows the use of standard backup techniques on the index and configuration files.
  • Mindbreeze does not require secondary servers for connectors (e.g. Tomcat); even custom connectors run directly on the appliance.
  • Mindbreeze includes a search app builder which provides drag and drop tools for creating use-case specific search apps without coding.

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 How to Configure the Top 4 GSA Features in Mindbreeze – Plus 6 New Favorites appeared first on Fishbowl Solutions.

Categories: Fusion Middleware, Other

We -as a country- are no longer to be trusted?

Frank van Bortel - Mon, 2017-10-30 03:15
Who Do You Trust? As legislation changed, Mozilla filed a bug with potential serious consequences. Check out bug 1408647. Removing the root certificate as trusted authority makes it look asif any certificate, issued by any of the Dutch PKI organizations, is potential unsafe. Which is correct, to a point, as the law allows the use of false keys by the Ducth autorities. Creepy. That makes the Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

Oracle Health Sciences Collaborates with dMed in China to Enhance Pharmacovigilance Management with Oracle Health Sciences Argus Safety

Oracle Press Releases - Sun, 2017-10-29 11:23
Press Release
Oracle Health Sciences Collaborates with dMed in China to Enhance Pharmacovigilance Management with Oracle Health Sciences Argus Safety

Suzhou, China—Oct 29, 2017

Today Oracle announced that is collaborating with dMed in China as rapidly emerging local Chinese biopharma companies look to meet growing regulatory compliance and safety management requirements but do not have the resources, systems and skills in-house to do so.

There is an increase in clinical trials in China, deepening regulatory reform at CFDA, and China’s new membership at ICH. All of these changes have heightened the importance of global alignment on clinical development and post approval responsibilities. One of the areas lagging is drug safety and pharmacovigilance. This has resulted in the strong need for a reliable drug safety database that helps meet international safety standards.

“This is why dMed decided to work with Oracle Health Sciences,” said Dr. Lingshi Tan, Chairman and CEO, dMed Biopharmaceutical Co., Ltd. “The Oracle Argus Safety system enables our Pharmacovigilance experts to provide comprehensive case management and safety reporting services. The ability of accessing a reliable drug safety database helps customers meet international safety standards and make better safety decisions.”

“We are pleased to announce our collaboration with dMed Biopharmaceutical Co., Ltd as an Argus Safety customer in China. dMed has right drug safety surveillance and pharmacovigilance professionals who can make best use of our system to support product safety monitoring in compliance with local and global regulatory requirements,” said Mr. Steve Rosenberg, senior vice president and general manager of Oracle Health Sciences. “We believe there will be fantastic synergy between dMed’s in-depth knowledge in pharmacovigilance and Oracle’s comprehensive pharmacovigilance platform.”

By collaborating with Oracle Health Sciences on business process services, dMed aims to help its clients to optimize global compliance and integrate risk management into key processes. Local sponsors such as Hua Medicine, Zai Lab and others are leveraging these services and the Argus platform to meet their Safety and compliance requirements.

Contact Info
Valerie Beaudett
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, please visit us at www.oracle.com.

About dMed Biopharmaceutical Co., Ltd

dMed, http://www.dmedglobal.com/), a clinical development services and solutions provider based in China that partners with both local and global pharmaceutical, biotech and medical device companies, is now an Argus Safety Business Process Service (BPS) partner for deployment of latest Argus multi-tenant bilingual system. Its services include scientific, strategic, regulatory and quality assurance related consultation for clinical development and product registration; clinical trial design and execution; clinical data management, biostatistics and programming, medical writing, pharmacovigilance and risk management; and clinical trial quality assurance and inspection readiness.


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

Valerie Beaudett

  • +1.650.400.7833

Ubuntu 17.10: problems with gnome extensions

Dietrich Schroff - Sun, 2017-10-29 06:16
After migrating to ubuntu 17.10 the unity desktop is gone and the system starts up with gnome 3.
As i wrote here, there are some problems with window decorations which can be fixed by (re-)moving some directories.

But i still had some problems with gnome extension:
The installation process via the webpage gnome extensions worked fine, but e.g. the system monitor did not show up...

The solution was easy:
apt install vanilla-gnome-desktopAnd after this fix the system monitor is there:

Oracle 12c - query behavior change (11g not thrown error while "group by" not mention in sub-query/in-line)

Tom Kyte - Sun, 2017-10-29 00:06
Hi Team, We are migrating from 11g to 12c. We observed one behavioral change, as "group by" not mention in in-line query but 11g not thrown error. Query characteristics ---------------------------------- 1. Main query contains a inline...
Categories: DBA Blogs


Tom Kyte - Sun, 2017-10-29 00:06
Categories: DBA Blogs

Local unique indexes on partitioned tables

Tom Kyte - Sun, 2017-10-29 00:06
Tom, I'm wondering why Oracle requires the partitioning key on a local unique index. I realize that internally Oracle doesn't want to have to scan all local index segments to check the constraint. But why should the partitioning key need to be o...
Categories: DBA Blogs

12c release 1 dump questions confusions

Tom Kyte - Sun, 2017-10-29 00:06
Greetings, Every time i submit a question, i get a sense of confidence that i will surely get a valid and updated answer from the world's most interactive and supportive forum. The group is a ORACLE DICTIONARY for me. I thank you from bottom of...
Categories: DBA Blogs

nVision Performance Tuning: 4. Partitioning of Ledger, Ledger Budget, and Summary Ledger Tables

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

Note: Partitioning is a licenced option in Oracle RDBMS, and is only available on Enterprise Edition.

nVision queries always contain single value predicates on LEDGER and FISCAL_YEAR.  They will also always have either single value predicate or a range predicate on ACCOUNTING_PERIOD.  Therefore, partitioning the ledger tables on these columns is an effective way to cut down the data to be processed by the query as early as possible.

I usually partition the ledger, ledger budget and summary ledger tables on the combination of FISCAL_YEAR and ACCOUNTING_PERIOD in a single range.
Most customers have monthly accounting periods, in which case I create 14 partitions for the current and previous fiscal years, but only have a single partition for each previous fiscal years.
  • One for each of the 12 accounting periods
  • One for period 0 (brought forward)
  • One for periods 998 and 999 (carry forward and adjustments)
I have seen one system with daily accounting periods that also had 14 partitions per year, in groups of 30 days.  This also worked very well.
I would then consider sub-partitioning on another column depending on the nature of data and the processing.  For example:
  • LEDGER is often a good candidate.  In which case, I would create one list sub-partition for each of the larger ledgers and have a default list partition for the rest.
  • On one a global system with various regional, but locally overnight, batch processing windows ledger was list sub-partitioned on BUSINESS_UNIT. A list partition was proposed for each region containing the top business units for that region.  This not only helped regional reporting but also minimised inter-regional contention.
  • It would even be possible to vary the sub-partitioning in different fiscal years if a change occurred in the business.
This example shows part of the DDL used to create the LEDGER table.
  • There is one range partition for the whole of the fiscal year 2015 because it is historical and rarely queried, and then not usually by a single period.
  • Monthly partitioning is used from the previous fiscal year, 2016, onwards.
  • Historical partitions are created without any reservation for free space as they are closed and won't be updated any further.  The could also be compressed.
CREATE TABLE sysadm.gfc_ledger
(PARTITION ledger_2014 VALUES LESS THAN (2015,0) PCTFREE 0 …
(SUBPARTITION ledger_2014_actuals VALUES ('ACTUALS')

,SUBPARTITION ledger_2014_z_others VALUES (DEFAULT)
,PARTITION ledger_2015_bf VALUES LESS THAN (2015,1) PCTFREE 0…
(SUBPARTITION ledger_2015_bf_actuals VALUES ('ACTUALS')

,SUBPARTITION ledger_2015_bf_z_others VALUES (DEFAULT)
,PARTITION ledger_2015_01 VALUES LESS THAN (2015,2) PCTFREE 0 …
(SUBPARTITION ledger_2015_01_actuals VALUES ('ACTUALS')

,SUBPARTITION ledger_2015_01_z_others VALUES (DEFAULT)

,PARTITION ledger_2015_12 VALUES LESS THAN (2015,13) PCTFREE 0 …
(SUBPARTITION ledger_2015_12_actuals VALUES ('ACTUALS')

,SUBPARTITION ledger_2015_12_z_others VALUES (DEFAULT)
,PARTITION ledger_2015_cf VALUES LESS THAN (2016,0) PCTFREE 0 …
(SUBPARTITION ledger_2015_cf_actuals VALUES ('ACTUALS')

,SUBPARTITION ledger_2015_cf_z_others VALUES (DEFAULT)
,PARTITION ledger_2016_bf VALUES LESS THAN (2016,1) PCTFREE 0 …
(SUBPARTITION ledger_2016_bf_actuals VALUES ('ACTUALS')

,SUBPARTITION ledger_2016_bf_z_others VALUES (DEFAULT)

I usually recommend locally partitioning all indexes.  Even though FISCAL_YEAR and ACCOUNTING_PERIOD are the 24th and 25th columns on the unique index on LEDGER, I would still locally partition it.
CREATE UNIQUE INDEX sysadm.ps_ledger_new ON sysadm.ps_ledger
(PARTITION ledger_2014 PCTFREE 0
(SUBPARTITION ledger_2014_actuals

,SUBPARTITION ledger_2014_z_others

Maintenance TasksThe introduction of range partitioning on FISCAL_YEAR brings some regular maintenance tasks.
  • New partitions must be added to the ledger and summary ledger tables for each new fiscal year before it is opened and transactions posted to it.  The LEDGER_BUDG table can be similarly partitioned and partitions should be added before budget entries are made.
  • I deliberately do not create MAXVALUE partitions on ledger tables.  If the application attempted to post data to an accounting period for which new partitions had not been created it would experience an Oracle error.  Therefore it is essential to remember to add the partitions in advance. I think this is preferable to forgetting to add the partitions and having performance degrade as data accumulates in the MAXVALUE partition.
  • As periods close and the application ceases to insert or update rows, their partitions can be compressed using
  • As and when old fiscal years are no longer needed they can be archived by simply dropping the partitions, or exchanging them out to another table.
Managing Partitioning in PeopleSoftApplication Designer is not good at managing partitioning.  I have written previously about the limited support for partitioning introduced in PeopleTools 8.54.  It uses Oracle's DBMS_METADATA package to preserve existing settings, including partitioning, but the support for initially implementing partitioning is poor.
It may be reasonable to manually manage partitioning in a single table, but if you also have a number of summary ledgers, and have perhaps also built materialized views on them, you can have a significant number of partitioned objects to manage.  Manual scripting is going to become a significant overhead.  You might want to look at Managing Oracle Table Partitioning in PeopleSoft Applications with GFC_PSPART package.

Use ORACLE_UNQNAME for DataGuard Environment

Michael Dinh - Sat, 2017-10-28 09:25

If you are running only 1 database on the host, then it may not be useful.

However, if you run multiple databases, then it makes it easier to automate provided there are consistencies and/or conventions.

DB configuration

HOST01:(SYS@qa):PHYSICAL STANDBY> show parameter db%name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      qa
db_unique_name                       string      qadr

OS configuration

$ env|grep ORACLE
$ ps -ef|grep pmon
  oracle  9896050        1   0 16:11:12      -  0:03 asm_pmon_+ASM
  oracle 10354862        1   0 20:06:31      -  0:02 ora_pmon_qa

Check DB status using srvctl

srvctl status database -d $ORACLE_UNQNAME -v
Database qadr is running with online services qarosvc
#!/bin/sh -e
. /opt/oracle/oracle_qa_env
dgmgrl -echo << END
connect /
show configuration
show database ${ORACLE_SID}
show database ${ORACLE_UNQNAME}
$ ./d.sh
DGMGRL for IBM/AIX RISC System/6000: Version - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
DGMGRL> show configuration

Configuration - dgqa

  Protection Mode: MaxPerformance
    qa   - Primary database
    qadr - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

DGMGRL> show database qa

Database - qa

  Enterprise Manager Name: qa_cluster
  Role:                    PRIMARY
  Intended State:          TRANSPORT-ON

Database Status:

DGMGRL> show database qadr

Database - qadr

  Enterprise Manager Name: qa1
  Role:                    PHYSICAL STANDBY
  Intended State:          APPLY-ON
  Transport Lag:           0 seconds (computed 0 seconds ago)
  Apply Lag:               0 seconds (computed 1 second ago)
  Apply Rate:              937.00 KByte/s
  Real Time Query:         ON

Database Status:

DGMGRL> exit

crsctl stat res -w “STATE = ONLINE”|egrep “db$|TYPE=ora.database.type”

#!/bin/sh -e
. /opt/oracle/oracle_qa_env
dgmgrl -echo << END
connect /
show configuration
show database ${ORACLE_SID}
show database ${ORACLE_UNQNAME}
. /opt/oracle/oracle_qa2_env
dgmgrl -echo << END
connect /
show configuration
show database ${ORACLE_SID}
show database ${ORACLE_UNQNAME}
. /opt/oracle/oracle_stageqa_env
dgmgrl -echo << END
connect /
show configuration
show database ${ORACLE_SID}
show database ${ORACLE_UNQNAME}
. /opt/oracle/oracle_test_env
dgmgrl -echo << END
connect /
show configuration
show database ${ORACLE_SID}
show database ${ORACLE_UNQNAME}
Improved dg_show.sh using function.
#!/bin/sh -e
  dgmgrl -echo << END
  connect /
  show configuration
  show database ${ORACLE_SID}
  show database ${ORACLE_UNQNAME}
. /opt/oracle/oracle_qa_env
. /opt/oracle/oracle_qa2_env
. /opt/oracle/oracle_stageqa_env
. /opt/oracle/oracle_test_env

Counting the number of business days between 2 dates.

Tom Kyte - Sat, 2017-10-28 05:46
how to get the number of days between two dates excluding saturdays and sundays using pl/sql?
Categories: DBA Blogs

PARALLEL Hint not getting used in SELECT

Tom Kyte - Sat, 2017-10-28 05:46
Hi, I have a SQL written in stored procedure: SELECT /*+ PARALLEL(TB_TEST, 8) +/ FROM TB_TEST WHERE DT <= TO_DATE('01/01/2015', 'MM/DD/YYYY'); When i execute the procedure and monitor v$session, I could see only one session with having SQL_I...
Categories: DBA Blogs

Colums into rows

Tom Kyte - Sat, 2017-10-28 05:46
Tom, I see lots of references to turning rows into columns, but how about turning columns into rows? Obviously I can select x union select y union select z, but that is only realistic for a small number of columns. What would you suggest for a lar...
Categories: DBA Blogs

US Bank executive team awards Cognizant Team on successful NBA Project Implementation.

Arvind Jain - Fri, 2017-10-27 19:09

I am glad to share some pictures from a recent San Francisco event where US Bank top executives recognized and awarded Cognizant NBA team for successful Production delivery of NBA on Adobe Marketing Cloud.

All those nights and weekend of labor is gone now but it also signals that new challenges and opportunities await for me and my team as it is mainly production and operations support from now on .....

Still Stuck on SiteStudio? Move Your Intranet and Modernize with WebCenter Portal

Fishbowl’s Director of Solutions, Jerry Aber, contributed to this blog post.

Surprisingly, there are still many SiteStudio (Oracle WCM) customers out there using the product for their employee intranet. We just chatted with another one this week, in fact. I say surprisingly because even though the product is technically under support (extended lifetime) until 2019, there are so many advantages and benefits of upgrading a SiteStudio intranet to Oracle WebCenter Portal. Oracle themselves outlined a few in their statement of direction document released back in 2012.

Fishbowl has done numerous WebCenter Portal projects over the last 5 years, and some of those have been SiteStudio to Oracle WebCenter Portal upgrades. We have found for employee intranets specifically that WebCenter Portal is the obvious choice due to its flexibility and how it aggregates content, applications, and data onto a single pane of glass. No more link farms, poorly branded sub-pages, and confusing navigation. If your organization is still  using SiteStudio for its intranet, perhaps this blog post will persuade you to upgrade and modernize today.

SiteStudio Revisited

SiteStudio sites are built on the premise of Templates, Regions, Fragments and Lists with a site design overlaying the top of the structure outlined by its architecture. It did include inline contribution and editing model that helps contributors manage the site with less IT intervention. However, the contribution model wasn’t very streamlined as essentially Word documents were used to structure page content and then converted to HTML. This caused numerous page formatting issues.

Compare this to ability with WebCenter Portal – and enhanced with Fishbowl’s Portal Solution Accelerator – to edit text inline of portal pages, and you have a contribution model that is truly optimized for business user contribution. The impact of this is more frequent updates to page content, which keeps employees coming back for new information leading to better engagement.

SiteStudio to WebCenter Portal: Making the Move

As customers consider their employee intranet/portal roadmap and SiteStudio upgrade path, a big concern that comes up frequently is regarding the overall “migration” from a web page-based SiteStudio intranet site to a Portal-based site. There is no natural migration/upgrade roadmap for making this happen as the underlying technologies are considerably different. Additionally, there are two large issues to consider: The SiteStudio code used to render the content, and that the web content is stored in SiteStudio data files.

However, what we’ve found is that WebCenter Portal sites can be created to consume the SiteStudio assets and use the SiteStudio development model by the leveraging what’s called the Content Presenter task flow. This is one way to ensure a tight and clean integration with the Oracle Content Server. This model works nicely when SiteStudio designs and tools are used, but does not translate well to any portal development paradigms. Such paradigms are way more flexible, modular and use current web technology patterns, such as Oracle JET, that not only make the site look nice but keeps it performing at a high-level.

Also, keep in mind this relegates you to sticking with the SiteStudio Data File storage model for your web content which can be a challenge when it comes to managing content and sharing content around the organization.

So, given that, what are some other questions you and your organization can ask to determine if upgrading from SiteStudio to Oracle WebCenter Portal makes sense and would be beneficial to your organization. Consider:

  • Is sticking with a SiteStudio design and development model future-proofing your platform? Does that help you deliver agile-like project and quickly respond to changing needs?
  • Does your development team want to use new web technology frameworks like Oracle JET?
  • Does your content need to be shared easily and seamlessly without conversion? Do  you want to continue to use Oracle WebCenter Content as your enterprise repository?
  • Do you want to provide easier contribution tools for your end users to manage the site better?
  • Does your organization have an initiatives around enhancing employee engagement, increasing employee retention, or attracting top talent – with your employee intranet viewed as the vehicle to help drive these initiatives?

If you answered yes to any of the above, the time is right to move from SiteStudio to WebCenter Portal. Only WebCenter Portal can deliver a modern and engaging experience for employee intranets, with mobile first design capabilities and the technology foundation for future portal creation at scale – on premise or in the cloud. It also provides the tightest integration with Oracle WebCenter Content, enabling your organization to centralize its high value content assets into an industry leading enterprise content management system.

Oracle WebCenter Portal 12c Value Proposition

WebCenter Portal provides all of this and more. It is a true portal platform that satisfies requests for a better user experience with better performing page loads, and page to page navigation. Furthermore it enables:

  • The ability to store content in a manner so that it can be managed and shared easily.
  • The use of inline contribution of content features using WYSIWYG capabilities.
  • Leveraging newer web technologies such as Oracle Jet, Angular, and others.
  • Integrations with Oracle applications such as E-Business Suite, PeopleSoft, and Taleo – surfacing up content from these systems directly within the portal.

SiteStudio was a great tool for building websites, but one could argue that it was never intended to be used for building employee portals or intranets. If your organization is looking to do just that, and take its employee intranet to the next level, Oracle WebCenter Portal is the clear choice.


The post Still Stuck on SiteStudio? Move Your Intranet and Modernize with WebCenter Portal appeared first on Fishbowl Solutions.

Categories: Fusion Middleware, Other

Oracle Database Docker Image in Docker Cloud (Digital Ocean)

Andrejus Baranovski - Fri, 2017-10-27 17:41
Red Samurai is using Docker for our internal development environment. We are running Oracle Database and WebLogic server (with ADF support) on Docker Cloud. It is much easier to manager Docker containers than to maintain our own server.

In this post I will describe how to setup Oracle Database in Docker Cloud. Of course you could run Docker container locally on your machine, but main power of Docker comes with the option to be able to run container in the Cloud.

If you are new to Docker and Docker Cloud, it is very easy to be lost - there are so many various blogs and articles, hard to understand from where to start. I would recommend to start from Get Started, Part 1: Orientation and setup tutorial. You will learn most of the important Docker commands and push Docker image to the registry. Next check this tutorial - Create your first service. It describes how to create Cloud Node through Docker Cloud interface. Keep in mind - Docker itself doesn't run Docker Container, it provides connectors to various Cloud providers for Docker - Azure, Amazon, Digital Ocean, etc. I did some research and it looks like Digital Ocean is the best option to run Docker container - pricing model is straightforward, registration and management processes are simple and clear.

First step should be to create Docker Node in Docker Cloud (you must be connected to Cloud provider). Here is the info for our Digital Ocean node instance:

Node creation process is straightforward. Once node is created, it becomes part of Node cluster:

Docker Cloud node creation process triggers droplet (Cloud instance) creation in Digital Ocean. This process takes around 5 minutes in total.

Digital Ocean provides very nice UI to manage and monitor droplet:

Graphs to monitor droplet performance:

Digital Ocean provides option to run administration console directly in the browser, without even using separate SSH connection (this is very convenient for quick administration).

I found it to be the easiest way to create Oracle DB docker image in Digital Cloud droplet by executing docker run command directly in droplet administration console. I'm using official Oracle Database Enterprise Edition Docker image.

With docker run command, i can pull and run Docker image (referencing official Oracle DB Docker registry). Where detach=true means container will run without blocking console:

docker run --detach=true --name RedSamuraiDB -p 1521:1521 -p 5500:5500 -e ORACLE_SID=RedSamuraiDB -e ORACLE_PDB=ORCLPDB1 store/oracle/database-enterprise:

Command is executed from Digital Ocean droplet console:

Image is downloaded directly from Docker Store into Digital Ocean droplet:

With docker run command, image is not only downloaded, but also container is started. We can execute docker ps -l to see if container was started successfully:

Finally we need to reset default password (Oradoc_db1) set for Oracle DB Docker container. This can be done by logging into sqlplus from Digital Ocean droplet console. First we need to enter into Docker container prompt by executing (use Docker container name):

docker exec -it RedSamuraiDB bash



DB is accessible from outside:

This brings power of Docker - Oracle DB setup in few minutes.

Security Alert CVE-2017-10151 Released

Oracle Security Team - Fri, 2017-10-27 17:00

Oracle just released Security Alert CVE-2017-10151 to address a vulnerability affecting Oracle Identity Manager.  This vulnerability has received a CVSS Base Score of 10.0.   Oracle recommends affected Oracle customers apply the workaround instructions and fix associated with this Security Alert as soon as possible.


For More Information:

The Advisory for Security Alert CVE-2016-10151 is located at http://www.oracle.com/technetwork/security-advisory/alert-cve-2017-10151-4016513.html


Subscribe to Oracle FAQ aggregator