Feed aggregator

Oracle Database Developer Choice Awards

Denes Kubicek - Wed, 2015-09-23 00:28
Don't forget to vote for the expert of your choice at https://community.oracle.com/community/database/awards. There are a lot of good men there deserving your voice for their activities in the community and for their selfless engagement.

Categories: Development

HCM Cloud Support Resources

Chris Warticki - Tue, 2015-09-22 16:05
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

First and ALWAYS – the #1 investment is made in the PRODUCT, PRODUCT, PRODUCT.

Remain a student of the product.

1. HCM Cloud PRODUCT Information Page

2. HCM Cloud Documentation Learning Center

3. Get trained on the PRODUCT – HCM Cloud

4. Oracle Learning Library

a.HCM Cloud Library

Personalize My Oracle Support Experience

1. Setup Proactive Alerts and Notifications

2. Customize your MOS Dashboard

3. Remain in the Know – Subscribe to Cloud and HCM Newsletters

Collaborate. Communicate. Connect

1. Oracle Mobile App – News, Events, Mobile MOS, Videos etc

2. Applications Customer Connect

3. My Oracle Support Community

a. Fusion HCM Cloud Community

b. Human Capital Management (HCM)

c. Taleo Knowledge Community

d. Taleo Enterprise

e. Taleo Business

f. Taleo Learn

SOCIAL Circles of Influence

1. Oracle HCM

2. Oracle Cloud Zone

3. Taleo

4. HCM Talk Radio (Podcasts)

5. Cloud Café (Podcasts)

Engage with Oracle Support

1. Upload ALL reports if logging a Service Request

2. Leverage Oracle Collaborative Support (web conferencing)

3. Better Yet – Record your issue and upload it (why wait for a scheduled web conference?)

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

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Calibri","sans-serif"; mso-bidi-font-family:"Times New Roman";}

4. Request Management Attention as necessary


/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Calibri","sans-serif"; mso-bidi-font-family:"Times New Roman";}

Time to Vote for Oracle Database Developer Choice Award Winners!

OTN TechBlog - Tue, 2015-09-22 13:15

The Oracle Database Developer Choice Awards celebrate and recognize technical expertise and contributions in the Oracle Database community. As longtime and new users of Oracle Database move to the Cloud and take advantage of this exciting new architecture, community experts will play a critical role in helping them succeed.

Panels of (mostly) Oracle ACE judges have now selected their finalists, and the time for public voting has begun! From 15 September to 15 October, we call on all members of the Oracle Database developer community to check out the finalists for each of these categories:

The winners of the Oracle Database Developer Choice Awards will be announced at the YesSQL! Celebration during Oracle OpenWorld 2015.

This is your chance to have your say in the community, and help reward great contributors who build up the Oracle Database developer community.

Read the official rules

Oracle Database Developer Choice Awards FAQ

Licht Is Uit? eProseed Shines the Light on IoT and Design Patterns with TopCasuS

Usable Apps - Mon, 2015-09-21 04:27

At the Oracle government and innovation event held in Rotterdam in the Netherlands, Oracle partner eProseed demoed a public sector solution that brought together the Internet of Things (IoT) and Activity Based Working (hat tip: Erik Veldhoen [@erikveldhoen]) to enhance business processes for customers: TopCasuS.  Oracle Applications User Experience design patterns and guidance helped eProseed to build a great solution in a productive and consistent way. eProseed NL managing partner, Lonneke Dikmans (@lonnekedikmans) explains more.

Overheid en Innovatie

Tijdens de Oracle Overheid en Innovatie beurs liet eProseed met hun oplossing voor gemeenten en centrale overheid zien hoe je met behulp van Internet of Things (IoT) bedrijfsprocessen kan optimaliseren en verbeteren. TopCasuS is gebaseerd op Gemma 2.0 principes en het concept ‘activity based working’. Dit betekent dat de gebruiker toegang heeft tot de juist informatie op het juiste moment.

TopCasuS UI using Oracle Alta UI

TopCasuS gebruikt Oracle Alta UI 

