Skip navigation.

Feed aggregator

"Creating Connections with People Analytics" by Bertrand Dussert

Linda Fishman Hoyle - Wed, 2016-01-20 11:55

Modern HCM supports the communication between employees and employers and is a tangible way to take care of a company’s greatest asset.

But rolling out a new employee portal designed to help a workforce manage their careers is only a starting point. Bertrand Dussert, vice president of HCM transformation and thought leadership for Oracle (pictured left), says HR leaders need to “understand how to leverage usage data to spot areas in the business potentially requiring attention.”

Using this data, called people analytics, can help organizations make better HR decisions. It can also be used to assess how employees are using HCM applications, how effective the applications are, as well as identify areas of concern. A Deloitte study indicates that in-depth analytics is “a challenge that needs to be addressed by organizations and companies that want to remain competitive.”

Do you know what you need to know about people analytics? Let Dussert’s article, published in HRE Online on December 22, 2015, be a starting point.

CMSWire: Collaboration, Digital Experience and Engagement Survey

WebCenter Team - Wed, 2016-01-20 09:53
We invite you to take CMSWire’s survey on collaboration, digital experience and engagement. During this 10-minute survey, we’ll seek input around how your organization is:
  • driving social collaboration around content;
  • delivering digital experiences across multiple channels; and 
  • providing self-service and business automation 

We’ll also explore your needs around self-service and engagement, as well as which tools your organization currently uses for content collaboration, social conversations, websites and self-service. 

In partnership with Oracle, we are conducting this survey so we can give you and your peers a picture of how businesses are engaging with customers, employees, partners and citizens. By participating, you will have the option to receive the survey results once they are available, and see how your efforts compare to others in the industry.

Bonus: Survey respondents will have a chance to win one of two free 2-day passes to CMSWire's DX Summit 2016. Winners will be contacted via email.  

We appreciate you taking the time to share your experiences and insights. Take the survey now!

Highlight numbers in an APEX Report (SQL and Class)

Dimitri Gielis - Wed, 2016-01-20 09:31
Last year I blogged about highlighting negative numbers in an APEX Report, the CSS only way.
At that time I gave two alternative approaches; by using JQuery or SQL, but it looks like I didn't do those posts yet, till somebody reminded me. This post is about using SQL to highlight something in a report.

Let's say we want to highlight negative numbers in a report (as in the previous post):

We have some CSS defined inline in the Page:
.negative-number {

The negative-number class we will add to some values. All the logic to know if it's a negative number will be in SQL. Why SQL you might ask? This example is very simple, but you could call a function which has a lot of complexity to decide if you want to assign a class to a record or not, the principe of this example is more important, that you can use logic in SQL to work with CSS.
The SQL Query of the Report looks like this. Watch for the case statement where we say when to assign a value for the class:
   when amount < 0
   then 'negative-number'
   else ''
 end as class
from dimi_transaction
order by id

Finally we assign the class to the amount, by adding a span in the HTML Expression of the Amount column:

The Class column you can make Conditional = Never as it's something we just use behind the scenes.
That's how you make a bridge between SQL and CSS.
You can now play more with the case statement and even let the class or style e.g. color, come from a user defined table... unlimited possibilities :)
Categories: Development

OAMConsole : 404 Page not found for /oamconsole in Oracle Access Manager 11gR2

Online Apps DBA - Wed, 2016-01-20 04:52
This entry is part 4 of 5 in the series Oracle Access Manager

This post covers issue encountered by one of our trainee in our Oracle Access Manager 11gR2 Training / Workshop (Training starts on 31st January, 2016 Discount of 200 USD is going on till 23rd of January, 2016, Apply Coupon code A200OFF) where /oamconsole was not working. (We provide dedicated machine to practice hands-on during the OAM training)

OAM Console (/oamconsole) is an application to manage Oracle Access Manager Configuration that gets deployed on WebLogic’s Admin Server (when you configure OAM Server). You access OAM Console from http://WebLogicAdminServerHost:AdminPort/oamconsole


While accessing an oamconsole at http://<host>:<port>/oamconsole

Error Displayed on screen as “404 Page Not Found”


Error 404–Not Found
From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1:
10.4.5 404 Not Found
The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.
If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address.

Root Cause :

If you hit issues like this then on WebLogic Console /console (this is another application that gets deployed when you create a WebLogic Domain) check status of oam_admin under deployments .

In my case deployment of oam_admin application was in Admin State hence /oamconsole was not accessible  . To find our root cause of application oam_admin in Admin state look at Admin Server log file and possibly try starting application from console (check fix below). In my case Server was hitting max number of open connections so increased limit on number of open connections on server.



Check status of deployment in WebLogic Server Console



Select application and click on Start -> Servicing All applications



