Feed aggregator

Smart View Version to use with OBIEE 11.1.1.7.1

Abhinav Agarwal - Mon, 2013-10-28 00:49
Users who have downloaded the latest version of Oracle Business Intelligence 11g - 11.1.1.7.1, and wish to use the Oracle Hyperion Smart View for Office add-in to connect to Oracle BI, need to use the latest version of Smart View - 11.1.2.3 - that is available for download on OTN here.
After downloading this version of Smart View, if you want this version of Smart View to be available as a link from the Home Page of Oracle BI EE (the "Download BI Desktop Tools" dropdown under the "Get Started..." section), you need to follow the instructions (also see Installing and Deinstalling Oracle Business Intelligence Client Tools)
You can find more information in the BI documentation library (Business Intelligence Documentation for Oracle Fusion Middleware 11g (11.1.1.7)) or in the Oracle Essbase Documentation Library, Release 11.1.2.2.200

Happy Monday!
Abhinav,
Bangalore, July 08, 2013

OBIEE Bundle Patch 11.1.1.7.1 Now Available

Abhinav Agarwal - Mon, 2013-10-28 00:48
Oracle Business Intelligence Suite Bundle Patch 11.1.1.7.1 is now available for download. The bundle patch id is 16556157 and can be downloaded from the My Oracle Support portal for Microsoft Windows x64 and Linux x86-64 platforms.

The ReadMe states "This Suite Bundle Patch is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.7.0."



Windows 8: create system image fails with 0x80070001

Dietrich Schroff - Sat, 2013-10-26 03:06
Last week i tried to create a system image with the built-in backup-tool from Windows 8. It sounds very easy:
  • connect an usb storage to your computer
  • start system image creation (look here)
    But then i got this error: 0x80070001

After googling around i found the following solution:
But there you get something with junctions and FAT-filesystems... This did not solve the problem...
The solution was very easy: I had truecrypt running and this created an additional mount point. After stopping truecrypt the system image was created without any error...

Welcome Carl's family, friends,

Carl Backstrom - Fri, 2013-10-25 17:15
Welcome Carl's family, friends, colleagues and anyone else that visits this site. It's been five years but seems like yesterday that Carl was laughing, joking, providing opinions, being a genius, debating, participating in shenanigans and overall just living life to the fullest. We all share great memories and good times and we wish everyone and their families the best.

 Thank you for being a part of his life. A few updates for everyone. Carl's daughter, Destany, is attending college in Sacramento and doing very well. She is exceptional young lady and makes us proud everyday. A special thanks to those who contributed to Carl's memorial fund as it is going to good use for her college education.

 For your viewing pleasure here are some of our favorite pictures of Carl. Have a great day...keep smiling and have a drink for Carl.

 -Best wishes from his family.






























When error say nothing about real issue

Virag Sharma - Thu, 2013-10-24 22:18
We want restore backup from source. So we took backup from source and copied it to /dba/share/MYDB on target. My collouge sent me email saying  restore failed with following error


rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 18 20:47:38 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount

Oracle instance started

Total System Global Area    8551575552 bytes

Fixed Size                     2245480 bytes
Variable Size                503319704 bytes
Database Buffers            8036286464 bytes
Redo Buffers                   9723904 bytes

RMAN> set DBID=2387922???;

executing command: SET DBID

RMAN> restore controlfile from '/dba/share/MYDB/c-2387922???-20130910-00.ctl';

Starting restore at 18-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=391 device type=DISK

channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/18/2013 20:48:04
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece




We searched MOS and forums. Most of the search , pointing it is old backup ( more then 7 day ),  some doc say backup corrupted etc etc. Instead going for whole story that how reached to conclusion, let we tell you the finding.

We found the mount option for /dba/share/MYDB ( where we copied backup from source ) not correct
...that's why getting error. We changed it to

           rw,bg,intr,hard,timeo=600,wsize=32768,rsize=32768,nfsvers=3,tcp,noacl 0 0

After this change we able to restore control file and rest of the backup successfully

Categories: DBA Blogs

BIP 11g Dynamic SQL

