Skip navigation.

Feed aggregator

BNB is participating in Oracle OpenWorld 2014

Javier Delgado - Sun, 2014-09-28 10:15
BNB is taking part in Oracle Open World 2014, the most important event for the Oracle customers, partners and employees ecosystem at a global scale. The event is starting today at the Moscone Center in San Francisco, September 28th and will close on October 2nd.

Up to 50.000 people will attend the event, which will involve more than 2.000 presentations. BNB participates as an Oracle Gold Partner, and we will be focusing on PeopleSoft, JD Edwards, Fusion and Taleo, while also looking at new trends on Big Data, Business Intelligence and Internet of Things.

As the event progress, I will be posting my impressions. This is my first Oracle Open World and it's all very exiting!

OOW 2014: ACE Director Briefing

Doug Burns - Sun, 2014-09-28 05:41

Disclosure: I'm attending Openworld at the invitation of the OTN ACE Director program who are paying for my flights, hotel and conference fee. My employer has helpfully let me attend on work time, as well as sending other team mates because they recognise the educational value of attending. Despite that, all of the opinions expressed in these posts are, as usual, all my own.

The first day of the ACE D briefing was a bit of a wipe-out for me as I had so much catching up on bits and pieces of work and personal email to do, having arrived very late the previous night, although I still managed to spend some valuable time catching up with friends of the Oak and non-Oak variety as well as hearing some useful info from various Product Managers. I was gutted to have missed Thomas Kurian's briefing session because, as I heard later, it was as splendid as usual. I think some of the enjoyment comes from people's fascination with how on top of things he is, talking at all sorts of technical and non-technical levels over a very wide portfolio. That's pretty much how I remember the last few briefings.

Despite the inevitable arrival of jet lag screwing up my sleep, I've been able to enjoy day two much more (once I'd absorbed some light-hearted wind-ups about my disappearing act). Today was always going to be the most enjoyable for me anyway as the agenda was more database-centric.

It kicked off with a session on the current state of play of MySQL which I must admit I've almost forgotten about (conspiracy theorists will enjoy that) but seems to be ticking along quite nicely with incremental performance and functionality improvements although the presenters were keen to point out that MySQLs forte is not it's functionality so much as it's ubiquity in the web area, given it's part of the LAMP stack. Like a lot of the presentations, it might not have been about something I use day to day but was very enjoyable keeping in touch with other technologies.

Next was an informal conversation with Bob Evans, the Chief Communications Officer, which covered a wide variety of subjects with the usual direct and critical approach I've come to expect from the ACE Directors in attendance (you might be surprised!), raising concerns about the interface between Oracle Sales and their shared customers. I was disappointed to hear that there seems to be a pattern of scheduling local sales events at the same time as Oracle ACE tour events. Seems pretty daft to me. (Another one for the conspiracy theorists, I suppose.)

Then Gene Eun gave us an update on the Oracle Database Cloud Service. Although I still feel Oracle are way behind the curve on this, I don't think that necessarily means they can't make up ground, as they have in the past, but I think the most important message for me was a reinforcement of an answer to a question I asked last year. There's no reason why people can't use the same technology to run their own on-premise cloud and, working in Finance as I seem to have done for a while, the most realistic implementations I can imagine are hybrids of onsite and offsite infrastructure to cope with regulatory requirements whilst still gaining the benefits of offsite deployment where that makes most sense.

I didn't spend so much time drinking coffee in the Oracle canteens this year, but I did manage to have an enjoyable catch-up with Uri Shaft, a true development geek who always has interesting thoughts both on those technologies he is or has been involved with, but also other development areas that he has nothing to do with! Never a man short on opinions on software and a truly nice guy. Sadly, the regular JB catch-up no longer exists and that Maria Colgan moves in entirely different circles these days! (That would be a joke, folks, and I'm looking forward to light refreshments and chat when she's in Singapore soon.)

Speaking of Maria, she was part of the presentation team for the two hour Oracle Database Development Update, which is one of the key sessions for most attendees. Penny Avril and Maria Colgan kicked off with an all-too-short session discussing release plans and a little about In-Memory Option but I was left with the feeling that, having put so much work into getting the In-Memory stuff ready, it's now a case of consolidating the work and delivering product. i.e. I didn't notice any earth-shattering announcements in the database area but I suppose last year made up for that!

So most of the session was focused on two non-RDBMS areas. George Lumpkin on documents in the database and JSON stuff which was one of those - interesting but not something I'm likely to work with for a while presentations. 

Dan McLary was almost certainly the speaker of the day as he delved into Oracle's BigData/Hadoop offering in good detail but with passion and a refreshing honesty about where Oracle fit into this field which still managed to be very positive about where Oracle are taking it. As he pointed out, the combination of being able to query anywhere (different data sources and technologies) with the functional richness of Oracle's SQL implementation is likely to be a pretty compelling offering. 

It was an afternoon full of good presenters likely to keep the jet-lagged awake (although both Connor McDonald and I were struggling badly by this stage) like David Peake who covered Apex and a new website - Learning SQL - to help people, erm, learn SQL. I think we'll be hearing more about this in the upcoming week.

Wim Coekaerts is always popular with a small chunk of the ACED crowd and was again with his usual Linux and VM update, an informal conversation delivered without notes or slides which hit mainly on the areas that the attendees wanted to discuss. In a neat piece of agenda symmetry, he pointed out the presence of DTrace probes for MySQL running on OEL, as he discussed in his recent blog post.

By now we were running late and beers were beckoning, so Steve Feuerstein did a great job of just about keeping people going with his discussion of Oracle's attempts to reengage and energise the traditional Oracle SQL and PL/SQL technologies we know and love with a new (and quite possibly younger!) audience - YesSQL! Keep an eye out for what is likely to be a fun and different session with Steven and Tom Kyte and other special guests at 18:30 on Monday in Moscone South 103.

... and with that all wrapped up, it was time for beers and the bus into the city. The hotel check-in wasn't the car crash it usually is, but by the time it was all done and dusted there was just time for a few more drinks and since then it has been sleep, sleep, sleep for me :-(

The usual thanks to the OTN team for putting together a varied and interesting briefing, which must be a really tough task when the Dev folks are all up to their eyebrows preparing for next week. Great work!

I'm hoping just an hour or two more and I'll be bright and breezy for Sunday, the first proper conference day. With my apparently new-found energy and dashing good looks (courtesy of Singapore), I'm expecting the week to be a good one!

Oracle on Windows

Laurent Schneider - Sun, 2014-09-28 05:31

@mkratoch is speaking at 10am UGF2633: Managing Oracle 12c on Windows

Again, 12cR1ps1 came before AIX and HPUX.


SQL> select dbms_utility.port_string, version 
  from v$instance;

PORT_STRING          VERSION         
-------------------- -----------------
IBMPC/WIN_NT64-9.1.0 12.1.0.2.0        

Oracle Cloud - Keeping Your Perspective

Floyd Teter - Sat, 2014-09-27 23:54
The fact that we live at the bottom of a deep gravity well, on the surface of a gas covered planet going around a nuclear fireball 90 million miles away and think this to be normal is obviously some indication of how skewed our perspective tends to be.”
             - Douglas Adams, The Salamander of Doubt: Hitchhiking The Galaxy One Last Time

Oracle OpenWorld kicks off tomorrow.  My thoughts are with all the folks struggling through the mess that is the U.S. transportation system right now.  That mess in Chicago has really rippled throughout the country.  Hope ya'all keep your perspective and that things work out to get everyone here without too much trouble.

Many of the messages coming from Oracle over the next few days will have to do with the Oracle Cloud.  Oracle has strategically committed to darn near everything as a service (service offerings being a subset of most cloud definitions, but pretty synonymous with "Oracle Cloud" at the moment).  With Oracle adding a new offering at the rate of one per working day (yeah, really), it's easy to get lost in it all.  It's tough to keep things in perspective.

So I've got a nifty chart I found to help ya'all keep it all straight (wish I could remember where I found it so I could give proper credit...but, alas, as you age the memory is the first thing to go).  This should be a pretty spiffy reference too help keep things in perspective during OpenWorld and even thereafter.  Here ya go...



The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 11–22)

Iggy Fernandez - Sat, 2014-09-27 17:20
On the Toad World site, I’m writing a series of blog posts and Wiki articles on the subject of EXPLAIN PLAN. I’m using EXPLAIN PLAN as a motif to teach not just SQL tuning but also relational theory, logical database design, and physical database design. In a year’s time, I hope to have enough material for […]
Categories: DBA Blogs

Openworld 2014

Steve Karam - Sat, 2014-09-27 14:30
Oracle OpenWorld

Are you going to Oracle OpenWorld 2014? I am, and I hope to see you there! As you probably know, OpenWorld is a humongous event with tens of thousands of people in attendance and some amazing presentations. Why, I even hear Oracle’s new CTO might be there. I wonder if he has anything to talk about?

This year we’ll have a ton of activity at the Delphix booth. You can check out the speaking schedule, location, and more on Delphix’s website. At the very least you’ll want to register to win a sweet custom carbon fiber bike. I’ll be speaking on Monday, Tuesday, and Wednesday at the booth so please come on by and say hello.

I’ll also be hanging out quite a bit at OakTable World with data technology luminaries Kyle Hailey, Tim Gorman, Ben Prusinski, Adam Bowen, and other Delphix folks to take part and prepare for a very special set of events: the Attacks!

CloneAttackDelphix, DBVisit, and Solarwinds will be teaming up to present #CloneAttack, #RepAttack, and #MonitorAttack respectively, three events aimed at giving you real-world usage of some outstanding products for the Oracle world. Delphix specifically will be providing all participants with a 90-day developer trial of Delphix in all its glory so you can learn and experiment yourself with virtual data platforms. Be sure to check it out.

Lastly, I’m excited to announce that I will once again be appearing on #theCUBE this year. John Furrier and Dave Vellante are incredible hosts who really dig deep into the meat of the new tech and offerings in the IT world, and I’m honored to have been a part of their show last year and to be on again this year. That will be on Monday at 1PM PDT, so tune in if you can.

This promises to be an outstanding OpenWorld. I look forward to seeing you there!

The post Openworld 2014 appeared first on Oracle Alchemist.

oracle.ias.cache.CacheFullException: J2EE JOC-017 The cache is full

Vikram Das - Sat, 2014-09-27 10:40
Yesterday, the users of an EBS R12.2 instance got this error when they logged in:

Error Page
You have Encountered an unexpected error.  Please contact the System Administrator for assistance.

On checking the $EBS_DOMAIN_HOME/servers/oacore_server1/logs/oacore_server1.out, we found this error:



oracle.ias.cache.CacheFullException: J2EE JOC-017 The cache is full.
       at oracle.ias.cache.CacheHandle.findObject(CacheHandle.java:1680)
       at oracle.ias.cache.CacheHandle.locateObject(CacheHandle.java:1118)
       at oracle.ias.cache.CacheAccess.get(CacheAccess.java:877)
       at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:771)
       at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802)
       at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4624)
       at oracle.apps.fnd.cache.AppsCache.get(Unknown Source)
       at oracle.apps.fnd.functionSecurity.Grant.getGrantArray(Unknown Source)
       at oracle.apps.fnd.functionSecurity.Authorization.getFunctionSecurityGrantedMenusForGrantee(Authorization.java:829)
       at oracle.apps.fnd.functionSecurity.Authorization.getFunctionSecurityGrantedMenus(Authorization.java:744)
       at oracle.apps.fnd.functionSecurity.Authorization.getFuncSecGrants(Authorization.java:251)
       at oracle.apps.fnd.functionSecurity.Authorization.testMenuTreeFunction(Authorization.java:499)
       at oracle.apps.fnd.functionSecurity.Navigation.getMenuTree(Navigation.java:254)
       at oracle.apps.fnd.functionSecurity.Navigation.getMenuTree(Navigation.java:279)
       at oracle.apps.fnd.functionSecurity.Navigation.getMenuTree(Navigation.java:160)
We tried bouncing services and deleting $EBS_DOMAIN_HOME/servers/oacore_server1/cache.  None of those actions helped.  Things got back to normal only after the Xmx, Xms,and permsize startup parameters for the oacore JVM were changed in weblogic console on Gary's suggestion:
-XX:PermSize=512m -XX:MaxPermSize=512m –Xms4096m –Xmx4096m
I also changed it in the context file:
Old: s_oacore_jvm_start_options">-XX:PermSize=128m -XX:MaxPermSize=384m -Xms512m -Xmx512mNew: s_oacore_jvm_start_options">-XX:PermSize=512m -XX:MaxPermSize=512m –Xms4096m –Xmx4096m
The oacore_server1 and oacore_server2 were bounced after this.  We haven't seen that error ever since.

There is a support.oracle.com article: Receive Intermittent Error You Have Encountered An Unexpected Error. Please Contact Your System Administrator (Doc ID 1519012.1)CauseThere are user accounts having extremely high numbers of FUN_ADHOC_RECI_XXXXXXX / FUN_ADHOC_INIT_XXXXXXX assigned.

Users have an extremely high number of (ADHOC) ROLES assigned to them, so when these attempt to login this fills the JOC ( Java object cache ) and causes it to run into it's limits resulting in the errors reported. Once bounce is done all is working fine until such an user logs in again.

While working in AGIS and creating and progressing batches, in the workflow there are several ad hoc roles created which remain on the system and do not get end dated or deleted. This can cause performance issues.
Ad Hoc Roles in WF_LOCAL_ROLES starting with FUN_ADHOC_RECI_XXXXXXX ; FUN_ADHOC_INIT_XXXXXXX with no expiration_date.

A. Run the following SQL to verify if there are accounts having extreme numbers of roles assigned

SQL> SELECT user_name, count(*) FROM wf_user_roles WHERE role_name <> user_name GROUP BY user_name ORDER BY 2;


B. Run following for particular user

SQL> SELECT distinct role_name FROM wf_user_roles
WHERE user_name = cp_user_name
or (user_name = (SELECT name FROM wf_local_roles wlr, fnd_user fusr
WHERE fusr.person_party_id = wlr.orig_system_id
AND wlr.orig_system = 'HZ_PARTY'
AND fusr.user_name = cp_user_name
AND rownum < 2))
AND role_name <> user_name;

Note: Replace cp_user_name with name of user having high number of ADHOC roles


SolutionTo implement the solution, please execute the following steps:

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Follow the steps given in document to purge the WF_LOCAL_ROLES for the AGIS transactions in 'COMPLETE' status.

AGIS: HOW TO DELETE AD HOC ROLES CREATED IN WORKFLOW (Doc ID 1446561.1)

3. If you are satisfied that the issue is resolved, migrate the solution as appropriate to other environments.



We had also logged SR with Oracle where they pointed us to the very same article and also asked us to do the following:

Action Plan
===========

1. How to find out the existing adhoc roles?

select name, start_date, start_date, expiration_date
from wf_local_roles
where orig_system = 'WF_LOCAL_ROLES'
order by name;

2. Define an expiration date for the ad hoc role:

exec WF_DIRECTORY.SetAdHocRoleExpiration (role_name=> >,expiration_date=>sysdate-1);


3. Periodically, purge expired users and roles in order to improve performance.

exec WF_PURGE.Directory(end_date);

This purges all users and roles in the WF_LOCAL_ROLES,WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables whose expiration date is less than or
equal to the specified end date and that are not referenced in any notification.

Parameter: end_date Date to purge to.

For more information, please refer to Oracle Workflow API Reference on page 2 – 128.
Use the workflow API's to purge the ad hoc roles:

NOTE:
After end dating the adhoc roles, the expired adhoc roles can also be purged by running the Purge Obsolete Workflow Runtime Data concurrent program. Make sure the "Core Workflow Only" parameter set to N.
Oracle also shared 3 open bugs (unpublished, can be read only Oracle employees) for this issue:
Bug 19025537 : ORACLE.IAS.CACHE.CACHEFULLEXCEPTION: J2EE JOC-017 THE CACHE IS FULL.
Bug 11772304 : JOC INVESTIGATION WITH 12.2
Bug 19582421 : R12.2 THE CACHE IS FULL; EXCEPTION IN OACORE_SERVER1 LOG.

Categories: APPS Blogs

Suppressing ADF LOV Like Operator Filtering

Andrejus Baranovski - Sat, 2014-09-27 05:05
ADF LOV component provides filtering option with STARTSWITH operation. This is used to check if similar value exists in the LOV, if such value exists - LOV popup is opened with all the suggested values. If user types 10 and there are 100, 1000 in the LOV, instead of accepting value 10 - LOV popup will be opened and all three values 10, 100, 1000 will be displayed. While this is useful, there is no option to turn off such functionality. My post describes a solution, that can be used to disable suggested LOV filtering.

Here you can see, how it works by default. User types 10, there is 100 in the LOV. LOV popup is opened with both suggested values. This can be annoying for advanced user, who already know the code and they don't need to use LOV popup to select it:


We can check generated SQL statement. Original LOV SQL was updated with LIKE and this was applied for bind variable value. This is how suggested LOV values are retrieved:


LIKE is applied for DepartmentID (LOV key), even we have set it explicitly in the LOV View Criteria to use EQUALS operator:


The solution is to override buildViewCriteriaClauses method in VO Impl class. ADF executes additional View Criteria to retrieve suggested LOV values, this criteria name is "__lov__filterlist_vcr___". We can intercept this View Criteria and replace all STARTSWITH operators with EQUALS:


With this fix applied, user could type 10 and there is no LOV popup opened anymore with suggested values:


Same SQL as before is generated, but LIKE is changed to =, this is the result of our fix:


New LOV value can be successfully saved to the DB:


Download  - ADFTableApp.zip.

I Heart Logs - Event Data, Stream Processing, and Data Integration by Jay Kreps; O'Reilly Media

Surachart Opun - Fri, 2014-09-26 23:01
As I have worked in server-side a long time as System Administrator. I must spend with logs. To use it for checking and investigation in issue. As some policies in some Companies, they want to keep logs over year or over ten years. So, it is not unusual to find out idea to store, integrate logs and do something.
A book tittle "I Heart Logs - Event Data, Stream Processing, and Data Integration" by Jay Kreps. It's very interesting. I'd like to know what I can learn from it, how logs work in distributed systems and learn from author who works at LinkedIn. A book! Not much for the number of pages. However, it gives much more for data flow idea, how logs work and author still shows readers why logs are worthy of reader's attention. In a book, that has only 4 chapters, but readers will get concept and idea about Data integration (Making all of an organization’s data easily available in all its storage and processing systems), Real-time data processing (Computing derived data streams) and Distributed system design (How practical systems can by simplified with a log-centric design). In addition, I like it. because author wrote from his experience at LinkedIn.

After reviewing: A book refers a lot of information(It's easy on ebook to click links) that's useful. Readers can use them and find out more on the Internet and use. For Data integration, It's focused to Kafka software that is a distributed, partitioned, replicated commit log service. It provides the functionality of a messaging system. Additional, It gave why the Big Data Lambda Architecture is good for batch system and a stream processing system and point about things a log can do.

So, Readers will be able to learn:
  • Learn how logs are used for programmatic access in databases and distributed systems
  • Discover solutions to the huge data integration problem when more data of more varieties meet more systems
  • Understand why logs are at the heart of real-time stream processing
  • Learn the role of a log in the internals of online data systems
  • Explore how Jay Kreps applies these ideas to his own work on data infrastructure systems at LinkedIn
Book - I Heart Logs - Event Data, Stream Processing, and Data Integration
Author: Jay KrepsWritten By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Oracle OpenWorld is Upon Us! Application Developers Unite!

Christopher Jones - Fri, 2014-09-26 19:25

It's a super, extra, enormously busy time of the year at Oracle because our big Oracle OpenWorld Conference is next week. We have all been working on new products and new presentations.

I have a full mix of events, meetings, presentations and booth duty. If you're at the conference drop by to say Hi. I'll be at the Application Development booth (Left - SLD-163) in Moscone South on Monday morning, Tuesday lunchtime and Wednesday morning (plus other odd times).

Also lookout for me onstage with Tom Kyte on Monday and with Steven Feuerstein on Wednesday.

The session details, and other sessions you might find interesting are listed on my Focus On Application Development page.

If you are a developer, I recommend coming to the Programming and Scripting "Meet the Expert" session at 6pm Tuesday evening (Moscone South - 307). I cannot stress enough how valuable it is to have a dialog and relationship with the developers who create the software and APIs you use.

Oracle Technology Network Team Ramping up to Oracle OpenWorld and JavaOne

OTN TechBlog - Fri, 2014-09-26 18:31

Normally on Fridays we accumulate the Best of Content for that week, but this time around we are going to look at what OTN has in store for Oracle OpenWorld and JavaOne attendees — starting with what is lined up for September 28th in the OTN Lounge located in Upper Lobby, Moscone South.

RAC Attack - 9am to 2pm - Learn how to configure and clone virtual machines, create and set up internal and external virtual networks, create different storage types, and set up a local DNS server and other challenging components.

OTN Kick Off Meetup - 3 to 5pm -  A perfect way to start the week!  Join us for a beverage, grab a community ‘band’ to help find like-minded folks, and network! You'll also be able to make origami, use our photo booth to share how much fun you are having, and Tweet for a beer.

The OTN Community Managers will be posting videos and blogs all week long so make sure to check them out often:

Blogs -
The Java Source Blog
OTN DBA/DEV Watercooler

YouTube Channels -
OTN
Java
OTN Garage
OTN ArchBeat

Follow @JavaOneConf for conference-specific announcements

Hacking sessions and interviews on NightHacktingTV - LIVE from the Java Hub, 9am-4pm PT.

APEX 4.2.6 patch available

Dimitri Gielis - Fri, 2014-09-26 15:01
Oracle released APEX 4.2.6 yesterday, it's also available from My Oracle Support as a patch set 19595896.

Here's the table of bug fixes.

Table 6 Bugs Fixed in the Oracle Application Express 4.2.6.00.03 Patch SetBug NumberDescription18393429Importing pre-4.2 application with data loading results in runtime error18609856APEX_WEB_SERVICE.CLOBBASE642BLOB converts incorrectly18658967Corrupted HTML mail messages are created from APEX_MAIL.SEND18719750ORA-01858 during application import18733989Errors picking up session with cookie when TOP CALL is not FSHOW, or ACCEPT19021052Oracle Application Express 4.2.4 throwing error while generating check boxes19313700Check box fails with ORA-06502 after upgrade from release 4.0 to 4.2.419482775ORA-06502 when importing application containing translations
Applying the patch took less than 7 minutes.


This is probably the latest patch before APEX 5.0 hits the road...

Categories: Development

Patch 19183482 resolves ORA-01403 getting plan with baseline

Bobby Durrett's DBA Blog - Fri, 2014-09-26 14:51

I was testing SQL plan baselines on a base 11.2.0.3 release of Oracle on a 64 bit Linux virtual machine.  I ran DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE to create a SQL plan baseline for a test query after running that query once to get its plan in the cursor cache.  When I ran the test query after creating the SQL plan baseline and called dbms_xplan.display_cursor to see its new plan I got an ORA-01403 error:

ORCL:SYSTEM>select * from table(dbms_xplan.display_cursor(null,null,'ALL'));

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------
SQL_ID  4mu5a860ardpz, child number 1

An uncaught error happened in prepare_sql_statement : ORA-01403: no data found

NOTE: cannot fetch plan for SQL_ID: 4mu5a860ardpz, CHILD_NUMBER: 1
      Please verify value of SQL_ID and CHILD_NUMBER;
      It could also be that the plan is no longer in cursor cache (check v$sql_plan)

I applied patch 19183482 to my test system and the ORA-01403 error went away:

ORCL:SYSTEM>select * from table(dbms_xplan.display_cursor(null,null,'ALL'));

PLAN_TABLE_OUTPUT
-------------------------------------------------------------------------------------
SQL_ID  4mu5a860ardpz, child number 1
-------------------------------------
select sum(blocks) from test

Plan hash value: 1950795681

---------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |       |       |    29 (100)|          |
|   1 |  SORT AGGREGATE    |      |     1 |     3 |            |          |
|   2 |   TABLE ACCESS FULL| TEST |  2844 |  8532 |    29   (0)| 00:00:01 |
---------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$1
   2 - SEL$1 / TEST@SEL$1

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - (#keys=0) SUM("BLOCKS")[22]
   2 - "BLOCKS"[NUMBER,22]

Note
-----
   - SQL plan baseline SQL_PLAN_dscatqjvyk4qy6b581ab9 used for this statement

Here is a zip of the script that I ran to create the ORA-01403 error and the output that it generated with and without the patch applied on my test database: zip

Here is a list of the bugs that patch 19183482’s readme says it will fix:

14512308: SPM BASELINE PLAN CANNOT BE REPRODUCED
15858022: ‘LIBRARY CACHE: MUTEX X’ AND LIBRARY CACHE LOCKS  PURGED_CURSOR
16400122: SPIKES IN LIBRARY CACHE
16625010: SPM BASELINE NOT WORKING FOR SQL CALLED FROM PL/SQL

I haven’t gotten very far into my investigation of SQL plan baselines but it looks like it would be a good idea to apply 19183482 before using SQL plan baselines on 11.2.0.3.  I barely got started using SQL plan baselines and I immediately hit this bug.

– Bobby









Categories: DBA Blogs

Security Alert CVE-2014-7169 Released

Oracle Security Team - Fri, 2014-09-26 14:20
Normal 0 false false false EN-US X-NONE X-NONE

Hi, this is Eric Maurice.

Oracle just released Security Alert CVE-2014-7169. Vulnerability CVE-2014-7169, previously known as CVE-2014-6271, affects GNU Bash, and if successfully exploited can result in providing a malicious attacker the ability to fully compromise a targeted system. GNU Bash is a popular open source command line shell incorporated into Linux and other widely used operating systems. The National Vulnerability Database (NVD) has given this vulnerability a CVSS Base Score of 10.0.

Oracle is continuing to investigate this vulnerability. Today’s Security Alert lists the products that Oracle has currently determined to be vulnerable to CVE-2014-7169. Download and installation instructions are provided for those products with available patches. Note that the fixes provided with this Security Alert address both vulnerabilities CVE-2014-7169 and CVE-2014-6271. The Security Alert Advisory will be updated to reflect the availability of fixes for additional products when they have successfully completed testing. It is Oracle’s priority to provide fixes that provide effective mitigation against this vulnerability while not introducing regressions or other issues. In other words, Oracle will provide fixes for additional affected products as soon as they have been fully tested and determined to provide effective mitigation against this vulnerability.

Due to the severity of this vulnerability, the public availability of detailed technical information, and reports of attempted exploitation, Oracle urges customers to apply the appropriate fixes when they become available.

Customers who are concerned about the status of individual products not listed in today’s Security Alert Advisory should contact Oracle Technical Support to obtain additional information. In response to these inquiries, the Security Alert Advisory may also be updated to reflect the status of these products to ensure the wider dissemination of relevant information.

For More Information:

The advisory for Security Alert CVE-2014-7169 is located at http://www.oracle.com/technetwork/topics/security/alert-cve-2014-7169-2303276.html.

More information has also been published at http://www.oracle.com/technetwork/topics/security/bashcve-2014-7169-2317675.html

The Oracle Software Security Assurance web site is located at http://www.oracle.com/us/support/assurance

/* 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-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; 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-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

Oracle Java Cloud Service

Anshu Sharma - Fri, 2014-09-26 10:56

Oracle Java Cloud Service which is a full featured WebLogic Server available as PaaS is now offering Trials for ISV Partners. Let us know if you have a Java Application which you would like to deploy on this environment. We can take you through the process and would value your feedback.

If you are at Oracle Open World next week then please check out these sessions

Build and Deploy Java Applications on Oracle Java Cloud Service in Minutes [HOL9445]

  • Wednesday, Oct 1, 10:15 AM - 11:15 AM - Intercontinental - Sutter,
  • Thursday, Oct 2, 2:30 PM - 3:30 PM - Intercontinental - Sutter

The Power of Java and Oracle WebLogic Server in Oracle Cloud [CON7930]

Tuesday, Sep 30, 12:00 PM - 12:45 PM - Moscone South - 270 

Oracle Java Cloud Service: Deploy Enterprise Applications in the Public Cloud [CON7936]

Thursday, Oct 2, 10:45 AM - 11:30 AM - Moscone South - 304 


Log Buffer #390, A Carnival of the Vanities for DBAs

Pythian Group - Fri, 2014-09-26 10:50

All eyes are on the Oracle Open World. Thousands of sessions, demos, and labs topped up with the countless networking opportunities, Moscone Center is the place to be.

Oracle:

Oracle OpenWorld 2014 – Bloggers Meetup.

Query to show sql_ids related to SQL Profiles.

Oracle OpenWorld is nearly upon us and the agenda is packed with interesting sessions. Prominent among these are several sessions by customers who are able to share their stories of success with Oracle Multitenant.

The biggest challenge for people coming to such huge events as Oracle OpenWorld is to navigate through all of the events that simultaneously happen at various locations.

Pythian at Oracle OpenWorld 2014.

SQL Server:

Monitoring Longest Running Transaction using SQL Server Agent Alerts .

Free PDF Booklet: 119 SQL Code Smells.

Level 1: What is “SQL Server AlwaysOn“?

10 things I learned about rapidly scaling websites with Azure.

Importing Excel Data into SQL Server Via SSIS: Questions You Were Too Shy to Ask

MySQL:

How to do reverse engineering with MySQL Workbench.

MySQL 5.5.40 Overview and Highlights.

MySQL 5.7.5: GROUP BY respects functional dependencies!

JSON UDF functions version 0.3.2 have been released.

Importing related MySQL tables into an Excel Data Model using MySQL for Excel.

Categories: DBA Blogs

ODAC 12c Release 3 Beta now available

Christian Shay - Fri, 2014-09-26 10:17

The Oracle Data Access Components (ODAC) 12c Release 3 Beta is now available! This beta introduces numerous new features for Entity Framework and managed ODP.NET.


Entity Framework 6 Code FirstODAC 12c R3 is the first ODP.NET release to certify with Entity Framework (EF) 6 and EF Code First. EF Code First is a popular development model for .NET object-relational mapping. Developers define the application domain model using source code, rather than with a designer or an XML-based configuration file. An EF Code First model's classes are defined in code through Plain Old CLR Objects (POCOs).

This support includes interoperability with the two Entity Framework methods that control the resulting Oracle data type: Data Annotations and Code First Fluent API. Data Annotations permit you to explicitly mark a class property with one or more attributes, whereas the Code First Fluent API permits you to use code rather than attributes to achieve the same goal.

Code First developers can modify and create their database schema as their model changes via EF Code First Migrations. ODP.NET supports EF Code First Migrations through the Visual Studio Package Manager Console commands.

These features are all available in both managed and unmanaged ODP.NET.


New ODP.NET, Managed Driver FeaturesSeveral new managed ODP.NET features have been delivered with this beta. XML DB developers can now use all of ODP.NET's XML classes that are supported by ODP.NET, Unmanaged Driver with the exception of the OracleXmlType.IsFragment and OracleCommand.XmlCommandType properties. This makes Unmanaged ODP.NET XML DB application migration to the managed driver a simple process.

ODP.NET, Managed Driver supports the VARCHAR2, NVARCHAR2, and RAW data types up to 32 KB in size. No code changes are required to use the larger data types, (which are a new Oracle Database 12c feature). By storing more data, developers can use these data types more frequently, providing programming flexibility. In addition, SQL Server to Oracle Database application migration is easier with these new data type sizes.

When using array binding to execute multiple DML statements, ODP.NET, Managed Driver can now provide an array that lists the number of rows affected for each input value from the bound array, rather than just the total number of rows affected. To retrieve the row count, ODP.NET can call the OracleCommand.ArrayBindRowsAffected property. You can use this information to better evaluate the DML's efficiency and whether the data changes were correctly applied.


.NET Framework 4.5.2 and Distributed TransactionsThe ODP.NET managed and unmanaged beta drivers are certified with new .NET Framework 4.5.2 release. .NET 4.5.2 introduces a new Microsoft Distributed Transaction Coordinator feature that allows ODP.NET, Managed Driver to support distributed transactions without requiring you to deploy Oracle.ManagedDataAccessDTC.dll with your application.


More to ComeUp next, the ODAC team plans a NuGet installable managed and unmanaged ODP.NET. Stay tuned to @OracleDOTNET to learn when it is available. We hope to hear your feedback via the OTN discussion forums.

EPM and BI Meetup at Next Week’s Openworld (and details of our Oracle DI Speakeasy)

Rittman Mead Consulting - Fri, 2014-09-26 10:08

Just a short note to help publicise the Oracle Openworld 2014 EPM and BI Meetup that’s running next week, organised by Cameron Lackpour and Tim Tow from the ODTUG board.

This is an excellent opportunity for EPM and BI developers and customers to get together and network over drinks and food, and chat with members of the ODTUG board and maybe some of the EPM and BI product management team. It’s running at Piattini, located at 2331 Mission St. (between 19th St & 20th St), San Francisco, CA 94110 from 7pm to late and there’s more details at this blog post by Cameron. The turnout should be pretty good, and if you’re an EPM or BI developer looking to meet up with others in your area this is a great opportunity to do so. Attendance is free and you just need to register using this form.

Similarly, if you’re into data warehousing and data integration you might be interested in our Rittman Mead / Oracle Data Integration’s Speakeasy event, running on the same evening (Tuesday September 30th 2014) from 7pm – 9pm at Local Edition, 691 Market St, San Francisco, CA. Aimed at ODI, OWB and data integration developers and customers and featuring members of the Rittman Mead team and Oracle’s Data Integration product team, again this is a great opportunity to meet with your peers and share stories and experiences. Registration is free and done through this registration form, with spaces still open at the time of posting.

Categories: BI & Warehousing

Oracle Openworld SF .NET and Windows Sessions

Christian Shay - Fri, 2014-09-26 10:04
Oracle Openworld San Francisco begins this Sunday, September 28!  Join the Oracle .NET development team and your fellow .NET developers and learn about new Oracle .NET features, including Entity Framework, Code First, Code First Migrations, NuGet packaging, support for new Oracle Database 12c features and much more. Meet Oracle and .NET experts at the .NET Demogrounds booth and at the "Ask the Experts" Q+A session. The .NET schedule listing is at this link. Register at the OpenWorld website. See you there!

On the Road with Luan

Pythian Group - Fri, 2014-09-26 08:59

For the months of September, October, and November, Microsoft SQL Server MVP Luan Moreno will be touring Brazil, Europe, and EUA for various speaking engagements. He’ll be sharing his SQL Server knowledge and insights during SQL Saturdays, conferences, and virtual conferences.

“Pythian is a company that values and truly supports employees in sharing their knowledge at community events,” Luan says. “It’s a pleasure to be a part of this amazing company.”

 

Date Location Event Topic Notes 27-Sep-14 São Paulo, Brazil SQL Saturday #325 In-Memory OLTP a.k.a Hekaton Speaking schedule 28-Sep-14 São Paulo, Brazil SQL Saturday #325 MythBusters – Caçadores de Mitos Speaking schedule 6-Oct-14 Online MVP ShowCast 2014 In-Memory OLTP – Cenários de Aplicação Register here 7-Oct-14 Online 24 Hours of Pass Troubleshooting SQL Server Extended Events Register here 7-Oct-14 Online 24 Hours of Pass In-Memory OLAP a.k.a ColumnStore Index Internals Register here 17-Oct-14 Porto Alegre, Brazil TDC 2014 ORM e Consultas x Performance Speaking schedule 25-Oct-14 Rio de Janerio, Brazil SQL Saturday #329 In-Memory OLAP a.k.a ColumnStore Index Speaking schedule Oct 28-31 Barcelona, Spain TechED 2014 Europe Subject Matter Expert (SME) – SQL Server Event schedule Nov 3-6 Redmond, Seattle MVP Summit 2014 TBD Event schedule Nov 4-7 Redmond, Seattle Pass Summit 2014 TBD Event schedule

 

Will you be attending any of these events? If so, Luan extends the invite to chat SQL Server over a coffee! Reach out to him at moreno@pythian.com or follow him on Twitter at @luansql.

Categories: DBA Blogs