If you want to learn more or wish to discuss challenges you are hitting in Oracle Access Manager Implementation or OAM Integration with Oracle E-Business Suite (R12.1/12.2), register for our Oracle Access Manager Training (next batch starts on 31st January, 2016 – Register before 23rd Jan and get discount of 200 USD,  Apply coupon code A2OFF ).

We are so confident on quality and value of our training that We provide 100% Money back guarantee so in unlikely case of you being not happy after 2 sessions, just drop us a mail before third session and We’ll refund FULL money.

We provide dedicated machine on cloud to practice OAM Implementation including integration with E-Business Suite and recording of live interactive trainings for life time access.

Stay tuned for more updates!!

Want to learn Oracle Access Manager?

Reserve your spot for FREE Demo Class with Hands-on Lab Exercises on 24th Jan 2016 at 7:30 AM PST/ 10:30 AM EST/ 9:00 PM IST/ 3:30 PM GMT by Oracle ACE Atul Kumar

Click here to reserve your spot for FREE

The post OAMConsole : 404 Page not found for /oamconsole in Oracle Access Manager 11gR2 appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

MobaXterm 8.6

Tim Hall - Wed, 2016-01-20 03:38

MobaXterm 8.6 has just been released. The downloads and changelog can be found here.

For SSH and X emulation, this is the best! I keep saying it, but give it a go. You won’t regret it. :)



MobaXterm 8.6 was first posted on January 20, 2016 at 10:38 am.
©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.

Video: SQL Server Databases on Microsoft Azure

Tim Hall - Wed, 2016-01-20 02:55

I mentioned in a previous post, the whole look and feel of Microsoft Azure has been rejigged. As a result, I had to do a run through of the SQL Server DBaaS stuff to update the screen shots in and old article on the subject.

Azure : SQL Server Databases on Azure

Since I was doing that, I figured I might as well do a video for my YouTube channel.



Video: SQL Server Databases on Microsoft Azure was first posted on January 20, 2016 at 9:55 am.
©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.

VirtualBox 5.0.14

Tim Hall - Wed, 2016-01-20 02:22

VirtualBox 5.0.14 has been born.

Downloads and changelog are in the usual places.

I’ve not done the installation on Linux yet, but it installed and seems to work fine on Windows 7 and Mac OS X (El Crapitan).



VirtualBox 5.0.14 was first posted on January 20, 2016 at 9:22 am.
©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.

January 2016 Critical Patch Update Released

Oracle Security Team - Tue, 2016-01-19 18:11

Oracle today released the January 2016 Critical Patch Update.  With this Critical Patch Update release, the Critical Patch Update program enters its 11th year of existence (the first Critical Patch Update was released in January 2005).  As a reminder, Critical Patch Updates are currently released 4 times a year, on a schedule announced a year in advance.  Oracle recommends that customers apply this Critical Patch Update as soon as possible.

The January 2016 Critical Patch Update provides fixes for a wide range of product families; including: 

  • Oracle Database
    • None of these database vulnerabilities are remotely exploitable without authentication. 
  • Java SE vulnerabilities
    • Oracle strongly recommends that Java home users visit the web site, to ensure that they are using the most recent version of Java and are advised to remove obsolete Java SE versions from their computers if they are not absolutely needed.
  • Oracle E-Business Suite.
    • Oracle’s ongoing assurance effort with E-Business Suite helps remediate security issues and is intended to help enhance the overall security posture provided by E-Business Suite.

Oracle takes security seriously, and strongly encourages customers to keep up with newer releases in order to benefit from Oracle’s ongoing security assurance effort.  

For more information:

The January 2016 Critical Patch Update Advisory is located at

The Oracle Software Security Assurance web site is located at

Oracle Applications Lifetime Support Policy is located at

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

Mike Hibbert – A Celebration

Rittman Mead Consulting - Tue, 2016-01-19 16:18

Mike Hibbert

It’s been a long while since I graced the blog with my presence and I had always hoped that when I did return, it would be with something new, or exciting to say.  Instead, I find myself writing something much more personal and subdued:  a celebration of one of our dear colleagues who, after a 2 year fight, lost his battle to cancer just before Christmas 2015.

Joining us in September 2010, Mike Hibbert was one of our longest serving team members.  We still don’t have too many people with over 5 years service, but Mike was one of us.  I was lucky enough to work with Mike from day one:  he was parachuted into the project I was working on to cover the large gaps in my OWB knowledge and experience.  His role on the project was not that of simply building some mappings (we were already 7 months into the 9 month engagement and the OWB estate had already been built).  Instead, Mike’s task was to mentor the clients OWB team and ensure their ETL development capability was in place.  At the same time, he had to come to terms with the OWB estate, review it and where necessary, make it production-ready.  Landing on a project late in the day is never an enviable task for us consultants…even more so when it is your first day on the new job!

