Skip navigation.

Feed aggregator

Which version of Oracle Linux should I pick for Oracle server product installations?

Tim Hall - Tue, 2015-11-10 10:38

linux-tuxOracle certifies many of their latest products for installation on Oracle Linux 6 and 7, so I guess the obvious question is, which should you pick?

I tend to have a dual approach to this. I always use the latest versions of everything for my play kit, but I tend to be a little conservative for production deployments, preferring to use the OS version the product was developed against. I’ve noticed Oracle Cloud and some VM templates are still using Oracle Linux 6, which makes me think Oracle are being a little conservative too.

We were lucky enough to get some time with Wim Coekaerts during the ACE Director briefing at Oracle OpenWorld 2015. During Wim’s session I asked this very question and (to paraphrase his response) he said, the products are written on Oracle Linux 6, so that’s a safe bet. The products are certified and supported on Oracle Linux 7, so you are fine to choose that, but it doesn’t really matter if you prefer to stick with Oracle Linux 6.

You might be asking yourself, why would I stick with such an old distribution? If you are using Oracle Linux you should be using Oracle’s kernel (currently UEK3), so even if the main distribution is older, you are still getting the latest and greatest kernel updates. This is very different to RHEL, where the kernel functionality is essentially fixed when the distribution is released, then just patched for critical updates. For a database or application server, the kernel is the important thing. You’re not bothered about having the latest version of Firefox on the server. :)

Oracle Linux 6 is supported until 2021, so there is no hurry to get rid of it any time soon. If you are doing new installations, the likelihood is your hardware replacement cycle will kick in before Oracle Linux 6 is out of date. If virtualized, you will probably rebuild your VMs as part of your application software updates within this time-scale also. :)

So in conclusion, don’t be afraid to make the jump to Oracle Linux 7, but equally, don’t be afraid to stick with Oracle Linux 6… Neither choice is a bad one in this case.



PS. For non-Oracle installations, there may be other more pressing reasons to jump to version 7. I’ve intentionally avoided mentioning systemd and firewalld. I don’t have time for that war. :)

Which version of Oracle Linux should I pick for Oracle server product installations? was first posted on November 10, 2015 at 5:38 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.

Not an Oracle Partner? Join Oracle Partner Network now For Free!

If you are an IT Company, Independent Software Vendor or even a Digital Agency and you are not an Oracle Partner yet, don't miss this chance and join Oracle Partner Network with no membership fee for...

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

Asking What Students Spend On Textbooks Is Very Important, But Insufficient

Michael Feldstein - Tue, 2015-11-10 08:37

By Phil HillMore Posts (378)

Mike Caulfield responded to my post on data usage to understand college textbook expenditures. The core of my argument is a critique of commonly cited College Board data. That data originating from financial aid offices leads to the conclusion that students on average either spend or budget $1,200 per year with that number rising, while there is more reliable data originating from students showing the number to be half that amount and dropping.

In Mike’s response post yesterday, he generally agreed with the observation but is concerned that “readers of that piece are likely to take away the wrong conclusion from Phil’s figures (even if Phil himself does not)”. There is a risk that people see the lower numbers and conclude the “crisis is overblown”, leading to this observation:

If we’re looking to find out if prices for some set of goods are too high, then by definition we cannot look at what people are spending as a reliable gauge, because one of the big effects of “prices too high” is that people can’t afford what they need.

If you don’t pay attention to this you get in all sorts of tautologies.

In the specific world of textbooks, Mike considers the lower-cost method of renting used textbooks, noting:

So which figure do we use here? The chances of getting everything you need as a rental are low. Sure, you could be the super-prepared student who knows how to work the system and get them *all* as rentals — but not every student can be first in line at the bookstore. And the ones at the back of the line — guess their socio-economic class and first generation status?

This is an important issue, and I appreciate Mike’s understanding that I am not arguing that college textbook pricing is an overblown crisis. I agree that the crisis is real and that the hardest-hit are likely low socio-economic class and first generation students.

But let’s move past these agreements and drop the gloves.

I do not believe that we are solely “looking to find out if prices for some set of goods are too high”. What we need is a richer picture understanding both prices and expenditures. This past spring on the same College Board data subject I wrote:

It is important to look at both types of data – textbook list prices and student expenditures – to see some of the important market dynamics at play. All in all, students are exercising their market power to keep their expenditures down – buying used, renting, borrowing, obtaining illegally, delaying purchase, or just not using at all. And textbook publishers are suffering, despite (or largely because of) their rising prices.

But there are downsides for students. There are increasing number of students just not using their required course materials, and students often delay purchase until well into the academic term. Whether from perceived need or from rising prices, this is not a good situation for student retention and learning.

This is not too far from Mike’s parable of the Perdimians and the concept of a food (or textbook) deficit. The richer picture should include some measurement of what is needed (the bag of textbooks) and what is spent (the expenditures) and if there are gaps. If we want to use College Board data to understand pricing, however, then we will need better guidance from the Education Department on what to include and not include (for consistency) and we need the data broken down by student demographics. The data right now is fundamentally flawed.

