Feed aggregator

Relocating OCR File and Voting Disk to new Diskgroup

VitalSoftTech - Tue, 2016-02-23 00:11
Are you moving you OCR and Voting disks from one storage to another? Read the step-by-step instructions on how to to move these files to a different diskgroup.
Categories: DBA Blogs

Running To Do Purge regularly, improves your performance

Anthony Shorten - Mon, 2016-02-22 16:44

One of the most common issues in implementations of Oracle Utilities Application Framework based products is the growth of To Do object.

The To Do object is to catch errors or events that need human intervention and cannot be addressed by the logic in the product. Basically something has to be done by someone to correct something as part of the process.

The To Do goes through various states and ends up Completed in its final state. There may be a few steps in between but eventually all To Do's should end up in a Completed state. Now when a To Do is in a completed state, the work associated is essentially completed so the retention of that To Do is a s long as your business wants to retain that data.

In terms of management there are a number of techniques that can be used to decide what to do with Completed To Do's:

  • You can use the ILM solution provided with most of the products to retain the To Do as long as your business requires to refer back to it.
  • You can use the To Do Purge batch job (F1-TDPG) to remove Completed To Do's. This job can be used globally or by To Do Type. This is the most common approach.

If you use the To Do Purge job then there are a few guidelines to optimize its use:

  • If there are a large number of completed To Do's to purge initially, then consider setting the noOfDays to a chunk of To Do's to efficiently to remove them.
  • You can set the scope of the job with a combination of isDeleteAll, deletedToDoTypes and excludedToDoTypes. This allows you to set different retention rates for each To Do Type.
  • You can copy the Batch control to implement different job conditions.
  • Schedule the purge jobs regularly to maintain a healthy balance between retention and storage costs.

Maintaining the To Do table has an impact on almost any part of the product as it is used by almost every process (directly or indirectly).

Rapid Install StartCD 51 for EBS 12.2 Now Available

Steven Chan - Mon, 2016-02-22 16:41

We are pleased to announce the availability of Oracle E-Business Suite StartCD (often just called StartCD 51). As the fundamental installation medium for EBS, the startCD is what you begin with when installing or upgrading to Release 12.2.

This latest startCD includes many important updates and fixes, as described in the README for the patch by which it is supplied. Obtaining startCD 51 is highly recommended for all customers who will use Rapid Install to perform an installation or upgrade to Release 12.2.

startCD 51

How Can I Obtain startCD
  • You can download startCD 51 as Patch 22066363.

What's New in this Update?

