Feed aggregator

Active Data Guard different Block Sizes?

Tom Kyte - Thu, 2017-07-20 04:46
Dear Tom, Can we have different block sizes between active and pasiv databases, when using Active DataGuard? For example: Block size of 8K for Active and 64 for pasiv database which is in Read only mode? If so, what can be concicvences whe...
Categories: DBA Blogs

Understanding Regular Expressions

Tom Kyte - Thu, 2017-07-20 04:46
Hi Tom, I was trying to understang the regular expression from the below link https://community.oracle.com/message/13402428#13402428 WITH sample_data AS ( SELECT 'C,D,E' AS str, '[A-Z]?' AS pattern FROM dual ) SELECT LEV...
Categories: DBA Blogs

Quries slow at noon

Tom Kyte - Thu, 2017-07-20 04:46
Good day Please I need serious help, I have a table with 4 million records. Here is my query select * from table where custname like rownum <40 and ( '%WE%' or custnumber like '%WE%') These are both var2 even thou I say custnumber. This runs well ...
Categories: DBA Blogs

Oracle Application Express Curriculum Announcement - an Addendum

Joel Kallman - Wed, 2017-07-19 15:09
Earlier today, on the "official" Oracle APEX blog, I published the announcement of the release of the Oracle Application Express curriculum with a permissive-use license.

Firstly, many thanks go to Chaitanya Koratamaddi, a product manager on the Oracle APEX team, based out of Hyderabad, India.  Chaitanya worked tirelessly on the development of this curriculum over the past year.  It's been a grand goal of ours to quickly grow the global APEX community, and one of the best ways to do this is by working with educators.  As I said in an earlier blog post, while education in Oracle Application Express (APEX) is offered as a part of many university and secondary school courses around the globe, in most cases, the educators took it upon themselves to develop their own custom curriculum.  We wanted to make it easy for new educators to adopt Oracle Application Express as part of a secondary school or university curriculum, and this freely offered curriculum will go a long way towards that.

Once the curriculum was developed and published, then the real fun began, namely, working within Oracle to have the curriculum released with a permissive use license.  One of the primary reasons for a permissive-use license was to be able to engage the ever-vibrant Oracle APEX community in the crowd-sourcing of translated content, as evidenced by translate-apex.com.  If this curriculum content was provided with a standard Oracle copyright, then translation of the content by a third-party couldn't even be considered.  We were told from the outset that it was very unlikely this request for a permissive-use license would ever be approved by one or more of the approving lines of business within Oracle.  We were asked if this was this ever done before at Oracle, and to our knowledge, it was not.  Setting precedent is never a good position to be in when you're humbly seeking approvals. ;)

However, after numerous months and rewriting the business justification numerous times, all approvals were obtained within Oracle.  And from this, I have two simple observations:

  1. Oracle is changing, and for the better.  Five years ago, there is zero chance this would have ever been approved within Oracle.  Zero.
  2. Oracle Application Express leads this great company...again.


If you're interested in the freely available curriculum for Oracle APEX, please visit apex.oracle.com/education.

(bash): The most useless commands (8)

Dietrich Schroff - Wed, 2017-07-19 14:57

After talking about

  1. rev
  2. yes
  3. sl
  4. cowsay
  5. cmatrix
  6. cal
 i found another funny command:
rigIts manpage tells the following:
DESCRIPTION
       Rig  is a utility that will piece together a random first name, last name, street num‐
       ber and address, along with a geographically consistant (ie, they all match  the  same
       area) city, state, ZIP code, and area code.

       It is suitable for such applications as feeding the NY times registration page to fend
       off junk (snail) mail and telemarketers, or for registering  on  BBS's  to  which  you
       don't wish to reveal your real information.I am not sure if this tool is banned by the NSA ;-) but here we go:
schroff@zerberus:~$ rig
Carmelo Suarez
947 East Parson St
Alton, IL  62002
(708) xxx-xxxx
schroff@zerberus:~$ rig
Janna Stewart
970 Potter Rd
Auburn, NY  13021
(315) xxx-xxxx
schroff@zerberus:~$ rig
Bernadine Collins
27 Willow Rd
Seattle, WA  98109
(206) xxx-xxxx

Partner Webcast - Oracle Exadata: Boosting Revenue

Join us to learn more about Oracle Systems, Engineered Systems and Storage. Learn what we understand by “Cloud Insurance” through our Systems Webcast Series for EMEA Partners. The...

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

JRE 1.8.0_141 Certified with Oracle EBS 12.1 and 12.2

Steven Chan - Wed, 2017-07-19 10:55

Java logo

Java Runtime Environment 1.8.0_141 (a.k.a. JRE 8u141-b15) and later updates on the JRE 8 codeline are now certified with Oracle E-Business Suite 12.1 and 12.2 for Windows clients.

Java Web Start is now certified with EBS 12.1 and 12.2 for Windows clients.  This JRE release may be run with either the Java plug-in or Java Web Start.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the JRE 6 codeline
  • From JRE 1.7.0_10 and later updates on the JRE 7 codeline 
  • From JRE 1.8.0_25 and later updates on the JRE 8 codeline
We test all new JRE releases in parallel with the JRE development process, so all new JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. 

You do not need to wait for a certification announcement before applying new JRE 6, 7, or 8 releases to your EBS users' desktops.

32-bit and 64-bit versions certified

This certification includes both the 32-bit and 64-bit JRE versions for various Windows operating systems. See the respective Recommended Browser documentation for your EBS release for details.

Where are the official patch requirements documented?

All patches required for ensuring full compatibility of the E-Business Suite with JRE 8 are documented in these Notes:

For EBS 12.1 & 12.2

Implications of Java 6 and 7 End of Public Updates for EBS Users

The Oracle Java SE Support Roadmap and Oracle Lifetime Support Policy for Oracle Fusion Middleware documents explain the dates and policies governing Oracle's Java Support.  The client-side Java technology (Java Runtime Environment / JRE) is now referred to as Java SE Deployment Technology in these documents.

Starting with Java 7, Extended Support is not available for Java SE Deployment Technology.  It is more important than ever for you to stay current with new JRE versions.

If you are currently running JRE 6 on your EBS desktops:

  • You can continue to do so until the end of Java SE 6 Deployment Technology Extended Support in June 2017
  • You can obtain JRE 6 updates from My Oracle Support.  See:

If you are currently running JRE 7 on your EBS desktops:

  • You can continue to do so until the end of Java SE 7 Deployment Technology Premier Support in July 2016
  • You can obtain JRE 7 updates from My Oracle Support.  See:

If you are currently running JRE 8 on your EBS desktops:

Will EBS users be forced to upgrade to JRE 8 for Windows desktop clients?

No.

This upgrade is highly recommended but remains optional while Java 6 and 7 are covered by Extended Support. Updates will be delivered via My Oracle Support, where you can continue to receive critical bug fixes and security fixes as well as general maintenance for JRE 6 and 7 desktop clients. Note that there are different impacts of enabling JRE Auto-Update depending on your current JRE release installed, despite the availability of ongoing support for JRE 6 and 7 for EBS customers; see the next section below.

Impact of enabling JRE Auto-Update

Java Auto-Update is a feature that keeps desktops up-to-date with the latest Java release.  The Java Auto-Update feature connects to java.com at a scheduled time and checks to see if there is an update available.

Enabling the JRE Auto-Update feature on desktops with JRE 6 installed will have no effect.

With the release of the January Critical patch Updates, the Java Auto-Update Mechanism will automatically update JRE 7 plug-ins to JRE 8.

Enabling the JRE Auto-Update feature on desktops with JRE 8 installed will apply JRE 8 updates.

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

What do Mac users need?

JRE 8 is certified for Mac OS X 10.8 (Mountain Lion), 10.9 (Mavericks), 10.10 (Yosemite), and 10.11 (El Capitan) desktops.  For details, see:

Will EBS users be forced to upgrade to JDK 8 for EBS application tier servers?

No.

JRE is used for desktop clients.  JDK is used for application tier servers.

JRE 8 desktop clients can connect to EBS environments running JDK 6 or 7.