Op dit moment zijn de volgende modules beschikbaar:

  • Sociaal domein. Enterprise-grade oplossing voor gemeenten die hen ondersteunt bij het uitvoeren van de drie decentralisaties;
  • Openbare ruimte. Module die gemeenten helpt de openbare gemeente schoon, heel en veilig te houden;
  • Shared services. Module voor gemeenten die fuseren of een shared service aan het inrichten zijn.

Licht Is Uit

De openbare ruimte wordt niet alleen schoon, heel en veilig gehouden met behulp van regulier onderhoud, maar ook door te reageren op meldingen. De meldingen kunnen worden gedaan door burgers via een app of the gemeentelijke website, door ambtenaren en ketenpartners en door gebruik te maken van IoT technieken.

Luc and Lonneke demo at the event

Lonneke en Luc op het evenement met Licht Is Uit

Tijdens het evenement demonstreerden ze het volgende scenario:

  1. Een lichtsensor in een fietstunnel meet de hoeveelheid licht in de tunnel. Mensen voelen zich veilig in een verlichte tunnel. 
  2. Als de tunnel donker is, bijvoorbeeld omdat het licht stuk is, wordt een notificatie verzonden naar het meldingen buitenruimte proces. 
  3. De ambtenaar die verantwoordelijk is voor het gebied van de fietstunnel ontvangt een notificatie dat er een nieuwe zaak is gestart en hij pakt deze op, op dezelfde manier als wanneer een burger of college de melding gedaan zou hebben.

English Language Version

The eProseed TopCasuS solution is based on Gemma 2.0 principles and Erik Veldhoen's (@erikveldhoen) concept of Activity Based Working. This means that the user has access to the right information at the right time. Right now, the following modules are available:

  • Social services. Enterprise grade solution for municipalities (Dutch local government) to support the implementation of new laws about youth care, work, and decentralized social support.
  • Public domain. Module to help municipalities to keep public services and the environment safe, clean, and working properly.
  • Shared services. Module to support municipalities when merging and when they need to implement shared services.

Licht Is Uit (Light Is Out) Demo

Keeping public areas safe, clean, and working properly is carried out by regular servicing, but also by the local authority's reaction to the prompt notifications of issues with their services. These notifications can be triggered by a citizen reporting an issue using a mobile app or a website or by a local authority employee or contractor noticing an issue. But now it can also be reported automatically using the IoT. At the Rotterdam event, eProseed NL CTO and managing partner Luc Bors (@lucb_) demoed with Lonneke how sensors detect an issue and let the local authority know about a problem:

  1. A sensor in a bike tunnel measures the amount of light in the tunnel. Pedestrians and cyclists can go safely through the tunnel.
  2. If a light bulb in the tunnel fails, or something else causes the tunnel to become dark, the sensor detects the change in lighting conditions and a notification is automatically sent to the local authority, creating a new case in their service system.
  3. The local authority employee responsible for the tunnel maintenance receives a notification that a new case has been started, can then assess the situation and process it, just as if a citizen had filed the issue. 

Watch out for more solutions that partners can build productively with reusable UX design patterns and Oracle technology and for demos of the solutions at an event near you soon.

Read more about our eProseed UX enablement event in Utrecht, too.  

ORA-01917: user or role 'PDB_DBA' does not exist

Pakistan's First Oracle Blog - Sat, 2015-09-19 01:42
I manually created a container database (CDB) 12.1.0.2.0 in my Linux 6.4 based virutal machine. After creating it, I tried to create a pluggable database but got following error:




SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
cdbtest          OPEN

1 row selected.

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> select * from cdb_pdbs;

    PDB_ID
----------
PDB_NAME
--------------------------------------------------------------------------------
      DBID    CON_UID GUID                             STATUS    CREATION_SCN
---------- ---------- -------------------------------- --------- ------------
       VSN LOGGING   FOR FOR     CON_ID
---------- --------- --- --- ----------
         2
PDB$SEED
3972600152 3972600152 201432B4FDA10CEBE0530900000AFE92 NORMAL             213
 202375680 LOGGING   NO  NO           2

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
cdbtest          OPEN

1 row selected.

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> select * from cdb_pdbs;

    PDB_ID
----------
PDB_NAME
--------------------------------------------------------------------------------
      DBID    CON_UID GUID                             STATUS    CREATION_SCN