Mike brought bags of technical experience in both OWB and OBIEE from his previous roles with Edenbrook & Hitachi Consulting, but what impressed me most about Mike in that first project was the way he built up such a good rapport with all the members of the clients diverse project team.  He gained the teams trust on the technical side early but also engaged with people at a very personal level.  His approach was friendly and easy-going and he would always show an active interest in everything about the people he was working with, be it understanding their perspective on a particular technical challenge or simply talking about last nights TV, major family milestones or the travails of our chosen football teams. His sense of humour was disarming and his natural approach stood him in very good stead throughout his time with Rittman Mead.

Mike spent most of his time with us working on the continent, initially in Belgium, but in 2011 he began working with one of our major clients in the Netherlands.  This was the start of a long and valued relationship with the client, where Mike fulfilled several roles, mainly around OBIEE but also getting his hands increasingly dirty with APEX!  The scope of the projects and the personnel involved changed over time, but Mike was a constant.  He championed new agile delivery methods and became a key member of the clients team, delivering a number of critical solutions to their business units across Europe.  All told, Mike worked with the same client for over 4 years – a mark of his value and importance to them.  He continued to work through his illness and treatment, taking very little time off.  He was still working into his final week.  I came to learn that this was how Mike wanted to tackle his illness and the courage and determination he showed in facing it in this way is an inspiration to us all.

Rittman Mead UK vs Rest of the World 5-a-side, 2013

Mike was a vital member of our team.  He was a founding father of the Rittman Mead Fantasy Football League, now in its 4th year and, although he never admitted it, I think he was always a little frustrated that he never won the title.  I always looked forward to the start of each season in anticipation of the interesting team names Mike always seemed to come up with…often cryptic, always cheeky and always guaranteed to raise a chuckle!  As a Manchester United fan, we could always rely on Mike to give us his hints and tips on which of the Red Devils we should have in our teams…occasionally, his advice even made some sense!  Mike’s main interests lay in sport.  He kept the illustrious tennis career he had before entering the BI world under wraps for quite a while, but his main pursuits were running and cycling – two things that he put together (with a swim beforehand for good measure) to compete in the occasional triathlon.  Amazingly, he continued his cycling through his illness, raising money for both Prostate Cancer UK and The Christie.  In proposing a UK vs Rest of the World 5-a-side match, little did Mike know that he would initiate the companies longest e-mail debate.  It caught our imagination and we had our first match during our BI Forum in 2013.  Mike played on the Rest of the World side (justified by his working relationship with the Netherlands!) and despite giving away a few years on us all, he duly earned the Man of the Match award.  I hope that we will be able to continue these 5-a-side battles in his memory for years to come.


On a personal level, Mike and I lived relatively close to each other and for a period, this meant us sharing flights to/from Manchester airport.  We spent some very early mornings in MAN departures and many an hour waiting for delayed flights from AMS (and inevitably enjoying the odd continental beer!).  We coincidentally earned our FA Level 1 coaching badges at the same time and each of us coached our own sons teams.  Our conversations would always eventually turn into a discussion of recent results, tactics and training methods…just another example of Mike’s personable style and his interest in others.

Mike will be sadly missed as a friend and colleague and the collective thoughts and support of Rittman Mead go out to the family that he leaves behind.

We are keen to lend our efforts to the amazing charitable efforts that Mike started and his family continues. We have some fund-raising ideas, which I think Mike would appreciate and I hope can come to fruition in the near future. In the meantime, if you knew or worked with Mike it would be great to hear your memories of him.

The post Mike Hibbert – A Celebration appeared first on Rittman Mead Consulting.

Categories: BI & Warehousing

Inside Higher Ed: One year after selling majority stake in company

Michael Feldstein - Tue, 2016-01-19 13:01

By Phil HillMore Posts (385)

One year ago I wrote a post critical of Inside Higher Ed for not doing a blanket disclosure about the sale of a majority stake to a private equity firm with other education holdings (most notably Ruffalo Noel Levitz).

Subsequent to the disclosure from the Huffington Post, IHE put up an ownership statement disclosing the ownership change and calling out that only editors are involved in editorial policies. The About Us page prominently links to this ownership statement.

In an interview with Education Dive, Scott Jaschik (an Inside Higher Ed founder and editor) noted his regret for not disclosing the sale up front while concluding:

“I guess I would just say to anyone who has questions, read us and read our coverage and call me if you think we’re doing anything that we shouldn’t,” [Jaschik] said.

In the past year I have done exactly that – watching carefully for editorial shifts, complaining publicly about one article, and privately emailing Jaschik on another issue.

My conclusion? Inside Higher Ed has shown no bias and no change in editorial policies based on the new ownership – they are living up to their word. IHE [Jaschik in particular] has also been quite good in discussing any questions or issues based on their coverage. IHE should be commended for their quality coverage of higher education news.


The post Inside Higher Ed: One year after selling majority stake in company appeared first on e-Literate.

Drop table cascade and reimport

Laurent Schneider - Tue, 2016-01-19 12:26

Happy new year :)

