Feed aggregator

IT Tage 2015 - "Analysing and troubleshooting Parallel Execution" presentation material

Randolf Geist - Sun, 2015-12-20 12:24
Thanks to all attending my presentation "Analysing and troubleshooting Parallel Execution" at the IT Tage conference 2015 in Frankfurt, Germany. You can download the presentation material here in Powerpoint of PDF format, as well as check the Slideshare upload.

Note that the Powerpoint format adds value in that sense that many of the slides come with additional explanations in the notes section.

If you are interested in more details I recommend visiting this post which links to many other posts describing the different new features in greater depth.

Join OTN team @ Oracle CloudWorld Developer January 19th..in NYC!

OTN TechBlog - Fri, 2015-12-18 12:10

The OTN team is excited to see you at the Oracle CloudWorld Developer event in New York, January 19, 2016. Join us to learn how you can leverage Oracle Cloud Platform technologies for the complete development lifecycle! Explore Oracle Paas that enables you to deliver better quality code with the agility you need to meet today's IT challenges.

  

Hear from the top technology experts about how cloud will transform your development organizations through sessions spanning across four tracks: Database, DevOps, Enterprise Integration and Mobile. Attend this free event and enjoy networking opportunities with your peers, product demos, break-out sessions, and hear from Chris Tonas, Vice President of Mobility and Development Tools at Oracle on best practices for development in the cloud.

Who should attend?
  • Developers 
  • Architects 
  • Database Administrators 
  • System Administrators 
  • Project Managers 
  • Students

11i pre-upgrade data fix script ap_wrg_11i_chrg_alloc_fix.sql runs very slow

Vikram Das - Wed, 2015-12-16 20:51
We are currently upgrading one of our ERP instances from 11.5.10.2 to R12.2.5.  One of the pre-upgrade steps is to execute the data fix script ap_wrg_11i_chrg_alloc_fix.sql.  However, this script has been running very very slow. After 4 weeks of monitoring, logging SRs with Oracle, escalating etc., we started a group chat today with our internal experts.  We had Ali, Germaine, Aditya, Mukhtiar, Martha Gomez and Zoltan.  I also invited our top notch EBS Techstack expert John Felix. After doing explain plan on the sql, Based on the updates being done by the query I predicted that it will take 65 days to complete.

John pointed out that the query was using the index AP_INVOICE_DISTRIBUTIONS_N4  that had a very high cost.  We used an sql profile that replaced AP_INVOICE_DISTRIBUTIONS_N4  with AP_INVOICE_DISTRIBUTIONS_U1.  The query started running faster and my new prediction was that it would complete in 5.45 days.

John mentioned that now another select statement was using the same index AP_INVOICE_DISTRIBUTIONS_N4 that had a very high cost.

After discussing among ourselves, we decided to drop the index, run the script and re-create the index. Aditya saved the definition of the index and dropped it.

DBMS_METADATA.GET_DDL('INDEX','AP_INVOICE_DISTRIBUTIONS_N4','AP')
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  CREATE INDEX "AP"."AP_INVOICE_DISTRIBUTIONS_N4" ON "AP"."AP_INVOICE_DISTRIBUTIONS_ALL" ("ACCOUNTING_DATE")
  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "APPS_TS_TX_IDX"

1 row selected.

SQL> drop index AP.AP_INVOICE_DISTRIBUTIONS_N4;

Index dropped.

The updates started happening blazing fast.  The whole thing got done in 39 minutes and we saw the much awaited:

SQL> set time on
16:34:16 SQL> @ap_wrg_11i_chrg_alloc_fix.sql
Enter value for resp_name: Payables Manager
Enter value for usr_name: 123456
-------------------------------------------------------------------------------
/erp11i/applcsf/temp/9570496-fix-16:34:40.html is the log file created
-------------------------------------------------------------------------------

PL/SQL procedure successfully completed.

17:13:36 SQL>

From 65 days to 5.45 days to 39 minutes.  Remarkable.  Thank you John for your correct diagnosis and solution.
Categories: APPS Blogs

Yes, there is MORE...OTN VTS Replay Content to binge on!

OTN TechBlog - Tue, 2015-12-15 14:50

As a reminder the Virtual Technology Summit content is highly technical demos, presentations and HOL prepared by both internal and external Oracle product experts.  Below are the latest highlighted sessions from the replay library groups on community.oracle.com.

Now onto the bingeing.... 

Pi on Wheels, Make Your Own Robot 

By Michael Hoffer, computer scientist, Goethe-Center for Scientific Computing in Frankfurt

The Pi on Wheels is an affordable open source DIY robot that is ideal for learning Java-related technologies in the context of the 
Internet of Things. In this session we will talk about how 3D printing works and how it can be utilized to build robots. The most 
fascinating aspect of 3D printing is that it is astonishingly easy to customize the robot. It allows you to build something completely 
new and different. We provide a Java based IDE that allows you to control and program the robot. In addition to that it can be used 
to programmatically design 3D geometries.  


By Alex Barclay, Principal Product Manager, Solaris and Systems Security, Oracle

Learn and understand about the security threats to your public and private cloud and gain insight into how the Oracle Security 
Architecture helps reduce risk. This webcast will provide detailed information on the top 20 cloud security threats and how different 
parts of the Oracle systems stack help eliminate each threat.

By Christian Shay, Principal Product Director, Oracle