Tim Dexter - Wed, 2013-10-23 23:38

Back in the 10g release, if you wanted something beyond the standard query for your report extract; you needed to break out your favorite text editor. You gotta love 'vi' and hate emacs, am I right? And get to building a data template, they were/are lovely to write, such fun ... not! Its not fun writing them by hand but, you do get to do some cool stuff around the data extract including dynamic SQL. By that I mean the ability to add content dynamically to your your query at runtime.

With 11g, we spoiled you with a visual builder, no more vi or notepad sessions, a friendly drag and drop interface allowing you to build hierarchical data sets, calculated columns, summary columns, etc. You can still create the dynamic SQL statements, its not so well documented right now, in lieu of doc updates here's the skinny.

If you check out the 10g process to create dynamic sql in the docs. You need to create a data trigger function where you assign the dynamic sql to a global variable that's matched in your report SQL. In 11g, the process is really the same, BI Publisher just provides a bit more help to define what trigger code needs to be called. You still need to create the function and place it inside a package in the db.

Here's a simple plsql package with the 'beforedata' function trigger.

Spec

create or replace PACKAGE BIREPORTS AS 

 whereCols varchar2(2000);
 FUNCTION beforeReportTrig return boolean;

end BIREPORTS;

Body

create or replace PACKAGE BODY BIREPORTS AS

  FUNCTION beforeReportTrig return boolean AS 
   BEGIN
      whereCols := ' and d.department_id = 100';
      RETURN true;
   END beforeReportTrig;

END BIREPORTS;

you'll notice the additional where clause (whereCols - declared as a public variable) is hard coded. I'll cover parameterizing that in my next post. If you can not wait, check the 10g docs for an example.

I have my package compiling successfully in the db. Now, onto the BIP data model definition.

1. Create a new data model and go ahead and create your query(s) as you would normally.

2. In the query dialog box, add in the variables you want replaced at runtime using an ampersand rather than a colon e.g. &whereCols.

 

select     d.DEPARTMENT_NAME,
...
 from    "OE"."EMPLOYEES" e,
    "OE"."DEPARTMENTS" d 
 where   d."DEPARTMENT_ID"= e."DEPARTMENT_ID" 
&whereCols

 

Note that 'whereCols' matches the global variable name in our package. When you click OK to clear the dialog, you'll be asked for a default value for the variable, just use ' and 1=1' That leading space is important to keep the SQL valid ie required whitespace. This value will be used for the where clause if case its not set by the function code.

3. Now click on the Event Triggers tree node and create a new trigger of the type Before Data. Type in the default package name, in my example, 'BIREPORTS'. Then hit the update button to get BIP to fetch the valid functions.
In my case I get to see the following:


Select the BEFOREREPORTTRIG function (or your name) and shuttle it across.

4. Save your data model and now test it. For now, you can update the where clause via the plsql package.

Next time ... parametrizing the dynamic clause.

Categories: BI & Warehousing

What are the Long-Term Prospects for Oracle Application Express?