Today I had to import a subset of a database and the challenge was to restore a parent table without restoring its children. It took me some minutes to write the code, but it would have taken days to restore the whole database.

INSERT INTO t2 (c1, c2) VALUES (1, 2);
INSERT INTO t3 (c2, c3) VALUES (2, 3);
INSERT INTO t4 (c3, c4) VALUES (3, 4);

expdp scott/tiger directory=DATA_PUMP_DIR dumpfile=scott.dmp reuse_dumpfiles=y

Now what happen if I want to restore T2 and T3 ?

If possible, I check the dictionary for foreign keys from other tables pointing to T2 and T3.

SELECT constraint_name
FROM user_constraints
WHERE (r_constraint_name) IN (
    SELECT constraint_name
    FROM user_constraints
    WHERE table_name IN ('T2', 'T3'))
  AND table_name NOT IN ('T2', 'T3');

TABLE_NAME                     CONSTRAINT_NAME               
------------------------------ ------------------------------
T4                             T4_T3_FK                      

T4 points to T3 and T4 has data.

Now I can drop my tables with the cascade options

drop table t2 cascade constraints;
drop table t3 cascade constraints;

Now I import, first the tables, then the referential constraints dropped with the cascade clause and not on T2/T3.

impdp scott/tiger tables=T2,T3 directory=DATA_PUMP_DIR dumpfile=scott.dmp

impdp scott/tiger  "include=ref_constraint:\='T4_T3_FK'" directory=DATA_PUMP_DIR dumpfile=scott.dmp

It’s probably possible to do it in one import, but the include syntax is horrible. I tried there

Oracle Database Critical Patch Update (CPU) Planning for 2016

With the start of the new year, it is now time to think about Oracle Critical Patch Updates for 2016.  Oracle releases security patches in the form of Critical Patch Updates (CPU) each quarter (January, April, July, and October).  These patches include important fixes for security vulnerabilities in the Oracle Database.  The CPUs are only available for certain versions of the Oracle Database, therefore, advanced planning is required to ensure supported versions are being used and potentially mitigating controls may be required when the CPUs can not be applied in a timely manner.

CPU Supported Database Versions

As of the October 2015 CPU, the only CPU supported database versions are,, and  The final CPU for will be July 2016. will be supported until October 2020 and will be supported until July 2021. and CPU support ended as of July 2015. 

Database CPU Recommendations
  1. When possible, all Oracle databases should be upgraded to or  This will ensure CPUs can be applied through at least October 2020.
  2. [12.1.01] New databases or application/database upgrade projects currently testing should immediately look to implement instead of, even if this will require additional effort or testing.  With the final CPU for being July 2016, unless a project is implementing in January or February 2016, we believe it is imperative to move to to ensure long-term CPU support.
  3. [ and prior] If a database can not be upgraded, the only effective mitigating control for many database security vulnerabilities is to strictly limit direct database access.  In order to restrict database access, Integrigy recommends using valid node checking, Oracle Connection Manager, network restrictions and firewall rules, and/or terminal servers and bastion hosts.  Direct database access is required to exploit database security vulnerabilities and most often a valid database session is required.

Regardless if security patches are regularly applied or not, general database hardening such as changing database passwords, optimizing initialization parameters, and enabling auditing should be done for all Oracle databases. 


Tags: Oracle DatabaseOracle Critical Patch Updates
Categories: APPS Blogs, Security Blogs

Oracle E-Business Suite Critical Patch Update (CPU) Planning for 2016

With the start of the new year, it is now time to think about Oracle Critical Patch Updates for 2016.  Oracle releases security patches in the form of Critical Patch Updates (CPU) each quarter (January, April, July, and October).  These patches include important fixes for security vulnerabilities in the Oracle E-Business Suite and its technology stack.  The CPUs are only available for certain versions of the Oracle E-Business Suite and Oracle Database, therefore, advanced planning is required to ensure supported versions are being used and potentially mitigating controls may be required when the CPUs can not be applied in a timely manner.

For 2016, CPUs for Oracle E-Business Suite will become a significant focus as a large number of security vulnerabilities for the Oracle E-Business Suite will be fixed.  The January 2016 CPU for the Oracle E-Business Suite (EBS) will include 78 security fixes for a wide range of security bugs with many being high risk such as SQL injection in web facing self-service modules.  Integrigy anticipates the next few quarters will have an above average number of EBS security fixes (average is 7 per CPU since 2005).  This large number of security bugs puts Oracle EBS environments at significant risk as many of these bugs will be high risk and well publicized.

Supported Oracle E-Business Suite Versions

Starting with the April 2016 CPU, only 12.1 and 12.2 will be fully supported for CPUs moving forward.  11.5.10 CPU patches for April 2016, July 2016, and October 2016 will only be available to customers with an Advanced Customer Support (ACS) contract.  There will be no 11.5.10 CPU patches after October 2016.  CPU support for 12.0 ended as of October 2015.