On the subject of impacts of pricing, Kim Thanos from Lumen Learning pointed out a Florida report from 2012 that asked students about this deficit. The findings:

Florida Table 6

That’s a high percentage of students avoiding textbooks, avoid or dropping courses, and performing poorly due to costs. And this type of data is only available by asking students.

But overall, I suspect Mike and I are on the same page in terms of concerns – the crisis is real, we need pricing and expenditures, and poor or first-gen students might not have access to the same cost cutting measures. On that note, if you accept 2-year vs. 4-year schools as a proxy for the measure of poor / first-generation students, the NACS data backs up Mike’s point. 2-year students are far less likely to go get course materials for free.

Acquisition by sector


As part of his argument, Mike looked at “first year suggested schedule for a math education major” and looked up bookstore list pricing and rental of used textbooks for those courses over a year.

  • One year of new textbooks: $1430.68
  • One year of rentals (mostly): $712.46
  • Mix, half rentals, half new: $1071.57

Getting back to the College Board usage of $1,225 for books and supplies and using the mix of half rentals, half new, Mike observes:

What I think you’ll find out is that although there is a lot of variability in the cost of textbooks for a year in different degrees, the College Board estimate is much closer  to estimating what students actually need than other measures offered.

Yes, $1,225 is closer to $1,072 than is the NACS and Student Monitor figures of $530 – $640. But the benefit of asking students for data and not relying on financial aid self-reporting is that the data is already far richer than the headlines. First-year students spend much more than others, as seen in the 2014 NACS report:

Highest lowest spending

It turns out that $1,019 is very close to Mike’s number of $1,072.

We need data on both pricing of required course materials (including local substitutes) and expenditures by students. The poor / first-generation problem should be addressed by better data from students – cross-tabs on student expenditures and asking them the impacts of pricing in particular – rather than falling back to College Board usage of financial aid office reporting.

Asking students how much they spend on college textbooks is an excellent question, but it is insufficient.

Thanks to Mike for extending this conversation and adding in the challenge of poor / first-generation students.

The post Asking What Students Spend On Textbooks Is Very Important, But Insufficient appeared first on e-Literate.

Refreshing PL/SQL Regions in APEX

Scott Spendolini - Tue, 2015-11-10 08:03

If you've been using APEX long enough, you've probably used a PL/SQL Region to render some sort of HTML that the APEX built-in components simply can't handle. Perhaps a complex chart or region that has a lot of custom content and/or layout. While best practices may be to use an APEX component, or if not, build a plugin, we all know that sometimes reality doesn't give us that kind of time or flexibility.

While the PL/SQL Region is quite powerful, it still lacks a key feature: the ability to be refreshed by a Dynamic Action. This is true even in APEX 5. Fortunately, there's a simple workaround that only requires a small change to your code: change your procedure to a function and call it from a Classic Report region.

In changing your procedure to a function, you'll likely only need to make one type of change: converting and htp.prn calls to instead populate and return a variable at the end of the function. Most, if not all of the rest of the code can remain untouched.

Here's a very simple example:


PROCEDURE print_region
(p_item IN VARCHAR2)
htp.prn('This is the value: ' || p_item);


FUNCTION print_region
(p_item IN VARCHAR2)
l_html VARCHAR2(100);
l_html := 'This is the value: ' || p_item;
RETURN l_html;

On the APEX side, simply create a Classic Report and set the query to something like this that refers to your function:

SELECT package_name.function_name(p_item => :P1_ITEM) result FROM dual
You'll then want to edit the Attributes of the Classic Report and turn off Pagination, set the Headings type to None and ensure Partial Page Refresh is enabled. Next, click on the Template Options and Disable Alternating Rows and Row Highlighting and then check Stretch Report.

2015 11 10 08 56 05

Make any other UI tweaks that you need, and you should now have a Dynamic PL/SQL Region that can be refreshed in a Dynamic Action.

Links for 2015-11-09 []

Categories: DBA Blogs

APEX 5 Cheat Sheet

Scott Spendolini - Mon, 2015-11-09 21:18
On Twitter today, Jeff Smith tweeted about a new SQL Developer cheat sheet that he created with a site called
Not to be outdone, I created a cheat sheet for the APEX 5 Keyboard Shortcuts. Not only can you view it online, but you can also download a PDF version of it. Check it out and let me know if there's anything that you'd like to see added.

IBM Bluemix Admin Console Command Line (CLI) Installation

Pas Apicella - Mon, 2015-11-09 20:32
The IBM Bluemix Dedicated/Local Administration Console also includes support for CLI to enable common management tasks to be performed using the Cloud Foundry Command Line by adding a plugin to enable support for it's commands.

Note: The Bluemix Admin CLI plugin requires version 6.11.2 or later.

Admin Console UI

Admin Console - Installing Command Line

The CLI to the admin console is installed as follows. The reference to this is found in your own Dedicated/Local install via a link as follows with "cli" appended to the Admin Console URL