This session explores .NET coding and tuning best practices to achieve faster data access performance. It presents techniques 
and trade-offs for optimizing connection pooling, caching, data fetching and updating, statement batching, and Oracle datatype 
usage. We will also explore using Oracle Performance Analyzer from Visual Studio to tune a .NET application's use of the Oracle 
Database end to end.

By Kent Graziano, Oracle ACE Director and Principal of Data Warrior
Oracle SQL Developer Data Modeler (SDDM) has been around for a few years now and is up to version 4.1. It really is an industrial 
strength data modeling tool that can be used for any data modeling task you need to tackle. This presentation will demonstrate at 
least five features, tips, and tricks that I rely on to make me more efficient (and agile) in developing my models. 

Get SDDM installed on your device and bring it to the session so you can follow along.

By Shukie Ganguly

WebLogic Server 12.1.3 provides support for innovative APIs and productive Tools for application development, including APIs for 
JAX-RS 2.0, JSON Processing (JSR 353), WebSocket (JSR 356), and JPA 2.1. This session from the July 2015 OTN Virtual 
Technology Summit provides an overview of each of these APIs, and then demonstrate how you can use these capabilities to 
simplify the development of server applications accessed by "rich" clients using lightweight web-based protocols such as REST 
and WebSocket.



More On Wearable Tech

Floyd Teter - Mon, 2015-12-14 14:04
I've been going through an amazing experience over the past month plus...purchased and began wearing an Apple iWatch.  Never really thought I would do so...kind of did it on the spur of the moment.  Plus a little push from my team lead at Oracle, who wears one and loves it.

Even after a month of wearing the iWatch, I can't really point at one particular feature that makes it worthwhile.  It's really more a collection of little things that add up to big value.

One example:  I have a reputation far and wide for being late for meetings (could be a Freudian thing, considering how much I detest meetings).  5 minutes before a meeting begins, my iWatch starts to vibrate on my wrist like a nano-jackhammer.  My punctuality for meetings is much improved now, much to the joy of my managers, peers and customers.

Another example:  I can take a phone call wherever I am, distraction free.  That's right, calling Dick Tracy.  Driving, taking a walk, whatever...we can talk now.

Notifications are wonderfully designed...much better than the iPhone or the iPad or the Mac or whatever.  I've actually turned on Notifications again, because they notify without being intrusive or distracting.

A few other dandies as well, like the idea of getting through the security line with the iWatch is a bit quicker than the iPhone or the much-improved implementation of Siri making voice-dictation for texting something I can now user reliably.

So its improved my productivity... not so much by hitting a home run in any particular area, but through lots of incremental little improvements.  Pretty cool wearable tech.

Oracle Apex 5.0 and APEX_JSON

Kubilay Çilkara - Sat, 2015-12-12 04:09
How many lines of code does it take to make a web service call? Answer: 39

That is how many lines of PL/SQL I had to write in Oracle Apex 5.0 to make a web service call to an external API.

I used Adzuna's REST API to retrieve the latitude and longitude and the price of 2 bed properties for rent in a specific location in UK. The API returns JSON which the APEX_JSON package is able to parse easily. Adzuna is a property search engine which also provides aggregate data for properties in various countries around the world.

I think the native APEX_JSON package in Oracle Apex 5.0 is very useful and makes integrating web services to your Oracle Apex applications very easy. Here is application I have created in matter of hours which shows you average rent properties in a location of your choice in UK.

Here is the link for the app:  http://enciva-uk15.com/ords/f?p=174:1













And here is the code:


If you want to run this as is in your SQL Workshop, make sure you replace {myadzunaid:myadzunakey} in the code with your adzuna app_id and app_key which you can obtain from the Adzuna website https://developer.adzuna.com/ as I have removed mine from the code. They also have a very good interactive api documentation here http://api.adzuna.com/static/swagger-ui/index.html#!/adzuna


create or replace procedure get_rent_data(p_where in varchar2, p_radius in number, p_room in number)
is
v_resp_r clob;
j apex_json.t_values;
l_paths apex_t_varchar2;
v_id varchar(50);
v_lat decimal(9,6);
v_lon decimal(9,6);
v_rent number(10);

begin
-- http housekeeping
apex_web_service.g_request_headers(1).name  := 'Accept'; 
apex_web_service.g_request_headers(1).value := 'application/json; charset=utf-8'; 
apex_web_service.g_request_headers(2).name  := 'Content-Type'; 
apex_web_service.g_request_headers(2).value := 'application/json; charset=utf-8';

v_resp_r := apex_web_service.make_rest_request 
      ( p_url => 'http://api.adzuna.com:80/v1/api/property/gb/search/1' 
      , p_http_method => 'GET' 
      , p_parm_name => apex_util.string_to_table('app_id:app_key:where:max_days_old:sort_by:category:distance:results_per_page:beds') 
      , p_parm_value => apex_util.string_to_table('{myadzunaid:myadzunakey}:'||p_where||':90:date:to-rent:'||p_radius||':100:'||p_room||'') 
      );
-- parse json
apex_json.parse(j, v_resp_r);


-- start looping on json
l_paths := apex_json.find_paths_like (
        p_values         => j,
        p_return_path => 'results[%]',
        p_subpath       => '.beds',
        p_value           => '2' );
        