David Peake - Wed, 2013-10-23 13:46
This is a very common question that I’m regularly asked in one form or another. The simple answer is that Oracle is committed to the ongoing development and support of Application Express. There are a number of key factors for Oracle’s commitment including the strong community support, the continued uptake from customers, the products standing within Oracle, and the passion of the Application Express Development Team.
The main reason I believe that the future looks very positive for Oracle Application Express is that the product delivers. An ever increasing number of organizations have successfully deployed applications with exceedingly good ROI, due to the very high productivity the tool delivers for developing and enhancing applications. It is becoming increasingly important to very rapidly iterate solutions to meet the ever-changing business demands, and this is where Application Express excels.
One of the big factors leading to the popularity of Application Express is the almost evangelical community of Oracle APEX developers worldwide. The community is very active on the OTN APEX Forum. There are approximately 150 blogs listed on the ODTUG APEX Blogroll. To date there have been over 25 books published on Application Express, six of which have been published in 2013 alone. There are over 130 consulting companies who cover Oracle Application Express consulting services listed on the APEX Community and Partners application. The customer evaluation instance of Oracle Application Express, at http://apex.oracle.com, which we provide to the public, has over 18,000 workspaces and gets over 5 million page views / week.
All of these statistics only talk to the health of the community and the activity, but doesn’t address the passion. One of the great things about being an active participant in this community is how enthused and motivated the APEX community is as a whole. My job takes me around the world presenting at conferences. As such I get to interact with a large number of people, and I’m regularly taken aback by the extensive networking,  collaboration, and camaraderie amongst APEX community members.
Application Express is not generally pushed by Oracle’s sales force, and we don’t receive the same marketing, as other “for-cost” products. However, the strengths of the tool have led to sustained organic growth within a growing number of organizations. One of the windows into this is reviewing the support calls, which reveals a plethora of large well-known organizations. Since releasing the Extending Oracle E-Business Suite Release 12 using Oracle Application Express white paper there has been significant uptake within the EBS community. I regularly receive emails from Oracle Sales Consultants who want me to talk to their customer about Application Express. The email will generally say something to the effect of “Customer x has been using APEX for years and they need someone to talk to them about y”. This growth is further supported by the fact that Application Express is downloaded from Oracle Technology Network (OTN) more than 100,000 times a year.
I define “mission critical” as those applications that would have a large negative impact on business operations, productivity, or profitability should they become unavailable to the business for extended periods. I have countless examples of where supposedly “quick and dirty” APEX applications, with only a few pages and/or a small user community, have matured and are now considered critical to the business. On the other end of the spectrum, there are also more and more very large APEX deployments with sizable development communities and company-wide usage. Application Express is viewed more as a strategic development tool than a simple RAD tool for building simple Web-based applications. It is still very much a RAD tool, but gone are the days when the tool is pigeon-holed as only capable of developing spreadsheet and Access replacements. More recently a number of organizations are focusing on establishing and growing Application Express “Private Cloud” environments and communities within their organization, rather than simply building APEX applications.  Just last month at OOW, Joel Kallman and I met with Solution Architects from three different organizations about this very matter.
Why is Application Express important to Oracle? When I first started developing custom applications against the Oracle Database there was one choice – Oracle Forms. Today Oracle has a myriad of different development tools to allow developers the freedom to develop using a range of languages and tools, one of which is still Oracle Forms. Oracle Application Express is Oracle’s primary tool for developing applications with SQL and PL/SQL. For Java developers, Oracle’s primary tool is Oracle JDeveloper and Application Development Framework (ADF), but we also provide support for Eclipse and NetBeans.
The importance to Oracle extends far beyond how important it is to our customers. Oracle itself utilizes Application Express extensively to meet business requirements and improve business processes. One of the best examples available externally is the Oracle Storewhich interfaces with over 10 back-end systems. Oracle Application Express is also tightly integrated into the Oracle Database Cloud Service, whereby when you request a database service you are provided with access to the Oracle Application Express builder environment to define and deploy your applications.
Other Oracle products such as Audit Vault and Database Firewall have integrated Application Express to reduce the number of reports they need to develop. They have replaced 300 SQL based reports with 30 APEX Interactive Reports, while providing significantly enhanced capabilities to their users. Oracle Database 12c Mutitenant allows for numerous Pluggable Databases (PDBs) to be defined in a single Container Database (CDB). The Multitenant Self- Service Provisioning system provides an interface to allow for the self-service provisioning of PDBs. This system was developed in under two months, from inception to delivery of the BETA product, using Application Express.
There is an extensive range of APEX solutions available to Oracle employees. For example, the Aria People application allows employees to search our organizational hierarchy and get contact details for any employee. This application is one of the most actively used applications within Oracle with over 1.2 million page views / day. Applications Technical Services, who are responsible for customizing Oracle’s Global Single Instance (GSI), use Application Express to extend EBS and then feed the requirements back to the EBS Development team. To realize operating efficiencies when we acquired Sun it was imperative that Sun’s operations be integrated rapidly into Oracle. To help facilitate this integration a number of key APEX applications were developed.
One of the key resources for Oracle employees is our hosted internal APEX instance, http://apex.oraclecorp.com. This service has over 2,000 workspaces, with over 12,000 applications, and over 2 million page views / week. More than 20,000 distinct employees from almost every line of business in Oracle use this service regularly. There is a huge variety of applications, from simple to complex, and from limited to critical importance for that business unit. Many of these applications are built and maintained by “citizen” developers.
Since it’s improbable inception, coming out of a skunk works project within Oracle Pre-Sales, by Mike Hichwa and Joel Kallman in 1999, Oracle Application Express has continued to evolve, improving both developer productivity and application capabilities. The Application Express Development Team is very adept at analyzing trends in the IT landscape and incorporating the best attributes of these, such as HTML5 and CSS, into Application Express to ensure the tool remains modern. The continued success of the tool is largely due to this dedicated team that interacts extensively with, and genuinely listens to, the APEX community. To facilitate community input we have implemented the APEX Feature Requests application and established a Feature Advisory Board, consisting of leaders from the APEX community. The board helps us identify the most important requests to consider for upcoming releases. New versions of Application Express are released approximately once a year. We also provide numerous patch sets to ensure bug fixes are available in a timely fashion.
In conclusion, I can’t guarantee that Oracle Application Express will always continue to have the incredible popularity, inside and outside Oracle, which it enjoys today. However, the above should give you confidence that Application Express has a very solid and promising future, and that Oracle will continue to invest in the tool’s ongoing development.

