Feed aggregator

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.

How to use DBMS_PARALLEL_EXECUTE to chunk over DB link

Tom Kyte - Tue, 2017-07-18 16:06
Hi Team, Can you please have a look at below: I tried copying table data from One DB to Other over DB link using DBMS_PARALLEL_EXECUTE. And it works as expected. Challenge I am facing here is: I have a table TB_TXN created on both Oracle D...
Categories: DBA Blogs

What type of role/grant that should be given to allow to grant permissions on other schemas

Tom Kyte - Tue, 2017-07-18 16:06
Hi, I have user, with name of "grant_schema". This user should be able to run below command. SQL> grant select, insert, update, delete on claims.table_name to CLAIMS_USER; What type of role/grant that should be give to my "grant_schema" to b...
Categories: DBA Blogs

Error in converting a date from one timezone to other

Tom Kyte - Tue, 2017-07-18 16:06
I want to convert a date in some time zone to date in the db timezone. Now for some reason i get UNKNOWN as the timezone_region when i run the query - <code>select extract(timezone_region from systimestamp) from dual;</code> But I was able to get...
Categories: DBA Blogs

Synchronize two databases

Tom Kyte - Tue, 2017-07-18 16:06
How do I sync two Oracle databases, so that every transaction from A is copied to B using database link. How do I go about it. We do not want to use GOLDENGATE or DATAGUARD for this. PLEASE HELP!!!
Categories: DBA Blogs

Critical Patch Update for July 2017 Now Available

Steven Chan - Tue, 2017-07-18 15:03

The Critical Patch Update (CPU) for July 2017 was released on July 18, 2017. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents. 

Supported products that are not listed in the "Supported Products and Components Affected" Section of the advisory do not require new patches to be applied.

The Critical Patch Update Advisory is available at the following location:

It is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches.

The next four Critical Patch Update release dates are:

  • October 17, 2017
  • January 16, 2018
  • April 17, 2018
  • July 17, 2018
References Related Articles
Categories: APPS Blogs

July 2017 Critical Patch Update Released

Oracle Security Team - Tue, 2017-07-18 11:00

Oracle today released the July 2017 Critical Patch Update.

This Critical Patch Update provides fixes for a wide range of product families including: Oracle Database Server, Oracle Enterprise Manager, Oracle Fusion Middleware, Oracle Hyperion, Oracle E-Business Suite, Oracle Industry Applications (Communications, Retail, and Hospitality), Oracle Primavera, Oracle Sun Products, Oracle Java SE, and Oracle MySQL.

Oracle recommends this Critical Patch Update be applied as soon as possible. A summary and analysis of this Critical Patch Update has been published on My Oracle Support (Doc ID 2282980.1)

For More Information:

The Critical Patch Update Advisory is located at http://www.oracle.com/technetwork/security-advisory/cpujul2017-3236622.html

My Oracle Support Note 2282980.1 is located at https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2282980.1 (MOS account required).

Recommended DB Parameters on the Oracle Database Appliance (ODA)

Yann Neuhaus - Tue, 2017-07-18 10:06

When creating a DB on the ODA using


# oakcli create database -db <db-name>

a template is used to set a couple of DB parameters like e.g.


_datafile_write_errors_crash_instance=FALSE
_db_writer_coalesce_area_size=16777216
_disable_interface_checking=TRUE
_ENABLE_NUMA_SUPPORT=FALSE
_FILE_SIZE_INCREASE_INCREMENT=2143289344
_gc_policy_time=0
_gc_undo_affinity=FALSE
db_block_checking='FULL'
db_block_checksum='FULL'
db_lost_write_protect='TYPICAL'
filesystemio_options='setall'
parallel_adaptive_multi_user=FALSE
parallel_execution_message_size=16384
parallel_threads_per_cpu=2
use_large_pages='ONLY'

In recent projects I saw a couple of DBs running on ODA, which did not have (all) those parameters set, because the DBs were migrated from a non-ODA-platform and the customer took over the previous settings.

The questions are: Are above parameters mandatory on ODA and where do I find them?

Actually Oracle writes in the documentation

http://docs.oracle.com/cd/E83239_01/doc.121/e83201/database-templates-oracle-database-appliance.htm#CMTAR269

“Oracle strongly recommends that you use the Oracle Database Appliance templates, because they implement best practices and are configured specifically for Oracle Database Appliance.”

So it’s not mandatory, but it’s “strongly recommended” by Oracle to set those parameters on ODA.

The parameters are actually defined in the XML-files

/opt/oracle/oak/onecmd/templates/OAK_oltp.dbt
/opt/oracle/oak/onecmd/templates/OAK_dss.dbt

E.g. on a virtualized X5-2 HA with 12.1.2.8.0 installed:


# grep "initParam name" /opt/oracle/oak/onecmd/templates/OAK_oltp.dbt
<initParam name="AUDIT_SYS_OPERATIONS" value="TRUE"/>
<initParam name="AUDIT_TRAIL" value="DB"/>
<initParam name="GLOBAL_NAMES" value="TRUE"/>
<initParam name="OS_AUTHENT_PREFIX" value=""/>
<initParam name="SQL92_SECURITY" value="TRUE"/>
<initParam name="PARALLEL_ADAPTIVE_MULTI_USER" value="FALSE"/>
<initParam name="PARALLEL_EXECUTION_MESSAGE_SIZE" value="16384"/>
<initParam name="PARALLEL_THREADS_PER_CPU" value="2"/>
<initParam name="_disable_interface_checking" value="TRUE"/>
<initParam name="_gc_undo_affinity" value="FALSE"/>
<initParam name="_gc_policy_time" value="0"/>
<initParam name="SESSION_CACHED_CURSORS" value="100"/>
<initParam name="OPEN_CURSORS" value="1000"/>
<initParam name="CURSOR_SHARING" value="EXACT"/>
<initParam name="_ENABLE_NUMA_SUPPORT" value="FALSE"/>
<initParam name="DB_LOST_WRITE_PROTECT" value="TYPICAL"/>
<initParam name="DB_BLOCK_CHECKSUM" value="FULL"/>
<initParam name="DB_BLOCK_CHECKING" value="FULL"/>
<initParam name="FAST_START_MTTR_TARGET" value="300"/>
<initParam name="UNDO_RETENTION" value="900"/>
<initParam name="_FILE_SIZE_INCREASE_INCREMENT" value="2143289344"/>
<initParam name="FILESYSTEMIO_OPTIONS" value="setall"/>
<initParam name="use_large_pages" value="only"/>
<initParam name="DB_FILES" value="1024"/>
<initParam name="processes" value="4800"/>
<initParam name="pga_aggregate_target" value="49152" unit="MB"/>
<initParam name="sga_target" value="98304" unit="MB"/>
<initParam name="db_create_file_dest" value="+DATA"/>
<initParam name="log_buffer" value="64000000" />
<initParam name="cpu_count" value="48"/>
<initParam name="pga_aggregate_limit" value="49152" unit="MB"/>
<initParam name="_datafile_write_errors_crash_instance" value="false"/>
<initParam name="_fix_control" value="18960760:on"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="compatible" value="11.2.0.x.0"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl")"/>
<initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
<initParam name="audit_trail" value="db"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="db_recovery_file_dest" value="+RECO"/>
<initParam name="db_recovery_file_dest_size" value="1843200" unit="MB"/>
<initParam name="db_create_online_log_dest_1" value="+REDO" />
<initParam name="_db_writer_coalesce_area_size" value="16777216"/>

Oracle does not take those parameters blindly when creating a DB with oakcli, but adjusts them as e.g. described in the Blog

https://blog.dbi-services.com/oda-32gb-template-but-got-a-database-with-16gb-sga/

I.e. the SGA_TARGET and PGA_AGGREGATE_TARGET parameters are adjusted based on the chosen database class. Also the COMPATIBLE-parameter is set to the current release (e.g. to 12.1.0.2.0).

So if you’re not able to create the DB on ODA using

# oakcli create database -db <db-name>

then I recommend to check the XML-file OAK_oltp.dbt (or in case of a Decision Support System/Warehouse-DB the file OAK_dss.dbt) and set the parameters in your database accordingly. Alternatively (and probably even better) you may create a dummy-DB using oakcli and check Oracle’s settings, which can then be used in your migrated DB, and drop the dummy-DB afterwards.

Here the parameters of a 12c-DB created on a virtualized ODA X6-2 HA 12.1.2.11.0 with oakcli create database using the smallest setting with 1 Core and the DSS-template:


*._datafile_write_errors_crash_instance=false
*._db_writer_coalesce_area_size=16777216
*._disable_interface_checking=TRUE
*._ENABLE_NUMA_SUPPORT=FALSE
*._FILE_SIZE_INCREASE_INCREMENT=2143289344
*._fix_control='18960760:on'
*._gc_policy_time=0
*._gc_undo_affinity=FALSE
*.audit_file_dest='/u01/app/oracle/admin/C12TEST/adump'
*.audit_sys_operations=TRUE
*.audit_trail='db'
*.cluster_database=true
*.compatible='12.1.0.2.0'
*.control_files='/u01/app/oracle/oradata/datastore/C12TEST/C12TEST/controlfile/o1_mf_dpw4ljnv_.ctl'
*.cpu_count=2
*.cursor_sharing='EXACT'
*.db_block_checking='FULL'
*.db_block_checksum='FULL'
*.db_block_size=8192
*.db_create_file_dest='/u02/app/oracle/oradata/datastore/.ACFS/snaps/C12TEST'
*.db_create_online_log_dest_1='/u01/app/oracle/oradata/datastore/C12TEST'
*.db_domain=''
*.db_files=1024
*.db_lost_write_protect='TYPICAL'
*.db_name='C12TEST'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area/datastore/C12TEST'
*.db_recovery_file_dest_size=476160m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=C12TESTXDB)'
*.fast_start_mttr_target=300
*.filesystemio_options='setall'
*.global_names=TRUE
*.inmemory_size=0m
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=16000000
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=1000
*.os_authent_prefix=''
*.parallel_adaptive_multi_user=TRUE
*.parallel_degree_policy='MANUAL'
*.parallel_execution_message_size=16384
*.parallel_force_local=FALSE
*.parallel_max_servers=80
*.parallel_min_servers=8
*.parallel_threads_per_cpu=2
*.pga_aggregate_limit=2048m
*.pga_aggregate_target=2048m
*.processes=200
*.remote_login_passwordfile='exclusive'
*.session_cached_cursors=100
*.sga_target=1024m
*.sql92_security=TRUE
*.undo_retention=900
*.use_large_pages='ONLY'

 