---------- ---------- -------------------------------- --------- ------------
       VSN LOGGING   FOR FOR     CON_ID
---------- --------- --- --- ----------
         2
PDB$SEED
3972600152 3972600152 201432B4FDA10CEBE0530900000AFE92 NORMAL             213
 202375680 LOGGING   NO  NO           2

So I tried with different options, but it always gave that error about PDB_DBA role. Searching the MOS, presented document.

This Document states that if we create a CDB manually we need to get from DBCA because we might have omit some options. CDB and PDB needs to be installed with all the options. I created CDB manually in first place because I had low disk space in my virtual machine, and I was intending to use all the options.

So if you get that error, the solution is to either create database through DBCA.
Categories: DBA Blogs

How to View Field Service Task Information

Joshua Solomin - Fri, 2015-09-18 12:23
If you have a Service Request (SR) that requires hardware replacement or a visit from a hardware support engineer, your SR will have "Field Service Tasks" associated with it. These tasks can be viewed in My Oracle Support as outlined below.

NOTE: If you have Services or MICROS products that require part replacement, you will need to switch to the My Oracle Support Portal to view the field tasks in the SR. (reference A).

1. In My Oracle Support, locate the SR region on the Dashboard or click the Service Request tab and locate your Service Request (reference B).

2. Open the desired Service Request, then click on the Field Service Tasks link (reference C) on the right hand side of the screen under the Summary section. A list of associated Tasks will display (reference D).

3. Click on the desired Task Number for details about that Task. The Task information is displayed and can be sorted using the Sort By drop down menu (reference E).

For additional tips on Service Request management view the My Oracle Support 'How-to' Series (Doc ID 1544005.2).

Selling Books on Amazon vs. Intelivideo

Bradley Brown - Thu, 2015-09-17 21:44
For the last couple of years I've heard that publishers don't like selling their books through Amazon.  The way I heard it described sounded like Amazon was forcing (or pushing) you to sell books for under $10.  It's actually pretty complicated as to how their pricing works, so I've attempted to simplify for you here.  If you want the details, you can read more here:

https://kdp.amazon.com/help?topicId=A301WJ6XCJ8KW0

Basically you have to pick which plan you’re on.  The 35% or 70% royalty plan.  At first glance, you would ask - why would anyone pick the 35% royalty plan?  Let's see, you do all of the research, write the book, take a book through 5 edits and get it to the point of publishing and Amazon is going to keep 35 "or" 70% of the revenue generated?  Logically who would say they only want to keep 35%?  It's more complicated - i.e. strings are attached to each choice.

If you pick the 70% royalty plan, you keep as much as 70% (minus delivery costs and with about 100 other rules) of whatever they sell it for.  But according to the small print, on a number of your sales, you’ll actually keep 35% of whatever they sell it for.  Here's the real kicker - if you want to keep 70% (minus delivery costs, VAT, etc), they force you to set the list price to $2.99 to $9.99 AND by the way they will keep 65% if they sell it in other countries, etc.  If you choose the 35% royalty plan (keep in mind, they are are keeping 65%), you can set the price between $2.99 and $200.  You can sell it for less than $2.99 (i.e. down to $.99) if you have a small book (i.e. less than 10Mb footprint).  They also say that the list price must be at least 20% below the lowest physical list price for the physical book.  Wow - SO many rules!

So Amazon charges (keeps) 30% (minus delivery costs) to 65% (and it’s usually this amount) and has minimum and maximum prices you can charge and a lot of rules AND it’s Amazon’s customer (not yours).

The 2 pricing options are explained (and tough to understand) here:

https://kdp.amazon.com/help?topicId=A29FL26OKE7R7B

And their FAQ is here:

https://kdp.amazon.com/help?topicId=A30F3VI2TH1FR8

We're soon to release (secure) eBook functionality at Intelivideo.  So how does it work?  If you pick the Pro Plan, you keep 85% of the revenue and you can set the price to whatever price you want.  We have some other fine print, but overall I can assure you that our pricing is WAY better than Amazon's offer - and it's your customer.  You can sell them more products.  You can do promotions to them.  You can upsell them.  I'm shocked by Amazon's model and now understand the frustration others have!

Oracle Priority Service Infogram for 17-SEP-2015