JDK 8 is not certified with the E-Business Suite.  EBS customers should continue to run EBS servers on JDK 6 or 7.

Known Issues

Internet Explorer Performance Issue

Launching JRE 1.8.0_73 through Internet Explorer will have a delay of around 20 seconds before the applet starts to load (Java Console will come up if enabled).

This issue fixed in JRE 1.8.0_74.  Internet Explorer users are recommended to uptake this version of JRE 8.

Form Focus Issue Clicking outside the frame during forms launch may cause a loss of focus when running with JRE 8 and can occur in all Oracle E-Business Suite releases. To fix this issue, apply the following patch:

References

Related Articles
Categories: APPS Blogs

Copying data from one partition to another in the same table

Tom Kyte - Wed, 2017-07-19 10:26
Hi Tom, we have a table that is daily partitioned based on activity date. On a daily basis, we do a bulk insert for todays (trunc(sysdate)) partition from previous days partition trunc(sysdate-1) with /*+ append*/ hint ( the value for partitionkey...
Categories: DBA Blogs

Privilege required for non DBA user to create the external table

Tom Kyte - Wed, 2017-07-19 10:26
Hi , What are the privilege required for a non DBA user to create the external table?
Categories: DBA Blogs

Skipping data corruption - Is there any way to skip past ORA-01427 in PLSQL Stored Proc?

Tom Kyte - Wed, 2017-07-19 10:26
Hi Tom I have a stored proc that dumps the content of view into a table. The stored proc simply uses "INSERT INTO - SELECT *" FROM statement to do its job. However, on one bad day, we had some data corrupted that resulted in ORA-01427. This Stor...
Categories: DBA Blogs

Optimizing minus funtion

Tom Kyte - Wed, 2017-07-19 10:26
Hi , I have a table with almost 500+ million records in it. i need to select distinct record based on the change code indicator , by which i mean , in my table for a given set business set key columns there can be many records with "A" , "U" an...
Categories: DBA Blogs

Display custom error using pragma

Tom Kyte - Wed, 2017-07-19 10:26
Hi, I am trying to associate a PL/SQL exception with a number and then use that to show my own error message to the caller. I keep on getting the default error message rather than my own error message. I have searched over the last couple of days ...
Categories: DBA Blogs

sql commands show different output from 11g to 12c

Tom Kyte - Wed, 2017-07-19 10:26
sql commands show different output from 11g to 12c Ex: 12.1.0.2 --------- SQL> sho parameter nls_date_format NAME TYPE ------------------------------------ -------------------------------- VALUE ----------...
Categories: DBA Blogs

Oracle Significantly Expands Cloud at Customer with PaaS and SaaS Services to Help Customers in their Journey to the Cloud

Oracle Press Releases - Wed, 2017-07-19 10:00
Press Release
Oracle Significantly Expands Cloud at Customer with PaaS and SaaS Services to Help Customers in their Journey to the Cloud Delivers unrivaled enterprise-grade public cloud SaaS, PaaS, and IaaS services in customers’ datacenters

Redwood Shores, Calif.—Jul 19, 2017

Empowering organizations to move workloads to the cloud while keeping their data on their own premises, Oracle today announced significant expansion of the breadth of services available through Oracle Cloud at Customer. The portfolio now spans all of the major Oracle PaaS categories and for the first time, also features Oracle SaaS services. Since its introduction just over a year ago, Oracle Cloud at Customer has experienced unprecedented growth with leading global organizations across six continents and more than 30 countries adopting the solution, including AT&T and Bank of America.

Oracle Cloud at Customer is designed to enable organizations to remove one of the biggest obstacles to cloud adoption—data privacy concerns related to where the data is stored. While organizations are eager to move their enterprise workloads to the public cloud, many have been constrained by business, legislative and regulatory requirements that have prevented them from being able to adopt the technology. These first-of-a-kind services provide organizations with choice in where their data and applications reside and a natural path to easily move business critical applications eventually to the public cloud.

“Oracle Cloud at Customer is a direct response to the remaining barriers to cloud adoption and turning those obstacles into opportunities by letting customers choose the location of their cloud services,” said Thomas Kurian, president, product development, Oracle. “We are providing a unique service that enables our customers to leverage Oracle Cloud services, including SaaS, PaaS, and IaaS, both on their premises and in our cloud.  Customers gain all the benefits of Oracle’s robust cloud offerings, in their own datacenters, all managed and supported by Oracle.”

Underpinning Oracle Cloud at Customer is a modern cloud infrastructure platform based on converged Oracle hardware, software-defined storage and networking and a first class IaaS abstraction. Oracle fully manages and maintains the infrastructure at customers’ premises so that customers can focus on using the IaaS, PaaS and SaaS services. This is the same cloud infrastructure platform that powers the Oracle Cloud globally.

Based on overwhelming customer demand, Oracle continues to expand the services available via Oracle Cloud at Customer. With today’s news, customers now have access to all of Oracle’s major PaaS categories, including Database, Application Development, Analytics, Big Data, Application and Data Integration, and Identity Management. These services take advantage of specific enhancements that have been made to the underlying Oracle Cloud at Customer platform such as servers with faster CPUs and NVMe-based flash storage, as well as all-flash block storage to deliver even better performance for enterprise workloads.

For the first time, Oracle has also made available via Oracle Cloud at Customer, the ability to consume Oracle SaaS services such as Enterprise Resource Planning, Human Capital Management, Customer Relationship Management, and Supply Chain Management in their own datacenters. These best-in-class, modern applications help unlock business value and increase performance by enabling businesses and people to be more informed, connected, productive, and engaged. Major organizations are already adopting this new option to modernize their key enterprise operations and benefit from the speed of innovation in Oracle SaaS without having to move sensitive application data outside their premises. With the addition of SaaS services to Oracle Cloud at Customer, customers have access to Oracle Cloud services across the entire cloud stack, all delivered in a subscription-based, managed model, directly in their datacenters.

Also, newly available is the Oracle Big Data Cloud Machine, which is an optimized system delivering a production-grade Hadoop and Spark platform with the power of dedicated nodes and the flexibility and simplicity of a cloud offering. Organizations can now access a full range of Hadoop, Spark, and analytics tools on a simple subscription model in their own data centers.

Oracle Cloud at Customer delivers the following Oracle Cloud services:

  • Infrastructure: Provides elastic compute, containers, elastic block storage, object storage, virtual networking, and identity management to enable portability of Oracle and non-Oracle workloads into the cloud.
  • Data Management: Enables customers to use the number one database to manage data infrastructure in the cloud with the Oracle Database Cloud, including Oracle Database Exadata Cloud for extreme performance and Oracle MySQL Cloud.
  • Big Data and Analytics:  Empowers an entire organization to use a single platform to take advantage of any data to drive insights. Includes a broad set of big data cloud services, including Oracle Big Data Cloud Service, Oracle Analytics Cloud, and Oracle Event Hub Cloud.
  • Application Development: Enables organizations to develop and deploy Java applications in the cloud using Oracle Java Cloud, Oracle Application Container Cloud, Oracle Container Cloud, and Oracle WebCenter Portal Cloud.
  • Enterprise Integration: Simplifies integration of on-premises applications to cloud applications, as well as cloud application to cloud application integration using Oracle Integration Cloud, Oracle SOA Cloud, Oracle Data Integrator Cloud, Oracle GoldenGate Cloud, Oracle Managed File Transfer Cloud, and Oracle Internet of Things Cloud.
  • Security: Enables organizations to use Oracle Identity Cloud to implement and manage consistent identity and access management policies.
  • Software-as-a-Service: Provides organizations with a complete suite of software to run their businesses, including Oracle ERP Cloud, Oracle CX Cloud, Oracle HCM Cloud, and Oracle Supply Chain Management Cloud.

Customer Demand Drives Expansion of Portfolio

Global organizations are turning to Oracle Cloud at Customer to standardize on a platform to modernize existing infrastructure and develop innovative new applications. Customers including City of Las Vegas, Federacion Colombiana de Municipios, Glintt Healthcare, HCPA, NEC, NTT DATA, Rakuten Card, State University of New York, and State Bank of India are benefitting from Oracle Cloud services from inside their own datacenters.

“The City of Las Vegas is shifting its Oracle application workloads to the Oracle Cloud,” said Michael Sherwood, Director Information Technologies, city of Las Vegas. “By keeping the data in our data center, we retain full control while enabling innovation, gaining efficiencies and building applications to better serve our community.”

“Today, public organizations are constantly innovating to meet the needs of our citizens. For the Colombian Federation of Municipalities, we have decided to digitally transform our territories to become smart cities,” said Alejandro Murillo, CIO of the Colombian Federation of Municipalities. “With Oracle Cloud at Customer, we have the technological capabilities to bring top-level solutions in the cloud to our municipalities, enabling them to operate with more agility and better serve our citizens.”

“Oracle Cloud at Customer provides us with a consolidated solution to make sensitive healthcare data securely available,” said Nuno Vasco Lopes, CEO, Glintt Healthcare Solutions. “The efficient and flexible solution has reduced the total cost of ownership by 18 percent and delivered high customer performance.” 

Oracle Cloud at Customer

The Oracle Cloud at Customer portfolio of services enables organizations to get all of the benefits of Oracle’s public cloud services in their datacenters. The business model is just like a public cloud subscription; the hardware and software platform is the same; Oracle experts monitor and manage the infrastructure; and the same tools used in Oracle’s public cloud are used to provision resources on the Oracle Cloud at Customer services. This is the only offering from a major public cloud vendor that delivers a stack that is 100 percent compatible with the public cloud but available on-premises, ensuring that customers get the same experience and the latest innovations and benefits using it in their datacenters as in the public cloud. 

Additional Resources
Contact Info
Nicole Maloney
Oracle
+1.415.235.4033
nicole.maloney@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
About Oracle

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

Trademarks

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

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. 

Talk to a Press Contact

Nicole Maloney

  • +1.415.235.4033

Kristin Reeves

  • +1.415.856.5145

Event Mapping: Extending "Personal Details" in HCM

Jim Marion - Wed, 2017-07-19 09:27

As you would expect, PeopleSoft's HCM self-service functionality allows employees to self-report many industry-generic, best-practice attributes. But none of us are industry-generic, which means we may have to capture more attributes than Oracle intended. The way I've seen many organizations handle this is to customize the delivered Personal Details pages to collect additional attributes. Although having an upgrade impact, customizing the classic versions of these pages makes a lot of sense. With continuous delivery, however, customers no longer apply massive upgrades, but rather iterative, incremental continuous upates. With this in mind, the cost of maintaining a customization is significantly higher than the traditional periodic upgrade model. A customization may be the only thing standing between you and important new features. Wouldn't it be nice to revert your personal details pages to vanilla?

Classic HCM housed several components that collectively represent "Personal Details." The Fluid iteration of Personal Details uses a design pattern akin to a WorkCenter to colocate the navigation for each of the Personal Details components. Rather than customize delivered components, what if we took any custom attributes and placed them in a separate component and then added that separate component to the list of Personal Details components?

The Personal Details tile of an HCM Employee Self Service landing page is a link to the employee address component (HR_EE_ADDR_FL). This component (or rather the primary page in the component) uses a two-panel layout to display a list of links on the left and a transaction area on the right. With a little bit of App Designer investigation, we see that the list on the left is really a Derived/Work disconnected Rowset populated through PeopleCode. Therefore, to add a link to the left-hand list, we need to insert rows into that disconnected Rowset. The question is, "How do we add a row to this list without modifying delivered PeopleCode?" The answer: Event Mapping. Related Content Event Mapping is an 8.55 PeopleTools feature that lets a developer map a PeopleCode event handler into a component event. What this means is we can write PeopleCode separate from Oracle's delivered PeopleCode and then map our PeopleCode into the same events already handled by Oracle. Since we are not intermingling our code with Oracle's, this is a configuration, not a customization.

Event Mapping configuration requires the following steps:

  1. Create an Application Class with mapped business logic,
  2. Define a Related Content Service Definition, and
  3. Map a component event to a Related Content Service Definition.

Before writing any PeopleCode, I recommend identifying your target event. Your PeopleCode has full access to the component buffer and executes in the same context as the target event handler. If your event handler targets RowInit of level 2, for example, PeopleCode functions such as GetRowset and GetRow will return the level 2 rowset or row respectively. Another reason to identify your target event first is because it is a good idea to have an understanding of the event PeopleCode you will be supplementing.

Oracle populates the left-hand list using component PostBuild PeopleCode. PostBuild is a great place to populate a navigation rowset, so we might as well use the same event. To begin, I created an Application Package and Class named GH_PERS_DET_EVT and PersonalDetailsTravelPrefs respectively. Next, we need to add a bit of PeopleCode to populate the appropriate Derived/Work record fields and rows. Identifying the proper buffer references requires a little bit of investigation. The key here is that Event Mapping PeopleCode has full access to the component buffer just like any other PeopleCode executing from a component event. Here is my PeopleCode:


import PT_RCF:ServiceInterface;

class PersonalDetailsTravelPrefs implements PT_RCF:ServiceInterface
method execute();

private
method AddStyle(&infld As Field, &inStyleName As string);
end-class;

method execute
/+ Extends/implements PT_RCF:ServiceInterface.execute +/

Local Rowset &rsLinks = GetLevel0()(1).GetRowset(Scroll.HCSC_TAB_DVW);

&rsLinks.InsertRow(&rsLinks.ActiveRowCount);

Local number &linkNbr = &rsLinks.ActiveRowCount;
Local Row &linkRow = &rsLinks.GetRow(&linkNbr);

Local Record &recWrk = &linkRow.HCSC_FL_WRK;
Local boolean &isAccessibleMode = False;

&linkRow.HCSC_TAB_DVW.ROW_NUM.Value = &linkNbr;

%This.AddStyle(&recWrk.HCSC_GROUPBOX_02, "psa_vtab");

/* initially hide counter and subtabs */
&recWrk.HCSC_COUNTER.Visible = False;
&recWrk.HCSC_EXPAND_ICN.Visible = False;
%This.AddStyle(&recWrk.HCSC_GROUPBOX_03, "psc_hidden");

&recWrk.HCSC_BTN_SELECT.Label = "Travel Profile";
&recWrk.HCSC_BTN_SELECT.HoverText = "Travel Profile";

REM ** generate the target URL for the new link;
Local string &targetUrl = GenerateComponentPortalURL(%Portal, %Node, MenuName.GH_CUSTOM_FL, %Market, Component.GH_TRAVEL_PREF_FL, Page.GH_TRAVEL_PREF_FL, "");
&recWrk.HCSC_BTN_SELECT.JavaScriptEvents = "href='" | &targetUrl | "'";

If GetUserOption("PPTL", "ACCESS") = "A" Then
&isAccessibleMode = True;
End-If;

If Not &isAccessibleMode Then

/* set label image */
&recWrk.HCSC_BTN_SELECT.LabelImage = Image.PS_EX_EXPENSE_M_FL;
%This.AddStyle(&recWrk.HCSC_BTN_SELECT, "hcsc_image-maxtabheight");
%This.AddStyle(&recWrk.HCSC_GROUPBOX_02, "psc_list-has-icon");

End-If;

end-method;

method AddStyle
/+ &infld as Field, +/
/+ &inStyleName as String +/

Local array of string &arrClass;

REM ** Don't add classes that already exist;
&arrClass = Split(&infld.FreeFormStyleName, " ");

If &arrClass.Find(&inStyleName) = 0 Then
&infld.AddFFClass(&inStyleName);
End-If;

end-method;

Most of the code is self explanatory. It inserts a row into a rowset, and then sets appropriate values for each of the necessary fields. I was able to identify the relevant fields by investigating how Oracle populates this rowset. There is one line, however, that differs dramatically from Oracle's delivered code, and that is the line that sets a value for HCSC_BTN_SELECT.JavaScriptEvents. The delivered design for this Rowset uses FieldChange PeopleCode to Transfer to a different component on click. If you are using PeopleTools 8.55, you do not have access to map a handler to the FieldChange event. Likewise, even though 8.56 has support for mapping to the FieldChange event, early releases, such as 8.56.01 and 8.56.02 do not support mapping to FieldChange events in subpages. This rowset happens to reside in a subpage. As an alternative, this code generates a URL to the target component and then sets the HTML href attribute of the inserted row so that clicking the link opens a new component.

Note: the transfer method described here may not display the usual PeopleSoft warning message regarding unsaved data. A future iteration would leverage the FieldChange event, but not until after Oracle posts a fix for components with subpages.

The next step is to define a Related Content Service Definition. Although not necessarily related, the Related Content Framework contains all of the hooks necessary to implement Event Mapping. With that in mind, Oracle chose to make Event Mapping a subset of the Related Content Framework. To define a Related Content Service Definition, navigate to PeopleTools > Portal > Related Content Service > Define Related Content Service and add a new value. The ID you choose for your Related Content Service is not important. No one except an administrator will see the ID. Enter a user friendly service name and choose a URL Type of Application Class. It is this one piece of Metadata that will tell the Event Mapping Framework what code to invoke. When the Application Class Parameters group box appears, enter your package, path, and class name.

The final step is to map the Service Definition into a component event. Navigate to PeopleTools > Portal > Related Content Service > Manage Related Content Service. When you first land on this page, you may see a list of Content References containing Related Content. Immediately switch to the Event Mapping tab. On this tab, you will see an inappropriately labeled link with the text Map the event of the Application pages. Select this link. PeopleSoft will respond by displaying the typical enterprise menu in a tree structure. Since we are mapping to a Fluid component, and Fluid components don't exist in the menu, check the Include hidden Crefs checkbox. This will make the Fluid Structure Content item visible. Expand Fluid Structure and Content > Employee Self Service and then select Personal Details. Upon selection, PeopleSoft will present you with the Event Mapping configuration page. Notice that this page is divided into sections, with each section denoting a different definition type. The first group box, for example, is for Component events. Since we are mapping to the Component PostBuild event, it is this first group box we need to configure. From the Event Name drop-down list, select PostBuild. Next, select the service you created in the previous step. Since I created a service named GH_PERS_DET_TRAVEL, that is the Service ID selected in the screenshot below. The final metadata attribute, Processing Sequence, is very important. This attribute defines whether our code should run before or after Oracle's delivered code. In this case we are adding rows to the end of a Rowset and we don't want Oracle to do anything that would change the appearance or behavior of the rows we add. With that in mind, we choose Post Process, which tells the framework to run our code AFTER Oracle's delivered code. Save and test.

The above screenshot is from PeopleTools 8.56. Depending on your tools release, your page may appear slightly different.

After configuration, you should see a screenshot that resembles the following. Note the Travel Profile link at the bottom of the list.

Note: As previously mentioned, the Personal Details component contains links to several other components. To ensure that your component appears in the list on each of these other components, you also have to map your PeopleCode into the PostBuild event on each of those other components. Since these other components do not exist as tiles, you will find them directly in the Fluid Pages folder.

Special shout out to my friend Mike at Sandia National Labs, who demonstrated a similar approach at Collaborate 2017. Thank you, Mike, for the encouragement to persevere. I initially wrote the code and configurations for this blog post in December while working with some friends in UK. Unfortunately, due to inconsistencies in PeopleTools at that time, this solution did not work. With PeopleTools 8.55.15 being incredibly stable, this solution is now fully functional. I initially gave up hope for Event Mapping in Fluid. But seeing Mike present the exact same scenario renewed my faith.

Podcast Show Notes: Trajectories: Career Paths of IT Stars

OTN TechBlog - Wed, 2017-07-19 08:58

Listen to the Podcast!How old were you when you first started experimenting with writing code?  How did that early interest evolve into your current career?

The genesis of this program was an interview I did with Sean Phillips at the Oracle Code event in Atlanta. Sean is Principal Software Engineer at a.i. Solutions, where works with NASA creating applications that plot trajectories for space missions.

In that interview I asked Sean about his own trajectory, about the career path that lead from his teenage interest in computers to a cool job making sure that zillion-dollar spacecraft get where they’re supposed to go. After the interview Sean and I agreed that it would be fun and interesting to get the career backstories from other accomplished developers and IT pros. Sean suggested several people to serve as panelists, and the result is the conversation you are about to hear. Listen!

This program was recorded on July 5, 2017.

The Panelists

(In alphabetical order)

Mark Heckler

Mark Heckler is a Developer Advocate, conference speaker, published author, and Java Champion. His focus is on developing innovative production-ready software at velocity.

Pratik Patel

Pratik Patel is Chief Technical Officer at TripLingo, a Java Champion, a frequent conference speaker, and a recognized expert in agile methodologies, mobile applications, and enterprise architecture.

Sean Phillips

Sean Phillips is Principal Software Engineer at a.i. Solutions, specializing in data visualizations and ground system automation. Sean was named a JavaOne Rock Star in 2016, and received the Duke's Choice Award in 2013.

Heather VanCura

Heather VanCura is Director and Chair of the JCP program, leader of global Java adoption programs in conjunction with Java User Group leaders, an international speaker, and passionate about Java, community building dynamics, and women in tech.

Johan Vos

Johan Vos is Chief Technical Officer at Gluon, a Java Champion, frequent conference speaker, and author. His current focus is on cross platform mobile Enterprise apps using Java on the back end and the native mobile front end.

Stephanie Xu

Stephanie Xu is a rising senior studying Computer Science at Cornell University. She previously interned at NASA and currently interns at TD Securities.

 

Additional Resources

 

TGI Fridays Becomes First UK Bar to Implement Bar Tab from Mastercard and Oracle

Oracle Press Releases - Wed, 2017-07-19 08:00
Press Release
TGI Fridays Becomes First UK Bar to Implement Bar Tab from Mastercard and Oracle Innovation eliminates the need to leave a card behind the bar

London, U.K.—Jul 19, 2017

Today TGI Fridays, Oracle and Mastercard announced the launch of Bar Tab at their Leicester Square location. Bar Tab is a new function within Mastercard’s Qkr! payment app that allows consumers to set up, manage and pay bar tabs using their smartphones. The application will be integrated into Oracle Hospitality’s restaurant management platform and Masterpass, the digital payment service. After today’s initial debut, TGI Fridays plans to deploy the app to 80 additional locations in the UK by the end of 2017. 

Customers can easily manage their tab through a designated four-digit PIN that connects orders in the restaurant management software to the Qkr! payment account. This means customers can easily manage the rounds that they are in with friends and split the bill. There is no need to hand over a payment card to bar staff, and no need to use a card machine.

“We’re always looking for ways to improve the unique Fridays experience for our guests,” said Jeremy Dunderdale, Head of Business Solutions, TGI Fridays UK. “With Bar Tab, we’re able to offer our diners the freedom to settle their bills on-demand, with this quicker and more convenient payment platform. Enabling self-service payments also allows our team members to focus on engaging guests in more meaningful ways – which is what we’re all about at Fridays.”

Betty DeVita, Chief Commercial Officer for Mastercard Labs, said: “Nobody wants to hand over their card to a bartender. Your card should be with you at all times, so it’s natural for people to leave a pub without having closed their tab. This is a common problem we wanted to solve through Qkr. For bar staff themselves we have removed the headache of card storage and admin.”

“Oracle Hospitality’s restaurant management platform allows the food and beverage industry to innovate by creating a single view of operations,” said Dale Grant, Senior Vice President Food and Beverage Oracle Hospitality. “With Oracle Hospitality solutions at the core, restaurants and bars can easily integrate additional solutions like Mastercard’s Qkr payments platform to reinvent their customer experience. By implementing Bar Tab, TGI Fridays can now offer its customers a quicker, more convenient experience that empowers staff to provide more welcoming bar experiences while reducing the number of unpaid tabs at the end of the night.”

About Oracle Hospitality

Oracle Hospitality develops hardware and software solutions that work together to help produce tailored guest service for hotels and F&B establishments. By addressing every facet of the business, Oracle Hospitality solutions help optimize operations across the board to deliver the speed, agility and efficiency required to meet customers’ unique needs.

About Mastercard

Mastercard (NYSE: MA), www.mastercard.com, is a technology company in the global payments industry.  We operate the world’s fastest payments processing network, connecting consumers, financial institutions, merchants, governments and businesses in more than 210 countries and territories.  Mastercard products and solutions make everyday commerce activities – such as shopping, travelling, running a business and managing finances – easier, more secure and more efficient for everyone.  Follow us on Twitter @MastercardUKBiz, join the discussion on the Beyond the Transaction Blog and subscribe for the latest news on the Engagement Bureau.

About TGI Fridays

TGI Fridays offers authentic, contemporary, and full-flavoured American food, signature cocktails, and a lively, personalised experience.   With a continually evolving menu overseen by award-winning executive chef Terry McDowell, it’s the perfect stop for free-poured, personalised cocktails served by Fridays® Master Bartenders, a quick tasty bite, or a longer dinner with friends. Fridays® opened its first UK restaurant in Birmingham in March 1986. There are now 80 Fridays open in the UK.

For more information visit www.tgifridays.co.uk or www.fridays.com.  Like us on Facebook, follow us on Twitter, or visit our YouTube channel.

Trademarks

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

NetSuite Supports BRCA Foundation with New Registry Program

Oracle Press Releases - Wed, 2017-07-19 08:00
Press Release
NetSuite Supports BRCA Foundation with New Registry Program Pro Bono Volunteers Build Out Sophisticated Enhancements to Meet Needs of Nonprofit Using the SuiteCloud Development Platform

San Mateo, Calif.—Jul 19, 2017

Oracle NetSuite Global Business Unit, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced that it has teamed up with the BRCA Foundation, a nonprofit created to fund research for the prevention of “BRCA cancers,” or cancers believed to be caused by “broken” BRCA genes, to help launch a BRCA registry project and help the BRCA Foundation gather information relevant to its mission and organizational vision. A four-person team from NetSuite, together with the BRCA Foundation, created customizations in NetSuite to encourage participants to sign up for the program and ultimately pass voluntary contact and demographic data from a genomics testing partner to the BRCA Foundation, using the NetSuite SuiteCloud development platform. This data will be used to provide individuals with news and information about BRCA cancers, and allow them to connect with potential studies in which they may want to participate.

Established in 2016 by NetSuite Co-founder and NetSuite Global Business Unit Executive Vice President of Development, Evan Goldberg, the BRCA Foundation was created to accelerate research and foster collaboration to prevent and cure BRCA cancers. BRCA1 and BRCA2 are genes that produce proteins that help repair damaged DNA. For people who have a mutation in those genes, DNA damage may not repair properly and are more likely to develop additional alterations that can lead to cancer. A nonprofit and a NetSuite customer, BRCA applied for pro bono services from Oracle NetSuite Social Impact to help it establish a registry to gather and share data to provide researchers with potential participants they might use to conduct studies that will lead to better treatment and preventative options.

“NetSuite has been incredibly helpful and supportive of our mission every step of the way,” said Gail Fisher, Deputy Director of the BRCA. “It’s amazing what talented people can do with such a flexible platform. The registry is going to go a long way in the fight against cancer and have a huge impact on people with BRCA.”

As a result of the project, the BRCA Foundation now has a button on its website allowing volunteers to sign up for a genetic cancer screening test from its genomic testing partner. If volunteers choose, they can provide the BRCA Foundation with contact and demographic data to be maintained securely within NetSuite. That data can then be used in the fight against cancer, for example by enrolling participants in clinical trials if they wish.

“This project was so gratifying to be a part of,” said Jerome Wi, Solution Consulting Manager at NetSuite and Project Manager for Suite Pro Bono. “I got to lend my development skills to support a project that will ultimately help to fight against cancer, all while using the SuiteCloud development platform.”

Contact Info
Christine Allen
Public Relations, Oracle NetSuite Global Business Unit
603-743-4534
PR@netsuite.com
About SuiteCloud

NetSuite’s SuiteCloud is a comprehensive offering of cloud-based products, development tools and services designed to help customers and commercial software developers take advantage of the significant economic benefits of cloud computing. Based on NetSuite, the industry’s leading provider of cloud-based financials/ERP software suites, SuiteCloud enables customers to run their core business operations in the cloud, and software developers to target new markets quickly with newly-created mission-critical applications built on top of mature and proven business processes.

The SuiteCloud Developer Network (SDN) is a comprehensive developer program for independent software vendors (ISVs) who build apps for SuiteCloud. All available SuiteApps are listed on SuiteApp.com, a single-source online marketplace where NetSuite customers can find applications to meet specific business process or industry-specific needs. For more information on SuiteCloud and the SDN program, please visit www.netsuite.com/developers.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

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

Trademarks

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

Talk to a Press Contact

Christine Allen

  • 603-743-4534

Partner Webcast - Oracle Bare Metal for Oracle EMEA Partners

Oracle Bare Metal Cloud Services combine the elasticity and utility of public cloud with the granular control, security, and predictability of on-premises infrastructure to deliver high-performance,...

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

OUD 11.1.2.3 – Patch 25840309: OUD BUNDLE PATCH 11.1.2.3.170718

Yann Neuhaus - Wed, 2017-07-19 05:55

A new OUD bundle patch was release at the 18th of July 2017, and this gives me the opportunity to show how fast an OUD can be patched, if configured correctly. In case you have an OUD multi master replication with a load balancer virtual IP on top, then zero downtime patching is possible. This is the configuration that I usually recommend. Not only for high availability, but also for maintenance.

A typical OUD installation consists not only of the OUD itself, but also of a few other components like the JDK, the WebLogic and the ODSM which is deployed in WebLogic and the last but not lease the OPatch utility.

In the end, for upgrading successfully to the OUD to bundle patch 11.1.2.3.170718 we need the following patches.

  • Patch 25840309: OUD BUNDLE PATCH 11.1.2.3.170718
  • Patch 13079846: Oracle JDK 1.7.0 (build 1.7.0_151-b15)
  • Patch 25869650: SU Patch [B25A]: WLS PATCH SET UPDATE 10.3.6.0.170718
  • Patch 6880880: OPatch patch of version 11.1.0.12.9 for Oracle software releases 11.1.0.x (OCT 2015)

A few steps can be done beforehand, like patching the OPatch itself and rolling out the new JDK. No downtime is required for those steps. A very important part is the Java environment. If you have set it up like in the following blog, you can change to the new JDK by simply changing a symbolic link.

https://blog.dbi-services.com/oud-oracle-unified-directory-11-1-2-3-how-to-change-the-java-version-of-oud-11-1-2-3-with-weblogic-and-odsm/

Ok. Let’s get started. Currently we do have the following patches in the staging area.

[dbafmw@dbidg01 20170718]$ ls -l
total 698560
-rw-r--r-- 1 dbafmw oinstall 467017155 Jul 19 07:37 p13079846_17000_Linux-x86-64.zip
-rw-r--r-- 1 dbafmw oinstall  98414546 Jul 19 07:33 p25840309_111230_Generic.zip
-rw-r--r-- 1 dbafmw oinstall  95019336 Jul 19 07:38 p25869650_1036_Generic.zip
-rw-r--r-- 1 dbafmw oinstall  54867592 Jul 19 08:34 p6880880_111000_Linux-x86-64.zip

And the following versions.

-- Current Java Version

[dbafmw@dbidg01 bin]$ ./java -version
java version "1.7.0_141"
Java(TM) SE Runtime Environment (build 1.7.0_141-b11)
Java HotSpot(TM) 64-Bit Server VM (build 24.141-b11, mixed mode)

-- Current WebLogic Version

. /u01/app/oracle/product/Middleware/11.1.2.3/wlserver_10.3/server/bin/setWLSEnv.sh
java weblogic.version -verbose
	
WebLogic Server 10.3.6.0.170117 PSU Patch for BUG24667634 FRI NOV 25 18:34:42 IST 2016 ImplVersion: 10.3.6.0
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050  ImplVersion: 10.3.6.0

-- Current OUD Version and OPatch version

[dbafmw@dbidg01 OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 11.1.0.11.0
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/oraInst.loc
OPatch version    : 11.1.0.11.0
OUI version       : 11.1.0.11.0
Log file location : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/cfgtoollogs/opatch/opatch2017-07-19_08-53-32AM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware/11.1.2.3"

Lsinventory Output file location : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/cfgtoollogs/opatch/lsinv/lsinventory2017-07-19_08-53-32AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Unified Directory                                             11.1.2.3.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  25383162     : applied on Fri Jun 02 11:39:44 CEST 2017
Unique Patch ID:  21007593
   Created on 8 Feb 2017, 02:26:53 hrs PST8PDT
   Bugs fixed:
     21110317, 24731779, 19596240, 20987332, 20786014, 19271756, 21024218
     24333856, 21184039, 17409345, 22555819, 21569267, 19987242, 17416498
     23703560, 22927723, 21835208, 21278352, 22308304, 24409239, 21620706
     21225831, 21634829, 23317872, 21126991, 20771322, 21189204, 19670854
     23327572, 22843404, 21097296, 23066020, 21298039, 21967348, 20688926
     20813995, 17488044, 18311877, 21249082, 20198154, 20415424, 23032811
     21207635, 21415093, 21831011, 21575993, 21882589, 17568241, 22611713
     20363721, 21498205, 21301617, 24577814, 19991366, 21098103, 21932111
     24390289, 21282258, 19636259, 24399724, 22916463, 20235234, 20630323
     20113230, 20554639, 24481116, 24681490, 21924319, 20979061, 20469049
     24490948, 22017920, 23195988, 22564810, 24565597, 22950438, 20881625
     21169776, 20736946, 21032490, 22641166, 21644986, 21337744, 23262289
     21509636, 21183856, 22369027, 22075202, 21464932, 20692543, 20805136
     21754188, 21889432, 20924952, 21683538, 20554436, 24372668, 20881496
     21527426, 23703466, 21605154, 24310538, 21959508, 22689164, 20875947
     22119339, 20778847, 23207713, 21503767, 21310463, 20554511, 21387378
     21075558, 22180844, 21665762, 20987758, 24405001, 20529805, 20470402
     20381973, 21881962, 20830152, 23090053, 17406282, 21461976, 20989144
     20180870, 20312191, 21111836, 22732230, 21387387, 19504096, 24544860, 18312432

Patch  21197325     : applied on Mon Mar 27 12:25:39 CEST 2017
Unique Patch ID:  18996262
   Created on 3 Jul 2015, 07:28:59 hrs PST8PDT
   Bugs fixed:
     21197325

--------------------------------------------------------------------------------

OPatch succeeded.

Patching the OPatch itself is an operation which requires no downtime. You simply unzip the new OPatch in the OUD home. Please be aware that the OPatch version 11.1.x is needed for patching the OUD. Any other version is not supported. In my case I patch the OPatch from version 11.1.0.11.0 to version 11.1.0.12.9.

[dbafmw@dbidg01 20170718]$ cp p6880880_111000_Linux-x86-64.zip /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/
[dbafmw@dbidg01 20170718]$ cd /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/
[dbafmw@dbidg01 Oracle_OUD1]$ unzip p6880880_111000_Linux-x86-64.zip
Archive:  p6880880_111000_Linux-x86-64.zip
  inflating: OPatch/operr
   creating: OPatch/scripts/oms/
  inflating: OPatch/scripts/oms/opatchauto.bat
  inflating: OPatch/scripts/oms/opatchauto
  inflating: OPatch/scripts/oms/generateMultiOMSPatchingScripts.pl
   creating: OPatch/scripts/oms/oms_child_scripts/
  inflating: OPatch/scripts/oms/oms_child_scripts/opatchauto_fmw
  inflating: OPatch/scripts/oms/oms_child_scripts/opatchauto_fa
   creating: OPatch/scripts/oms/wlskeys/
  inflating: OPatch/scripts/oms/wlskeys/createkeys.sh
...
...

[dbafmw@dbidg01 OPatch]$ ./opatch lsinv | grep "OPatch version"
OPatch version    : 11.1.0.12.9

As a next step. We roll out the new JDK, which is 1.7.0_151-b15. This is also a step which requires no downtime, because we simply untar the new JDK in the appropriate directory. We are not changing the symbolic link at this point.

[dbafmw@dbidg01 20170718]$ cp jdk-7u151-linux-x64.tar.gz /u01/app/oracle/product/Middleware/11.1.2.3/
[dbafmw@dbidg01 20170718]$ cd /u01/app/oracle/product/Middleware/11.1.2.3/
[dbafmw@dbidg01 11.1.2.3]$ tar -xzvf jdk-7u151-linux-x64.tar.gz
jdk1.7.0_151/
jdk1.7.0_151/LICENSE
jdk1.7.0_151/release
jdk1.7.0_151/jre/
jdk1.7.0_151/jre/LICENSE
jdk1.7.0_151/jre/Welcome.html
jdk1.7.0_151/jre/plugin/
jdk1.7.0_151/jre/plugin/desktop/
jdk1.7.0_151/jre/plugin/desktop/sun_java.png
jdk1.7.0_151/jre/plugin/desktop/sun_java.desktop
jdk1.7.0_151/jre/lib/
jdk1.7.0_151/jre/lib/fontconfig.SuSE.10.properties.src
jdk1.7.0_151/jre/lib/alt-rt.jar
jdk1.7.0_151/jre/lib/meta-index
jdk1.7.0_151/jre/lib/net.properties
jdk1.7.0_151/jre/lib/oblique-fonts/
jdk1.7.0_151/jre/lib/oblique-fonts/LucidaSansDemiOblique.ttf
jdk1.7.0_151/jre/lib/oblique-fonts/fonts.dir
jdk1.7.0_151/jre/lib/oblique-fonts/LucidaTypewriterOblique.ttf
...
jdk1.7.0_151/db/bin/sysinfo.bat
jdk1.7.0_151/db/bin/setNetworkClientCP
jdk1.7.0_151/db/bin/derby_common.bat
jdk1.7.0_151/db/bin/startNetworkServer.bat
jdk1.7.0_151/db/bin/startNetworkServer
jdk1.7.0_151/db/bin/setNetworkServerCP.bat
jdk1.7.0_151/db/bin/stopNetworkServer
jdk1.7.0_151/db/README-JDK.html
jdk1.7.0_151/db/NOTICE
jdk1.7.0_151/README.html
jdk1.7.0_151/THIRDPARTYLICENSEREADME.txt

The symbolic link is still pointing to the old JDK version, which is 1.7.0_141.

[dbafmw@dbidg01 11.1.2.3]$ rm jdk-7u151-linux-x64.tar.gz
rm: remove write-protected regular file ‘jdk-7u151-linux-x64.tar.gz’? y
[dbafmw@dbidg01 11.1.2.3]$ ls -l | grep jdk
lrwxrwxrwx  1 dbafmw oinstall     12 May 29 14:10 jdk -> jdk1.7.0_141
drwxr-x---  8 dbafmw oinstall   4096 Dec 12  2016 jdk1.7.0_131
drwxr-xr-x  8 dbafmw oinstall   4096 Mar 14 06:10 jdk1.7.0_141
drwxr-xr-x  8 dbafmw oinstall   4096 Jul 12 11:31 jdk1.7.0_151

Now the downtime for the WebLogic and OUD server starts. From a downtime perspective, the WebLogic server is not so important, because it is only used for ODSM. If the WebLogic server is down, it means only that you can’t use the graphical ODSM tool anymore. It is much more important to get the OUD up and running again.

[dbafmw@dbidg01 ~]$ ./stopOUD.sh
Stopping Weblogic Server...
...
Stopping Derby Server...
Stopping Server...
...

After the WebLogic and OUD server is stopped, it is time to switch the symbolic link for the JDK to the new version.

[dbafmw@dbidg01 11.1.2.3]$ rm jdk
[dbafmw@dbidg01 11.1.2.3]$ ln -s jdk1.7.0_151 jdk
[dbafmw@dbidg01 11.1.2.3]$ ls -l | grep jdk
lrwxrwxrwx  1 dbafmw oinstall     12 Jul 19 09:02 jdk -> jdk1.7.0_151
drwxr-x---  8 dbafmw oinstall   4096 Dec 12  2016 jdk1.7.0_131
drwxr-xr-x  8 dbafmw oinstall   4096 Mar 14 06:10 jdk1.7.0_141
drwxr-xr-x  8 dbafmw oinstall   4096 Jul 12 11:31 jdk1.7.0_151

Now we can patch the OUD to 11.1.2.3.170718.

[dbafmw@dbidg01 OPatch]$ cdh
[dbafmw@dbidg01 11.1.2.3]$ cd Oracle_OUD1/OPatch/
[dbafmw@dbidg01 OPatch]$ ./opatch apply /u01/app/oracle/product/Middleware/stage/PSU/20170718/25840309
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/oraInst.loc
OPatch version    : 11.1.0.12.9
OUI version       : 11.1.0.11.0
Log file location : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/cfgtoollogs/opatch/25840309_Jul_19_2017_09_05_01/apply2017-07-19_09-05-01AM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware/11.1.2.3"

Applying interim patch '25840309' to OH '/u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1'
Verifying environment and performing prerequisite checks...

Conflicts/Supersets for each patch are:

Patch : 25840309

        Bug Superset of 25383162
        Super set bugs are:
        21110317,  24731779,  19596240,  20987332,  20786014,  19271756,  21024218,  24333856,  21184039,  17409345,  22555819,  21569267,  19987242,  17416498,  23703560,  22927723,  21835208,  21278352,  22308304,  24409239,  21620706,  21225831,  21634829,  23317872,  21126991,  20771322,  21189204,  19670854,  23327572,  22843404,  21097296,  23066020,  21298039,  21967348,  20688926,  20813995,  17488044,  18311877,  21249082,  20198154,  20415424,  23032811,  21207635,  21415093,  21831011,  21575993,  21882589,  17568241,  22611713,  20363721,  21498205,  21301617,  24577814,  19991366,  21098103,  21932111,  24390289,  21282258,  19636259,  24399724,  22916463,  20235234,  20630323,  20113230,  20554639,  24481116,  24681490,  21924319,  20979061,  20469049,  24490948,  22017920,  23195988,  22564810,  24565597,  22950438,  20881625,  21169776,  20736946,  21032490,  22641166,  21644986,  21337744,  23262289,  21509636,  21183856,  22369027,  22075202,  21464932,  20692543,  20805136,  21754188,  21889432,  20924952,  21683538,  20554436,  24372668,  20881496,  21527426,  23703466,  21605154,  24310538,  21959508,  22689164,  20875947,  22119339,  20778847,  23207713,  21503767,  21310463,  20554511,  21387378,  21075558,  22180844,  21665762,  20987758,  24405001,  20529805,  20470402,  20381973,  21881962,  20830152,  23090053,  17406282,  21461976,  20989144,  20180870,  20312191,  21111836,  22732230,  21387387,  19504096,  24544860,  18312432
Interim patch 25840309 is a superset of the patch(es) [  25383162 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y

Backing up files...
Rolling back interim patch '25383162' from OH '/u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1'

Patching component oracle.idm.oud, 11.1.2.3.0...
RollbackSession removing interim patch '25383162' from inventory

OPatch back to application of the patch '25840309' after auto-rollback.

Patching component oracle.idm.oud, 11.1.2.3.0...

Verifying the update...
Patch 25840309 successfully applied
Log file location: /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/cfgtoollogs/opatch/25840309_Jul_19_2017_09_05_01/apply2017-07-19_09-05-01AM_1.log

OPatch succeeded.
[dbafmw@dbidg01 OPatch]$

[dbafmw@dbidg01 OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/oraInst.loc
OPatch version    : 11.1.0.12.9
OUI version       : 11.1.0.11.0
Log file location : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/cfgtoollogs/opatch/opatch2017-07-19_09-05-45AM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware/11.1.2.3"

Lsinventory Output file location : /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/cfgtoollogs/opatch/lsinv/lsinventory2017-07-19_09-05-45AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Unified Directory                                             11.1.2.3.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  25840309     : applied on Wed Jul 19 09:05:10 CEST 2017
Unique Patch ID:  21265541
   Created on 14 Jul 2017, 00:55:06 hrs PST8PDT
   Bugs fixed:
     21310463, 21503767, 23531972, 25396981, 25201795, 25411721, 20554639
     24372668, 20415424, 17406282, 22180844, 24409239, 17416498, 20987332
     21298039, 21075558, 21575993, 24577814, 21110317, 22927723, 20235234
     22308304, 17409345, 21301617, 21846477, 20989144, 22641166, 21098103
     24390289, 24753992, 22564810, 21415093, 20554511, 20469049, 22732230
     21569267, 23607708, 21889432, 22963292, 21882589, 25022506, 25326997
     19596240, 21387378, 21278352, 21683538, 21387387, 18325609, 20786014
     20692543, 21665762, 21184039, 20778847, 20805136, 21932111, 20881625
     20736946, 22555819, 25176210, 19504096, 23703466, 23032811, 20771322
     20830152, 24677562, 21461976, 22017920, 19670854, 23090053, 21527426
     20813995, 21169776, 20113230, 20875947, 21282258, 24490948, 24731779
     18312432, 20529805, 21097296, 25173266, 24681490, 21464932, 21881962
     21498205, 21605154, 24793179, 21249082, 21509636, 22611713, 23703560
     22369027, 21126991, 20470402, 22075202, 21207635, 24902148, 24763428
     25451319, 25167070, 21111836, 22950438, 19991366, 20312191, 19987242
     20198154, 25166847, 21967348, 23066020, 24544860, 21032490, 24481116
     24701083, 25951621, 24405001, 21835208, 23327572, 24399724, 20979061
     20630323, 21959508, 19636259, 17568241, 25437857, 23319809, 19947883
     20987758, 20881496, 20924952, 20554436, 21754188, 20381973, 21183856
     24333856, 21620706, 24310538, 22916463, 21634829, 21337744, 22843404
     21924319, 20180870, 17488044, 20688926, 21811333, 21189204, 21644986
     23195988, 24565597, 22119339, 22689164, 23207713, 25686699, 25166924
     21831011, 18311877, 19271756, 21024218, 21680391, 21225831, 20979247
     20363721, 23262289, 23317872

Patch  21197325     : applied on Mon Mar 27 12:25:39 CEST 2017
Unique Patch ID:  18996262
   Created on 3 Jul 2015, 07:28:59 hrs PST8PDT
   Bugs fixed:
     21197325

--------------------------------------------------------------------------------

OPatch succeeded.

After the patching has successfully done, we can start the OUD instance.

[dbafmw@dbidg01 ~]$ /u01/app/oracle/product/Middleware/11.1.2.3/asinst_1/OUD/bin/start-ds
[19/Jul/2017:09:06:48 +0200] category=CORE severity=INFORMATION msgID=132 msg=The Directory Server is beginning the configuration bootstrapping process
[19/Jul/2017:09:06:48 +0200] category=CORE severity=NOTICE msgID=458886 msg=Oracle Unified Directory 11.1.2.3.170718 (build 20170621135318Z, R1706210545) starting up
[19/Jul/2017:09:06:52 +0200] category=RUNTIME_INFORMATION severity=NOTICE msgID=20381717 msg=Installation Directory:  /u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1
[19/Jul/2017:09:06:52 +0200] category=RUNTIME_INFORMATION severity=NOTICE msgID=20381719 msg=Instance Directory:      /u01/app/oracle/product/Middleware/11.1.2.3/asinst_1/OUD
...
...
[19/Jul/2017:09:06:57 +0200] category=CORE severity=INFORMATION msgID=720 msg=No worker queue thread pool size specified: sizing automatically to use 24 threads
[19/Jul/2017:09:06:57 +0200] category=PROTOCOL severity=NOTICE msgID=2556180 msg=Started listening for new connections on Administration Connector 0.0.0.0 port 4444
[19/Jul/2017:09:06:57 +0200] category=PROTOCOL severity=NOTICE msgID=2556180 msg=Started listening for new connections on LDAP Connection Handler 192.168.56.201 port 1389
[19/Jul/2017:09:06:57 +0200] category=PROTOCOL severity=NOTICE msgID=2556180 msg=Started listening for new connections on LDAP Connection Handler 192.168.56.201 port 1636
[19/Jul/2017:09:06:57 +0200] category=CORE severity=NOTICE msgID=458887 msg=The Directory Server has started successfully
[19/Jul/2017:09:06:57 +0200] category=CORE severity=NOTICE msgID=458891 msg=The Directory Server has sent an alert notification generated by class org.opends.server.core.DirectoryServer (alert type org.opends.server.DirectoryServerStarted, alert ID 458887):  The Directory Server has started successfully
[dbafmw@dbidg01 ~]$

Ok. OUD is up and running again and ready to use. The whole downtime for patching it, in case you don’t have a multi master replication, was only a few minutes. That is very fast from my point of view.

Now let’s take care of the WebLogic Server. First of all, we need to unzip the new WebLogic patch into the bsu/cache_dir directory, or any other directory.

[dbafmw@dbidg01 ~]$ echo $JAVA_HOME
/u01/app/oracle/product/Middleware/11.1.2.3/jdk
[dbafmw@dbidg01 ~]$ /u01/app/oracle/product/Middleware/11.1.2.3/jdk/bin/java -version
java version "1.7.0_151"
Java(TM) SE Runtime Environment (build 1.7.0_151-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.151-b15, mixed mode)

[dbafmw@dbidg01 20170718]$ cp p25869650_1036_Generic.zip /u01/app/oracle/product/Middleware/11.1.2.3/utils/bsu/cache_dir/
[dbafmw@dbidg01 20170718]$ cd /u01/app/oracle/product/Middleware/11.1.2.3/utils/bsu/cache_dir/
[dbafmw@dbidg01 cache_dir]$ unzip p25869650_1036_Generic.zip
Archive:  p25869650_1036_Generic.zip
  inflating: README.txt
  inflating: B25A.jar
  inflating: patch-catalog_25250.xml
[dbafmw@dbidg01 cache_dir]$

Patching the WebLogic server is a little different then patching the OUD. It does not come with the OPatch utility, but for and foremost it is not cumulative. That means, you can’t apply patch B over patch A. You have to remove patch A beforehand. In case you have not removed it beforehand, you will end up with conflict like shown below.

[dbafmw@dbidg01 cache_dir]$ . /u01/app/oracle/product/Middleware/11.1.2.3/wlserver_10.3/server/bin/setWLSEnv.sh

[dbafmw@dbidg01 cache_dir]$ cd /u01/app/oracle/product/Middleware/11.1.2.3/utils/bsu/

[dbafmw@dbidg01 bsu]$ ./bsu.sh -install -patch_download_dir=/u01/app/oracle/product/Middleware/11.1.2.3/utils/bsu/cache_dir -patchlist=XIDD -prod_dir=/u01/app/oracle/product/Middleware/11.1.2.3/wlserver_10.3
Result: Failure
Unable to locate patch archive: XIDD
[dbafmw@dbidg01 bsu]$ ./bsu.sh -install -patch_download_dir=/u01/app/oracle/product/Middleware/11.1.2.3/utils/bsu/cache_dir -patchlist=B25A -prod_dir=/u01/app/oracle/product/Middleware/11.1.2.3/wlserver_10.3
Checking for conflicts.....
Conflict(s) detected - resolve conflict condition and execute patch installation again
Conflict condition details follow:
Patch B25A is mutually exclusive and cannot coexist with patch(es): XIDD

[dbafmw@dbidg01 bsu]$ ./bsu.sh -remove -patchlist=XIDD -prod_dir=/u01/app/oracle/product/Middleware/11.1.2.3/wlserver_10.3
Checking for conflicts....
No conflict(s) detected

Removing Patch ID: XIDD..
Result: Success

[dbafmw@dbidg01 bsu]$

[dbafmw@dbidg01 bsu]$ ./bsu.sh -install -patch_download_dir=/u01/app/oracle/product/Middleware/11.1.2.3/utils/bsu/cache_dir -patchlist=B25A -prod_dir=/u01/app/oracle/product/Middleware/11.1.2.3/wlserver_10.3
Checking for conflicts.....
No conflict(s) detected

Installing Patch ID: B25A..
Result: Success

[dbafmw@dbidg01 bsu]$

[dbafmw@dbidg01 ~]$ nohup /u01/app/oracle/product/Middleware/11.1.2.3/user_projects/domains/base_domain/bin/startWebLogic.sh &
[1] 20001
[dbafmw@dbidg01 ~]$ nohup: ignoring input and appending output to ‘nohup.out’

Ready. We have now patched the WebLogic server to 10.3.6.0.170718. In case you have issues with the bsu utility, you might want to use the -log option for debugging: bsu.sh -log=bsu_debug.trc. Or you take a quick look at the BSU Command line interface reference guide. http://docs.oracle.com/cd/E14759_01/doc.32/e14143/commands.htm

Ok. OUD and WebLogic is fully patched and running. But what about the ODSM? Do I have to redeploy it? No, you don’t. The odsm.ear is redeployed automatically. The odsm.ear file is shipped along with every OUD bundle patch (bppatchnumber/files/odsm/odsm.ear). A new odsm.ear file is included with Patch 11.1.2.3.170718 at the following location:

[dbafmw@dbidg01 odsm]$ pwd
/u01/app/oracle/product/Middleware/11.1.2.3/Oracle_OUD1/odsm
[dbafmw@dbidg01 odsm]$ ls -l
total 36660
-rw-r----- 1 dbafmw oinstall 37535804 Jul 14 09:55 odsm.ear

When you restart the Server for the first time after applying the patch, it will automatically redeploy the new odsm.ear file. Therefore, you might experience a slower restart of the WebLogic server. If you want, you cat take a look at the logs related to odsm.ear file deployment.

[dbafmw@dbidg01 logs]$ pwd
/u01/app/oracle/product/Middleware/11.1.2.3/user_projects/domains/base_domain/servers/AdminServer/logs
[dbafmw@dbidg01 logs]$ cat AdminServer.log | grep odsm.ear
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <J2EE> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602820> <BEA-160166> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/application.xml'. The plan was merged.>
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <Munger> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602830> <BEA-2156202> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/application.xml'. The plan was merged.>
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <J2EE> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602830> <BEA-160166> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/weblogic-application.xml'. The plan was merged.>
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <Munger> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602832> <BEA-2156202> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/weblogic-application.xml'. The plan was merged.>
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <Munger> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602833> <BEA-2156202> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/weblogic-application.xml'. The plan was merged.>
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <Munger> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602863> <BEA-2156202> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/application.xml'. The plan was merged.>
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <Munger> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602863> <BEA-2156202> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/weblogic-application.xml'. The plan was merged.>
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <Munger> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602863> <BEA-2156202> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/application.xml'. The plan was merged.>
####<Jul 19, 2017 10:23:22 AM CEST> <Info> <Munger> <dbidg01> <AdminServer> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1500452602863> <BEA-2156202> <References were found in deployment plan for module 'odsm.ear' with uri, 'META-INF/weblogic-application.xml'. The plan was merged.>

If for any reason the odsm.ear file deployment fails during the first restart of the Server, then you manually need to redeploy the file. That’s it. We have now successfully upgraded JDK, OPatch, OUD, and WebLogic/ODSM to the latest release.

At the end, repeat the whole procedure on the second OUD, if you have one.

Conclusion

Patching an OUD requires a few steps, however, it can be done very fast if it is prepared well. And in case you have multi master replication with a load balancer vip on top, you can do it with no downtime at all.

 

Cet article OUD 11.1.2.3 – Patch 25840309: OUD BUNDLE PATCH 11.1.2.3.170718 est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator