Feed aggregator

Oracle Java Cloud Service

Anshu Sharma - Fri, 2014-09-26 11: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 


ODAC 12c Release 3 Beta now available

Christian Shay - Fri, 2014-09-26 11: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.

Oracle Openworld SF .NET and Windows Sessions

Christian Shay - Fri, 2014-09-26 11: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!

Latest OAM certified against EBS

Frank van Bortel - Fri, 2014-09-26 04:22
OAM 11.1.2.2 certified EBS This blog entry shows OAM 11G Rel 2 PS2 (a.k.a. 11.1.2.2.0) is certified against the Oracle e-Business suite 11 and 12 as of February 2014. Just in case you missed it, like me. Oracle e-business and SSO using OAMThe blog entry also references a series of articles on how to do e-Business Suite SSO using OAM.Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

Database Links

Tim Dexter - Thu, 2014-09-25 14:39

Yeah, its been a while, moving on ...

I got a question a week back asking about how BI Publisher could handle dblinks. The customer currently has db links from DB1 to DB2 and uses them in their queries. Could BIP handle the syntax and pass it on to the database in its SQL or could it handle the link another way?

select e1.emp_name
, e1.emp_id
,e2.manager
from emps e1
, emps@db2 e2
where e1.manager_id = e2.id

Well, there is the obvious way to create the join in BIP. Just get rid of the db link alttogether and create two separate database connections (db1 and db2). Write query A against db1 and query B against db2. Then just create a join between the two queries, simple.

 But, what if you wanted to use the dblink? Well, BIP would choke on the @db2 you would have in the sql. Some silly security rules that, no, you can not turn off if you want to. But there are ways around it, the choking, not the security. Create an alias at the database level for the emp@db2, that way BIP can parse the resulting query. Lets assume I create an alias in the db for my db linked table as 'managers'. Now my query becomes:

select e1.emp_name
, e1.emp_id
,e2.manager
from emps e1
, managers e2
where e1.manager_id = e2.id

 BIP will not choke, it will just pass the query through and the db can handle the linking for it.

Thats it, thats all I got on db links. See you in 6 months :)




Categories: BI & Warehousing

ODI 12c - Migrating from OWB to ODI - PLSQL Procedures

Antonio Romero - Thu, 2014-09-25 12:42

Check the blog post below for supporting PLSQL procedures within ODI and how you can get 100s of percentage fold improvements; 

https://blogs.oracle.com/dataintegration/entry/odi_12c_migrating_from_owb

Cheers
David 

ODI 12c - Migrating from OWB to ODI - PLSQL Procedures

Antonio Romero - Thu, 2014-09-25 12:42

 

Check the blog post below for supporting PLSQL procedures within ODI and how you can get 100s of percentage fold improvements; 

https://blogs.oracle.com/dataintegration/entry/odi_12c_migrating_from_owb

Cheers
David 

Drinks! Food! Fun! at the My Oracle Support Monday Mix Event at OpenWorld San Francisco

Chris Warticki - Thu, 2014-09-25 10:00
Join us for a fun and relaxing happy hour at the annual My Oracle Support Monday Mix. This year’s gathering is Monday, September 29th from 6:00 to 8:00 p.m. at the ThirstyBear Brewing Company – just a 3 minute walk from Moscone Center.

After a busy day at Oracle OpenWorld, take a break and unwind with your peers. Stop by and get to know the Oracle Support Engineers you depend on as well as key Oracle Support executives and developers over drinks and hors d’oevres. 

Admission is free for Premier Support customers with your Oracle OpenWorld badge. Visit our website for more details. We’ll see you there!

Visit the Support and Services Oracle OpenWorld website to discover how you can take advantage of all Oracle OpenWorld has to offer.


.htmtableborders, .htmtableborders td, .htmtableborders th {border : 1px dashed lightgrey ! important;} html, body { border: 0px; } body { background-color: #ffffff; } img, hr { cursor: default }


 

Focus on Accounting Hub at Oracle OpenWorld

David Haimes - Thu, 2014-09-25 00:27

This is number three in my Focus on Oracle OpenWorld Series and this one is in on my home turf, it was the talk of Las Vegas earlier this year at Collaborate.  I have explained the difference between Fusion Accounting Hub and Financial Accounting Hub before, but now we have the Accounting Hub Reporting Cloud Service.  I’ll be talking about this briefly in the OAUG GL SIG meeting and there is also a session from my boss, Rob Zwiebach that will cover it (spoiler alert, we might use some of the same slides), but he will also have Alex from our internal finance org to give talk about their experience running the accounting hub for the last few years.  Rob’s session details are below:

Introducing Oracle Fusion Accounting Hub Reporting Cloud Service [CON8404]

Existing Oracle E-Business Suite customers now have an out-of-the-box coexistence strategy. With Oracle Fusion Accounting Hub Reporting Cloud Service, you can have the power of Oracle Fusion Reporting in the cloud. This session explains the benefits and details of Oracle Fusion Accounting Hub Reporting Cloud Service.

Alex SanJuan – VP Finance, Oracle
Rob Zwiebach, VP Financial Application Development, Oracle

Tuesday, Sep 30, 4:45 PM – 5:30 PM – Westin Market Street – Metropolitan II
I already have a number of customer meetings lined up to discuss accounting hub and a few more I’m trying to squeeze in, so it is shaping up to be an exciting new chapter for the Accounting Hub.


Categories: APPS Blogs

Extending EBS R12.1 and above using APEX White Paper Released

David Peake - Wed, 2014-09-24 17:46
Extending Oracle E-Business Suite Release 12.1 and above using Oracle Application Express Revision 2 has just been released. 

This paper is a major revision which now includes certification for Oracle E-Business Suite Release 12.2 and also an alternate database architecture using Oracle Database links. You can download the paper from OTN: http://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-ebs-extension-white-paper-345780.pdf





Wireshark hanging on Windows 8.1 at startup

Dietrich Schroff - Wed, 2014-09-24 14:09
After upgrading Windows 8 to Windows 8.1 my wireshark freezed on every startup without showing up the main window.
The only workaround was to deinstall wireshark including wincap and installing it again. But after the nex reboot, it freezed again.

After searching around i found the following fix, with cured this problem:

inside the registry you have to change the DWORD start in
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\npf

from 0 or 1 to 2. After that wireshark will start properly even after reboots....

Another possible solution are to issue these commands as administrator:
sc start npf
sc config npf start= delayed-auto

Top 7 Reasons Why Oracle Conferences Rock!

This page has been permanently moved. Please CLICK HERE to be redirected.

Thanks, Craig.Top 7 Reasons Why Oracle Conferences Rock!
Why take the time and make the effort to attend an Oracle database conference or Oracle user group meeting? We're all busy, so there had better be some super good reasons to make the effort! For me, the benefits definitely exceed the cost.

There are many different conferences to choose from. There are professional conferences, leadership conferences, scientific conferences and business focused conferences. So why an Oracle Database conference? What's the big deal?

This is difficult for me to explain, so I've summarized why I love Oracle conferences into a "Top 7" list.

Number 7. Get free stuff from vendors
I suspect 50% of Oracle DBAs attend conferences because they love getting free stuff. If you want to maximize the good stuff, timing is everything. Get to the booth when the exhibition hall first opens, because vendors have tons of stuff to give away and they are full of energy. Also, just before the exhibition hall closes on the final day show up again. Vendors are tired and want to get rid of as much stuff as possible... and you just happen to be there!

Number 6. Become known in your industryIf you want to focus and excel in your career in a particular area, then pass on what you know. If you hold on to what you learn, no one will know you're an expert but you... and that's lonely. One of the best ways to become known and enjoy conferences is to speak at them. If this is something you want to do, please email me. I'll mentor you. I'm serious.

Number 5. Talk to others, if you want toWant to talk with people who care about Oracle technology as much as you do? Conferences are a great way to break out of your rut and think... and if you want to talk. One of the reasons I like conferences is it gives me a chance to meet with past students.

Number 4. Learn, if you want to
There are always opportunities to learn at conferences. How many times have I heard someone say they were in a lame session. But when I ask if they read the abstract first, they say no. If you want to increase your chances of attending great sessions, read the abstract. Second, look for speakers you like. Third, sit next to the door just in case you need to make a quick exit! The worst you can do is look at the agenda and pick the sessions you want to attend. Do a little research and you'll be surprised how many good sessions there are.


Number 3. Be inspired!How many places can you go to receive inspiration? Not many, is my answer! Because I can chill for a bit at conferences, observe what's going on in our industry and interact with a wide variety of people associated with Oracle technology, I tend to leave with a fresher and more refined view... or better said, "A Wider View." That in itself is worth the cost of any conference.

Number 2. Network with vendors, speakers, colleagues
I take it one step at a time. I always cruise the exhibition halls looking for new products and touching base with the vendors I know. Personally, I like to encourage the new vendors because it is a massive investment for them to exhibit. When I'm cruising, that's where I typically reconnect with students and other DBAs. It's a more comfortable and relaxing environment for me. If you want to speak with an expert face-to-face, a conference is a natural place to do this. If someone walks up to me with an AWR report, I'll make time for them. If they email me the week before, I'll do whatever I can to schedule some time with them.

Number 1. Be with friends
This one is personal. When I'm teaching or consulting, it's very intense and compressed. But at conferences, I get a chance to unwind, sit back, have a beer, and talk. I'm really involved with the IOUG conference and each year I look forward to reconnecting with this small group of friends. It's such a good feeling to be with "Oracle friends" without having to talk... about Oracle. I can just sit and listen without anyone wondering... What's wrong with Craig? You can do the same thing. Find an Oracle user group and volunteer.

Why Attend? Because Oracle conferences rock!There you have it. Seven reasons why Oracle conferences and Oracle User Groups rock! If you're not planning to attend any, you're missing a great way to connect, advance your career, and have a lot of fun. See you there!!

All the best in your Oracle performance work!

Craig.




Categories: DBA Blogs

Behind the Screen with Oracle Support at OpenWorld San Francisco

Chris Warticki - Wed, 2014-09-24 11:40
Get beyond the support interface screen to meet the experts from Oracle Support at the Oracle Support Stars Bar. Have a tough question about supporting or upgrading your Oracle products? Looking for best practices for problem prevention, rapid resolution, and product upgrades? Stop by the Stars Bar and speak directly with an expert who can help.

While you’re there, check out one of our 10-minute briefing sessions on the hottest support topics. Here are just a few of the high-impact briefings you can see at this year’s Stars Bar:
  • Proactive Support Best Practices
  • Oracle Platinum Services
  • My Oracle Support Tips & Tricks
  • And many more!


The Support Stars Bar is open Monday, Tuesday and Wednesday in the Moscone West Exhibition Hall (Booths 3461 and 3908). More details here.

Visit the Services and Support Oracle OpenWorld Website to discover how you can take advantage of all Oracle OpenWorld has to offer.

See you there!

Why the In-Memory Column Store is not used (I)

Karl Reitschuster - Wed, 2014-09-24 11:17

yuuupie!

Now finally after a long period of waiting - and looking presentations and reading blogs I was able to do In-Memory databasing on my own. Having sampled some theoretical background how a a pure In-Memory Db works with SAP HANA; my expectations on the Oracle In-Memory Option were high. Also because Oracle promised it would work without code change, out of the box.

The setup

The Oracle database is located on Sun Solaris Machine with enough memory and 32 Xeon-Cores; The Memory Pool is sized 64G, compared to the rest of the SGA , buffer cache , shared_pool ... 4G, and 300G of data.

My Data Model Checklist book is now available in Spanish – Just in time for #OOW14!

Galo Balda's Blog - Wed, 2014-09-24 10:34

The Data Warrior

Exciting news!

I just got this email from Amazon:

Congratulations, your book “UNA LISTA DE VERIFICACIÓN PARA REALIZAR REVISIONES A LOS DISEÑOS DE MODELOS DE DATOS” is live in the Kindle Store and is currently enrolled in KDP Select. It is available for readers to purchase here.

If you are in Mexico, you can get the book here.

If you are in Spain, you can get it here.

Now, truth is I do NOT speak, read or write Spanish. But my good friend, and Oracle expert, Galo Balda does!

I am very grateful to Galo for putting in the effort to translate my little book so other data professionals around the world could read it in their native language.

You can (and should) follow Galo on Twitter, and on his personal blog in either English or Spanish.

BTW – Galo is speaking at OOW14 too…

View original post 36 more words


Filed under: Uncategorized
Categories: DBA Blogs

Access Management Alternatives (Part II): OpenDJ for LDAP, EUS and TNSNames

Frank van Bortel - Wed, 2014-09-24 05:43
Directory Service: OpenDJ Installation has been described in a previous part. The question now is to make OpenDJ Oracle compatible, so that it can be used with EUS and TNS names resolution. In fact, I want to be able to install and use TNS Name resolution and Enterprise User Security (EUS) as done before. Clues One clue was already mentioned, the appearance of $ORACLE_HOME/config/EUS/Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

Private Storage

Frank van Bortel - Wed, 2014-09-24 05:20
Just a little project I just happened to be upgrading my workstation, and was left with some spare parts. I had some memory modules, an old P5 motherboard, and several AT-style enclosures. Also, I noticed my trusty Synology Diskstation began needing some larger disks. Or maybe it was time to replace it all together? Keeping up indexing my music and photos seems to become quite a daunting task, Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

Focus on User Groups at Oracle OpenWorld

David Haimes - Tue, 2014-09-23 08:22

Anyone who reads my blog regularly might be tired of me praising user groups, but I believe it is worth repeating myself.  The type of information sharing you get from user groups is unique and very valuable, it is important for Oracle to support that, be aware of it, but not interfere.  I have been involved with the Oracle Apps User Group via the GL SIG for several years now but I will never push my agenda, I listen, provide information or presentations that are requested and I learn.  Many of my colleagues will tell you the same.  So Sunday is User Group day at OpenWorld and I look forward to seeing a lot of familiar faces and learning something new.  I have a bit of a schedule crunch this year, 12 months ago I committed to run the 5k “Dolphin Dash” School fundraiser with my 8 year old son, I didn’t think for a minute it would fall on the same date as OpenWorld.  So I have to run a 5k at 9am and then dash into San Francisco to present at the GL SIG for 11am, if I arrive in my running gear, still sweating please accept my apologies.  I will stay around for more of the sessions and always I will be active on twitter, so you can find me that way too.

At the GL SIG I’ll be talking about and briefly showing the new Accounting Hub Reporting Cloud Service, which I am very excited about.  You will also hear from Lakshmi Sampath from Dell about SLA on their upgrade to R12.  The full agenda is below, I hope to see a lot of you there.

—————————————————————————————–

Agenda GL-SIG @ OpenWorld 2014 on Sunday, September 28th, 11.00am
Location – Moscone W – 3005

Agenda

  1. Introduction to the SIG
  2. Proactive support presentation
  3. Sponsor message (Excel4Apps)
  4. Lakshmi (SLA on Upgrade @ Dell)
  5. David Haimes new Accounting Hub Cloud Reporting Service
  6. Open questions

We will be joined by our Oracle colleagues to tell us about ProActive support and their leading practices to deliver content and help to the Oracle user community.
Excel4Apps will be helping us by sponsoring the meeting at this conference.

In the past many oracle apps customers have looked elsewhere for their reporting needs – until now – see a preview of “Accounting Hub Reporting Cloud Service”. See how many finance users are using their favorite tools for reporting – Smartview, Cubes, and related functionality to get their financials.  Fusion Account Hub Reporting Cloud Service is a new subscription service provides out of the box integration with EBS R12 General Ledger for reporting.  This session will provide an introduction to the new service, how it connects, works with EBS data, the reporting capabilities available and what it does and does not support.  Come listen to David Haimes, Senior Director, Financials Product Development t alk about the new service.

Hear what Lakshmi Sampath from Dell has to say about their upgrade to R12. The presentation covers the R12 Upgrade Case-Study at Dell providing details on what happens during upgrade to R12 in various subledgers (PO, AP, AR, PA, FA) with respect to SLA. This presentation will also provide details on strategies for data conversion to SLA model during upgrade, and cover critical lessons learned during the upgrade @ DELL.

—————————————————————————————–

 


Categories: APPS Blogs

OED 12c

Nuno Souto - Tue, 2014-09-23 03:51
Yeah...    Aka: Oracle Enterprise Damager... For those who might not know - yes indeed, a few of the so-called "cognoscenti" are not all-knowing! - we've been engaged in using grid control to monitor all our db servers for quite a while. That's both MSSQL and Oracle RDBMS servers.  For 4 years now! In a nutshell and to cut a very long story short:  - we started with 10g.  The lesser said Noonshttp://www.blogger.com/profile/04285930853937157148noreply@blogger.com2

OOW - Focus On Support and Services for Siebel CRM

Chris Warticki - Mon, 2014-09-22 09:00
 
Thursday, Oct 02, 2014

Conference Sessions

Customer Success Story: State of Michigan, MAGI Case Study
Beth Long, Project Manager, Cgi Technologies and Solutions Inc.
Sue Doby, Senior Director, Public Sector Consulting, Oracle
9:30 AM - 10:15 AM Marriott Marquis - Salon 1/2/3* CON2747
Best Practices for Maintaining Siebel CRM
PREM Lakshmanan, Senior Director Customer Support, Oracle
Iain Mcgonigle, Senior Director, Customer Support, Oracle
12:45 PM - 1:30 PM Moscone West - 3009 CON8314
  
My Oracle Support Monday Mix

Monday, Sep 29

Join us for a fun and relaxing happy hour at the annual My Oracle Support Monday Mix. This year’s gathering is Monday, September 29 from 6:00 to 8:00 p.m. at the ThirstyBear Brewing Company – just a 3 minute walk from Moscone Center. Admission is free for Premier Support customers with your Oracle OpenWorld badge. Visit our web site for more details: http://www.oracle.com/goto/mondaymix 6:00 PM - 8:00 PM ThirstyBear Brewing Company
Oracle Support Stars Bar & Mini Briefing Center

Monday, Sep 29

Ask the stars of Oracle Support your toughest questions, learn about proactive support tools and advanced support offerings, and win a prize at one of our 10-minute mini-briefings where you are sure to leave with valuable tips and best practices based on our experience supporting Oracle customers around the globe. 9:45 AM - 6:00 PM Moscone West Exhibition Hall, 3461 and 3908

Tuesday, Sep 30

Ask the stars of Oracle Support your toughest questions, learn about proactive support tools and advanced support offerings, and win a prize at one of our 10-minute mini-briefings where you are sure to leave with valuable tips and best practices based on our experience supporting Oracle customers around the globe. 9:45 AM - 6:00 PM Moscone West Exhibition Hall, 3461 and 3908

Wednesday, Oct 01

Ask the stars of Oracle Support your toughest questions, learn about proactive support tools and advanced support offerings, and win a prize at one of our 10-minute mini-briefings where you are sure to leave with valuable tips and best practices based on our experience supporting Oracle customers around the globe. 9:45 AM - 3:45 PM Moscone West Exhibition Hall, 3461 and 3908

To secure a seat in a session, please use Schedule Builder to add to your Schedule.

Pages

Subscribe to Oracle FAQ aggregator