Cet article Recommended DB Parameters on the Oracle Database Appliance (ODA) est apparu en premier sur Blog dbi services.

Oracle Named a Leader in 2017 Analyst Evaluation for Digital Process Automation Software

Oracle Press Releases - Tue, 2017-07-18 10:00
Press Release
Oracle Named a Leader in 2017 Analyst Evaluation for Digital Process Automation Software Oracle positioned as a leader and selected for evaluation based on proven customer adoption, strong go-to-market strategy, and breadth of capabilities

Redwood Shores, Calif.—Jul 18, 2017

Oracle today announced it has been named a leader in the Forrester Wave™ Digital Process Automation (DPA) Software report. This placement confirms leadership for Oracle Process Cloud, which is part of Oracle Cloud Platform.

“By delivering comprehensive process automation capabilities such as no- and low-code process design, case management and simplified connections to SaaS, Social, Cloud and on-premise systems, Oracle provides customers with a powerful option to continuously deliver engaging customer, employee, and partner experiences at every stage in their business transformation journey,” said Vikas Anand, vice president, product management, Oracle. “Today business process automation augmented with intelligent machine learning is helping organizations drive best next actions and provide them with better, timely decision making capabilities.”

In Forrester's 30-criteria evaluation of DPA vendors, they evaluated 12 significant software providers. Oracle was cited as a leader with the highest possible scores in the low-code/no-code, smart forms and user experience, process flow and design, mobile engagement, API support, data virtualization, deployment options, and ease of implementation criteria.

Download Forrester’s Wave report for “Digital Process Automation Software, Q3 2017” here.

Oracle Process Cloud Service was built from the ground up for the cloud to provide enterprises of all sizes with the low-code app dev platform that they need to build business agility and control their digital destiny. With full lifecycle support for end-to-end process automation spanning departments, SaaS apps, and on-premises systems of record, Oracle Process Cloud Service empowers business analysts and process designers with the tools they need to rapidly deliver differentiating experiences in a collaborative manner. Oracle Process Cloud Service comes with Quick Start App templates and pre-built integrations to companion platform services including, Content Management, Integration, Mobile, Intelligent Bots, and IoT Apps, to enable rapid delivery of engaging experiences across channels and devices.

Customer Momentum

“Process automation is central to our integration strategy,” said Ravi Gade, senior director of apps IT and digital transformation, Calix. “Calix leverages Oracle Process Cloud to reduce IT backlog, ensure compliance, and simplify connections across our rapidly evolving SaaS and on-premises business systems.”

“Using a combination of Oracle Process Cloud Service and Oracle Application Builder Cloud Service along with the cloud-native best practices introduced by our partner, Rubicon Red, we have a comprehensive, integrated cloud platform that enables us to deliver innovative, modern solutions,” said Ryan Klose, general manager, corporate, National Pharmacies. “The Oracle Cloud Platform gives us flexibility to connect to all our core systems, and easily deliver to a range of user interfaces, whether they be online, mobile/tablet, devices/IoT, or emerging chatbot technology.” 

"Oracle Process Cloud Service has allowed us to dramatically shorten our time-to-market by up to 40 percent,” said Matt Wright, chief technology officer, Rubicon Red. “Oracle provides developers with immediate access to a full lifecycle process management environment—including development, test, and production—and enterprise-quality tooling, without needing to build and maintain an IT infrastructure.”

Additional information:
Contact Info
Nicole Maloney
Oracle
+1.415.235.4033
nicole.maloney@oracle.com
Sarah Fraser
Oracle
+1.650.743.0660
sarah.fraser@oracle.com
About Oracle

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

Trademarks

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

Talk to a Press Contact

Nicole Maloney

  • +1.415.235.4033

Sarah Fraser

  • +1.650.743.0660

VirtualBox 5.1.24

Tim Hall - Tue, 2017-07-18 08:20