I am speaking @AIOUG - SANGAM13 conference

Syed Jaffar - Wed, 2013-10-23 07:39
This post is specifically aimed to the folks back in India, mostly in Hyderabad or surrounding places.

Perhaps most of you probably knew that the All India Oracle Users Group (AIOUG) annual conference SANGAM13 will be taking place in Hyderabad this year. I have been trying my luck over the past couple of years to attend and present at least a session at the conference without a success. However, this time I determined not to miss the conference, and successfully proposed two sessions.

I am glad to inform you guys that I an able to make it to the conference this year and also delivering the following two technical sessions:

  • Oracle RAC 12c upgrade - best practices (9/11/2013)
  • Troubleshooting & Managing Clusterware - 360 degrees (9/11/2013)
Having said that, I am indeed super excited to visit Hyderabad after a very long time, as this will be my first visit to the city after almost a decade, yes, you read it correctly!. Though I belong to the same state, I couldn't get a chance to visit Hyderabad over the past 10 years or so. You guys can guess all my excitement. 

I strongly recommend and encourage all of you who live in India or Hyderabad not to miss the opportunity to attend the conference and meet with many world known Oracle Gurus, like, Arup Nanda, Gaja Krishna Vidyanatha, Murali Vallath, also many other local big shots.

For enrollment and more information about the conference, do visit the one of the following websites:


Look forward to seeing you folks at the conference.

Have a good time.

Enterprise Install of Identity & Access Management 11.1.2

Frank van Bortel - Wed, 2013-10-23 07:18
Hardware Virtual hardware added to the Database and OUD/OVD installs: an 8GB/4CPU VM. Basic Software Of course, jrockit (the 37 release, the 45 does not always work with OFM 11GR2...) and WebLogic 10.3.6. WLS 12 is not yet certified against OFM I&AM 11GR2, as far as I know. Software install Start off with I&AM software 11.1.2.1: V37472. [oracle@idm ~]$ /oracle/install/Software/OFM/Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

Excel VS BI in Financial Analysis: why the fight was over before it started

Chet Justice - Mon, 2013-10-21 19:50
by Victor Fagundo

The argument over why Businesses should abandon Excel in favor of more structured tools has been raging for as long as I have had more than a casual exposure to Oracle products. From the standpoint of an IT user Excel appears to be a simplistic, flat-file-based, error-prone tool that careless people use, despite its obvious flaws. Petabytes of duplicative Excel spreadsheets clog network drives across the globe; we as IT users know it, and it drives us crazy. Why, oh why, can’t these analysts, project managers, and accountants not grasp the elegant beauty of a centralized database solution that ensures data integrity, security, and has the chops to handle gobs of data, and abandon their silly Excel sheets?

I’ll tell you why: Excel is better. Excel the most flexible and feature-rich tool for organizing and analyzing data. Ever. Period.