11.5.10 Recommendations
  1. When possible, the recommendation is to upgrade to12.1 or 12.2.
  2. Obtaining an Advanced Customer Support (ACS) contract is a short term (until October 2016) solution, but is an expensive option.
  3. An alternative to applying CPU patches is to use Integrigy's AppDefend, an application firewall for Oracle EBS, in proxy mode which blocks EBS web security vulnerabilities.  AppDefend provides virtual patching and can effectively replace patching of EBS web security vulnerabilities.

In order to mitigate some mod_plsql security vulnerabilities, all Oracle EBS 11i environments should look at limiting the enabled mod_plsql web pages.  The script $FND_TOP/patch/115/sql/txkDisableModPLSQL.sql can be used to limit the allowed pages listed in FND_ENABLED_PLSQL.  This script was introduced in 11i.ATG_PF.H and the most recent version is in 11i.ATG_PF.H.RUP7.  This must be thoroughly tested as it may block a few mod_plsql pages used by your organization.  Review the Apache web logs for the pattern '/pls/' to see what mod_plsql pages are actively being used.  This fix is included and implemented as part of the January 2016 CPU.

12.0 Recommendations
  1. As no security patches are available for 12.0, the recommendation is to upgrade to 12.1 or 12.2 when possible.
  2. If upgrading is not feasible, Integrigy's AppDefend, an application firewall for Oracle EBS, provides virtual patching for EBS web security vulnerabilities as well as blocks common web vulnerabilities such as SQL injection and cross-site scripting (XSS).  AppDefend is a simple to implement and cost-effective solution when upgrading EBS is not feasible.