VirtualBox 5.1.24 has been released.

The downloads and changelog are in the usual places.

I’ve done an installation on my laptop (macOS Sierra) and it worked fine. I probably won’t get to do it on Windows and Oracle Linux hosts until the weekend.

Cheers

Tim…

VirtualBox 5.1.24 was first posted on July 18, 2017 at 2:20 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Cloud Ward: Who Will Win the Battle for IT's Future?

Gerger Consulting - Tue, 2017-07-18 07:27
Attend the free webinar by Oracle's former Chief Communications Officer Bob Evans and learn how to prepare a better cloud strategy for your organization.

As cloud computing surges into the mainstream and becomes the backbone of enterprise IT, hundreds of cloud vendors are fighting for customer dollars. Which ones are framing their cloud services in terms of what businesses want and need, versus pounding their chests over how wonderful their technology is?
Will the big incumbents such as IBM, SAP and Oracle be able to pivot to the cloud with enough capability and urgency to meet the intense requirements of modern digital businesses? Which top cloud vendors are positioning cloud in a silo, and which are blending cloud vision with AI, cognitive, machine learning, and more?
This discussion will address these and other high-priority issues for IT buyers and decision-makers.
Registration is free but space is limited.
Categories: Development

Machine Learning in Oracle Database – Classification of Conference Abstracts based on Text Analysis

Amis Blog - Tue, 2017-07-18 01:53

Machine Learning is hot. The ability to have an automated system predict, classify, recommend and even decide based on models derived from past experience is quite attractive. And with the number of obvious applications of machine learning – Netflix and Amazon recommendations, intelligent chat bots, license plate recognition in parking garages, spam filters in email servers – the interest further grows. Who does not want to apply machine learning?

This article shows that the Oracle Database (platform) – with the Advanced Analytics option – is perfectly capable of doing ‘machine learning’. And has been able to do such learning for many years. From the comfort of their SQL & PL/SQL zone, database developers can play data scientists. The challenge is as follows:

For the nlOUG Tech Experience 2017 conference, we have a set of about 90 abstracts in our table (title and description). 80 of these abstracts have been classified into the conference tracks, such as DBA, Development, BI & Warehousing, Web & Mobile, Integration & Process. For about 10 abstracts, this classification has not yet been done – they do not currently have an assigned track. We want to employ machine learning to determine the track for these unassigned abstracts.