for i in 1 .. l_paths.count loop
       v_id := apex_json.get_varchar2(p_values => j, p_path => l_paths(i)||'.id'); 
       v_rent := apex_json.get_varchar2(p_values => j, p_path => l_paths(i)||'.price_per_month'); 
       v_lat := apex_json.get_varchar2(p_values => j, p_path => l_paths(i)||'.latitude');
       v_lon := apex_json.get_varchar2(p_values => j, p_path => l_paths(i)||'.longitude');

-- debug print values to page
 htp.p(v_id||'-'||v_lat||','||v_lon||'Rents : £'||v_rent);

end loop;

END;

Categories: DBA Blogs

Five Questions to Ask Before Purchasing a Data Discovery Tool

Kubilay Çilkara - Thu, 2015-12-10 17:14
Regardless of what type of industry or business you are involved in, the bottom-line goal is to optimize sales; and that involves replacing any archaic tech processes with cutting-edge technology and substituting any existing chaos with results-driven clarity.
Data discovery tools, being a business-intelligence architecture, creates that clarity through the incorporation of a user-driven process that searches for patterns or specific items in a data set via interactive reports.  Visualization is a huge component of data discovery tools.  One can merge data from multiple sources into a single data set from which one can create interactive, stunning dashboards, reports and analyses.  The user is able to observe data come to life via striking visualizations.  Furthermore, business users want to perform their own data analysis and reporting—with a data discovery tool they can!  After it’s all said and done, smarter business decisions are generated; and that drives results.
Before purchasing a data discovery tool, however, several questions should be addressed:

1: What About Data Prep?

It’s important to realize that there are companies who will claim their data-discovery products are self-service; but keep in mind that many of the products will necessitate a data prep tool in order to access the data to be analyzed.  Preparing data is challenging; and if a data prep tool is not included, one must be purchased.  Choose a data discovery tool that enables data prep to be handled without any external support.
As a side note:  governed self-service discovery provides easy access to data from IT; and an enterprise discovery platform will give IT full visibility to the data and analytic applications while it meets the business’s need for self-service.  Business users embrace the independence they are empowered with to upload and combine data on their own.  

2:  Is Assistance from IT Required for Data Discovery Tools?

Business users desire the ability to prepare their own, personal dashboards and explore data in new ways without needing to heavily rely on IT.  Data discovery tools do not require the intervention of IT professionals, yet the relationship with IT remains.  Data discovery tools empower the business to self-serve while maintaining IT stewardship.  Data discovery tools allow users to directly access data and create dashboards that are contextual to their needs—whenthey need it and how they need it!  This, in turn, reduces the number of requests for reports and dashboards from IT staff and allows those professionals to focus more intently on development projects and system improvements.  Software solutions that support data discovery, such as business intelligence platforms with innovative visualization capabilities, are zealously supported by non-technical business users since they can perform deep, intuitive analysis of any enterprise information without reliance on IT assistance.  
      
3:  Will Data Discovery Tools Allow One to Interact with the Data?

The fun thing is, you can play with the data to the point of being able to create, modify and drill down on a specific display.  A beautiful feature of data discovery tools is the interactive component which permits one to interact with corporate data sources visually to uncover hidden trends and outliers.  Data discovery facilitates intuitive, visual-based and multivariate analysis via selecting, zooming, pivoting, and re-sorting to alter visuals for measurement, comparisons and observation.

4:  Are Data Discovery Tools Intended for Enterprise Use?

Enabling the business to self-serve while maintaining IT stewardship creates reliable decisions the enterprise can rely on.  Data discovery tools are invaluable for enterprise use—organizations can plan their approach to incorporate data discovery tools into their infrastructure and business practice. 
Data discovery tools allow one to retrieve and decipher data from spreadsheets, departmental databases, enterprise data warehouse and third-party data sources more efficiently than ever!  Multidimensional information can be transformed into striking graphical representations—3D bar and pie charts, histograms, scatter plots and so much more!  Data discovery tools deliver enterprise solutions within the realms of business information and analytics, storage, networks & compliance, application development, integration, modernization and database servers and tools.  

5:  With Data Discovery Tools Can I Retrieve Answers At any Time?

Data discovery tools will allow you to make inquiries and get answers quickly and seamlessly.  Geographic location will make no difference since files can be loaded on a laptop or even a mobile phone or other mobile devices.  With a few clicks, you can unlock all your data from servers, a mainframe or a PC. 
Multiple charts, graphs, maps and other visuals can, all, be combined in analytic dashboards and interactive apps.  Answers to crucial questions and issues can be quickly unveiled.  Analysts can share the data, with ease, among all users via the web and mobile devices—all operating like a fine-tuned engine—anytime, anywhere.       

Data discovery tools are changing business intelligence!

Mike Miranda writes about enterprise software and covers products offered by software companies like rocket software about topics such as Terminal Emulation, Legacy Modernization, Enterprise Search, Big Data, Enterprise Mobility and more.
Categories: DBA Blogs

The Infogram is Moving!

Oracle Infogram - Thu, 2015-12-10 17:10
See us at our new site: Oracle Priority Support Infogram.

Playing with graphOra and Graphite