For the past few years I have lived in a hybrid Finance/IT role, and in coming from IT, I was shocked at how much Excel was used, for everything. But after working with Excel on a daily basis for several years, I am a convert. An adept Excel user can out-develop any tool ( BI, Apex, Hyperion, Crystal Reports ) handily. (when dataset size is not an issue). Microsoft has done too much work on Excel, made it too extendable, too intuitive, built in so much, that no structured tool like BI, APEX, SAP, Hyperion will EVER catch up to its usability/flexibility.

Take this real-world example that came across my desk a few months ago: for a retail chain define a by-week, by-unit sales target, and create a report that compares actual sales to this target. Oh, and the weekly sales targets get adjusted each quarter based on current financial outlook.

How quickly could you turn around a DW/BI solution to this problem? What would it involve?
• Create table to house targets
• Create ETL process to load new targets
• Define BMM/Presentation Layers to expose targets
• Develop / test / publish report.

A day? Maybe? If one person handled all steps (unlikely, since the DB layers and RPD layers are probably handled by different people.)

I can tell you how long it took me in Excel: 3 hours (OBIEE driven data-dump, married with target sheet supplied to me). I love OBIEE, but Excel was still miles faster/more efficient for this task. And I could regurgitate 6 other examples like this one off at a moment’s notice.

Case in point: 95% of the data that C-level executives use to make strategic decisions is Excel based.

If you’ve ever sat in on a presentation to a CEO or other C-level executive at any medium to large sized company, you know that people are not bringing up dashboards, or any other applications. They are presenting PowerPoints with a few (less than 7) carefully massaged facts on them. If you trace the source of these numbers back down the rabbit hole, your first stop is always Excel. Within these Excel workbooks you will find “guesses” and “plugs” that fill gaps in solid data, to arrive at an actionable bit of information. It’s these “guesses” and “plugs” that are very hard to code for in an environment like OBIEE  (or any other application). Can it be done? Yes, of course, with gobs of time and money. And during the fitful and tense development, the creditably of the application is going to take major hits.

Given the above, the usefulness of OBIEE might seem bleak. But I strongly feel that applications such as OBIEE do have a proper place in the upper organizational layers of modern business: Facilitating the Tactical business layers, and providing data-dumps to the Strategic Business layers.

Since this post is mainly about Excel, I will focus on how OBIEE can support the analyses that are inevitably going to be done in Excel.

Data Formatting, Data Formatting, FORMATTING!! I can’t stress this enough. For an analyst, having to re-format numbers that come out of an export so that you can properly display them or drive calcs off them in Excel is infuriating, and wasteful.  My favorite examples: in a BI environment I worked with percentages were exported as TEXT, so while they looked fine in the application, as soon as you exported them to Excel and built calcs off them, your answer was overstated by a factor of 100 (Excel understood “75%” to be the number 75 with a text character appended, not the number 0.75).

Ask your users how they would like to SEE a fact in Excel: with decimals or not?  With commas or not? Ensure that when exported to Excel, facts and attributes function correctly.

“Pull” refreshes of information sources in Excel. In the finance world, most Excel workbooks are low to medium complexity financial models, based off a data-dump from a reporting system. When the user wants to refresh the model, they refresh the data-dump, and the Excel calculations do the rest. OBIEE currently forces a user to “push” a new data-dump by manually running/exporting from OBIEE and then pasting the data into the data-dump tab in the workbook. What an Excel user really desires is to have a data dump that can be refreshed automatedly, using values that exist on other parts of the workbook to define filters  of data-dump. Then all the user needs to do is trigger a “pull” and everything else is automated. Currently OBIEE has no solution to this problem that is elegant enough for the common Excel user. (Smartview must have its filters defined explicitly in the Smartview UI each time an analysis is pulled.)

The important part to take away from these 2 suggestions, and this entire post, is that to maximize the audience of OBIEE, we must acknowledge that Excel is the preferred tool of the Finance department, due to its flexibility, and support friendly exports to Excel as a best practice. We must also understand that accounting for this flexibility in OBIEE is daunting, and probably not the best use of the tool. If your users are asking for a highly complex attribute or fact, that is fraught with exceptions and estimations, chances are they are going to be much happier if what you give them is reliable information in a data-dump form, and allow them to handle the exceptions and estimations in Excel.
Categories: BI & Warehousing

Three Things To Do Before Starting Hadoop Project

Chen Shapira - Sun, 2013-10-20 11:45

I spent the last 6 month helping customers design, implement and deploy successful Hadoop systems. Over time, you start seeing patterns. Certain things that if the customer gets right before the project event starts increase the probability that the project will finish successfully and on-time.

Lets assume you already took the most important step – you have an actual use-case or a problem to solve, and you think  Hadoop could be the right technology to use in this case. What now?

  1. Learn how to automate production deployments: 
    Yes, Cloudera Manager would do a lot for you. But occasionally you’ll need to run the same command on 20+ servers. Thats what large clusters are all about. So get used to the idea from the beginning. Learn how to write loops in bash, how to ssh into remote machines to run commands, how to distribute files and restart services.
    You can build your own tools (I had for years), but these days you can just pick your favorite automation tool and use that instead. My favorite is Ansible. It works exactly the way I would have written a cluster automation tool, so learning it never felt like an effort and its usage is never surprising or unintuitive to me. Others prefer Puppet, Chef or Cfengine. It doesn’t matter what you use, but when I show up at your office as your Cloudera Solutions Architect and ask you to update sysctl.conf on your 50 node cluster, I don’t want you too look surprised, alarmed or tell me it will take few hours.
  2. Don’t try to boil the ocean:
    Hadoop implementation is often the first chance the dev/ops teams get to do something completely new. There is a blank slate, white sheet of paper, and you can design the perfect system. Fixing every problem the old system had and building functionality you always dreamed of.Better security!  Machine learning! Open source!
    I say – Using Hadoop successfully is a large and challenging project. Changing organizational processes and culture toward better security and processes is a large and challenging project. Creating a data driven organization is a huge project. Mixing them doesn’t give you three projects for the price of one. It isn’t even just three times more challenging than one project, I’d say the risk is an order of magnitude higher, and the risk of just implementing Hadoop is high enough. Especially in the early stages. Which brings us to… 
  3. Do a POC:
     Pay Cloudera or do it yourself. Either way, you need a POC. 
    If you start with a 12 month project, you will have to do a lot of design upfront. At a time when you have too little information. At the beginning of a large project, you won’t know for sure how the system will be used and you probably won’t know enough about Hadoop. Sure, you can call Cloudera Services and discuss the design with us, but even we can sometimes (rarely!) get things wrong. With 12 month projects you will be very deep in the project before you’ll find that limitation we completely forgot to mention.
    Be agile (really agile, 6 month project with daily scrum doesn’t count): Solve the smallest useful problem first. Implement just a single workflow, single statistical analysis, parse and search data from one source. Whatever is useful for your users – do it first. Learn in the process and build from there. This will allow you to build experience and iron-out issues at the system’s usefulness, load and importance grow.
  4. (Bonus tip) Get the most out of the POC: 
    Not all POCs are created equal. Sometimes the customer hires us to “prove that Hadoop can do X”. We get very specific requirements and very short time-frame, and we need to build a system that does X. I can see why customers need proof that their vendor can deliver. But this approach is of limited value. Because at the end of the POC you are left with a non-production system and you don’t know more Hadoop than you knew before. I love teaching, but when the attitude is “prove us this works” and the requirements are inflexible, there isn’t much time for discussions and casual learning. Most of the knowledge transfer will only happen in the delivery document, which is not the same as lively discussions.
    Better POC happens when a customer brings in Cloudera to help them build their first Hadoop project. There are still time and scope constraints, but now the POC is not about “Prove us this works” but rather “Help us make it work”. We work together as a team. We will brainstorm design possibilities with you and share best practices. We will teach you how to build the system, how to configure it and troubleshoot it. You get a chance to learn all our little tricks of development and deployment that makes life easier. At the end of the POC, your team will have real Hadoop expertise, relevant to your specific system, problems, culture, data and requirements. I see this as the best investment you can make in Hadoop for your organization. 
    But I may be a bit biased.

 


Categories: DBA Blogs

The road ahead for WebLogic 12c

Edwin Biemond - Sat, 2013-10-19 13:07
Before we can describe all the new features of WebLogic 12.1.3 & 12.1.4 and compare this to the 12.1.2 version we should first take a look at the 10.3.6 version. WebLogic 10.3.6 is still the latest 11g version but Oracle will support 10.3.6 till 2018 and extended support till 2021. So Oracle’s Fusion Apps and we have enough time to migrate to WebLogic 12.1.X. Oracle also promised that the upgrade

Oracle 12c beta exam...

Bas Klaassen - Fri, 2013-10-18 01:06
This morning I will be taking the Oracle 12c database install/admin beta exam..Hoping I am well prepared for this three hour exam...Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com6
Categories: APPS Blogs

Windows 8.1: Update via Store

Dietrich Schroff - Thu, 2013-10-17 13:25
Yesterday i did the update from Windows 8 to Windows 8.1 via Windows App Store. Here some screenshots:

The Download took more than 1 hour...
The some configurations before the reboot:
But after the reboot it took more than 15 minutes until i was able to login again. And that without any progress bar - just several messages like configuring applications and more than once percentage indicators running from 0% to 100% and then the next one...

ODI 12c is GA

Antonio Romero - Thu, 2013-10-17 10:53

Great news today, ODI 12c is GA! See the Welcome Oracle Data Integration 12c posting from Irem. Great to see the hard work from our development teams come to light. Looking forward to MUCH MUCH MORE TOO!

Happy Birthday ODI 12c!


ODI 12c is GA

Antonio Romero - Thu, 2013-10-17 10:53

Great news today, ODI 12c is GA! See the Welcome Oracle Data Integration 12c posting from Irem. Great to see the hard work from our development teams come to light. Looking forward to MUCH MUCH MORE TOO!

Happy Birthday ODI 12c!


Where are the Folder Options in Windows 2008?

Mike Rothouse - Wed, 2013-10-16 13:55
For whatever reason, I can never remember where the Folder Options tabs are located in Windows 2008.  Adding a note here for future reference.  The same applies for Windows 7. Go to Control Panel / Folder OptionsFiled under: Microsoft, Windows OS Tagged: folder options, folder options 2008

iPod Classic Adventures

Mike Rothouse - Tue, 2013-10-15 20:35
Every couple of months, my daughter comes home with some new challenge for me to resolve with her iPod Classic.  I thought resetting the iPod would solve just about anything she could possibly do to inhibit the normal function of the device.  That is until she decided to set a passcode and promptly forgot what […]

October 2013 Critical Patch Update Released

Oracle Security Team - Tue, 2013-10-15 14:42

Hello, this is Eric Maurice.

Oracle today released the October 2013 Critical Patch Update.  As previously announced, this Critical Patch Update is the first one to integrate Java SE.  In other words, moving forward planned security fixes for Oracle products, including Java SE, will released on the same schedule.  As a result, the average number of fixes delivered through each future Critical Patch Update is, at least for the foreseeable future, likely to be greater than in previous Critical Patch Updates.   As an additional reminder, Oracle publishes the release dates of future Critical patch Updates a year in advance.  The release dates for the next 4 Critical Patch Update releases are located on the Security Alerts and Critical Patch Updates page at http://www.oracle.com/technetwork/topics/security/alerts-086861.html.

Today’s Critical Patch Update provides 127 new security fixes across a wide variety of product families including:  Oracle Database, Oracle Fusion Middleware, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite, Oracle Supply Chain Products Suite, Oracle PeopleSoft Enterprise, Oracle Siebel CRM, Oracle iLearning, Oracle industry Applications, Oracle FLEXCUBE, Oracle Primavera, Oracle Java SE, Oracle and Sun Systems Products Suite,  Oracle Linux and Virtualization, and Oracle MySQL.

Out of these 127 new fixes, 2 are specifically for Oracle Database.  The maximum CVSS Base Score for the database vulnerabilities is 5.5.  One of these database vulnerabilities has already been fixed in all supported version and platform combinations.  The other vulnerability is remotely exploitable without authentication.  Fixing this second vulnerability requires that customers configure network encryption between their clients and servers if data is sent over untrusted networks.   Note that Oracle recently updated its licensing agreement so that network encryption (native network encryption and SSL/TLS) and strong authentication services (Kerberos, PKI, and RADIUS) are no longer part of Oracle Advanced Security and are available in all licensed editions of all supported releases of the Oracle database.  Finally note that 2 Oracle Fusion Middleware fixes are applicable to database deployments and as such are listed in the Database Risk Matrix of the Critical Patch Update advisory.

Out of these 127 fixes, 51 are for Java SE.  50 of the Java SE vulnerabilities fixed in this Critical patch Update are remotely exploitable without authentication.  The maximum CVSS Base Score for these Java SE vulnerabilities is 10.0, which denotes a complete takeover of the targeted system (down to the operating system) in instances where Java executes with administrative privileges (i.e. system privileges).  Out of these 51 Java vulnerabilities, only 8 are applicable to client and server deployments of Java.  40 apply to client deployment of Java, including one which is only exploitable during Java client deployment.  One of the vulnerabilities applies to the JHat developer tool.  The last 2 vulnerabilities apply to sites that run the Javadoc tool as a service.   For more information about these Java vulnerabilities, see the security matrix for Java SE located on the Critical Patch Update Advisory.

As a reminder, desktop users can leverage the Java Autoupdate or visit Java.com to ensure that they are running the most recent version of Java.  Java SE security fixes delivered through the Critical Patch Update program are cumulative.  In other words, running the most recent version of Java provides users with the protection resulting from all previously-released security fixes.   Oracle strongly recommends that Java users, particularly home users, keep up with Java releases so as to protect themselves against malicious exploitation of Java vulnerabilities. 

This Critical Patch Update release also provides 17 security fixes for Oracle Fusion Middleware, 12 of which are for vulnerabilities which are remotely exploitable without authentication.  The maximum CVSS Base Score for these Fusion Middleware vulnerabilities is 7.5. 

4 new security fixes are for Oracle Enterprise Manager Grid Control.  All of these Enterprise Manager Grid Control vulnerabilities are remotely exploitable without authentication, and the maximum CVSS Base Score for these vulnerabilities is 4.3.

This Critical Patch Update release also provides 22 new security fixes for Oracle applications as follows: 1 for Oracle E-Business Suite, 2 for Oracle Supply Chain Products Suite, 8 for PeopleSoft Enterprise, 9 for Siebel CRM, and 2 for iLearning.  It furthermore provides 6 new security fixes for Oracle Industry Applications and 1 for Oracle Financial Services Software.  

Finally, this Critical Patch Update delivers 12 new security fixes for the Oracle and Sun Systems Products Suite.   5 of these vulnerabilities are remotely exploitable without authentication.   The maximum CVSS Base Score for these vulnerabilities is 6.9.

As usual, Oracle recommends that this Critical Patch Update be applied as soon as possible.  To a large extent, maintaining a proper security posture requires that organizations keep up to date with Oracle’s security patches and supported releases so as to take advantage of Oracle’s ongoing security assurance effort. 

For More Information:

The Critical Patch Updates and Security Alerts page is located at http://www.oracle.com/technetwork/topics/security/alerts-086861.html

The Advisory for the October 2013 Critical Patch Update is located at http://www.oracle.com/technetwork/topics/security/cpuoct2013-1899837.html

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

Desktop users can make sure they run the most recent version of Java by visiting http://java.com/en/download/installed.jsp.

RTO and RPO

Mike Rothouse - Mon, 2013-10-14 14:17
What is the difference between Recovery Time Objective (RTO) and Recovery Point Objective (RPO)?  That was a question that came up recently in a disaster recovery discussion.  Good explanation provided by Dejan Kosutic’s Blog entry. In summary: Recovery Time Objective (RTO) is “target time set for resumption of product, service or activity delivery after an incident”. […]

Pages

Subscribe to Oracle FAQ aggregator