pasapicella@pas-macbookpro:~$ cf add-plugin-repo BluemixAdmin
OK added as 'BluemixAdmin'
pasapicella@pas-macbook-pro:~$ cf install-plugin bluemix-admin-cli -r BluemixAdmin Looking up 'bluemix-admin-cli' from repository 'BluemixAdmin' 8889440 bytes downloaded... Installing plugin /var/folders/rj/5r89y5nd6pd4c9hwkbvdp_1w0000gn/T/bluemix-admin... OK Plugin BluemixAdminCLI v0.0.1 successfully installed. pasapicella@pas-macbook-pro:~$ cf plugins Listing Installed Plugins... OK
Finally target admin API endpoint:
pasapicella@pas-macbook-pro:~$ cf baa The API endpoint has been updated to ''
At this point you can now run Admin Console commands as follows. To get help issue "cf {command} --help" The current supported commands are as follows: bluemix-admin-api, baa                              
bluemix-admin-add-user, baau                        
bluemix-admin-remove-user, baru                     
bluemix-admin-set-organization, baso                
bluemix-admin-unset-organization, bauo              
bluemix-admin-set-quota, basq                       
bluemix-admin-add-report, baar                      
bluemix-admin-delete-report, badr                   
bluemix-admin-retrieve-report, barr                 
bluemix-admin-enable-service-plan, baesp            
bluemix-admin-disable-service-plan, badsp           
bluemix-admin-add-service-plan-visibility, baaspv   
bluemix-admin-remove-service-plan-visibility, barspv
bluemix-admin-edit-service-plan-visibilites, baespv 
bluemix-admin-set-region-access, basra              
bluemix-admin-create-organization, baco             
bluemix-admin-delete-organization, bado
Categories: Fusion Middleware

Western Canada Regional Users Group 2015

Jim Marion - Mon, 2015-11-09 17:29

I will be in Calgary next week presenting PeopleTools topics at the Western Canada Regional Users Group meeting. My sessions are at 1 PM and 2:15 PM. See you there!

The SaaS Race

Floyd Teter - Mon, 2015-11-09 13:12
So I've been back at Oracle for about a month now.  I'd say the biggest change so far is my perspective on trends in SaaS and Cloud.  Prior to gaining that perspective from the inside, I really did not have a full appreciation for just how early in the game we are.  Not just Oracle, but everybody.

During my undergrad days, when remote learning was done with smoke signals (no Internet yet), I remember learning about Bruce Henderson's Growth-Share Matrix:

Cash Cows have high market share in a low growth industry.  Dogs have low market share in a slow-growth, mature industry.  Question Marks have low market share in a fast growing industry (this is where most companies start).  And Stars have high market share in a fast growing industry.

So apply those definitions in the SaaS market.  The market itself is fast-growing, so by definition we don't have any Cash Cows or Dogs.  But I'd also say that we don't have any SaaS providers with high market share's a pretty competitive market at the moment in terms of market share.  So, by process of elimination, all the providers are still Question Marks - relatively recent entries in a fast growing market, but none of those entries have achieved a dominant market share yet...mostly because the market itself is still now.

With that in mind, I read a lot of hooey in the press:  so-and-so will dominate/collapse/rise/die/excel/be eliminated...whatever the latest news cycle dictates.  Take all that stuff with a grain of salt...we're very, very early in what promises to be a very long race for market share with many players who have the resources to see the race through to the end.  We're just getting started.

Fedora 23 and Oracle 11gR2/12cR1

Tim Hall - Mon, 2015-11-09 12:32

A few months ago I mentioned doing some Fedora 22 installations. At the time I did some pre-emptive installations on the Alpha release of Fedora 23 also.

Now the final release of Fedora 23 is out, I’ve run through the articles again to make sure things are all ship-shape.

It’s pretty much as it was before, with the nice bonus that the “MATE Desktop” package group has been fixed. Happy days! :)

As always, installations of Oracle server products on Fedora are not a great idea, as explained here.

If you do like playing with this stuff, knock yourself out… :)



Fedora 23 and Oracle 11gR2/12cR1 was first posted on November 9, 2015 at 7:32 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.

The Eternal Newbie

Tim Hall - Mon, 2015-11-09 11:56

It’s been over a decade since I first heard Tom Kyte talking about Project Marvel, which eventually became Application Express (APEX). Since then I’ve “used” just about every version of APEX. I use the term “used” very loosely, because I typically use APEX for a few days to get a job done, then never touch it again for months. By the time I come back, I pretty much have to start the learning process from the beginning again.

This is a perfect example of the “Eternal Newbie”. I could quite legitimately put 10+ years experience of APEX (including previous names) on my CV and it wouldn’t be a lie, but in reality I’m only about as good as any PL/SQL developer that’s been playing with APEX for a week.

It’s not that APEX is difficult, quite the contrary, but the process of getting good at anything takes time and repetition. You’ve probably heard the variations on “10,000 hours to become an expert” saying. It doesn’t matter that it’s not true or accurate. What matters is it highlights the need for time, repetition and constantly striving to improve. A little plodding once in a while does not count for experience in my book.