Marcelo Ochoa - Thu, 2015-12-10 11:57
Following Neto's blog post about graphOra (Docker Image) – Oracle Real Time Performance Statistics I did my personal test using a Docker image for 12c.
First, I started a 12c Docker DB using:
# docker run --privileged=true --volume=/var/lib/docker/db/ols:/u01/app/oracle/data --name ols --hostname ols --detach=true --publish=1521:1521 --publish=9099:9099 oracle-12102Next starting Graphite Docker image:
# docker run --name graphs-db -p 80 -p 2003 -p 2004 -p 7002 --rm -ti nickstenning/graphiteNext installing graphOra repository:
# docker run -ti --link ols:oracle-db netofrombrazil/graphora --host oracle-db --port 1521 --sid ols --create
Enter sys password: -------
Creating user graphora
Grant access for user graphora to create sessions
Grant select privilege on V$SESSION_EVENT, V$SYSSTAT, V$STATNAME for user graphora
---
GraphOra is ready to collect your performance data!

Finally starting the graphOra Docker image:
# docker run -ti --link ols:oracle-db --rm --link graphs-db netofrombrazil/graphora --host oracle-db --port 1521 --sid ols --interval 10 --graphite graphs-db --graph-port 2003
phyReads: 0 phyWrites: 0 dbfsr: 43.30 lfpw: 43.30
phyReads: 0 phyWrites: 0 dbfsr: 0.00 lfpw: 0.00
phyReads: 0 phyWrites: 0 dbfsr: 0.00 lfpw: 0.00
and that's all, happy monitoring.
Here an screenshot from my monitored session:
Note on parameters used
First from the original post is mandatory to remove parameter graphOra, I think is due to changes on the image build of  Docker image netofrombrazil/graphora.
Second I used --link Docker syntax to avoid IP usage on command line options, that is, my Oracle DB is running on a container named ols, Graphite server running on a container named graphs-db, so by passing parameters --link ols:oracle-db --link graphs-db graphOra container receives connectivity and /etc/host file updated with the IP address of both related containers.

Using Apache Drill REST API to Build ASCII Dashboard With Node

Tugdual Grall - Thu, 2015-12-10 04:56
Read this article on my new blog Apache Drill has a hidden gem: an easy to use REST interface. This API can be used to Query, Profile and Configure Drill engine. In this blog post I will explain how to use Drill REST API to create ascii dashboards using Blessed Contrib. The ASCII Dashboard looks like Prerequisites Node.js Apache Drill 1.2 For this post, you will use the SFO Tugdual Grallhttps://plus.google.com/103667961621022786141noreply@blogger.com0

More OTN VTS OnDemand Highlighted Sessions

OTN TechBlog - Tue, 2015-12-08 13:09

Today we are featuring more sessions from each OTN Virtual Technology Summit Replay Group.  See session titles and abstracts below for content created by Oracle employees and community members.  Watch right away and then join the group to interact with other community members and stay up to date on when NEW content is coming! 

Master Data Management (MDM) Using Oracle Table Access for Hadoop - By Kuassi Mensah, Oracle Corporation
The new Hadoop 2 architecture leads to a bloom of compute engines. Some Hadoop applications such as Master Data Management and Advanced Analytics perform the majority of their processing from Hadoop but need access to data in Oracle database which is the reliable and auditable source of truth. This technical session introduces upcoming Oracle Table Access for Hadoop (OTA4H) which exposes Oracle database tables as Hadoop data sources. It will describe OTA4H architecture, projected features, performance/scalability optimizations, and discuss use cases.  A demo of various Hive SQL and Spark SQL queries against Oracle table will be shown.

What's New for Oracle and .NET (Part 2)  - By Alex Keh, Senior Principal Product Manager, Oracle
With the release of ODAC 12c Release 4 and Oracle Database 12c, .NET developers have many more features to increase productivity and ease development. These sessions explore new features introduced in recent releases with code and tool demonstrations using Visual Studio 2015

How To Increase Application Security & Reliability with Software in Silicon Technology - By Angelo Rajuderai, Worldwide Technology Lead Partner Adoption for SPARC, Oracle and Ikroop Dhillon, Principal Product Manager, Oracle

Learn about Software in Silicon Application Data Integrity (ADI) and how you can use this revolutionary technology to catch memory access errors in production code. Also explore key features for developers that make it easy and simple to create secure and reliable high performance applications.


Real-Time Service Monitoring and Exploration  - By Oracle ACE Associate Robert van Molken
There is a great deal of value in knowing which services are deployed and correctly running on an Oracle SOA Suite or Service Bus instance. This session explains and demonstrates how to retrieve this data using JMX and the available Managed Beans on Weblogic. You will learn how the data can be retrieved using existing Java APIs, and how to explore dependencies between Service Bus and SOA Suite. You'll also learn how the retrieved data can be used to create a simple dashboard or even detailed reports.


Shakespeare Plays Scrabble  - By José Paumard Assistant Professor at the University Paris 13
This session will show how lambdas and Streams can be used to solve a toy problem based on Scrabble. We are going to solve this problem with the Scrabble dictionary, the list of the words used by Shakespeare, and the Stream API. The three main steps shown will be the mapping, filtering and reduction. The mapping step converts a stream of a given type into a stream of another type. Then the filtering step is used to sort out the words not allowed by the Scrabble dictionary. Finally, the reduction can be as simple as computing a max over a given stream, but can also be used to compute more complex structures. We will use these tools to extract the three best words Shakespeare could have played. 



How to monitor Weblogic correct HEALTH STATE using EM12c Metric Extension