Oracle Infogram - Thu, 2015-09-17 16:41

OpenWorld

OpenWorld is coming up soon, and articles on how to get the most of it are starting to fill the blogosphere. Here’s one from The Data Warehouse Insider: OpenWorld 2015 on your smartphone and tablet.


RDBMS

SE2 - Some questions, some answers ..., from Upgrade your Database – NOW!


PL/SQL

A PL/SQL Inlining Primer, from Oracle Database PL/SQL and EBR.

Exadata

Exadata 12.1.2.2.0 Software is Released, from Emre Baransel, Support Engineer's Blog.


Hardware

All-Flash Oracle FS1 Storage System, from Oracle PartnerNetwork News.

SOA and BPM



Java

Concurrency on the JVM, from The Java Source.


Solaris


EBS

From the Oracle E-Business Suite Support blog:






From the Oracle E-Business Suite Technology blog:




The Fundamental Challenge of Computer System Performance

Cary Millsap - Thu, 2015-09-17 11:46
The fundamental challenge of computer system performance is for your system to have enough power to handle the work you ask it to do. It sounds really simple, but helping people meet this challenge has been the point of my whole career. It has kept me busy for 26 years, and there’s no end in sight.
Capacity and WorkloadOur challenge is the relationship between a computer’s capacity and its workload. I think of capacity as an empty box representing a machine’s ability to do work over time. Workload is the work your computer does, in the form of programs that it runs for you, executed over time. Workload is the content that can fill the capacity box.


Capacity Is the One You Can Control, Right?When the workload gets too close to filling the box, what do you do? Most people’s instinctive reaction is that, well, we need a bigger box. Slow system? Just add power. It sounds so simple, especially since—as “everyone knows”—computers get faster and cheaper every year. We call that the KIWI response: kill it with iron.
KIWI... Why Not?As welcome as KIWI may feel, KIWI is expensive, and it doesn’t always work. Maybe you don’t have the budget right now to upgrade to a new machine. Upgrades cost more than just the hardware itself: there’s the time and money it takes to set it up, test it, and migrate your applications to it. Your software may cost more to run on faster hardware. What if your system is already the biggest and fastest one they make?

And as weird as it may sound, upgrading to a more powerful computer doesn’t always make your programs run faster. There are classes of performance problems that adding capacity never solves. (Yes, it is possible to predict when that will happen.) KIWI is not always a viable answer.
So, What Can You Do?Performance is not just about capacity. Though many people overlook them, there are solutions on the workload side of the ledger, too. What if you could make workload smaller without compromising the value of your system?
It is usually possible to make a computer produce all of the useful results that you need without having to do as much work.You might be able to make a system run faster by making its capacity box bigger. But you might also make it run faster by trimming down that big red workload inside your existing box. If you only trim off the wasteful stuff, then nobody gets hurt, and you’ll have winning all around.

So, how might one go about doing that?
Workload“Workload” is a conjunction of two words. It is useful to think about those two words separately.


The amount of work your system does for a given program execution is determined mostly by how that program is written. A lot of programs make their systems do more work than they should. Your load, on the other hand—the number of program executions people request—is determined mostly by your users. Users can waste system capacity, too; for example, by running reports that nobody ever reads.

Both work and load are variables that, with skill, you can manipulate to your benefit. You do it by improving the code in your programs (reducing work), or by improving your business processes (reducing load). I like workload optimizations because they usually save money and work better than capacity increases. Workload optimization can seem like magic.
The Anatomy of PerformanceThis simple equation explains why a program consumes the time it does:
r = cl        or        response time = call count × call latencyThink of a call as a computer instruction. Call count, then, is the number of instructions that your system executes when you run a program, and call latency is how long each instruction takes. How long you wait for your answer, then—your response time—is the product of your call count and your call latency.

Some fine print: It’s really a little more complicated than this, but actually not that much. Most response times are composed of many different types of calls, all of which have different latencies (we see these in program execution profiles), so the real equation looks like r = c1l1 + c2l2 + ... + cnln. But we’ll be fine with r = cl for this article.