The steps we will go through to solve this challenge:

  • Create a database table with the conference abstracts – at least columns title, abstract and track

  • Create an Oracle Text policy object

  • Specify the model configuration settings

  • Create the model using the model settings and text transformation instructions to DBMS_DATA_MINING.CREATE_MODEL.

  • Test the model/Try out the model – in our case against the currently unassigned conference abstracts

  • The volume of code required for this is very small (less than 30 lines of PL/SQL). The time it takes to go through this is very limited as well. Let’s see how this works. Note: the code is in a GitHub repository: https://github.com/lucasjellema/theArtOfMachineLearning .

    Note: from the Oracle Database documentation on text mining:

    Text mining is the process of applying data mining techniques to text terms, also called text features or tokens. Text terms are words or groups of words that have been extracted from text documents and assigned numeric weights. Text terms are the fundamental unit of text that can be manipulated and analyzed.

    Oracle Text is a Database technology that provides term extraction, word and theme searching, and other utilities for querying text. When columns of text are present in the training data, Oracle Data Mining uses Oracle Text utilities and term weighting strategies to transform the text for mining. Oracle Data Mining passes configuration information supplied by you to Oracle Text and uses the results in the model creation process.

    Create a database table with the conference abstracts

    I received the data in an Excel spreadsheet. I used SQL Developer to import the file and create a table from it. I then exported the table to a SQL file with DDL and DML statements.

    image

     

    Create an Oracle Text policy object

    An Oracle Text policy specifies how text content must be interpreted. You can provide a text policy to govern a model, an attribute, or both the model and individual attributes.

    DECLARE
      l_policy     VARCHAR2(30):='conf_abstrct_mine_policy';
      l_preference VARCHAR2(30):='conference_abstract_lexer';
    BEGIN
      ctx_ddl.create_preference(l_preference, 'BASIC_LEXER');
      ctx_ddl.create_policy(l_policy, lexer => l_preference);
    END;
    

    Note: the database user you use for this requires two system privileges from the DBA: grant execute on ctx_ddl and grant create mining model

    Specify the text mining model configuration settings

    When the Data Mining  model is created with a PL/SQL command, we need to specify the name of a table that holds key-value pairs (columns setting_name and setting value) with the settings that should be applied.

    Create this settings table.

    CREATE TABLE text_mining_settings
      (
        setting_name  VARCHAR2(30),
        setting_value VARCHAR2(4000)
      );
    

    Choose the algorithm to use for classification – in this case Naïve Bayes. Indicate the Oracle Text policy to use – in this case conf_abstrct_mine_policy- through INSERT statements.

    DECLARE
      l_policy     VARCHAR2(30):='conf_abstrct_mine_policy';
    BEGIN
      -- Populate settings table
      INSERT
      INTO text_mining_settings VALUES
        (
          dbms_data_mining.algo_name,
          dbms_data_mining.algo_naive_bayes
        );
      INSERT
      INTO text_mining_settings VALUES
        (
          dbms_data_mining.prep_auto,
          dbms_data_mining.prep_auto_on
        );
      INSERT
      INTO text_mining_settings VALUES
        (
          dbms_data_mining.odms_text_policy_name,
          l_policy
        ); 
      COMMIT;
    END;
    

     

    Pass the model settings and text transformation instructions to DBMS_DATA_MINING.CREATE_MODEL

    I do not like the elaborate, unintuitive syntax required for creating model. I do not like the official Oracle Documentation around this. It is not as naturally flowing as it should be, the pieces do not fit together nicely. It feels a little like the SQL Model clause – something that never felt quite right to me.

    Well, this is how it is. To specify which columns must be treated as text (configure text attribute) and, optionally, provide text transformation instructions for individual attributes, we need to use a dbms_data_mining_transform.TRANSFORM_LIST object to hold all columns and/or SQL expressions that contribute to the identification of each record. The attribute specification is a field (attribute_spec) in a transformation record (transform_rec). Transformation records are components of transformation lists (xform_list) that can be passed to CREATE_MODEL. You can view attribute specifications in the data dictionary view ALL_MINING_MODEL_ATTRIBUTES.

    Here is how we specify the text attribute abstract:

    dbms_data_mining_transform.SET_TRANSFORM( xformlist, ‘abstract’, NULL, ‘abstract’, NULL, ‘TEXT(TOKEN_TYPE:NORMAL)’);

    where xformlist is a local PL/SQL variable of type dbms_data_mining_transform.TRANSFORM_LIST.

    In the call to create_model, we specify the name of the new model, the table (of view) against which the model is to be built, the target column name for which the model should predict the values, the name of the database table with the key value pairs holding the settings for the model and the list of text attributes:

    DECLARE
      xformlist dbms_data_mining_transform.TRANSFORM_LIST;
    BEGIN
      -- add column abstract as a column to parse and use for text mining
      dbms_data_mining_transform.SET_TRANSFORM( xformlist, 'abstract', NULL, 'abstract', NULL, 'TEXT(TOKEN_TYPE:NORMAL)');
      dbms_data_mining_transform.SET_TRANSFORM( xformlist, 'title', NULL, 'title', NULL, 'TEXT(TOKEN_TYPE:NORMAL)');
      DBMS_DATA_MINING.CREATE_MODEL( model_name => 'ABSTRACT_CLASSIFICATION'
      , mining_function => dbms_data_mining.classification
      , data_table_name => 'OGH_TECHEXP17'
      , case_id_column_name => 'title'
      , target_column_name => 'track'
      , settings_table_name => 'text_mining_settings'
      , xform_list => xformlist);
    END;
    

    Oracle Data Miner needs to have one attribute that identifies each records; the name of the column to use for this is passed as the case id.

     

    Test the model/Try out the model – in our case against the currently unassigned conference abstracts

    Now that the model has been created, we can make use of it for predicting the value of the target column for selected records.

    First, let’s have the model classify the abstracts without track:

    SELECT title
    ,      PREDICTION(ABSTRACT_CLASSIFICATION USING *) AS predicted_target
    ,      abstract
    FROM   OGH_TECHEXP17
    where  track is null
    

     

    image

    We can use the model also to classify data on the fly, like this (using two abstracts from a different conference that are not stored in the database at all):

    with sessions_to_judge as
    ( select 'The Modern JavaScript Server Stack' title
      , 'The usage of JavaScript on the server is rising, and Node.js has become popular with development shops, from startups to big corporations. With its asynchronous nature, JavaScript provides the ability to scale dramatically as well as the ability to drive server-side applications. There are a number of tools that help with all aspects of browser development: testing, packaging, and deployment. In this session learn about these tools and discover how you can incorporate them into your environment.' abstract
      from dual
      UNION ALL
      select 'Winning Hearts and Minds with User Experience' title
      , 'Not too long ago, applications could focus on feature functionality alone and be successful. Today, they must also be beautiful, responsive, and intuitive. In other words, applications must be designed for user experience (UX) because when they are, users are far more productive, more forgiving, and generally happier. Who doesnt want that? In this session learn about the psychology behind what makes a great UX, discuss the key principles of good design, and learn how to apply them to your own projects. Examples are from Oracle Application Express, but these principles are valid for any technology or platform. Together, we can make user experience a priority, and by doing so, win the hearts and minds of our users. We will use Oracle JET as well as ADF and some mobile devices and Java' abstract
      from dual
    )
    SELECT title
    ,      PREDICTION(ABSTRACT_CLASSIFICATION USING *) AS predicted_target
    ,      abstract
    FROM   sessions_to_judge
    

     

    image

    Both abstracts are assigned tracks within the boundaries of the model. If these abstracts were submitted to the Tech Experience 2017 conference, they would have been classified like this. It would be interesting to see which changes to make to for example the second abstract on user experience in order to have it assigned to the more fitting Web & Mobile track.

    One final test: find all abstracts for which the model predicts a different track than the track that was actually assigned:

    select *
    from ( SELECT title
           ,      track 
           ,      PREDICTION(ABSTRACT_CLASSIFICATION USING *) AS predicted_track
           FROM   OGH_TECHEXP17
           where  track is not null
         )
    where track != predicted_track
    

    image

    Seems not unreasonable to have a second look at this track assignment.

    Resources

    Source code in GitHub: https://github.com/lucasjellema/theArtOfMachineLearning 

    Oracle Advanced Analytics Database Option: https://www.oracle.com/database/advanced-analytics/index.html 

    My big inspiration for this article:  Introduction to Machine Learning for Oracle Database Professionals by Alex Gorbachev – https://www.slideshare.net/alexgorbachev/introduction-to-machine-learning-for-oracle-database-professionals

    Oracle Documentation on Text Mining: https://docs.oracle.com/database/122/DMPRG/creating-model-that-includes-text-mining.htm#DMPRG604

    Toad World article on Explicit Semantic Analysis setup using SQL and PL/SQL: https://www.toadworld.com/platforms/oracle/b/weblog/archive/2017/01/16/explicit-semantic-analysis-setup-using-sql-and-pl-sql

    Sentiment Analysis Using Oracle Data Miner – OTN article by Brendan Tierney – http://www.oracle.com/technetwork/articles/bi/odm-sentiment-analysis-tierney-2416652.html 

    My own blogs on Oracle Database Data Mining from PL/SQL – from long, long ago: Oracle Datamining from SQL and PL/SQL and Hidden PL/SQL Gem in 10g: DBMS_FREQUENT_ITEMSET for PL/SQL based Data Mining

    The post Machine Learning in Oracle Database – Classification of Conference Abstracts based on Text Analysis appeared first on AMIS Oracle and Java Blog.

    Upgrading 11.2.0.2 to 11.2.0.3 using import/export

    Tom Kyte - Mon, 2017-07-17 21:46
    I have I have a Solaris 11.1 system with Oracle 11.2.0.2 with grid/ASM and databases. I need to migrate the databases to another Solaris 11.1 system that will have Oracle 11.2.0.3 software. 1. Can I export the ENTIRE 11.2.0.2 database and import ...
    Categories: DBA Blogs

    Mirror Schema to another database

    Tom Kyte - Mon, 2017-07-17 21:46
    I have schema access to database A and have DBA access to database B. I have the same schema in both databases. How do I synchronize every changes that occur in A to happen in B on a daily basis.
    Categories: DBA Blogs

    Virtualization on Windows 10 with Virtual Box, Hyper-V and Docker Containers

    Amis Blog - Mon, 2017-07-17 16:17

    Recently I started working on a brand new HP ZBook 15-G3 with Windows 10 Pro. And I immediately tried to return to the state I had my previous Windows 7 laptop in: Oracle Virtual Box for running most software in virtual machines, using Docker Machine (and Kubernetes) for running some things in Docker Containers and using Vagrant to spin up some of these containers and VMs.

    I quickly ran into some issues that made me reconsider – and realize that some things are different on Windows 10. In this article a brief summary of my explorations and findings.

    • Docker for Windows provides near native support for running Docker Containers; the fact that under the covers there is still a Linux VM running is almost hidden and from command line (Powershell) and a GUI I have easy access to the containers. I do  not believe though that I can run containers that expose a GUI – except through a VNC client
    • Docker for Windows leverages Hyper-V. Hyper-V lets you run an operating system or computer system as a virtual machine on Windows. (Hyper-V is built into Windows as an optional feature; it needs to be explicitly enabled) Hyper-V on Windows is very similar to VirtualBox
    • In order to use Hyper-V or Virtual Box, hardware virtualization must be enabled in the system’s BIOS
    • And the one finding that took longest to realize: Virtual Box will not work if Hyper-V is enabled. So the system at any one time can only run Virtual Box or Hyper-V (and Docker for Windows), not both. Switching Hyper-V support on and off is fairly easy, but it does require a reboot

    Quick tour of Windows Hyper-V

    Creating a virtual machine is very easy. A good example is provided in this article: https://blog.couchbase.com/hyper-v-run-ubuntu-linux-windows/ that describes how a Hyper-V virtual machine is created with Ubuntu Linux.

    I went through the following steps to create a Hyper-V VM running Fedora 26. It was easy enough. However, the result is not as good in terms of the GUI experience as I had hoped it would be. Some of my issues: low resolution, only 4:3 aspect ratio, I cannot get out of full screen mode (that requires CTRL-ALT-BREAK and my keyboard does not have a break key. All alternative I have found do not work for me.

      • Download ISO image for Fedora 26 (Fedora-Workstation-Live-x86_64-26-1.5.iso using Fedora Media Writer or from https://fedora.mirror.wearetriple.com/linux/releases/26/Workstation/x86_64/iso/)
      • Enable Virtualization in BIOS
      • Enable Hyper-V (First, open Control Panel. Next, go to Programs. Then, click “Turn Windows features on or off”. Finally, locate Hyper-V and click the checkbox (if it isn’t already checked))
      • Run Hyper-V Manager – click on search, type Hype… and click on Hype-V Manager
        image
      • Create Virtual Switch – a Network Adapter that will allow the Virtual Machine to communicate to the world
        image
      • Create Virtual Machine – specify name, size and location of virtual hard disk (well, real enough inside he VM, virtual on your host), size of memory, select the network switch (created in the previous step), specify the operating system and the ISO while where it will be installed from
        image
      • Start the virtual machine and connect to it. It will boot and allow you to run through the installation procedure
      • Potentially change the screen resolution used in the VM. That is not so simple: see this article for an instruction: https://www.netometer.com/blog/?p=1663 Note: this is one of the reasons why I am not yet a fan of Hyper-V
      • Restart the VM an connect to it; (note: you may have to eject the ISO file from the virtual DVD player, as otherwise the machine could boot again from the ISO image instead of the now properly installed (virtual) hard disk
        image

    References

    Article that explains how to create a Hyper-V virtual machine that runs Ubuntu (including desktop): https://blog.couchbase.com/hyper-v-run-ubuntu-linux-windows/ 

    Microsoft article on how to use local resources (USB, Printer) inside Hyper-V virtual machine: https://docs.microsoft.com/en-us/windows-server/virtualization/hyper-v/learn-more/Use-local-resources-on-Hyper-V-virtual-machine-with-VMConnect 

    Microsoft documentation: introduction of Hypervisor Hyper-v on Windows 10: https://docs.microsoft.com/en-us/virtualization/hyper-v-on-windows/about/

    Two article on converting Virtual Box VM images to Hyper-V: https://cloudbase.it/convert-virtualbox-to-hyper-v/ and (better) https://www.groovypost.com/howto/migrate-virtual-box-vms-windows-10-hyper-v/

    And: how to create one’s own PC into a Hyper-V VM: http://www.online-tech-tips.com/free-software-downloads/convert-pc-into-virtual-machine/

    Rapid intro to Docker on Windows

    Getting going with Docker on Windows is surprisingly simple and pleasant. Just install Docker for Windows (see for example article for instructions: https://www.htpcbeginner.com/install-docker-on-windows-10/ ). Make sure that Hyper-V is enabled – because Docker for Windows leverages Hyper-V to run a Linux VM: the MobyLinuxVM that you see the details for in the next figure.

    SNAGHTMLcb5d37 

    At this point you can interact with Docker from the Powershell command line – simply type docker ps, docker run, docker build and other docker commands on your command line. To just run containers based on images – local or in public or private registries – you can use the Docker GUI Kitematic. It is a separate install action – – that is largely automated as is described here  https://www.htpcbeginner.com/install-kitematic-on-windows/ –to get Kitematic installed. That is well worth the extremely small trouble it is.

    image

    From Kitematic, you have a graphical overview of your containers as well as an interactive UI for starting containers, configuring them, inspecting them and interacting with them. All things you can do from the command line – but so much simpler.

    image

    In this example, I have started a container based on the ubuntu-xfce-nvc image (see https://hub.docker.com/r/consol/ubuntu-xfce-vnc/) which runs the Ubuntu Linux distribution with “headless” VNC session, Xfce4 UI and preinstalled Firefox and Chrome browser.

    image

    The Kitematic IP & Ports tab specify that port 5901 – the VNC port – is mapped to port 32769 on the host (my Windows 10 laptop). I can run the MobaXterm tool and open a VNC session with it, fir 127.0.0.1 at port 32769. This allows me to remotely (or at least outside of the container) see the GUI for the Ubuntu desktop:

    image

    Even though it looks okay and it is pretty cool that I can graphically interact with the container, it is not a very good visual experience – especially when things start to move around. Docker for Windows is really best for headless programs that run in the background.

    For quickly trying out Docker images and for running containers in the background – for example with a MongoDB database, an Elastic Search Index and a Node.JS or nginx web server – this seems to be a very usable way of working.

    References

    Introducing Docker for Windows: https://docs.docker.com/docker-for-windows/ Documentation

    Download Docker for Windows Community Edition: https://www.docker.com/community-edition#/download

    Article on installation for Kitematic – the GUI for Docker for Windows: https://www.htpcbeginner.com/install-kitematic-on-windows/ 

    Download MobaXterm: http://mobaxterm.mobatek.net/ 

    Virtual Box on Windows 10

    My first impressions on Virtual Box compared to Hyper-V that for now at least I far prefer Virtual Box(for running Linux VMs).The support for shared folders between host and guest, the high resolution GUI for the Guest, and the fact that currently many prebuilt images are available for Virtual Box and not so many (or hardly any) for Hyper-V are for now points in favor of Virtual Box. I never run VMs with Windows as Guest OS, I am sure that would impact my choice.

    Note- once more- that for VirtualBox to run on Windows 10, you need to make sure that hardware virtualization is enabled in BIOS and that Hyper-V is not enabled. Failing to take care of either of these two will return the same error VT-x is not available (VERR_VMX_NO_VMX):

    image

    Here is a screenshot of a prebuilt VM image running on Virtual Box on Windows 10 – all out of the box.

    image

    No special set up required. It uses the full screen, it can interact with the host, is clipboard enabled, I can easily toggle between guest and host and it has good resolution and reasonable responsiveness:

    image

    Resources

    Article describing setting up two boot profiles for Windows 10 – one for Hyper-V and one without it (for example run Virtual Box): https://marcofranssen.nl/switch-between-hyper-v-and-virtualbox-on-windows/

    Article that explains how to create a Hyper-V virtual machine that runs Ubuntu (including desktop): https://blog.couchbase.com/hyper-v-run-ubuntu-linux-windows/ 

    Microsoft article on how to use local resources (USB, Printer) inside Hyper-V virtual machine: https://docs.microsoft.com/en-us/windows-server/virtualization/hyper-v/learn-more/Use-local-resources-on-Hyper-V-virtual-machine-with-VMConnect 

    Microsoft documentation: introduction of Hypervisor Hyper-v on Windows 10: https://docs.microsoft.com/en-us/virtualization/hyper-v-on-windows/about/

    HP Forum Entry on enabling Virtualization in BIOS fo ZBook G2 : https://h30434.www3.hp.com/t5/Business-Notebooks/Enable-hardware-virtualization-on-HP-ZBOOK-15-G2/td-p/5513726 

    Introducing Docker for Windows: https://docs.docker.com/docker-for-windows/ Documentation

    Download Docker for Windows Community Edition: https://www.docker.com/community-edition#/download

    Article on installation for Kitematic – the GUI for Docker for Windows: https://www.htpcbeginner.com/install-kitematic-on-windows/ 

    Two article on converting Virtual Box VM images to Hyper-V: https://cloudbase.it/convert-virtualbox-to-hyper-v/ and (better) https://www.groovypost.com/howto/migrate-virtual-box-vms-windows-10-hyper-v/

    And: how to create one’s own PC into a Hyper-V VM: http://www.online-tech-tips.com/free-software-downloads/convert-pc-into-virtual-machine/

    The post Virtualization on Windows 10 with Virtual Box, Hyper-V and Docker Containers appeared first on AMIS Oracle and Java Blog.

    Check Your EBS Database Configuration with Database Parameter Settings Analyzer

    Steven Chan - Mon, 2017-07-17 15:31

    Database ParaIn addition to helping customers resolve issues via Service Requests, Oracle Support also builds over 60 free diagnostic tools for Oracle E-Business Suite 12.2, 12.0, 12.1, and 11i. These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments. They look for common issues and generate standardized reports summarizing that provide solutions for known issues and recommendations on best practices.

    Here's an index to these tools:

    Spotlight on Database Parameter Settings Analyzer

    We publish a definitive list of Oracle Database initialization parameter settings for the optimal performance of Oracle E-Business Suite 12.2, 12.1, and 12.0:  

    This document is updated regularly; for example, it was recently updated to account for changes introduced by the April 2017 updates to the AD and TXK utilities.

    It can be challenging to keep up with those changes simply by scanning Note 396009.1 yourself.  You can automate this process by using the Database Parameter Settings Analyzer:

    The Database Parameter Settings Analyzer compares your database's parameter settings to the latest recommendations in Note 396009.1.  It reports on any differences, and makes recommendations about your sga_target, shared_pool_size, shared_pool_reserved_size and processes parameters based upon the number of active users for your environment.  

    This tool can be run manually or configured to run as a concurrent request, so it can be scheduled to be run periodically and included in regular database maintenance cycles.

    Can this script be run against Production?

    Yes. There is no DML in the Analyzer Script, so it is safe to run against Production instances to get an analysis of the environment for a specific instance. As always it is recommended to test all suggestions against a TEST instance before applying to Production.

    Related Articles

    Categories: APPS Blogs

    Pages

    Subscribe to Oracle FAQ aggregator