As an example of this, on Friday I was trying to get something to work with a Shuttle control in APEX 5.0.2. I found a couple of great examples on Dmitri‘s and Denes blogs, which (I thought) got me 90% of the way to what I wanted to achieve, but the last 10% took me half of Friday, then the whole of Saturday evening. If I was actually any good at this stuff it would have probably taken me 2 mins. What’s more, if I was good, I would have probably realised Dmitri and Denes’ examples actually got me to 99.9% of what I was trying to achieve, but my inexperience meant I kept shooting myself in the foot. After all that time playing and reading, I felt like a master of Shuttle controls in APEX, but if I don’t look at APEX for a week I’m going to be totally screwed. I have some knowledge now, but it will take repetition to make it stick, and based on past experience, that’s not going to happen. :)

I did a video a few months ago about the term “Senior” in relation to IT jobs. My recent fumblings with APEX made me think about this subject again.

With my 10+ years of APEX experience, I’m obviously a “Senior APEX Developer”. Just remind me, how do I alter a breadcrumb? :)



The Eternal Newbie was first posted on November 9, 2015 at 6:56 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.

Oracle E-Business Suite – R12.2 Post Install checks (HTTP, Help Page, Login Page, JSP) got failed

Online Apps DBA - Mon, 2015-11-09 08:41

This post is from our Oracle Apps DBA (R12.2) Training for E-Business Suite  (In which we cover Architecture, Installation, File System, WebLogic Concepts, Patching, Cloning , Common Tasks and difference in 12.2 from previous version, Register here for Oracle Apps DBA 12.2 Training )

One of the trainee from our current batch, having an issue in Oracle E-Business Suite R12.2 (EBS) installation where some of the post-install checks (Help Page, Login Page, JSP, HTTP, Virtual Directory) was failed as shown below:


Click on X symbol, to know the error message for the issue as here I clicked on  X symbol beside HTTP and it display, below window with error message


After that I checked in EBS Installation logs /u01/oracle/PROD/fs1/inst/apps/PROD_iamdemo07/logs/08261229.log for the root cause of the issue and below are the error messages:

RW-50015: Error: – Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.



checking URL = http://<hostname>:8088/OA_HTML/jtfTestCookie.jsp

RW-50015: Error: – JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Login Page


RW-50015: Error: – Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

WLS Domain Validation


EBS Domain validation failed for RUN filesystem.


Check Domain deployment logs and re-deploy the RUN domain.


Log file at : /u01/oracle/PRD12288/fs1/EBSapps/appl/admin/PROD_iamdemo07/log .


EBS Domain validation failed for PATCH filesystem.


Check Domain deployment logs and re-deploy the PATCH domain.

Log file at : /u01/oracle/PRD12288/fs2/EBSapps/appl/admin/PROD_iamdemo07/log .

Connecting AdminServer


Connecting to t3://<hostname>:7090 with userid weblogic …

This Exception occurred at Thu Aug 27 05:03:07 BST 2015.

javax.naming.CommunicationException [Root exception is t3://<hostname>:7090: Destination unreachable; nested exception is: Connection refused; No available router to destination]

Error while connecting Admin Server !!!

Exiting WebLogic Scripting Tool.

.end std out.

.end err out.

ERROR: Unable to add the loggers for oacore application

ERROR: Failed to create the EBS domain.

Failed to deploy the E-Business Suite domain

 Then I came to know that EBS domain was not created and deployed successfully and When  I checked on AdminServer log file /u01/oracle/PROD55/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD55/servers/AdminServer/logs

It was showing below error message:

Caused By: /tmp/.ovdlock.tmp (Permission denied)
at Method)
at oracle.ods.virtualization.config.ConfigureAdapters.configure(








Fix for this issue:

1. As /tmp/.ovdlock.tmp was not having permission Installation failed. So we have change the permission to 777 with below command:

chmod -R 777 /tmp/.ovdlock.tmp

2. Another is to run the script which is located under $AD_TOP/patch/115/bin and delete failed EBS domain as

perl ebs-delete-tech -contextfile=/u01/oracle/PROD55/fs1/inst/apps/PROD55_iamdemo07/

appl/admin/PROD55_iamdemo07.xml -techtype=wls

3. Then again run the script which is located under $AD_TOP/patch/115/bin on both file system (RUN and Patch) and Create EBS domain as

a) Run script on RUN file system (fs1)

perl ebs-deploy-alltech -contextfile=/u01/oracle/PROD55/fs1/inst/apps/PROD55_iamdemo07/appl/


You should see below output:

NMProcess: <Aug 19, 2015 2:22:57 PM> <INFO> <EBS_domain_PROD55> <AdminServer> <Rotated server output log to “/u01/oracle/PROD55/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD55/

NMProcess: Aug 19, 2015 2:22:57 PM weblogic.nodemanager.server.LogFileRotationUtil log
NMProcess: INFO: Rotated server output log to “/u01/oracle/PROD55/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD55/