Call count depends on two things: how the code is written, and how often people run that code.
  • How the code is written (work) — If you were programming a robot to shop for you at the grocery store, you could program it to make one trip from home for each item you purchase. Go get bacon. Come home. Go get milk... It would probably be dumb if you did it that way, because the duration of your shopping experience would be dominated by the execution of clearly unnecessary travel instructions, but you’d be surprised at how often people write programs that act like this.
  • How often people run that code (load) — If you wanted your grocery store robot to buy 42 things for you, it would have to execute more instructions than if you wanted to buy only 7. If you found yourself repeatedly discarding spoiled, unused food, you might be able to reduce the number of things you shop for without compromising anything you really need.
Call latency is influenced by two types of delays: queueing delays and coherency delays.
  • Queueing delays — Whenever you request a resource that is already busy servicing other requests, you wait in line. That’s a queueing delay. It’s what happens when your robot tries to drive to the grocery store, but all the roads are clogged with robots that are going to the store to buy one item at a time. Driving to the store takes only 7 minutes, but waiting in traffic costs you another 13 minutes. The more work your robot does, the greater its chances of being delayed by queueing, and the more such delays your robot will inflict upon others as well.
  • Coherency delays — You endure a coherency delay whenever a resource you are using needs to communicate or coordinate with another resource. For example, if your robot’s cashier at the store has to talk with a specific manager or other cashier (who might already be busy with a customer), the checkout process will take longer. The more times your robot goes to the store, the worse your wait will be, and everyone else’s, too.
The SecretThis r = cl thing sure looks like the equation for a line, but because of queueing and coherency delays, the value of l increases when c increases. This causes response time to act not like a line, but instead like a hyperbola.


Because our brains tend to conceive of our world as linear, nobody expects for everyone’s response times to get seven times worse when you’ve only added some new little bit of workload, but that’s the kind of thing that routinely happens with performance. ...And not just computer performance. Banks, highways, restaurants, amusement parks, and grocery-shopping robots all work the same way.

Response times are trememdously sensitive to your call counts, so the secret to great performance is to keep your call counts small. This principle is the basis for perhaps the best and most famous performance optimization advice ever rendered:
The First Rule of Program Optimization: Don’t do it.

The Second Rule of Program Optimization (for experts only!): Don’t do it yet.

The ProblemKeeping call counts small is really, really important. This makes being a vendor of information services difficult, because it is so easy for application users to make call counts grow. They can do it by running more programs, by adding more users, by adding new features or reports, or by even by just the routine process of adding more data every day.

Running your application with other applications on the same computer complicates the problem. What happens when all these application’ peak workloads overlap? It is a problem that Application Service Providers (ASPs), Software as a Service (SaaS) providers, and cloud computing providers must solve.
The SolutionThe solution is a process:
  1. Call counts are sacred. They can be difficult to forecast, so you have to measure them continually. Understand that. Hire people who understand it. Hire people who know how to measure and improve the efficiency of your application programs and the systems they reside on.
  2. Give your people time to fix inefficiencies in your code. An inexpensive code fix might return many times the benefit of an expensive hardware upgrade. If you have bought your software from a software vendor, work with them to make sure they are streamlining the code they ship you.
  3. Learn when to say no. Don’t add new features (especially new long-running programs like reports) that are inefficient, that make more calls than necessary. If your users are already creating as much workload as the system can handle, then start prioritizing which workload you will and won’t allow on your system during peak hours.
  4. If you are an information service provider, charge your customers for the amount of work your systems do for them. The economic incentive to build and buy more efficient programs works wonders.

Drop It Like It's Not

Scott Spendolini - Thu, 2015-09-17 09:50
I just ran the following script:

-- TABLES
FOR x IN (SELECT table_name FROM user_tables)
LOOP
  EXECUTE IMMEDIATE('DROP TABLE ' || x.table_name || ' CASCADE CONSTRAINTS');
END LOOP;

-- SEQUENCES
FOR x IN (SELECT sequence_name FROM user_sequences)
LOOP
  EXECUTE IMMEDIATE ('DROP SEQUENCE ' || x.sequence_name);
END LOOP;

-- VIEWS
FOR x IN (SELECT view_name FROM user_views)
LOOP
  EXECUTE IMMEDIATE ('DROP VIEW ' || x.view_name);
END LOOP;