Arun Bavera - Fri, 2015-12-04 17:00
Requirement is to know failed status of Weblogic Servers.
image
image


For Weblogic 11g:



Refer:
EM12c: How to Monitor WebLogic Server Health Status in Enterprise Manager 12c Cloud Control (Doc ID 1984804.1)

http://www.oracle.com/webfolder/technetwork/tutorials/obe/em/em12c/metric_extensions/Metric_Extensions.html

https://docs.oracle.com/cd/E24628_01/doc.121/e24473/metric_extension.htm#EMADM10032

Categories: Development

Oracle Proudly Releases PeopleTools 8.55

PeopleSoft Technology Blog - Fri, 2015-12-04 16:29

PeopleTools 8.55 has now been released for general availability.  With this release, Oracle continues to demonstrate our commitment to extend the value of our customers’ investment in PeopleSoft.  The capabilities included in this release have been designed to enhance many of the features we’ve delivered previously as well as to provide our application users substantial new functionality.  Features in this release focus on continued improvements to the PeopleSoft User Experience while providing additional technology options that will help you take advantage of data center innovations proven to reduce ongoing operating costs and assist in developing a Cloud deployment strategy. Our beta customers have been using PeopleTools 8.55 for a few months and definitely liked what they saw.

The PeopleTools Beta Program had two participants, Centene Corporation and Cerner Corporation. During the Beta Program, participants explored the improvements to the PeopleSoft Fluid User Experience and the PeopleSoft Cloud Architecture (PCA) and found “smooth sailing” with few bugs reported and significant productivity improvements to environment provisioning with PCA.

PeopleTools 8.55 dramatically extends our investment in the Fluid User Experience. New in 8.55 are features such as Fluid Dashboards, Fluid Master/Detail pages and the new Activity Guide Framework.  Our intention with this latest release is to extend the capabilities of PeopleSoft Fluid to include functionality required by Power Users and to make the overall application experience as intuitive as possible. 

For example, PeopleTools 8.55 introduces a new Tile Wizard that makes the creation of these important navigation elements and process “building blocks” much simpler.  Tiles automatically resize based on the content they display, the size of the device being used, even based on the orientation of the mobile device. 

With this release we deliver Fluid Dashboards that augment our existing Fluid Home Page structures.  Dashboards can display tiled content just like home pages, but also allow Tiles to display external, non-PeopleSoft content such as information from a BI system or an external website or application system.

One of the long-standing strengths of PeopleSoft’s user experience has been the ability for our customers to alter the look and behavior of the screens to reflect their own company’s “brand”.  With PeopleTools 8.55, we extend the Branding Framework to include the ability to easily apply your company’s brand to Fluid pages and components.

There are very many new PeopleSoft Fluid features in PeopleTools 8.55, all of which extend our commitment to ensuring you have the most powerful, complete business applications and that these applications reflect the intuitive usability that your employees expect from today’s web systems. 

In a similar vein, we have extended many other elements of the PeopleSoft system infrastructure including Selective Adoption and Application Lifecycle Management features, the PeopleSoft Analytics capabilities and the ability for customers to deploy and manage PeopleSoft in a cloud datacenter. Most of the cloud infrastructure technology applies to on premise customers as well, and even to customers who don't use virtualization. A major benefit of our approach is that we can bring cloud-like benefits to customers who are not running on any form of cloud infrastructure.

With PeopleTools 8.55, we have continued to address the needs of our customers to achieve improved operational efficiency in the deployment, configuration and administration of their PeopleSoft applications.  As our customers see innovations across the technology landscape that include cloud service offerings, datacenter efficiencies through system virtualization and improved resource automation, they have asked us to identify opportunities for them to take advantage these innovations to help them better manage their datacenter operating costs.  Many of our customers are looking to cloud offerings as a strategic opportunity to achieve improved leverage and efficiency. 

PeopleTools 8.55 introduces the new PeopleSoft Cloud Architecture (PCA), a comprehensive organization of system-wide structures, features and capabilities that will allow our customers to achieve greater operational efficiencies.  Whether a company has a DevOps strategy to improve the collaboration between their internal PeopleSoft development and Quality Assurance teams and their IT Operations group, or a comprehensive initiative to leverage Cloud solutions for datacenter operations, PeopleSoft’s Cloud Deployment Architecture will assist our customers to reach these strategic goals with their own PeopleSoft application investment.

The PCA and incorporated features such as Deployment Packages (DPKs) work with the Application Configuration Manager (ACM) and PeopleSoft’s virtualization capabilities to provide customers a near fully automated process to install and configure PeopleTools.  Our goal is to help our customers leverage server and datacenter innovations such as market-leading resource virtualization solutions with choice of virtualization platform vendor as well as dynamic deployment of our solutions to public and private cloud platforms. PeopleTools patches deployed using DPKs can be found on MOS on the new PeopleSoft PeopleTools Patches Homepage.

PeopleTools 8.55 offers significant enhancements across the entire product footprint.  We introduced new features that improve the productivity of your developers as well as your end users.  It will be easier to deploy PeopleSoft applications on the cloud, develop custom mobile applications that incorporate PeopleSoft data and provide your users personalized access to PeopleSoft information and analytic content.  This release builds functionality into the product as a result of direct customer input, industry analysis and internal feature design.  New features, bug fixes and product certifications combine to offer PeopleSoft customers improved application user experience and operational efficiency.