NMProcess: <Aug 19, 2015 2:22:57 PM> <INFO> <EBS_domain_PROD55> <AdminServer> <Server error log also redirected to server log>
NMProcess: Aug 19, 2015 2:22:57 PM weblogic.nodemanager.server.LogFileRotationUtil log
NMProcess: INFO: Server error log also redirected to server log
NMProcess: <Aug 19, 2015 2:22:57 PM> <INFO> <EBS_domain_PROD55> <AdminServer> <Server output log file is ‘/u01/oracle/PROD55/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD55/servers/AdminServer/logs/AdminServer.out’>
NMProcess: Aug 19, 2015 2:22:57 PM weblogic.nodemanager.server.AbstractServerManager log
NMProcess: INFO: Server output log file is ‘/u01/oracle/PROD55/fs1/FMW_Home/user_projects/domains/

Creation and deployment of E-Business Suite domain completed..
<Aug 19, 2015 2:30:18 PM BST> <Warning> <JNDI> <BEA-050001> <WLContext.close() was called in a different thread than the one in which it was created.>

b) Run script on Patch file system (fs2)

perl ebs-deploy-alltech -contextfile=/u01/oracle/PROD55/fs2/inst/apps/PROD55_iamdemo07/appl/


4. Start All EBS services as


./ <apps_username>/<apps_password>

You should see below output:

All enabled services for this node are started. Exiting with status 0 check the logfile /u01/oracle/PROD55/fs1/inst/apps/PROD55_iamdemo07/logs/appl/admin/log/adstrtal.log for more information …

This will create complete domain and managed servers.

After that, clicked on Retry button and all Post Install checks passed but one post install check “WLS Domain Validation” have warning message so we can ignore this and proceed further without having any issue as EBS Domain was successfully completed.


Now Oracle E-Business Suite R12.2 Installation completed successfully.

Access the EBS URL: http://hostname:port

If you want to learn more about Oracle Apps DBA (Architecture, Installation, WebLogic, Patching, Cloning and other maintenance tasks with the upgrade of Oracle E-Business Suite 12.2.0 to 12.2.4) then have a look at our Oracle Apps DBA (R12.2) Training.

Note: We are so confident on our workshops that we provide 100% Money back guarantee, 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 (or ask us from our 100s of happy trainees in our private Facebook Group)

The post Oracle E-Business Suite – R12.2 Post Install checks (HTTP, Help Page, Login Page, JSP) got failed appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Basic OBIEE Enumeration Checklist

Several clients and partners have asked for this checklist lately. Posting it for those who may find it useful:

  1. If possible ask for the following:
    1. System diagram
    2. All URLs – WebLogic, Enterprise Manager and OBIEE
    3. Ask about load balancer and reverse proxy
    4. WebLogic accounts and passwords for both /EM and /Console
    5. TNSNAMES info and DB accounts and passwords for WebLogic repository database
    6. Ideally O/S accounts and passwords for server supporting WebLogic – will need for WLST scripts
    7. Request copy of config.xml file for each environment. If o/s accounts are surrendered these can be easily obtained.
  2. Network probe
    1. NMAP scan for WebLogic and OBIEE ports 7001, 9701 and 9703. Suggest scanning 9700 – 9710. Also NMAP scan for Oracle networking 1521 (default).  Suggest scanning 1520-1530
    2. Check WebLogic and OBIEE specific URLs. For public facing, use Google. For internal construct URLs using information gathered from NMAP:



Administration Server Console


Enterprise Manager Console


Enterprise Manager Agent


Oracle Portal


Oracle Forms


Oracle Reports


Oracle Discoverer Viewer



If external Google: intitle:"WebLogic Server" intitle:"Console Login" inurl:console –


Look for: analytics/saw.dll

e.g. if external Google: Inurl: analytics/saw.dll –


  1. Inventory the databases associated with WebLogic. Issue the following from the repository databases:
  2. Read and analyze the primary WebLogic configurations. The primary config file is the /domains/DOMAIN_NAME/config/config.xml 
  3. Get server information, suggest running WLST scripts for – Google several good examples: ‘wlst script list servers and information’
  4. Get WebLogic user information, suggest running WLST scripts for – Google several good examples: ‘wlst script list users’
  5. For OBIEE authentication will first be done by WebLogic. WebLogic will determine who can access OBIEE. WebLogic groups may or may not then drive authorization. Older OBIEE solutions also might internally authenticate within the repository (RDP).  Overall security authorization within OBIEE can be at control at various levels; Catalog/Presentation, RPD and within the data sources or a combination of everything. There can also be no security/authorization e.g. authentication by WebLogic to use OBIEE and then handoff to a PUBLIC / generic OBIEE report.
Tags: Oracle Fusion MiddlewareOracle Business Intelligence (OBIEE)
Categories: APPS Blogs, Security Blogs

Don't Miss Tomorrow's Webcast on Cloud Services featuring Customer Mythics