Basically, drop all tables, views and sequences.  It worked great, cleaning out those objects in my schema without touching any packages, producers or functions.  The was just one problem:  I ran it in the wrong schema.

Maybe I didn't have enough coffee, or maybe I just wasn't paying attention, but I essentially wiped out a schema that I really would rather not have.  But I didn't even flinch, and here's why.

All tables & views were safely stored in my data model.  All sequences and triggers (and packages, procedures and functions) were safely stored in scripts.  And both the data model and associated scripts were safely checked in to version control.  So re-instantating this project was a mere inconvenience that took no more than the time it takes to drink a cup of coffee - something I clearly should have done more of earlier this morning.

Point here is simple: take the extra time to create a data model and a version control repository for your projects - and then make sure to use them!  I religiously check in code and then make sure that at least my TRUNK is backed up elsewhere.  Worst case for me, I'd lose a couple of hours or work, perhaps even less, which is far better than the alternative.

Oracle Partners ♥ UX Innovation Events

Usable Apps - Thu, 2015-09-17 09:35

I have just returned from a great Apps UX Innovation Events Internet of Things (IoT) hackathon held in Oracle Nederland in Utrecht (I was acting in a judicial capacity). This was the first of such events organized in cooperation with an Oracle partner, in this case eProseed

eProseed Managing Partner Lonneke Dikmans

Design patterns maven: eProseed managing partner, SOA, BPM and UX champ, Lonneke Dikmans (@lonnekedikans) at the hackathon. Always ready to fashion a business solution in a smart, reusable way.

You can read more about what went on at the event on other blogs, but from an Oracle partner enablement perspective (my main role), this kind of participation means a partner can:  

  • Learn hands-on about the latest Oracle technology from Oracle experts in person. This event provided opportunities to dive deep into Oracle Mobile Cloud Service, Oracle IoT Cloud, Oracle Mobile Application Framework, Oracle SOA Suite, and more, to explore building awesome contextual and connected solutions across a range of devices and tech.
  • Bring a team together in one place to work on business problems, to exchange ideas, and to build relationships with the "go-to" people in Oracle's technology and user experience teams.  
  • Demonstrate their design and development expertise and show real Oracle technology leadership to potential customers, to the Oracle PartnerNetwork, and to the educational, development, and innovation ecosystem.

That an eProseed team was declared the winners of the hackathon and that eProseed scored high on all three benefits above is just sweet!

eProseed NL team demo parking solution

The eProseed NL team shows off its winning "painless parking" IoT solution.

Many thanks to eProseed for bringing a team from across Europe and for working with Apps UX Innovation Events to make this event such a success for everyone there!

Stay tuned for more events on the Apps UX Innovation Events blog and watch out for news of the FY16 PaaS4SaaS UX enablement for Oracle partners on this blog.

Pictures from the IoT hackathon are on the Usable Apps Instagram account

Index Advanced Compression: Multi-Column Index Part I (There There)

Richard Foote - Thu, 2015-09-17 01:57
I’ve discussed Index Advanced Compression here a number of times previously. It’s the really cool additional capability introduced to the Advanced Compression Option with 12.1.0.2, that not only makes compressing indexes a much easier exercise but also enables indexes to be compressed more effectively than previously possible. Thought I might look at a multi-column index to highlight just […]
Categories: DBA Blogs

My Nomination for the Oracle Database Developer Choice Awards

Dietmar Aust - Thu, 2015-09-17 00:30
Actually this came as a wonderful surprise ... I have been nominated for the Oracle Database Developer Choice Awards:
I have basically devoted my entire work life to build solutions based on Oracle technology ... and you can build some pretty cool stuff with it. I have always enjoyed building software that makes a difference ... and even more so share to what I have learned and support and inspire others to do the same. The people in the Oracle community are simply amazing and I have made a lot of friends there. If you have an account for the Oracle Technology Network (OTN) I would appreciate your vote ! And if you don't feel like voting for me ... vote anyway in all the different categories ... because the Oracle community deserves the attention. Thanks, ~Dietmar.

US Consumer Law Attorney Rates

Nilesh Jethwa - Wed, 2015-09-16 22:27

The hourly rate in any consulting business or practice increases by the years of experience in the field.

Read more at: http://www.infocaptor.com/dashboard/us-consumer-law-attorney-rates