Among other enhancements, startCD version

  • Includes important fixes for fresh install and upgrade scenarios
  • Introduces EBS use of Oracle Database 12cR1 (
  • Introduces EBS use of Oracle Fusion Middleware Web Tier Utilities
  • Installs additional technology stack patches for Oracle Database 11g and Fusion Middleware
Do I Need A New Stage Area For startCD

Yes, you must create a new stage area to use startCD A stage area created with an earlier startCD will not work. This is because (as noted above) startCD uses Oracle Database 12cR1 (, while earlier startCDs used 11gR1 ( In addition, startCD uses a later patch set (  of Oracle Fusion Middleware Web Tier Utilities than the patch set used by earlier startCDs.

How Can I Obtain Oracle Database and Oracle Web Tier Utilities

You can download Oracle Database and Oracle Web Tier Utilities from the Oracle Software Delivery Cloud as part of the Release 12.2.5 media:

  • Go to the Oracle Software Delivery Cloud and search for Oracle Financials for your platform (EBS is not shown as a product option, so you need to choose a listed product such as Financials).
  • Under Release 12.2.5, download the Zip files for "Oracle Database" and "Oracle Web Tier Utilities".

startCD 51 extras

Where Can I Find More Information About Installing EBS?

Refer to the following Release 12.2 Web Library book for more information about creating the stage area, other installation prerequisites, and the various available installation actions and options:

  • Oracle E-Business Suite Installation Guide: Using Rapid Install (Part No. E22950) (PDF or HTML)

As well as the Installation Guide mentioned above, you should refer to the following My Oracle Support knowledge documents as applicable:

Related Articles

Categories: APPS Blogs

Performance Data Visualization for SLOB. The SLOB Expert Community is Vibrant!

Kevin Closson - Mon, 2016-02-22 13:58

Thanks to Nikolay Savvinov (@oradiag) for his excellent post on how to wrap his scripts around the SLOB test driver (runit.sh) to capture and produce performance data visualization graphs.  I recommend a visit to his post here:

Performance Data Visualization with SLOB


As always, the link for SLOB is: Obtain the SLOB Kit and Helpful Information Here

Filed under: oracle

Advanced SQL Webinar on February 23

Gerger Consulting - Mon, 2016-02-22 06:58
On February 23, Oracle ACE Kim Berg Hansen is hosting a free webinar about pattern matching with SQL in Oracle 12c. More than 140 developers have already signed up. Register at this link.

Categories: Development

Real Footy: Oracle Cloud UX and Rapid Development Kit Down Under

Usable Apps - Sun, 2016-02-21 01:11

Tales and Sales

I am just back from an awesome Oracle Applications User Experience (OAUX) communications and outreach event in Sydney, Australia. This was not my first time in Oz, but engaging with a regional audience eager for our Cloud UX message and PaaS4SaaS enablement, it was clear I wasn't in Kansas anymore.

Woah! A-Game time!

Over two days, customers, partners, and internal sales folks were treated to the best of Oracle Cloud user experience (UX) with a packed-solid, hands-on set of sessions that were all about the Oracle Cloud business.

Cloud UX RDK Released into the Wild in Australia!

Cloud UX PaaS4SaaS RDK released into the wild in Australia! 

My main focus was on the Oracle Cloud UX Rapid Development Kit (RDK) for PaaS4SaaS and on selling to win business using the Cloud UX message.

Selling Cloud UX: Real Footy

This is the age of storytelling and demonstrating empathy with your audience. User experience is about keeping it real and resonating with your users, so I opened the selling with UX session with the story of a fellow Dubliner who is also an Irish and Aussie Australian Football League (AFL) hero: Jim Stynes.

 Selling Cloud UX in Sydney

Blue Monday: Selling that Cloud UX 

Jim's contribution to Australia transcended mere footy team loyalty. His own empathy with an entire community was felt by lots of people in many walks of life, even if they had no interest in the AFL or football (apologies to Melbourne Demons fans).

Jim Stynes

Move beyond your demons: Jim Stynes (Image: Wikipedia Public Domain

 Jim kept it real.

I explained this importance of connecting with your sales audience on an emotional level to win business with the Cloud UX message, reinforced our Cloud UX strategy of Simplicity, Mobility, and Extensibility and our design philosophy of Glance, Scan, Commit, imparted best practices for engaging with customers using proven UX techniques, and closed out with some examples of how to do it all!

The Rapid Development Kit: Real Development

The Cloud UX RDK is now available for building Release 10 PaaS4SaaS solutions. Together, with Senior User Experience Architect and master of all things technical in the RDK, Lancy Silveira (@LancyS), we delivered a hands-on demo of what's in the RDK, how partners can use it to identify business opportunities for PaaS4SaaS, and then design and develop winning solutions.

A big emphasis was put on APIs as UX design, on how OAUX has made it easy for partners and customers to build web service integrations, and realizing the right simplified UI Cloud UX use cases that add value to decision-makers and end users.

Lancy demos the RDK live in Sydney

Lancy shows off how easy it is to build great simplified UIs for SaaS and PaaS using the RDK live in Sydney. 

Later we played tag-team with OAUX Director Greg Nerpouni (@gnerpouni) and his super-practical sessions on Cloud UX extensibility. We provided a deep-dive exploration of the RDK as Lancy stepped through the technical parts of the RDK, demoed the Oracle Applicatons Cloud Release 10 simplified UI page layouts, declarative components, SaaS task flows and services, and handled any technical questions about using the kit to accelerate the delivery of PaaS and SaaS solutions in productive, reusable ways.

I relayed more wisdom of the PaaS4SaaS crowd and RDK success stories, so nobody was in any doubt about the importance of PaaS and SaaS to customers, partners, and to Oracle. The cloud has changed everything about customer expectations about PaaS custom apps and SaaS extensions UX and their availability, and now we're giving the Oracle PartnerNetwork community a real enabler to meet those expectations: the RDK. 

We also used this opportunity to gauge interest in building solutions using the RDK so that we can plan additional OAUX outreach and communication events in the region, to hear audience feedback on our approach, and to find out what typical use cases are being encountered locally for SaaS and PaaS in the Oracle Cloud.

OAUX and Partner Team in Sydney

The OAUX and Oracle SaaS Applications Alliances and Channels, APAC teams collaborate in Sydney: (L-R) Nicole Giovanetti, Shy Meei Siow, Geet Singh (@geet_s), Lancy Silveira, and Greg Nerpouni

In all, this was one great event. I suspect you will be seeing OAUX boots on the ground in this region again shortly.

In the meantime, stay tuned to the OAUX channels.

Thank you, Sydney! 

More Information

glibc CVE re: getaddrinfo() and userspace ksplice

Wim Coekaerts - Sat, 2016-02-20 17:48
I have my own server with Oracle Linux 6 (of course) where I host a ton of personal stuff and this server was also affected by the nasty DNS bug from last week (see : CVE-2015-7547 ). Everyone really should update glibc and make sure their system is patched (any distribution) by the way - this is a very serious vulnerability... The nice thing, however, was that this is a perfect example for user space ksplice patching. A quick ksplice update for glibc on this box, and it was patched, no restarting the system no restarting sshd or any other app for that matter. A split microsecond and life goes on happily. Nothing affected, no downtime, no pauses, no hiccups. That's the way to patch these things.

userspace ksplice

Most awesomely cool stuff. Solving real world problems. Imagine running a few 100 docker instances or a couple of Linux containers and you have to update the host's glibc and bring all that down... talk about impact.

kernel patches ... check

critical OS libraries like SSL and GLIBC ... check.

Oracle Linux 6 and 7 support ... check

glibc CVE re: getaddrinfo() and userspace ksplice

Wim Coekaerts - Sat, 2016-02-20 17:48
I have my own server with Oracle Linux 6 (of course) where I host a ton of personal stuff and this server was also affected by the nasty DNS bug from last week (see : CVE-2015-7547 ). Everyone really should update glibc and make sure their system is patched (any distribution) by the way - this is a very serious vulnerability... The nice thing, however, was that this is a perfect example for user space ksplice patching. A quick ksplice update for glibc on this box, and it was patched, no restarting the system no restarting sshd or any other app for that matter. A split microsecond and life goes on happily. Nothing affected, no downtime, no pauses, no hiccups. That's the way to patch these things.

userspace ksplice

Most awesomely cool stuff. Solving real world problems. Imagine running a few 100 docker instances or a couple of Linux containers and you have to update the host's glibc and bring all that down... talk about impact.

kernel patches ... check

critical OS libraries like SSL and GLIBC ... check.

Oracle Linux 6 and 7 support ... check

Tools - Only Upgrades for the Interaction Hub

PeopleSoft Technology Blog - Fri, 2016-02-19 11:59

Now that the Interaction Hub is on the Selective Adoption release process (like all PeopleSoft applications), some customers have been asking us about Tools-only upgrades for the Interaction Hub 9.1, and how that relates to taking maintenance and updates using PeopleSoft Update Manager (PUM).

Although it is possible to do a Tools-only upgrade to 8.55 and continue to use your earlier (non-PUM) release of the Interaction Hub 9.1, we don’t recommend this.  Issues will arise when you need to apply maintenance or any kind of update in the future.  Instead, we strongly recommend that you first move your Interaction Hub to the PUM baseline, then do your Tools upgrade.  This will make the process of taking fixes for Interaction Hub much easier going forward.  Taking subsequent Tools upgrades and Interaction Hub images will be simpler and go more smoothly once Interaction Hub is on PUM.

Note that this is no different than the process for other PeopleSoft applications.  Selective Adoption and PUM are the means for taking all maintenance and updates for PeopleSoft applications now, and Interaction Hub is part of that.  Selective Adoption and PUM are great new processes and tools that make taking maintenance and updates simpler and easier, so you should take advantage of that.

Image 2 of the Interaction Hub 9.1 is now available, and it has some exciting features that you may want to adopt.  So that is another reason to start using Selective Adoption and PUM.  The Update Manger home page has the information you need to perform to get your Interaction Hub on the PUM model.

There is a lot of great information on Selective Adoption on the PeopleSoft Info portal. 

Webcast Replay, Q&A: Driving Innovation with Cloud Self Service and Engagement

WebCenter Team - Fri, 2016-02-19 11:11

Thank you to all who joined us last Wednesday on our live webcast: Driving Innovation with Cloud Self-Service and Engagement; we appreciate your interest and the Q&A that followed. For those who missed it or who would like to watch it again, we now have the on-demand replay available for the webcast here.

On the webcast, our Cloud executive, David Le Strat discussed the key market trends that are driving the transformation in IT's responsibilities and line of business users' engagement. He then went on to discuss some common use cases for collaboration, business automation and self service, and community engagement that we are seeing in the market today and how Oracle Cloud Content and Process solutions address these evolving needs. The value proposition becomes incredibly powerful for Oracle Applications and Oracle SaaS customers as Oracle Cloud Content and Process extends these and other applications' collaboration, self-service and sites communications capabilities. Do give the webcast a watch and you may find use cases that hit close to home.

We also wanted to capture some of the most asked questions and our experts' responses here. But please do follow up with us and comment here if you have additional questions or feedback. We always look forward to hearing from you.

Q. Do you see these solutions being used by IT or by business users? I am in marketing and am wondering how "user-friendly" these solutions are.

A. Cloud solutions are specifically designed to be LoB/user friendly with drag and drop interfaces, easy navigation and template based building. The solutions are also mobile-optimized for anytime, anywhere, any device use and consumption. So, all the convenience you see and experience in your consumer world has now been brought to extend your enterprise content and process collaboration and sites building capabilities. Do try out the free trial at cloud.oracle.com/documents  to experience the ease and intuitiveness first hand. Your IT counterparts will be pleased to have an enterprise-grade, standards-based, pluggable, secure and fully auditable solutions in place that minimize IT reliance and you will be pleasantly surprised at the convenience, ease of use and on-boarding.

Q. Does Oracle Documents Cloud work with your WebCenter Content Management?

A. Yes. To avoid information silos, Oracle Documents Cloud Service integrates with your source of record, your existing content management system like Oracle WebCenter Content so that the content you have access to and you share is in sync with your source of record. We recommend you look at IDC paper on Hybrid Content Management that addresses this very point.

Q. To confirm, the idea with Sites Cloud is to build interactive sites?

A. Yes. Oracle Sites Cloud Service enables users to build microsites and community sites that brings together people, content, processes and even conversations. Integration with Oracle Documents Cloud ensures that content is being leveraged from Oracle Documents Cloud content repository. Processes can be kicked-off, tracked, worked on via integration with Oracle Process Cloud from within Sites and conversations can be easily embedded again as part of Oracle Documents Cloud Service. Do check out https://cloud.oracle.com/en_US/cloud-sites  for more information.

Q. Is Documents Presenter available as part of Oracle Documents Cloud Service or is this a separate application to be purchased?

A. The Presenter app is available as part of Oracle Documents Cloud Service. The Presenter app allows you to curate relevant content available in Oracle Documents Cloud Service, and present it in visually appealing format right off your iPad. You can view a short video on Presenter here.

Q. Will Cloud Documents be integrated with Oracle SaaS Apps to facilitate the collaboration in the Cloud?

A. Yes. It is integrated with Oracle SaaS apps like Oracle Sales Cloud, Oracle Marketing Cloud and we will continue to extend such integration capabilities. Oracle SaaS and Application customers will find great synergies and ease in leveraging Oracle Cloud Content and Process with their existing investments.

Q. Can we view some demos of the solution for marketing or sales?

A. Yes, very much so. Please reach out to your Oracle account rep or connect with us via Comments here on this blog and we would be happy to go through each of these use cases with you in detail or any that is more closely related to your specific needs. Thank you for your interest.

Do E-Business Suite Users Need to Worry About Java 9?

Steven Chan - Thu, 2016-02-18 14:06

No, Oracle E-Business Suite users do not need to worry about changes coming in Java 9. The Java team recently published their plans for removing the Java browser plugin in a future version of Java. The announcement states (key words highlighted for emphasis):

Oracle plans to deprecate the Java browser plugin in JDK 9. This technology will be removed from the Oracle JDK and JRE in a future Java SE release.

What does "deprecate" mean?

"Deprecate" means that there will still be a JRE 9 browser plug-in. Users will still be able to run Java-based applications using the JRE 9 browser plug-in.

What does this mean for E-Business Suite users running JRE 9?

The release of Java 9 will not have any effect on E-Business Suite users. JRE 9 will continue to work with the E-Business Suite in browsers that support Java (via the NPAPI protocol). 

What browsers will support the JRE 9 plug-in?

Internet Explorer, Firefox ESR, and Safari will continue to support NPAPI -- and, therefore, Java and Forms.  We recommend that customers who need to use Forms-based products in the E-Business Suite use those browsers.

Alphabet (Google) Chrome and Microsoft Edge do not support NPAPI, so Java-based apps cannot run in those browsers.  

Will E-Business Suite still require Java?

Yes.  Our ongoing use of Forms for high-volume professional users of the E-Business Suite means that power users will continue to have a need to run Java.  We replicate, simplify, or migrate selected Forms-based flows to OA Framework-based (i.e. web-based HTML) equivalents with every EBS update, but I would imagine that Forms will continue to be part of the E-Business Suite technology stack for the foreseeable future.  I expect that this will apply to both the EBS 12.1 and 12.2 release streams.

Will E-Business Suite change how it starts Java?

Yes, it's very likely. We're working on what happens in the "future Java SE release" that follows Java 9.  We are actively reviewing options for future updates to Java, EBS, and Forms to address Forms compatibility via Java Web Start right now. 

Oracle will do everything possible to ensure that customers can continue to run all parts of the E-Business Suite.

When will EBS do this?

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates.  You're welcome to monitor or subscribe to this blog for updates, which as soon as they're available.  

Related Articles

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 decision.  The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Categories: APPS Blogs

Webcast: Next-Generation Accounts Payable Automation and Dynamic Discounting

WebCenter Team - Thu, 2016-02-18 13:07
Oracle Corporation Next-Generation Accounts Payable Automation and Dynamic Discounting Transform Your Accounts Payable and Supply Chain into a Profit Center

Invoice processing is time-consuming and expensive work. This is especially true if invoicing involves inefficient paper-based processes, manually-conducted approvals and manual data-entry into the financial system. These inefficient methods affect the bottom line by increasing costs, creating liability & accrual blind-spots and causing other cash management, reconciliation & reporting challenges.

Change the game with the Next-Generation of A/P Process Automation and learn how to:
  • Automate up to 90% of invoice processing with automated 2/3-way match and automated invoice creation with all major ERP business applications
  • Streamline operations with best practice workflows, eliminating paper, manual data entry and associated errors
  • Get real-time visibility into your end-to-end process with 360º Analytics, including Compliance, Automation and Efficiency metrics
  • Dynamic Discount Management enables organizations to save an additional 1 to 2% of annual spend
Register Now for this webcast.
Red Button Top Register Now Red Button Bottom Live Webcast Calendar February 23, 2016
10:00 AM PT
/ 1:00 PM ET
#OracleAPProcess Speakers:

Chris Preston Chris Preston,
Senior Director Digital Experience, Strategy & Business Development, Oracle
Nilay Banker Nilay Banker
Founder & CEO
Inspyrus Integrated Cloud Applications and Platform Services Copyright © 2016, Oracle Corporation and/or its affiliates.
All rights reserved.
Contact Us | Legal Notices and Terms of Use | Privacy Statement

column width change in 12c

Laurent Schneider - Thu, 2016-02-18 12:14

In 11g I used to have 30 characters width in my dictionary

SQL> select table_name, column_name from user_tab_columns;

TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------
BONUS                          COMM
BONUS                          SAL
BONUS                          JOB
BONUS                          ENAME
DEPT                           LOC
DEPT                           DNAME
DEPT                           DEPTNO
EMP                            DEPTNO
EMP                            COMM
EMP                            SAL
EMP                            HIREDATE

TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------
EMP                            MGR
EMP                            JOB
EMP                            ENAME
EMP                            EMPNO
SALGRADE                       HISAL
SALGRADE                       LOSAL
SALGRADE                       GRADE

18 rows selected.

Which was pretty nice to read with no setting.

Now in 12c it is ugly enought to make your eyes tired

SQL> select table_name, column_name from user_tab_columns;



















18 rows selected.


This is due to a change of the width of the underlying column in the dictionary. Probably a good-news for our data modeling colleagues that it may be 128 in future.

But currently it is only 30 characters in 12c. So why not format it correctly ?

Simply add the format in $ORACLE_HOME/sqlplus/admin/glogin.sql

col TABLE_NAME for a30
col COLUMN_NAME for a30 

DISCLAIMER: it’s fine to add UNIQUE_KEY_LEVEL_NAME or REFERENCED_TRIGGER_NAME, but you may have application tables that have columns called OWNER or USER, it is probably safer to not assume they are all smaller than 30 chars, so don’t add common names.

Bluemix CLI Installation and Use on Bluemix PUBLIC

Pas Apicella - Thu, 2016-02-18 04:53
We recently announced a seperate CLI for Bluemix known as "Bluemix CLI". You can find out more about it at the following link


The Bluemix command line interface (CLI) provides a set of commands that are grouped by namespace for users to interact with Bluemix. Some Bluemix CLI commands, which are called bx commands, are wrappers of existing cf commands, and others are unique for Bluemix. The information that follows lists all commands that are supported by Bluemix CLI and includes their names, options, usage, prerequisites, descriptions, and examples.

Download it from Here


The following shows how to use it once you installed it for you operating System.

1. Target End Point

pasapicella@pas-macbook-pro:~$ bluemix api https://api.ng.bluemix.net
Invoke 'cf api https://api.ng.bluemix.net'...

Setting api endpoint to https://api.ng.bluemix.net...

API endpoint:   https://api.ng.bluemix.net (API version: 2.40.0)
Not logged in. Use 'bluemix login' to log in.

2. Login as shown below

pasapicella@pas-macbook-pro:~$ bluemix login -u pasapi@au1.ibm.com -p ****** -o pasapi@au1.ibm.com -s dev
Invoke 'cf login -u pasapi@au1.ibm.com -p ****** -o pasapi@au1.ibm.com -s dev'...

API endpoint: https://api.ng.bluemix.net

Targeted org pasapi@au1.ibm.com

Targeted space dev

API endpoint:   https://api.ng.bluemix.net (API version: 2.40.0)
User:           pasapi@au1.ibm.com
Org:            pasapi@au1.ibm.com
Space:          dev

3. Test the "bluemix info" call.

pasapicella@pas-macbook-pro:~$ bluemix info
Listing Bluemix info...

build:                      221004
routing_endpoint:           https://api.ng.bluemix.net/routing
console_endpoint:           https://mccp.ng.bluemix.net
region:                     us-south
app_ssh_endpoint:           ssh.ng.bluemix.net:2222
vms_endpoint:               https://mccp.ng.bluemix.net
token_endpoint:             https://mccp.ng.bluemix.net/uaa
containers_endpoint:        https://mccp.ng.bluemix.net
version:                    2
description:                IBM Bluemix
user:                       b6c020b4-e11a-4630-a6a2-3f20fcec7f90
app_ssh_oauth_client:       ssh-proxy
logging_endpoint:           wss://loggregator.ng.bluemix.net:443
doppler_logging_endpoint:   wss://doppler.ng.bluemix.net:4443
authorization_endpoint:     https://mccp.ng.bluemix.net/login
api_version:                2.40.0
name:                       Bluemix
support:                    http://ibm.com

And my favorite which is the "bluemix list" command.

pasapicella@pas-macbook-pro:~$ bluemix list
Getting CF applications in org 'pasapi@au1.ibm.com' / space 'dev' as pasapi@au1.ibm.com...
Name                        Type             State     Instances   Memory   Disk   URLs
bluemix-apples-springboot   CF Application   STARTED   1/1         512M     1G     bluemix-apples-protozoological-yabby.mybluemix.net
containerbridge             CF Application   STOPPED   0/1         64M      1M
pas-bmspringboot-demo       CF Application   STARTED   1/1         512M     1G     pas-bmspringboot-demo.mybluemix.net
pas-dotnet-helloworld       CF Application   STARTED   1/1         256M     1G     pas-dotnet-helloworld.mybluemix.net
pas-mjalbums                CF Application   STARTED   1/1         512M     1G     pas-mjalbums.mybluemix.net
pas-mobile-web              CF Application   STARTED   1/1         512M     1G     pas-mobile-web.mybluemix.net
pas-mongodb-local           CF Application   STARTED   1/1         450M     1G     pas-mongodb-local.mybluemix.net
pas-mysql-local             CF Application   STARTED   1/1         450M     1G     pas-mysql-local.mybluemix.net
pas-postgresql-local        CF Application   STARTED   1/1         450M     1G     pas-postgresql-local.mybluemix.net
pas-sb-elastic              CF Application   STARTED   1/1         450M     1G     pas-sb-elastic.mybluemix.net
pas-SpringBootJARDemo       CF Application   STARTED   1/1         512M     1G     pas-SpringBootJARDemo.mybluemix.net
pas-tonynode                CF Application   STARTED   1/1         512M     1G     pas-tonynode.mybluemix.net
springboot-swagger-rest     CF Application   STARTED   1/1         512M     1G     apples-sacroiliac-subfacies.mybluemix.net

Getting services in org 'pasapi@au1.ibm.com' / space 'dev' as pasapi@au1.ibm.com...
Name                              Type               Service           Plan               Bound CF Apps                                                            Last Operation
API Management-wv                 Service Instance   API Management    APImStandardPlan
BlazeMeter-92                     Service Instance   blazemeter        free-tier
cleardb-mysql                     Service Instance   cleardb           spark              pas-SpringBootJARDemo
Cloudant-NoSQL-DB-mel-training    Service Instance   cloudantNoSQLDB   Shared
dev_elephantsql                   Service Instance   elephantsql       turtle             bluemix-apples-springboot, pas-postgresql-local, pas-SpringBootJARDemo
jhipster-postgresql               Service Instance   elephantsql       turtle
pas-mongodb                       Service Instance   mongodb           100                pas-mongodb-local
pas-mongodb-lab                   Service Instance   mongolab          sandbox
pas-mysql                         Service Instance   cleardb           spark              containerbridge, pas-mjalbums, pas-mysql-local
pas-telstrademo-cloudantNoSQLDB   Service Instance   cloudantNoSQLDB   Shared
todo-mongo-db                     Service Instance   mongolab          sandbox
Twilio-7b                         Service Instance

Getting containers in org 'pasapi@au1.ibm.com' / space 'dev' as pasapi@au1.ibm.com...
No containers were found.

Getting container groups in org 'pasapi@au1.ibm.com' / space 'dev' as pasapi@au1.ibm.com...
Name                  Type              State             Instances   Memory   URLs
pas-etherpad1         Container Group   RESIZE_FAILED     0/1         256M     pas-etherpad1.mybluemix.net
pas-sb-container      Container Group   UPDATE_COMPLETE   1/1         512M     pas-sb-container.mybluemix.net
pas-mysql-container   Container Group   CREATE_COMPLETE   1/1         512M

Getting VM groups in org 'pasapi@au1.ibm.com' / space 'dev' as pasapi@au1.ibm.com...
No VM groups were found.
Categories: Fusion Middleware

What Is This COE Thing?

Floyd Teter - Wed, 2016-02-17 12:32
Since joining Oracle, I've heard this same question repeatedly:  "This Oracle HCM Cloud Center Of Excellence team you've joined...what do they do?"  So I thought I'd attempt to answer that question here in the hopes that people may get some benefit from it.

Be aware that you can search the web and find many definitions regarding a Center of Excellence is and what it does.  Forget that stuff, most of it does not apply here.  We're creating an entirely different model.

Our team does not create any of the core elements of the Cloud HCM product: the software nor the service.  We focus on making all aspects of the product better.  At the risk of using language that is already overused in enterprise software, we work to make the customer experience better.  And the work is a mix of strategic initiatives and responses to current issues.

Some of our typical activities include:

  • Providing internal tools and processes for improved delivery of software services
  • Serving as functional and technical experts for strategic customers with unique challenges
  • Creating aids and solutions to help customers move from subscription to Go Live better, faster and cheaper
  • Give feedback to Product Development on wide-spread product issues that may lead to solutions within Cloud HCM products
  • Guiding strategic partners about products, methodologies, and current issues through regularly scheduled "cadence calls".
The upshot is that our team is located at the intersection of product development, delivery, and service.  We're a team of experts in all aspects of Oracle Cloud HCM and we apply that expertise wherever it's needed: internal Oracle teams, strategic partners, and customers.

So there you have it.  That's what we do.  And we're ready for you when you need us. So question answered...I hope...you can let me know in the comments.

ASR Summary Cheat sheet for Exadata and Enterprise Manager12c

Arun Bavera - Wed, 2016-02-17 11:19
What is ASR:

Phone Home feature for Engineered System View the ASR Demo Video.
ASR resolves problems faster by automatically opening service requests for Oracle's qualified server,  storage, and Engineered Systems when specific faults occur.

Note: From EM13c  onwards ASR is integrated directly.
Refer: https://docs.oracle.com/cd/E63000_01/EMASR/intro.htm#EMASR108

How to use ASR 

1. ASR can be installed in External system Linux or Solaris. (Small RPM package) We can install it in our OMS box.
2. Requires communnication between ExaData Assets where ASR monitoring is valid.
     4.15.1 ASR Port Usage http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch4_asr_enviro_admin.htm#ASRUD193  
3. Requires Communication to transport.oracle.com:443
4. ASR can send same SR Creation info to Omnibus via SNMP Trap.
      4.16.1 Managing SNMP Trap Destinations for Service Request Notifications:  

ASR Manager systems require Oracle Java 7 - JDK 7 (JDK 1.7.0_13) or later JDK 7 updates or Oracle Java 8 (1.8.0_25 or later).
Oracle Linux 5.3 or later. Red Hat Enterprise Linux 6.3 or later.
For IPv6, the ASR Manager server needs to be enabled for dual stack IPv6/IPv4

Test from designated ASR Manager server below:
telnet transport.oracle.com 443
/usr/bin/wget https://transport.oracle.com/v1/

transport.oracle.com (

1. Set-up firewall rules to allow bi-directional SNMP/UDP traffic to traverse between ASR Assets and the ASR Manager.
2. Ensure that ASR assets can send SNMP telemetry data out on port 162 to the ASR Manager. ( test using OneCommand)
3. Ensure that the ASR Manager can communicate with Service Tags on ASR asset, via http, using port 6481.
4. If your environment requires SNMP v3 to use the Oracle ASR service, you will need to configure both ASR Manager and any ASR Assets. See  
   Configuring ASR Manager for SNMP v3 and Optional ILOM Setup: SNMP v3 for ASR Assets for more information in Chapter 2.http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.htm#CHDBAEEA
5. Verify Telemetry on each component valid for ASR monitoring -http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch1_asr_overview.htm#CEGFGDBG
6. Verify MOS account: MOS accont and SupportIdentifier How To Manage and Approve Pending ASR Assets In My Oracle Support (Doc ID 1329200.1):
7. Install ASR Manager - http://docs.oracle.com/cd/E37710_01/doc.41/e26747/toc.htm
          Install ASR Manager -
  Test connectivity:
  Register  ASR with Oracle Support:
                      asr> register
 asr> show_reg_status
 asr> test_connection ( /opt/asrmanager/bin/asr test_connection)
 asr> autoupdate
 asr> show_version

 service asrm stop
 tar -cvf db.tar.bz /var/opt/asrmanager/db
 tar -cvf configuration.tar.bz /var/opt/asrmanager/configuration
 service asrm start
 asr> send_deactivations -a
 asr> send_activations -a
 asr> list_asset
 asr> disable_asr_manager <1 48="" hours="" to="">
 asr> enable_asr_manager
 asr> disable_asset -i IP_address
 asr> enable_asset -i IP_address
 asr> send_test -i IP_address
 asr> send_test -h host name
 asr> deactivate_asset -i IP_address
 rpm -e asrmanager;rm -rf /var/opt/asrmanager/

 asr>  set_property snmp.receiver.port 1162
 asr>  get_property snmp.receiver.port
 service asrm restart

8. Configure ASR Assets - http://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm
Activate Exadata Assets.--http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch3_asr_assets.htm#BEIDCBAI

Check the Service Tag:  http://asr_system_hostname:6481/stv1/agent/

9. Pre-check Engineered Systems ASR Configuration Check via ASREXACHK (Doc ID 1450112.1) to verify the ASR deployment.
10. Approve ASR assets refer
How To Manage and Approve Pending ASR Assets In My Oracle Support (Doc ID 1329200.1)
11. Audit log at /var/opt/asrmanager/log/auditlog
12. Check ASR Email
13. Create Test Alert - ILOM - Refer http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch4_asr_enviro_admin.htm#ASRUD171
14. Check Ports: -4.15.1 ASR Port Usage
15. Configure ASR to send SNMP traps to Command center: 4.16.1 Managing SNMP Trap Destinations for Service Request Notifications:  
  asr> set_notification_trap [-i ipAddress -p port -c community] [-h hostname -p port -c community]
  asr> set_notification_trap -i -p 162 -c public
  asr> show_notification_trap
  asr> delete_notification_trap -i
  asr> send_test [-i ipAddress] [-h hostname]
  The SUN-ASR-NOTIFICATION-MIB file is located at:
16. Troubleshooting:  http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD202

Oracle® Auto Service Request Exadata Database Machine Quick Installation Guide 5.5.1

Oracle® Auto Service Request Exadata Database Machine Quick Installation Guide
Release 5.5

Categories: Development


Marian Crkon - Tue, 2016-02-16 22:53

シアリスは海綿体の血流を促してペニスのサイズを増大させる効果があります。これを使う事によって、ED気味で勃起力が衰えた男性の性器にもう一度活力を与える事が期待できます。シアリスは従来のED治療薬と違い、投与後36時間とい […]



The Feature - Tue, 2016-02-16 22:53



Categories: APPS Blogs

How to Do Pattern Recognition with SQL in Oracle 12c

Gerger Consulting - Tue, 2016-02-16 08:03
More than 120 developers have signed up for Kim Berg Hansen's webinar about pattern recognition with SQL in Oracle 12c. Sign up for this free webinar if you want to improve your SQL skills and learn from the best.
Categories: Development


Subscribe to Oracle FAQ aggregator