As you get started with your PeopleTools 8.55 planning, be sure to review PT 8.55 Certifications on MOS so that you don’t encounter any last minute incompatibilities. Setting up the infrastructure can take time – plan for it. If you are looking for more information on PeopleTools 8.55, be sure to review the Technology tab for PeopleTools 8.55 Features and Enhancements or go to peoplesoftinfo.com for more information on anything related to PeopleSoft.

Enjoy!

Gluent launch! New production release, new HQ, new website!

Tanel Poder - Fri, 2015-12-04 12:23

I’m happy to announce that the last couple of years of hard work is paying off and the Gluent Offload Engine is production now! After beta testing with our early customers, we are now out of complete stealth mode and are ready talk more about what exactly are we doing :-)

Check out our new website and product & use case info here!

Follow us on Twitter:

We are hiring! Need to fill that new Dallas World HQ ;-) Our distributed teams around the US and in London need more helping hands (and brains!) too.

You’ll be hearing more of us soon :-)

Paul & Tanel just moved in to Gluent World HQPaul & Tanel just moved in to Gluent World HQ

NB! If you want to move to the "New World" - offload your data and workloads to Hadoop, without having to re-write your existing applications - check out Gluent. We are making history! ;-)

PeopleSoft Announces Certification of Oracle Database 12c with Secure Enterprise Search

PeopleSoft Technology Blog - Fri, 2015-12-04 12:13

PeopleSoft is pleased to announce that the Oracle's 12c database is now certified for use with Secure Enterprise Search and the PeopleSoft Search Framework.  Details on how to use 12c with PeopleSoft Search are available in PeopleTools Certification Notes (Document 2081577.1) and the Knowledge Document Upgrading SES database to 12c (Document 2084851.1).

In addition to the certification steps, we have also provided an automated mechanism for customers to upgrade their SES Database to 12c.  This is an important business need for customers to perform their SES Database Upgrade.


APEX Feature Request

Denes Kubicek - Thu, 2015-12-03 01:41
Just created a new feature request for APEX at https://apex.oracle.com/pls/apex/f?p=55447:19:::NO:19:P19_ID:50481528500531591330407043519019274105 … Extend Interactive Report API - Get IR Query. The feature request is abut the following:

"This API should deliver a couple of different SQL statements for an interactive report. There are several possible requirements I can think of:

1. IR query including visible columns and filter values - actual SQL for the user session,
2. IR query including all columns and the original SQL,
3. get column names of an IR with or without column alias,...

Having this SQL we should be able to run it as EXECUTE IMMEDIATE, without having to replace any binds.

This feature could be included in the actions menu and available as a plugin for dynamic actions - new dynamic action feature (action)."

Please, feel free to go there and vote for it.

Categories: Development

IBM Containers running Spring Boot Applications with IBM Bluemix

Pas Apicella - Wed, 2015-12-02 16:56
There is now a new command line plugin for IBM containers on Bluemix so you can push and run docker images using CF CLI itself. The steps below show you how to set this up and I use a basic spring boot application as a docker image to test this out.

Steps

Take a note of the docker local host IP. In this example it was as follows, as I test my docker image on my laptop prior to pushing it to Bluemix.

-> docker is configured to use the default machine with IP 192.168.99.100

1. Install the latest CF command line, I used the following version.

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ cf --version
cf version 6.14.0+2654a47-2015-11-18


https://github.com/cloudfoundry/cli

2. Install IBM Containers Cloud Foundry plug-in

pasapicella@pas-macbook-pro:~$ cf install-plugin https://static-ice.ng.bluemix.net/ibm-containers-mac

**Attention: Plugins are binaries written by potentially untrusted authors. Install and use plugins at your own risk.**

Do you want to install the plugin https://static-ice.ng.bluemix.net/ibm-containers-mac? (y or n)> y

Attempting to download binary file from internet address...
9314192 bytes downloaded...
Installing plugin /var/folders/rj/5r89y5nd6pd4c9hwkbvdp_1w0000gn/T/ibm-containers-mac...
OK
Plugin IBM-Containers v0.8.788 successfully installed.


Note: Default plugin directory as follows

$HOME/.cf/plugins


3. Login to IBM Containers

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS$ cf ic login
Client certificates are being retrieved from IBM Containers...
Client certificates are being stored in /Users/pasapicella/.ice/certs/...
Client certificates are being stored in /Users/pasapicella/.ice/certs/containers-api.ng.bluemix.net/0bcbcada-bd11-4372-b416-955dff3078a1...
OK
Client certificates were retrieved.

Deleting old configuration file...
Checking local Docker configuration...
OK

Authenticating with registry at host name registry.ng.bluemix.net
OK
Your container was authenticated with the IBM Containers registry.
Your private Bluemix repository is URL: registry.ng.bluemix.net/apples

You can choose from two ways to use the Docker CLI with IBM Containers:

Option 1: This option allows you to use "cf ic" for managing containers on IBM Containers while still using the Docker CLI directly to manage your local Docker host.
    Use this Cloud Foundry IBM Containers plug-in without affecting the local Docker environment:

    Example Usage:
    cf ic ps
    cf ic images