If You're In Latvia, Estonia, Romania, Slovenia or Croatia, Oracle APEX is Coming to You!

Joel Kallman - Wed, 2015-09-16 21:04
In the first part of October, my colleague Vlad Uvarov and I are taking the Oracle APEX & Oracle Database Cloud message to a number of user groups who are graciously hosting us.  These are countries for which there is growing interest in Oracle Application Express, and we wish to help support these groups and aid in fostering their growing APEX communities.

The dates and locations are:

  1. Latvian Oracle User Group, October 5, 2015
  2. Oracle User Group Estonia, Oracle Innovation Day in Tallinn, October 7, 2015
  3. Romanian Oracle User Group, October 8, 2015
  4. Oracle Romania (for Oracle employees, at the Floreasca Park office), October 8-9, 2015
  5. Slovenian Oracle User Group, SIOUG 2015, October 12-13, 2015
  6. Croatian Oracle User Group, 20th HrOUG Conference, October 13-16, 2015

You should consider attending one of these user group meetings/conferences if:

  • You're a CIO or manager, and you wish to understand what Oracle Application Express is and if it can help you and your business.
  • You're a PL/SQL developer, and you want to learn how easy or difficult it is to exploit your skills on the Web and in the Cloud.
  • You come from a client/server background and you want to understand what you can do with your skills but in Web development and Cloud development.
  • You're an Oracle DBA, and you want to understand if you can use Oracle Application Express in your daily responsibilities.
  • You know nothing about Oracle Application Express and you want to learn a bit more.

The User Group meetings in Latvia, Estonia and Romania all include 2-hour instructor-led hands on labs.  All you need to bring is a laptop, and we'll supply the rest.  But you won't be merely watching an instructor drive their mouse.  You will be the ones building something real.  I guarantee that people completely new to APEX, as well as seasoned APEX developers, will learn a number of relevant skills and techniques in these labs.

If you have any interest or questions or concerns (or complaints!) about Oracle Application Express, and you are nearby, we would be very honored to meet you in person and assist in any way we can.  We hope you can make it!

Presenting the Hotsos Symposium Training Day – 10 March 2016 (Heat)

Richard Foote - Wed, 2015-09-16 05:06
I’ve just accepted an invitation to present the Hotsos Symposium Training Day on 10 March 2016 in sunny Dallas, Texas. In the age of Exadata and In-Memory databases, it’ll be an updated and consolidated version of my Index Internals and Best Practices seminar. With an emphasis on using indexes appropriately to boost performance, it’ll feature […]
Categories: DBA Blogs

Presentation slides for my ORDS talk at KScope 2015

Dietmar Aust - Tue, 2015-09-15 12:48
Hi guys,

in June I gave a talk at the ODTUG KScope conference regarding the optimal setup of Oracle ORDS for Oracle Application Express: Setting Up the Oracle APEX Listener (Now ORDS) for Production Environments

You can access the slides certainly through the ODTUG site. They have even recorded the presentation and made it available to their members.

This seems to be a good investment for $99 per year for a paid membership, because now you also have access to the other content from the ODTUG conferences. I am not affiliated with ODTUG but all I can say is that the KScope conference is the best place for an Oracle developer to learn and connect with the best folks in the industry.

For everybody else who is not (yet) an ODTUG member you can download my slides and the config file here: http://www.opal-consulting.de/downloads/presentations/2015-06-ODTUG-KScope-ORDS-in-production/

Cheers and all the best,
~Dietmar.

P.S.: The configuration is based on the version 3.0.0 of ORDS. You should definitely move to 3.0.1 which is currently available.

But on the other hand I was once again thrown of by another problem with version 3.0.1 running the schema creation scripts for the ORDS schema users (ords_metadata and ords_public_user) .

Thus I have come to the conclusion it is best to do it step by step, the database users have to be created first. You can extract the installation scripts from the ords.war just as well:
- http://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#CHDDIFEC
- http://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#CHDFJHEA



Copycat blog