WebCenter Team - Mon, 2015-11-09 08:08

Don't miss this great opportunity to not only hear from Oracle executive, David Le Strat on Oracle Cloud Services strategy for self-service, collaboration and engagement but also directly from our customer, Mythics on how leveraging Oracle Process Cloud and Oracle Documents Cloud together is a much stronger value proposition to drive business agility and process innovation.

Register today for the webcast and you will also get an opportunity to ask questions live to our executives and experts at hand.

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Live Webcast: 3 Ways to Power Digital Workplace Collaboration and Mobility
Tuesday, November 10, 2015
10 am PT/ 1 pm ET

Note that the same link will host the on demand replay of the webcast within a day or two.

WEBCAST: Three Ways to Power Digital Workplace Collaboration and Mobility a:link { color: #1f4f82; } a:visited { color: #1f4f82; } a:hover { color: #1f4f82; } a:active { color: #1f4f82; } table, th, td { border-color: #c0c0c0 !important; } #bold{ font-weight:bold; } #SpeakerImg{ border: 1px solid #c0c0c0 ; padding: 2px; } #connectionBox{ border: 1px #c0c0c0 solid; width: 178px; margin: 0px auto 0px auto; } .footerLinks{ color: #FF0000 !important; font-size: 10px; font-style: Arial, Helvetica, sans-serif; } #agenda{ border-color: #CCCCCC; border-style: solid; border-width: 1px 0px 0px 0px; } #bodyTable{ border-right: 1px solid; border-left: 1px solid; border-top: 1px solid; border-bottom: 1px solid; } #headerLogo{ padding-left: 21px; } #headerImg{ display: block; }

Oracle Corporation  Three Ways to Power Digital Workplace Collaboration and Mobility Cloud Engagement beyond Simple File Sharing

A recent study showed that over a year, organizations with enterprise social collaboration saw a 96% improvement in customer response times. 96%! And with the mobile workforce reaching 1.3 billion this year, it is no wonder that organizations are looking differently at user engagement today.

Join this webcast to find out how Oracle is addressing the critical need for social- and mobile-enabled cloud engagement, and hear directly from Mythics on how the company is leveraging Oracle Cloud Services to drive workplace collaboration, streamline contracts management and accelerate business value. Learn how your organization can drive speed to market and improve mobility and productivity for Marketing, Sales, HR, Operations and Customer Experience.

You will learn about:
  • Oracle's strategy, vision and comprehensive solution to address the market need
  • Mythics' business automation and collaboration use cases and cloud strategy
  • A roadmap to driving business innovation, mobility and productivity with cloud engagement

Register Now for this webcast.

Red Button Top Register Now Red Button Bottom Live Webcast Calendar November 10, 2015
10:00 AM PT
/ 1:00 PM ET
Brent Seaman Brent Seaman,
Vice President Cloud Solutions
Mythics, Inc.
David Le Strat David Le Strat,
Senior Director Product Management,
WebCenter and Business Process Management
Oracle Integrated Cloud Applications and Platform Services Copyright © 2015, Oracle Corporation and/or its affiliates.
All rights reserved.
Contact Us | Legal Notices and Terms of Use | Privacy Statement

/* 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-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-family:"Calibri","sans-serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi- mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

A Smart Badge for a Smart Office

Oracle AppsLab - Mon, 2015-11-09 02:53

Editor’s note: Maybe you got a chance to check out our IoT Smart Office demo at the OAUX Exchange during OpenWorld. If not, don’t fret, we’ll describe its many cool bits here, beginning with this post from Raymond (@yuhuaxie) on his smart badge build. A Smart Office needs an equally smart badge.

We showcased the Smart Office at OAUX Exchange.

You put on a badge and walked into an office in the future, and everything came alive. You may be dazzled by the lights, screens, voice commands and gesture, and may not have paid any attention to the badge. Well, the badge is the key to start all the magical things when you approach the office. And it is worth some mention of its build.

The classical version:

If you tried it at the Exchange event, you can feel it is just like a normal badge, except it is a little heavier and has a vivid display.

Inside that home-made leather pouch, there is a 3.5” TFT display, a large recycled LiPo battery (taken out of a thin power bank we got at Kscope15), and one controller called LightBlue Bean (@punchthrough), which happened to be the same controller inside “Smart Bracelet” we showcased a year earlier to light up different colors to guide you an expo path.

The Smart Badge needs to be programmable and to tell its presence, so that we can program it to be a particular persona, and it can indicate to other listener (a Raspberry Pi server acting as IoT brain) about its presence or approaching to Smart Office.

The LightBlue Bean does the job perfectly, as it has two personalities: BLE and Arduino compatible controller. We created an iOS app to talk to the Bean over Bluetooth to set up persona, and the Arduino side of Bean would control the TFT display to show proper badge image.


The Smart Badge

When the person wearing the Smart Badge approaches the office, the Raspberry Pi server would detect its coming, and can send out a remote notification to iPhone and Apple Watch, so that you can “check in” to the office from an Apple Watch, and then start the whole sequence of Smart Office coming alive.

At the OAUX Exchange event, due to limited space issue, we did not use BLE presence detection we built, but instead, we used a time-delay mechanism to send out notification to Apple Watch.


Inside the Smart Badge

For those curious minds, we prepared another version, to show the components inside the Smart Badge. I would call it . . .

The techno version:

Instead of stacking up the components, we spread the components so people can see the parts and wiring. We designed and laser-cut acrylic sheets to make a transparent case, and it resembles the typical laminated badge you see at conferences.

As you can see, the wiring between the Bean and TFT is pretty much for the display control over SPI protocol, plus one wire to access SD card inside TFT display board, and another wire to control the backlight. The BLE part is all over wireless.



By the way, we made another version using ESP8266 (NodeMCU) instead of the Bean, because we just love the little ESP8266.

We connected the TFT display with NodeMCU over hardware SPI, and similar approach for access SD card and backlight control. Since NodeMCU has so many more pins available (some PWM pins too), we can actually control the backlight to dim at many brightness level, instead of just turning on and off, as in the Bean case.

The NodeMCU is flushed as an Arduino variant, and set up as a web server with its built-in wifi capability. The iOS app mentioned earlier can program this Smart Badge using HTTP request over wifi. In fact, it can be programmed using any browser or CLI, without the need of tethering to iPhone.

NodeMCU is such a recent toy on the block, that it takes some time to get it work with TFT display. For example, the image just does not look right when controlled by NodeMCU. After some perseverance, it was straightened out.


The card version:

We were considering making the Smart Badge as small as possible. This design was to make it just a bit larger than the TFT display, by stacking NodeMCU behind TFT, and use a tiny proto-board to neatly wire everything. It is about the size of a deck of card, hosted in a transparent acrylic case.

Figured that it does not look like a badge, but it is a nice little display hooked on the Internet, that can sit on a desktop. So I decided to fit in a 3 x AAA everyday battery, instead of the LiPo battery which usually use JST connector and is a hassle to recharge.



Currently, this version can show a badge, also do some slide shows. But it can do much more – with NodeMCU (ESP8266), it is a web server that can listen for instructions, it is web client to pull information from outside, it runs MQTT to react to outside events, and it has many pins to hook up sensors and controllers. Plus that the TFT is a touch display, we can make touch input to switch to different modes, etc.

It could be a real functional Smart Office monitor/notification center.

I guess this is just the starting point of a little toy.Possibly Related Posts:

Oracle Live SQL

Oracle recently introduced a new generation online SQL tool, called Live SQL. Live SQL is a kind of search engine for database developers but also a great free learning tool for those...

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

Wrong Results

Jonathan Lewis - Mon, 2015-11-09 00:23

Here’s a little gem in 12c that arrived in my email a few days ago: a query where the result depends on the SQL*Plus arraysize!

The email had a short description, and a script to create a small data set that would demonstrate the problem. I’m not going to show you the query, or the result set, but here’s a sample of the output from an SQL*Plus session after creating the data. This is, by the way, on a “single-user” system – there is no way that some other session is changing the data – especially after the opening “set transaction”:

SQL> set transaction read only;

Transaction set.

SQL> set arraysize 1
SQL> select ...


541 rows selected.

SQL> set arraysize 4
SQL> select ...


599 rows selected.

SQL> set arraysize 10
SQL> select ...


620 rows selected.

SQL> set arraysize 32
SQL> select ...


616 rows selected.

The correct result set should have had the 616 rows reported when the arraysize was set to 32 (of, course, it’s possible with an arraysize of 32 the 616 rows returned weren’t the correct 616 rows – rows seemed to get multiplied or deleted fairly arbitrarily as the arraysize changed).

The execution plan was a little unusual in that it forced a nested loop join with a tablescan on the inner table; and when I ran the query with rowsource execution statistics enabled the number of starts of the inner tablescan was 1,597 but the number of rows actually returned varied. My first thought was that some new mechanical optimisation of the tablescan code was losing track of where it had got to in the repeated tablescans – but it turned out I was wrong.

Here’s the execution plan (with camouflage) – the key detail is in a section I didn’t look at intially, the column projection:

select * from table(dbms_xplan.display_cursor('0dh0kh9qa88mz',1,'-note +projection'));

| Id  | Operation           | Name | Rows  | Bytes | Cost (%CPU)| Time     |
|   0 | SELECT STATEMENT    |      |       |       | 14118 (100)|          |
|   1 |  NESTED LOOPS       |      |    29 |  2958 | 14118   (2)| 00:00:01 |
|*  2 |   HASH JOIN         |      |   892 | 57088 |    35   (3)| 00:00:01 |
|   3 |    TABLE ACCESS FULL| ABC  |   549 | 21411 |    17   (0)| 00:00:01 |
|   4 |    TABLE ACCESS FULL| DEF  |   892 | 22300 |    17   (0)| 00:00:01 |
|*  5 |   TABLE ACCESS FULL | XYZ  |     1 |    38 |    16   (0)| 00:00:01 |

Predicate Information (identified by operation id):
   2 - access("DEF"."ABC_FK"="ABC"."ABC_ID")
   5 - filter(("DEF"."COL0"="XYZ"."COL0" AND "XYZ"."COL1"="ABC"."COL1"
              AND "XYZ"."COL2"="ABC"."COL2"))

Column Projection Information (identified by operation id):
   1 - "ABC"."ABC_ID"[NUMBER,22], "DEF"."ABC_FK"[NUMBER,22],
       "ABC"."COL2"[NUMBER,22], "ABC"."COL1"[NUMBER,22],
       "DEF"."COL0"[VARCHAR2,20], "XYZ"."COL1"[NUMBER,22],
       "XYZ"."COL2"[NUMBER,22], "XYZ"."COL0"[VARCHAR2,20]
   2 - (#keys=1) "ABC"."ABC_ID"[NUMBER,22], "DEF"."ABC_FK"[NUMBER,22],
       "ABC"."COL2"[NUMBER,22], "ABC"."COL1"[NUMBER,22],
   3 - (rowset=200) "ABC"."ABC_ID"[NUMBER,22], "ABC"."COL1"[NUMBER,22],
   4 - (rowset=200) "DEF"."ABC_FK"[NUMBER,22], "DEF"."COL0"[VARCHAR2,20]
   5 - "XYZ"."COL1"[NUMBER,22], "XYZ"."COL2"[NUMBER,22],

The predicate section is irrelevant in this case, and I’ve camouflaged the names of the tables and columns – the only interesting bit is the appearance of the (rowset=200) in the projection information. This is reporting a feature new in 12c (and not to be confused with Oracle Java Rowsets) that should improve the performance of some queries.

I didn’t actually look at the projection information until after I’d asked the Oak Table members if they had ever seen this type of anomaly before – and Stefan Koehler emailed back to suggest that the problem might be related to rowsets (there are a couple of similar bugs on MoS, e.g: 17016479 and 20960570) – so I checked the projection, then repeated my tests after disabling the feature with a call to: ‘alter session set “_rowsets_enabled”=false;’

Problem solved – although I’ve told the person who emailed me to report this discovery and workaround to Oracle support and see what they supply as the approved solution.

It is possible to affect the feature through event 10055 – different levels disable it at different locations in the code; the list of options is given in the $ORACLE_HOME/rdbms/mesg/oraus.msg file (if you’re not running Windows):

//            Level:
//            0x00000001 - turn off for table scan
//            0x00000002 - turn off for hash join consume
//            0x00000004 - turn off for hash join produce
//            0x00000008 - turn off for group by
//            0x00000010 - turn off for sort
//            0x00000020 - turn off for table-queue out
//            0x00000040 - turn off for table-queue in
//            0x00000080 - turn off for identity
//            0x00000100 - turn off for granule iterator
//            0x00000200 - turn off for EVA functions
//            0x00000400 - turn off for PL/SQL
//            0x00000800 - turn off for upgrade
//            0x00001000 - turn off for database startup
//            0x00002000 - turn off for blobs and clobs
//            0x00004000 - turn off for tracing row source
//            0x00008000 - turn off rowset information in explain plan
//            0x00010000 - disable hash join rowsets fast path
//            0x00020000 - turn off for bloom create
//            0x00040000 - turn off for bloom use
//            0x00080000 - disable prefetch for hash join
//            0x00100000 - disable prefetch for bloom
//            0x00200000 - disable semi blocking hash join
//            0x00400000 - turn off rowset for fixed table

I tried the first few levels and found that both levels 1 and 2 eliminated the problem (and eliminated the appearance of the (rowset=200) entry in the projection information). Given the shape of the plan I had thought that just one of 1,2 or 4 might have been relevant so I was a little surprised to find that both 1 and 2 were effective – but that’s probably just a question of interpretation of the brief descriptions.


I’ve asked the owner of the problem if it’s okay to post the script to create the tables and data – and the answer was yes: the content was already heavily camouflaged anyway. So here’s a file you can download if you want to test other environments: insert_script_12c_bug

It’s declared as a “.doc” file to get past the upload process, but it’s really a flat text file.

Update 16th Nov

The official “minimum impact” workaround is to set event 10055 at level 2097152 (disable semi blocking hash join). Alternatively there is also a patch available. See Mike Dietriech’s blog for details:

Spring Security Demo with a Bootstrap Look and Feel

Pas Apicella - Sun, 2015-11-08 21:31
I decided to take the Spring Security demo at the following link , and add Bootstrap to it. In the end it's basically the same code and the Form Based Login will accept one user "pas/welcome1".

Here is the updated demo with Bootstrap added to the UI pages. You can deploy this to Bluemix using the "Deploy to Bluemix" directly from GitHub and it will as you to Sing into IBM devOps prior to deploying it directly into your Bluemix Environment.
Categories: Fusion Middleware