Option 2: Use the Docker CLI directly. In this shell, override the local Docker environment to connect to IBM Containers by setting these variables. Copy and paste the following commands:
    Note: Only Docker commands followed by (Docker) are supported with this option.

     export DOCKER_HOST=tcp://containers-api.ng.bluemix.net:8443
     export DOCKER_CERT_PATH=/Users/pasapicella/.ice/certs/containers-api.ng.bluemix.net/0bcbcada-bd11-4372-b416-955dff3078a1
     export DOCKER_TLS_VERIFY=1

    Example Usage:
    docker ps
    docker images
4. View docker images

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS$ cf ic images
REPOSITORY                                        TAG                 IMAGE ID            CREATED             VIRTUAL SIZE
registry.ng.bluemix.net/ibm-mobilefirst-starter   latest              5996bb6e51a1        6 weeks ago         770.4 MB
registry.ng.bluemix.net/ibm-node-strong-pm        latest              ef21e9d1656c        8 weeks ago         528.7 MB
registry.ng.bluemix.net/ibmliberty                latest              2209a9732f35        8 weeks ago         492.8 MB
registry.ng.bluemix.net/ibmnode                   latest              8f962f6afc9a        8 weeks ago         429 MB
registry.ng.bluemix.net/apples/etherpad_bluemix   latest              131fd7a39dff        11 weeks ago        570 MB


5. Clone application to run as docker image

$ git clone https://github.com/spring-guides/gs-rest-service.git

6. Create a file called Dockerfile as follows in the "complete" directory

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ cat Dockerfile
FROM java:8
VOLUME /tmp
ADD target/gs-rest-service-0.1.0.jar app.jar
RUN bash -c 'touch /app.jar'
ENTRYPOINT ["java","-Djava.security.egd=file:/dev/./urandom","-jar","/app.jar"]


7. Package the demo

$ mvn package

8. Build docker image

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ docker build -t gs-rest-service .
Sending build context to Docker daemon 13.44 MB
Step 1 : FROM java:8
8: Pulling from library/java
1565e86129b8: Pull complete
a604b236bcde: Pull complete
5822f840e16b: Pull complete
276ac25b516c: Pull complete
5d32526c1c0e: Pull complete
0d61f7a71c59: Pull complete
16952eac0a64: Pull complete
2fb3388c8597: Pull complete
ca603b247c8e: Pull complete
1785f2bc7c99: Pull complete
40e61a6ae215: Pull complete
32f541968fe6: Pull complete
Digest: sha256:52a1b487ed34f5a76f88a336a740cdd3e7b4486e264a3e69ece7b96e76d9f1dd
Status: Downloaded newer image for java:8
 ---> 32f541968fe6
Step 2 : VOLUME /tmp
 ---> Running in 030f739777ac
 ---> 22bf0f9356a1
Removing intermediate container 030f739777ac
Step 3 : ADD target/gs-rest-service-0.1.0.jar app.jar
 ---> ac590c46b73b
Removing intermediate container 9790c39eb1f7
Step 4 : RUN bash -c 'touch /app.jar'
 ---> Running in e9350ddebb75
 ---> 697d245c6afb
Removing intermediate container e9350ddebb75
Step 5 : ENTRYPOINT java -Djava.security.egd=file:/dev/./urandom -jar /app.jar
 ---> Running in 42fc22473930
 ---> df853abfea57
Removing intermediate container 42fc22473930
Successfully built df853abfea57


9. Run locally

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ docker run --name gs-rest-service -p 80:8080 -d -t gs-rest-service
a392aa15da81fb4ca6c16a6307e0bd1c6b22f9a046228f1fc477d3fe12e15f16


10. Test as follows

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers$ curl http://192.168.99.100/greeting
{"id":1,"content":"Hello, World!"}