Vikram Das - Tue, 2015-09-15 03:50
While doing a google search today I noticed that there is another blog that has copied all content from my blog and posted it as their own content and even kept a similar sounding name: http://oracleapps-technology.blogspot.com .  I have made a DMCA complaint to google about this.  The google team asked me to provide a list of URLs.  I had to go through the copycat's whole blog and create a spreadsheet with two columns. One column with URL of my original post and second column with the URL of the copycat's blog.  There were 498 entries.  I patiently did it and sent the spreadsheet to google team and got a reply within 2 hours:


Hello,
In accordance with the Digital Millennium Copyright Act, we have completed processing your infringement notice. We are in the process of disabling access to the content in question at the following URL(s):

http://oracleapps-technology.blogspot.com/

The content will be removed shortly.

Regards,
The Google Team 
Categories: APPS Blogs

Adding the "Deploy to Bluemix" Button to my Bluemix Applications in GitHub

Pas Apicella - Mon, 2015-09-14 19:25
Not before time I finally added my first "Deploy to Bluemix" button on my GitHub projects for Bluemix applications. The screen shot below shows this for the Spring Session - Spring Boot Portable Cloud Ready HTTP Session demo.


Here is what it looks like when I do deploy this using the "Deploy to Bluemix" button and requires me to log in to IBM Bluemix. What happens when you use this button it adds the prohect code via FORK to your own DevOps projects , adds a pipeline to compile/deploy the code and finally deploys it as you Expect it to do.



More Information

https://developer.ibm.com/devops-services/2015/02/18/share-code-new-deploy-bluemix-button/
Categories: Fusion Middleware

EM12c 12.1.0.5 Upgrade Tasks

Arun Bavera - Mon, 2015-09-14 14:51
1.      Upgrade Primary OMR, OMS using Installer of 12.1.0.5   - 2 Hours
   Check if OMR requires upgrade:
12c Database has been Certified as an EM 12.1.0.4 or 12.1.0.5 Repository with Certain Patchset and PSU Restrictions (Doc ID 1987905.1)
12.1.0.2 Patch Set Updates - List of Fixes in each PSU (Doc ID 1924126.1)
12.1.0.2 Patch Set - Availability and Known Issues (Doc ID 1683799.1)
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1)


Applying Enterprise Manager 12c Recommended Patches (Doc ID 1664074.1)

2.     Upgrade Primary Agent      - 6 Minutes

3.      Cleanup Agent

4.      Cleanup OMS

5.      Upgrade Secondary  OMS     - 30 Minutes

6.      Cleanup Agent

7.      Cleanup OMS

8.      Apply Monthly Agent/OMS Patches available 
    Oracle Recommended Patches (PSU) for Enterprise Manager Base Platform (All Releases) (Doc ID 822485.1)
    Document 2038446.1 - Enterprise Manager 12.1.0.5.0 (PS4) Master Bundle Patch List

9.  Install Latest JDK 1.6 (Note: 1944044.1) JDK 1.6.0.95.. 
        Refer:
All Java SE Downloads on MOS (Doc ID 1439822.1)
  How to Upgrade JDK to 1.6 Update 95 on OMS 12.1.0.4 or 12.1.0.5 (Doc ID 2059426.1)
How to Upgrade the JDK Used by Oracle WebLogic Server 11g to a Different Version (Doc ID 1309855.1)
How to Upgrade the JDK Used by Oracle WebLogic Server 12c to a Different Version (Doc ID 1616397.1)
         How to Install and Maintain the Java SE Installed or Used with FMW 11g/12c Products (Doc ID 1492980.1)

10.     Install Weblogic latest PSU (1470197.1)  

11.  Verify Load Balancer

12.  OMS Sizing 

Refer:
Enterprise Manager Cloud Control Upgrade Guide

EM 12c R5: Checklist for Upgrading Enterprise Manager Cloud Control from Version 12.1.0.2/3/4 to 12.1.0.5 (Doc ID 2022505.1)

12c Database has been Certified as an EM 12.1.0.4 or 12.1.0.5 Repository with Certain Patchset and PSU Restrictions (Doc ID 1987905.1)

EM 12c: How to Patch the EM-Integrated Oracle BI Publisher (Doc ID 1982656.1)

http://oraforms.blogspot.com/2014/05/oracle-em12c-release-and-patch-schedules.html


Categories: Development

Pages

Subscribe to Oracle FAQ aggregator