12.1 Recommendations
  1. 12.1 is supported for CPUs through October 2019 for implementations where the minimum baseline is maintained.  The current minimum baseline is the 12.1.3 Application Technology Stack (  This minimum baseline should remain consistent until October 2019, unless a large number of functional module specific (i.e., GL, AR, AP, etc.) security vulnerabilities are discovered.
  2. For organizations where applying CPU patches is not feasible within 30 days of release or Internet facing self-service modules (i.e., iSupplier, iStore, etc.) are used, AppDefend should be used to provide virtual patching of known, not yet patched web security vulnerabilities and to block common web security vulnerabilities such as SQL injection and cross-site scripting (XSS).
12.2 Recommendations
  1. 12.2 is supported for CPUs through July 2021 as there will be no extended support for 12.2.  The current minimum baseline is 12.2.3 plus roll-up patches R12.AD.C.Delta.7 and R12.TXK.C.Delta.7.  Integrigy anticipates the minimum baseline will creep up as new RUPs (12.2.x) are released for 12.2.  Your planning should anticipate the minimum baseline will be 12.2.4 in 2017 and 12.2.5 in 2019 with the releases of 12.2.6 and 12.2.7.  With the potential release of 12.3, a minimum baseline of 12.2.7 may be required in the future.
  2. For organizations where applying CPU patches is not feasible within 30 days of release or Internet facing self-service modules (i.e., iSupplier, iStore, etc.) are used, AppDefend should be used to provide virtual patching of known, not yet patched web security vulnerabilities and to block common web security vulnerabilities such as SQL injection and cross-site scripting (XSS).
EBS Database Recommendations
  1. As of the October 2015 CPU, the only CPU supported database versions are,, and and CPU support ended as of July 2015.  The final CPU for will be July 2016.
  2. When possible, all EBS environments should be upgraded to or, which are supported for all EBS versions including
  3. If database security patches (SPU or PSU) can not be applied in a timely manner, the only effective mitigating control is to strictly limit direct database access.  In order to restrict database access, Integrigy recommends using the EBS feature Managed SQLNet Access, Oracle Connection Manager, network restrictions and firewall rules, and/or terminal servers and bastion hosts.
  4. Regardless if security patches are regularly applied or not, general database hardening such as changing database passwords, optimizing initialization parameters, and enabling auditing should be done for all EBS databases.
Tags: Oracle E-Business SuiteOracle Critical Patch Updates
Categories: APPS Blogs, Security Blogs

Recover from ORA-01172 & ORA-01151

DBASolved - Tue, 2016-01-19 07:48

This morning I was working on an Oracle Management Repository (OMR) for a test Enterprise Manager that is used by a few consultants I work with. When I logged into the box, I found that the OMR was down. When I went to start the database, I was greeted with ORA-01172 and ORA-01151.

These errors basically say:

ORA-01172 – recovery of thread % stuck at block % of file %
ORA-01151 – use media recovery to recover block, restore backup if needed

So how do I recover from this. The solution is simple, I just needed to perform the following steps:

1. Shutdown the database

SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

2. Mount the database

SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.0033E+10 bytes
Fixed Size 2934696 bytes
Variable Size 1677723736 bytes
Database Buffers 8321499136 bytes
Redo Buffers 30617600 bytes
Database mounted.

3. Recover the database

SQL> recover database;
Media recovery complete.

4. Open the database with “alter database”

SQL> alter database open;
Database altered.

At this point, you should be able to access the database (OMR) and then have the EM environment up and running.


Filed under: Database
Categories: DBA Blogs

Using SKIP LOCKED feature in DB Adapter polling

Darwin IT - Tue, 2016-01-19 04:53
Last few days I spent with describing a Throttle mechanism using the DB Adapter. Today the 'Distributed Polling' functionality of the DB Adapter was mentioned to me, which uses the SKIP LOCKED clausule of the database.

On one of the pages you'll get to check the 'Distributed Polling' option:
Leave it like it is, since it adds the 'SKIP LOCKED' option in the 'FOR UPDATE' clausule.

In my example screendump I set the Database Rows per Transaction, but you might want to set in a sensible higher value with regards to the 'RowsPerPollingInterval' that you need to set yourself in the JCA file:

The 'RowsPerPollingInterval' is not an option in the UI, unfortunately. You might want to set this as a multiple to the MaxTransactionSize (in the UI denoted as 'Database Rows per Transaction').

A great explanation for this functionality is this A-Team blogpost. Unfortunately the link to the documentation about 'SKIP LOCKED' in that post is broken. I found this one. Nice thing is that it suggests using AQ as preferred solution in stead of SKIP LOCKED.

Maybe a better way for throttling is using the AQ Adapter together with the properties

It’s Called Data Analysis And Not Data Synthesis For A Reason

Michael Feldstein - Mon, 2016-01-18 18:31

By Phil HillMore Posts (385)

I’ve never been a big TEDtalks fan, but recently I’ve been exploring some of the episodes, partially based on peer pressure.

@PhilOnEdTech @mfeldstein67 y'all should do a weekly PTI style podcast rundown of the issues raised each week in edtech.

— Glenda Morgan (@morganmundum) January 15, 2016

In the process I ran across a talk from Sebastian Wernicke, who has a bioinformatics background but now seems to specialize in giving talks. The talk in question is “How to use data to make a hit TV show”, which starts by looking at two data approaches to binge TV production – Amazon’s use of data analysis to choose a new show concept, leading to Alpha House, and Netflix’s use of data to look at lots of show components but then to let humans make conclusions and “take a leap of faith”, leading to House of Cards. The anecdotes set up his description of where data fits and where it doesn’t, and this mirrors what Michael and I are seeing in the use the broad application of personalized learning.

We have described in our most recent EdSurge article:

Bottom Line: Personalized learning is not a product you can buy. It is a strategy that good teachers can implement.

While Wernicke is not addressing education, he describes the same underlying issue in memorable way (starting at 8:18 in particular).

Now, personally I’ve seen a lot of this struggle with data myself, because I work in computational genetics, which is also a field where lots of very smart people are using unimaginable amounts of data to make pretty serious decisions like deciding on a cancer therapy or developing a drug. And over the years, I’ve noticed a sort of pattern or kind of rule, if you will, about the difference between successful decision-making with data and unsuccessful decision-making, and I find this a pattern worth sharing, and it goes something like this.

So whenever you’re solving a complex problem, you’re doing essentially two things. The first one is, you take that problem apart into its bits and pieces so that you can deeply analyze those bits and pieces, and then of course you do the second part. You put all of these bits and pieces back together again to come to your conclusion. And sometimes you have to do it over again, but it’s always those two things: taking apart and putting back together again.

And now the crucial thing is that data and data analysis is only good for the first part. Data and data analysis, no matter how powerful, can only help you taking a problem apart and understanding its pieces. It’s not suited to put those pieces back together again and then to come to a conclusion. There’s another tool that can do that, and we all have it, and that tool is the brain. If there’s one thing a brain is good at, it’s taking bits and pieces back together again, even when you have incomplete information, and coming to a good conclusion, especially if it’s the brain of an expert.

And that’s why I believe that Netflix was so successful, because they used data and brains where they belong in the process. They use data to first understand lots of pieces about their audience that they otherwise wouldn’t have been able to understand at that depth, but then the decision to take all these bits and pieces and put them back together again and make a show like “House of Cards,” that was nowhere in the data. Ted Sarandos and his team made that decision to license that show, which also meant, by the way, that they were taking a pretty big personal risk with that decision. And Amazon, on the other hand, they did it the wrong way around. They used data all the way to drive their decision-making, first when they held their competition of TV ideas, then when they selected “Alpha House” to make as a show. Which of course was a very safe decision for them, because they could always point at the data, saying, “This is what the data tells us.” But it didn’t lead to the exceptional results that they were hoping for.

So data is of course a massively useful tool to make better decisions, but I believe that things go wrong when data is starting to drive those decisions. No matter how powerful, data is just a tool . . .

We are not the only people to describe this distinction. Tony Bates’ latest blog post describes a crossroads we face in automation vs. empowerment:

The key question we face is whether online learning should aim to replace teachers and instructors through automation, or whether technology should be used to empower not only teachers but also learners. Of course, the answer will always be a mix of both, but getting the balance right is critical.

What I particularly like about the Wernicke description is that he gets to the difference between analysis (detailed examination of the elements or structure of something, typically as a basis for discussion or interpretation) and synthesis (combination or composition, in particular)[1]. Data is uniquely suited to the former, the human mind is uniquely suited to the latter.

This is not to say that the use of data and analytics can never be used to put information back together, but it is crucial to understand there is a world of difference in data for analysis and data for synthesis. In the world of education, the difference shows up in whether data is used to empower learners and teachers or whether it is used to attempt automation of the learning experience.

  1. Using Google’s definitions.

The post It’s Called Data Analysis And Not Data Synthesis For A Reason appeared first on e-Literate.

CrossFit and Coding: 3 Lessons for Women and Technology

Usable Apps - Mon, 2016-01-18 17:21

Yes, it’s January again. Time to act on that New Year resolution and get into the gym to burn off those holiday excesses. But have you got what it takes to keep going back?

Here’s Sarahi Mireles (@sarahimireles), our User Experience Developer in Oracle’s México Development Center, to tell us about how her CrossFit experience not only challenges the myths about fierce workouts being something only for the guys but about what that lesson can teach us about coding and women in technology too…

Introducing CrossFit: Me Against Myself

Heard about CrossFit? In case you haven’t, it’s an intense fitness program with a mix of weights, cardio, other exercises, and a lot of social media action too about how much we love doing CrossFit.

CrossFit is also a great way to keep fit and to make new friends. Most workouts are so tough that you’re left all covered in sweat, your muscles are on fire, and you feel like it's going to be impossible to even move the next day.

But you keep doing it anyway. 

One of the things I love most about CrossFit is that it is super dynamic. The Workout of the Day (WOD) is a combination of activities, from running outside, gymnastics, weight training, to swimming. You’re never doing the same thing two days in a row. 

Sounds awesome, right? Well, it is!

But some people, particularly women, unfortunately think CrossFit will make them bulk up and they’ll end up with HUGE muscles! A lot of people on the Internet are saying this, and lots of my friends believe it too: CrossFit is really for men and not women. 

From CrossFit to CrossWIT: Women in Techology (WIT)

Just like with CrossFit, there are many young women who also believe that coding is something meant only for men. Seems crazy, but let's be honest, hiring a woman who knows how to code can be a major challenge (my manager can tell you about that!).

So, why aren't women interested in either coding or lifting weights? Or are they? Is popular opinion the truth, that there are some things that women shouldn't do rather than cannot do?

The reality is that CrossFit won't make you bulk up like a bodybuilder, any more than studying those science, technology, engineering or mathematics (STEM) subjects in school won’t make you any less feminine. Women have been getting the wrong messages about gender and technology from the media and from advertising since we were little girls. We grew up believing that intense workout programs, just like learning computer languages, and about engineering, science and math, are “man’s stuff”. And then we wonder where are the women in technology?!

3 Lessons to Challenge Conventions and Change Yourself

So, wether you are interested in these things, or not, I would like to point out 3 key lessons, based on my experience, that I am sure would help you in some stage of your life: 

  1. Don't be afraid of defying those gender stereotypes. You can become whatever you want to be: a successful doctor, a great programmer, or even a CrossFit professional. Go for it!

  2. Choosing to be or to do something different from what others consider “normal” can be hard, but keep doing it! There are talented women in many fields of work who, despite the stereotypes, are awesome professionals, are respected for what they do, and have become key parts of their organizations and companies. Coding is a world largely dominated by men now, with 70% of the jobs taken by males, but that does not stop us from challenging and changing things so that diversity makes the tech industry a better place for everyone

  3. If you are interested in coding, computer science, or technology in general, keep up with your passion by learning more from others by reading the latest tech blogs, for example. If you don't know where to start, here are some great examples to inspire you: our own VoX, Usable Apps, and AppsLab blogs. Read up about the Oracle Women in Technology (WIT) program too.

I'm sure you'll find something of interest in the work Oracle does and you can use our resources to pursue your interests in a career in technology! And who knows? Maybe you can join us at an Oracle Applications User Experience event in the future. We would love to see you there and meet you in person.

I think you will like what you can become! Just like the gym, don’t wait until next January to start.

Related Links

Seven Days with the Xiaomi Mi Band: A Model of Simple Wearable Tech UX for Business

Oracle AppsLab - Mon, 2016-01-18 02:47

Worn Out With Wearables

That well-worn maxim about keeping it simple, stupid (KISS) now applies as much to wearable tech (see what I did there?) user experience as it does to mobile or web apps.

The challenge is to keep on keeping “it” simple as product managers and nervous C-types push for more bells and whistles in a wearable tech market going ballistic. Simplicity is a relative term in the fast changing world of technology. Thankfully, the Xiaomi Mi Band has been kept simple and the UX relates to me.


The Mi Band worn alongside Apple Watch (42mm version) for size.

I first heard about the Mi Band with a heads-up from OAUX AppsLab chief Jake Kuramoto (@jkuramot) last summer. It took me nearly six months to figure out a way to order this Chinese device in Europe: When it turned in up Amazon UK.


We both heard about the Mi from longtime Friend of the ‘Lab, Matt Topper (@topperge).

I’ve become jaded with the current deluge of wearable tech and the BS washing over it. Trying to make sense of wearable tech now makes my head hurt. The world and its mother are doing smartwatches and fitness trackers. Smartglasses are coming back. Add the wellness belts, selfie translators that can get you a date or get you arrested, and ingestibles into the mix; well it’s all too much to digest. There are signals the market is becoming tired too, as the launch of the Fitbit Blaze may indicate.

 Mi Band (All app images are on iOS)

On a winning streak: Mi Band (All app images are on iOS)

But after 7 days of wearing the Mi Band, I have to say: I like it.

Mi User Experience Es Tu User Experience

My Mi Band came in a neat little box, complete with Chinese language instructions.

 A big UX emerges.

Inside the little box: A big UX emerges.

Setup was straightforward. I figured out that the QR code in the little booklet was my gateway to installing the parent App (iOS and Android are supported) on my iPhone and creating an account. Account verification requires an SMS text code to be sent and entered. This made me wonder where my data was stored and its security. Whatever.

I entered the typical body data to get the Mi Band setup for recording my activity (by way of steps) and sleep automatically, reporting progress on the mobile app or by glance at the LEDs on the sensor (itself somewhat underwhelming in appearance. This ain’t no Swarovski Misfit Shine).


Enter your personal data. Be honest.

Metric, Imperial, and Jin locale units are supported.

Metric, Imperial, and Jin locale units are supported.

I charged up the sensor using yet another unique USB cable to add to my ever-growing pile of Kabelsalat, slipped the sensor into the little bracelet (black only, boo!), and began the tracking of step, sleep and weight progress (the latter requires the user to enter data manually).

steps_1 steps_2 sleep_1 sleep_2 weight_1 weight_2

I was impressed by simplicity of operation that was balanced by attention to detail and a friendly style of UX. The range of locale settings, the quality of the visualizations, and the very tone of the communications (telling me I was on a “streak”) was something I did not expect from a Chinese device. But then Xiaomi is one of the world’s biggest wearable tech players, so shame on me, I guess.

fitbit_v_mi_2 AppleHealth

The data recorded seemed to be fairly accurate. The step count seemed to be a little high for my kind of exertion and my sleep stats seemed reasonable. The Mi Band is not for the 100 miles-a-week runners like me or serious quantified self types who will stick with Garmin, Suunto, Basis, and good old Microsoft Excel.

fitbit_v_mi_1 fitbit_v_mi_2

For a more in-depth view of my activity stats, I connected the Mi Band to Apple Health and liked what I saw on my iPhone (Google Fit is also supported). And of course, the Mi Band app is now enabled for social. You can share those bragging rights like the rest of them.

But, you guessed it. I hated the color of the wristband. Only black was available, despite Xiaomi illustrations showing other colors. WTF? I retaliated by ordering a Hello Kitty version from a third party.

The Mi Band seems ideal for the casual to committed fitness type and budding gym bunnies embarking on New Year resolutions to improve their fitness and need the encouragement to keep going. At a cost of about 15 US dollars, the Mi Band takes some beating. Its most easily compared with the Fitbit Flex, and that costs a lot more.

Beyond Getting Up To Your Own Devices

I continue to enjoy the simple, glanceable UX and reporting of my Mi Band. It seems to me that its low price is hinting at an emergent business model that is tailor-made for the cloud: Make the devices cheap or even free, and use the data in the cloud for whatever personal or enterprise objectives are needed. That leaves the fanatics and fanbois to their more expensive and complex choices and to, well, get up to their own devices.

So, for most, keeping things simple wins out again. But the question remains: how can tech players keep on keeping it simple?

Mi Band Review at a Glance


  • Simplicity
  • Price
  • Crafted, personal UX
  • Mobile app visualizations and Apple and Google integration


  • Lack of colored bands
  • Personal data security
  • Unique USB charging cable
  • Underwhelming #fashtech experience

Your thoughts are welcome in the comments.Possibly Related Posts:

Video: Oracle Linux Virtual Machine (VM) on Micorosft Azure

Tim Hall - Mon, 2016-01-18 02:17

The interface for Microsoft Azure has been re-jigged since I last did screen shots, so I did a run through of creating an Oracle Linux VM and recorded it for my channel.

I also updated the associated article.



Video: Oracle Linux Virtual Machine (VM) on Micorosft Azure was first posted on January 18, 2016 at 9:17 am.
©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.