11. PUSH TO BLUEMIX AS follows

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ docker tag gs-rest-service registry.ng.bluemix.net/apples/gs-rest-service
pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ docker push registry.ng.bluemix.net/apples/gs-rest-service
The push refers to a repository [registry.ng.bluemix.net/apples/gs-rest-service] (len: 1)
Sending image list
Pushing repository registry.ng.bluemix.net/apples/gs-rest-service (1 tags)
Image 5822f840e16b already pushed, skipping
Image 276ac25b516c already pushed, skipping
Image 5d32526c1c0e already pushed, skipping
Image a604b236bcde already pushed, skipping
Image 1565e86129b8 already pushed, skipping
Image 0d61f7a71c59 already pushed, skipping
Image 2fb3388c8597 already pushed, skipping
Image 16952eac0a64 already pushed, skipping
Image ca603b247c8e already pushed, skipping
Image 1785f2bc7c99 already pushed, skipping
Image 40e61a6ae215 already pushed, skipping
Image 32f541968fe6 already pushed, skipping
22bf0f9356a1: Image successfully pushed
ac590c46b73b: Image successfully pushed
697d245c6afb: Image successfully pushed
df853abfea57: Image successfully pushed
Pushing tag for rev [df853abfea57] on {https://registry.ng.bluemix.net/v1/repositories/apples/gs-rest-service/tags/latest}


12. List all allocated IP

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ cf ic ip list
Number of allocated public IP addresses:  2

IpAddress        ContainerId
134.168.13.83
134.168.15.105


13. Create a container from the uploaded image

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ cf ic run -p 8080 --memory 512 --name pas-sb-container registry.ng.bluemix.net/apples/gs-rest-service:latest
b1fe3159-0c19-4d54-b0f5-cdd938618deb


14. Assign IP to container

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ cf ic ip bind 134.168.13.83 pas-sb-container
OK
The IP address was bound successfully.


15. Verify it's running

pasapicella@pas-macbook-pro:~/bluemix_apps/CONTAINERS/ibm-containers/gs-rest-service/complete$ cf ic ps -a
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS                  PORTS                          NAMES
3794802b-b0c                  ""                  4 minutes ago       Running 3 minutes ago   134.168.13.83:8080->8080/tcp   pas-sb-container

16. Invoke as follows

$ curl http://134.168.13.83:8080/greeting


More Information

Plugin Reference ->

https://www.eu-gb.bluemix.net/docs/containers/container_cli_reference_cfic.html

Installing cf ci plugin ->

https://www.eu-gb.bluemix.net/docs/containers/doc/container_cli_cfic.html

Categories: Fusion Middleware

How to fix Putty timeout issue

Arun Bavera - Tue, 2015-12-01 14:00

Set this in Putty/SuperPutty:

image

Categories: Development

Oracle Management Cloud – An Overview

Debu Panda - Tue, 2015-12-01 07:30
Most organizations are transforming themselves to digital enterprises, and IT plays a key role in this transformation. The ways applications are built, delivered, and consumed have significantly changed in the last few years. Organizations have adopted agile methodologies and delivering applications very rapidly, adopted hybrid Cloud, and many of the applications are now consumed from mobile devices. This transition poses a lot of challenges to IT Organizations, and they need new generation tools that can manage their applications and infrastructure.


Oracle Management Cloud is a suite of next generation integrated monitoring, management, and analytics solution for IT organizations that enables a real-time, collaborative environment in which all stakeholders have a clear end-to-end view to the applications and technologies that support business services. Oracle Management Cloud is a part of Oracle Cloud (platform) offerings.

Top Concerns for DevOps/IT Ops

The following figure shows the top concerns for DevOps/IT Ops.




Many organizations lose a lot of revenue and credibility due to unplanned application outages and they spend a lot of expensive hours in war rooms instead of focusing on innovation. Oracle Management Cloud aims to remove the unnecessary time spent in War Rooms by eliminating multiple information silos in management that exist across end user, applications, infrastructure, and machine data.

Oracle Management Cloud is designed for modern heterogeneous IT environment running either Oracle or non-Oracle software/infrastructure. It supports applications either deployed in on-premises, private cloud, Oracle Public Cloud or third-party cloud services.

Following are the three services available now:


I have summarized the high-level features supported by these services. I will write more about these services in future blogs.


Cloud Service
Persona
Features
DevOps
IT Ops
Developer
App Support
  • End User Monitoring
  • Server Request Performance
  • Application Topologies
  • Integrated Log Visibility
  • Integration with Analytics

DevOps
IT Ops (DBA, MW Admin, Sys Admin)
Developer
App Support
Business
  • Light Touch Data Aggregation of all kinds of machine data
  • Topology-Aware Exploration
  • Machine Learning
  • APM Integration
  • Dashboards

Business Analyst
Capacity manager
IT Ops
DevOps
  • Analyze Resource Usage
  • Discover Systemic or common performance problems
  • Plan for the Future



Key Benefits
 Following are some of the few key benefits that you can get from Oracle Management Cloud:
  • Gain 360-degree insight into the performance, availability, and capacity of your applications and infrastructure investments
  •  Find and fix application issues fast by eliminating the unnecessary complex manual application monitoring processes and multiple toolsets
  • Improve efficiency of IT organizations by reducing dependence on large groups of IT staff participating in war rooms
  • Search, explore, and correlate machine data data to troubleshoot problems faster, derive operational and business insight, and make better decisions.
  • Makes IT organizations proactive by identifying systemic problems and capacity issues
  • Reduce Cost of Operations as these services are offered in the cloud and customers do not have to maintain any underlying infrastructure 

Resources
Here are links to few resources if you want to learn about Oracle Management Cloud

Open Source Cool Web App with PL/SQL and Formspider

Gerger Consulting - Tue, 2015-12-01 01:21
As an independent consultant, Nicholas Mwaura needed a Formspider demo application so that he can show the best of the product to his potential clients.

However, all the sample applications on the Formspider web site were developer oriented. We had no application online which consultants, IT managers can use to impress other stakeholders with Formspider. (Facepalm)

Nicholas decided to built this demo application himself even though this was going to be the first time he is going to work with Formspider. The tool encouraged him that much.

Think about this for a minute. When we learn a new tool, most of us are happy if we build a Hello World application as our first one. Nicholas built a demo application to demonstrate the best of Formspider. This speaks volumes about his high technical skills and how Formspider empowers Oracle Forms and PL/SQL developers.

You can watch the entire webinar below. The webinar consists of four parts:

1) Introduction to Formspider by me

2) Nicholas Mwaura on Formspider

3) Development of the Demo Appliaction

4) Questions and Answers



Below are the slides Nicholas used during the webinar:



Open Source Demo Application



Nicholas is sharing his work as an open source application with the Formspider community. This is indeed very nice him and we are much indebted to him for his generosity.

You can use the application at this link.

You can download the source code of the application from this link.

If you’d like to contribute to this open source project, here is the project’s GitHub page.

Yalim K. Gerger

Founder
Categories: Development

Pages

Subscribe to Oracle FAQ aggregator