Feed aggregator

Reminder: Upgrade WebCenter Portal 11.1.1.8 to 11.1.1.9

Steven Chan - Thu, 2017-02-23 02:06

Oracle Fusion Middleware products get new Patch Set updates.  When a new Patch Set has been released, a 12 month Grace Period for the previous Patch Set begins.  Once that Grace Period ends, no new patches for the previous Patch Set will be released.

For more details, see:

Oracle WebCenter Portal was formerly called "OracleWebCenter Suite ".  WebCenter Portal 11.1.1.8 was released in April 2013.  WebCenter Portal 11.1.1.9 was released in May 2015, which means that the Grace Period for WebCenter Portal 11.1.1.8 ended after May 2016. 

All E-Business Suite users running WebCenter Portal 11.1.1.8 should upgrade to WebCenter Portal 11.1.1.9 to remain under Error Correction Support. WebCenter Portal 11.1.1.x is covered by Premier Support to December 2018, and covered by Extended Support to December 2021.

Related Articles

Categories: APPS Blogs

Links for 2017-02-22 [del.icio.us]

Fuad Arshad - Thu, 2017-02-23 02:00

Links for 2017-02-22 [del.icio.us]

Categories: DBA Blogs

Lateral Usage in 12c

Tom Kyte - Wed, 2017-02-22 20:06
Hi, I have learned that there is a new LATERAL keyword available in 12c Version. However, trying to understand the usage of the same. tried going through some links, but couldn't get complete picture. Syntax happy. Can you please help me.
Categories: DBA Blogs

convert CLOB data over 4K character to character

Tom Kyte - Wed, 2017-02-22 20:06
Hi, I am creating a materialized view, which needs to join multiple tables, and one of them (just only one table) giving me duplicate records in the view. When I used 'Distinct' keyword it was throwing error, knowing that when SELECT script has CL...
Categories: DBA Blogs

Analytics vs subquery

Tom Kyte - Wed, 2017-02-22 20:06
I have an example data set where I would like to count the number of RET status for a given event. This was a simple query, but now they would like the count reset when there is a different created_by. Barney in this example would reset the coun...
Categories: DBA Blogs

Convert rows to columns dynamically

Tom Kyte - Wed, 2017-02-22 20:06
Hi Tom, I have a table with data as below BRANCHNAME CUSTOMERNUM 100 1001010 100 1001011 103 1001012 104 1001013 104 1001014 104 1001015 105 1001016 105 1001017 106 1001018 now my requirement is to get the output as below. Get the c...
Categories: DBA Blogs

Website Broken Links (Mostly Not Oracle-Related)

Tim Hall - Wed, 2017-02-22 14:57

In a recent twitter exchange someone asked if I scan for broken links, oh if you only knew, and the answer is yes. I don’t do it all the time as the results can be rather depressing, and I am OCD enough to force myself to fix them. I also get people notifying me of them, which is very welcome, so I am always trying to keep on top of this stuff. Based on that exchange I thought it was about time, so I logged on the sitecrawl.net and started a new scan.

As usual, the number of internal broken links were low. I had a couple of typos in links that are now corrected.

Typically I am greeted by hundreds of broken links to Oracle documentation, but thankfully this time that was pretty good. Only about 30, many of which were to ORDS docs.

Probably the biggest offenders this time were:

  • Google : They dropped the Picassa URLs, so lots of blog posts had to be amended.
  • Twitter. Now it’s not actually Twitter’s fault, but there were a lot of twitter accounts in the blog comments that no longer exist. I’m not even talking about those that are obvious people trying to promote their brand, but regular users too. I didn’t realise ditching your Twitter account was such a big thing.
  • URL Shortners : Either the URL shortener reference no longer exists, the thing it points to no longer exists, or a retweet has chopped off the URL, so it is just junk.

I’ve been pretty merciless with some of this stuff. Rather than wasting a whole weekend, it’s only taken about 2 hours to get things ship-shape.

Cheers

Tim…

Website Broken Links (Mostly Not Oracle-Related) was first posted on February 22, 2017 at 9:57 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle New Public Cloud Licensing Policy – Good or Bad?

Pythian Group - Wed, 2017-02-22 11:05

A little while ago after a question from a customer about supporting Oracle products on the Google Cloud Platform (GCP) I decided to take a look for any updates to the Oracle public cloud support policies. The document can be easily found on the Oracle website. I quickly noticed some significant changes in the new version of the document. More specifically, I’m referring to the changes that came with the latest version of that document dated January 23, 2017.

In this blog I will attempt to summarize the findings and my thoughts about the matter. Before proceeding any further, let’s begin with a safe harbor notice (as Oracle does) and mention that I do not work for Oracle and I am not a licensing expert. Some of my observations may be incorrect and everyone reading this post is strongly encouraged to make a fully informed decision only after consultation with an Oracle sales representative. After reading the Oracle licensing policy, you should bear in mind that the document provides only guidelines and it is published for “education purposes only”.

So, what do we have in the new edition? The document shares details about the Oracle licensing policy on public cloud environments including AWS EC2, AWS RDS and Microsoft Azure platforms. Alas, still no mention of Google Cloud Platform (GCP). It leaves GCP out of charted territory and even though it doesn’t explicitly prohibit you from moving your Oracle products to GCP, it makes it difficult to estimate the impact and cost.

The first paragraph has a link to listing of all Oracle products where the policy applies. Notably, the document explicitly lists almost all Oracle Database Enterprise Edition options and packs except Oracle RAC and Multitenant. If the absence of Oracle RAC may have some technical justifications, then the exclusion of the Multitenant option doesn’t make too much sense for me.

The next paragraph reveals a lot of changes. The new version of the document officially recognizes AWS vCPU as a thread, not as a core. Prior to January 23 2017, we used to have an AWS published document showing vCores by instance type for licensing calculations, and it was widely-used even though it was never officially provided by Oracle. People used number of cores from the document and applied the Oracle multi-core factor table on top of the cores count. There was never a similar document for Azure consequently considered a vCPU as a vCore and the same calculation using the multi-core factor table. The new version of the Oracle document now states explicitly that the two vCPU on AWS have the same licensing cost as one vCPU on Azure.

It’s explicitly stated in the document that either two vCPU from AWS or one vCPU from Azure are equivalent to one Oracle CPU license. Another statement confirms that from now on, the Oracle multi-core factor no longer applies for the mentioned public cloud environments. This can be a serious impact to people migrating or planning to migrate to AWS or Azure using Bring Your Own License (BYOL) policy. They may now find themselves in a difficult position. Either you plan your migration to a smaller environment or increase your licensing cost. In this case, it’s important to keep in mind that the size of AWS EC2 instance may have direct impact not only to CPU power but to maximum available I/O on the storage layer.

Additionally, there is now a section containing formally defined rules for Oracle Database Standard Edition and Standard Edition 2. According to the paper, we count every four vCPUs on AWS or two vCPUs on Azure as one socket. This means that you cannot have more than 8 AWS vCPUs for a Standard Edition 2 (SE2) license. Standard Edition (SE) allows you to have a 16 vCPU machine, and hence still provides more opportunities when sizing EC2 or RDS . Unfortunately, the SE is only available up to version 12.1.0.1 and support for that release is coming to an end. So what can still be used for an Oracle SE2 on AWS? We can get one of the *.2xlarge instances on EC2 or pick up a similarly sized RDS instance. Is that going to be big enough? That depends on your workload profile, but again, keep in mind IO limitations per instance type. It is going to be a maximum of 8000 IOPS per the instance. Not a small number, but you will need to measure and identify your IO requirements before going to the cloud.

On one hand, the new policies are way more clear and direct than they used to be and I believe that the clarification is good. It is always easier to plan your implementations and budget when you are confident of what to expect. On the other hand, it looks like we have to pay twice as much in licensing fees when moving to AWS or Azure when compared with any bare metal or OVM environment on premises. Will it make Oracle products more attractive for customers? I have some doubts that it will. Will it make the Oracle Cloud a more interesting target platform for cloud migrations? Possibly. That is likely the main goal of Oracle but we’ve yet to see if it works out for them as expected. I liked it when Oracle made Oracle Express Edition (XE) available for everyone for free and when Oracle Standard Edition came with the RAC option at no additional costs. While I don’t have any official numbers, I think that the Express Edition and RAC included with SE turned many customers onto Oracle products. However, I’m afraid that the new licensing policy for cloud may do the opposite and turn some people away from Oracle and consequently play out really badly for Oracle in the long term.

Categories: DBA Blogs

ORA-00933 SQL command not properly ended Solution

Complete IT Professional - Wed, 2017-02-22 05:00
Are you getting the ORA-00933: SQL command not properly ended error? Learn what causes it and how to resolve it in this article. ORA-00933 Cause You have run an SQL statement and have gotten this error: ORA-00933: SQL command not properly ended What causes this error? Most likely, the SQL statement you’re running has a […]
Categories: Development

Webcast: "Migrating and Managing Customizations for EBS 12.2"

Steven Chan - Wed, 2017-02-22 02:05

EBS customizationsOracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for an overview of how to manage your customizations when upgrading to EBS 12.2, see:

Have you created custom schemas, personalized or extended your Oracle E-Business Suite environment? Santiago Bastidas, Senior Principal Product Manager, discusses how to select the best upgrade approach for existing customizations. This session will help you understand the new customization standards required by the Edition-Based Redefinition feature of Oracle Database to be compliant with the Online Patching feature of Oracle E-Business Suite. You’ll learn about customization use cases, tools, and technologies you can use to ensure that all your customizations are preserved during and after the upgrade. You’ll also hear about reports you can run before the upgrade to detect and fix your customizations to make them 12.2-compliant. This material was presented at Oracle OpenWorld 2016.

Categories: APPS Blogs

Script to recompile the synonyms in a schema

Tom Kyte - Wed, 2017-02-22 01:46
Hi I have written the below script to recompile the synonyms in all the schemas but I am getting invalid character error. Could you check is there any wrong with the script: spool 'c:synonyms.txt' begin for i in (select object_name,ow...
Categories: DBA Blogs

Join (or equivalent) a collection to a table.

Tom Kyte - Wed, 2017-02-22 01:46
I need to build a procedure that will accept a collection of numbers that I need to then find matches in a table. If the elements of the collection were in another table, then it would be a simple case to join the tables. How can I accomplish this ...
Categories: DBA Blogs

Dedicated and Shared Mode

Tom Kyte - Wed, 2017-02-22 01:46
Hi Tom, How can we know that our database is running on shared mode or dedicated mode. Can we configure the database so that we can change the mode according to our need. Thanks, Snehasish Das.
Categories: DBA Blogs

Exceptions handling - how to rollback correctly

Tom Kyte - Wed, 2017-02-22 01:46
Hi everyone, my question is about how to correctly handling exception in a pl/sql procedure: I need to rollback everything made in a begin-end block if there's any kind of exception. Here's the example code: <code>create table prova (cod ...
Categories: DBA Blogs

Log_checkpoint_interval and timeout

Tom Kyte - Wed, 2017-02-22 01:46
Hi, It is rather confusing from documentation that the meaning of Log_checkpoint_interval and log_checkpoint_timeout between Oracle 8 and 8i versions. I believe that even though the definitions changed in 8i meaning is same,if so why did the...
Categories: DBA Blogs

OGG: Unable to lock file “/xxx/de000000″ (error 11, Resource temporarily unavailable).

Yann Neuhaus - Wed, 2017-02-22 00:32

When you see the above message in the GoldenGate logfile there are usually orphan processes that prevent GoldenGate from locking the file (typically when your trail files are on NFS). In a case I had at a customer last week this was not the case. It could be confirmed that there are no other processes sitting on the file by doing an fuser on the file on all nodes of the cluster (This was an 8 node Exadata). What we finally needed to do was:

cd [TRAIL_DIRECTORY]
mv de000000 de000000_bak
cp de000000_bak de000000
rm de000000

Once we did this we could start the extract again and GoldenGate was happy. Hope this helps …

 

Cet article OGG: Unable to lock file “/xxx/de000000″ (error 11, Resource temporarily unavailable). est apparu en premier sur Blog dbi services.

Oracle Mobile Cloud Service 3.1 is available now!

Are you a digital business yet? Mobile is the center of Digital Transformation.  Oracle Mobile Cloud Service provides you with the power and the tools you need to develop a strategy for...

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

PeopleTools Idea Pages

PeopleSoft Technology Blog - Tue, 2017-02-21 16:26

We're doing a lot to enhance PeopleTools, and we have many avenues for gathering requirements: focus groups, conferences, research, advisory boards, and so on.  One area that we would like to promote particularly is the PeopleSoft Idea pages.  There is an idea page for PeopleTools specifically.  We are monitoring these pages regularly, so if you have suggestions for enhancements regardless of size or complexity, please feel free to submit them here.  This is your chance to guide us in the direction of PeopleSoft technology.  In addition to submitting your own ideas, you can vote on the suggestions of others to give them more weight.  Take a look at these pages and submit your ideas and suggestions.  This area is really for ideas about any area of PeopleSoft technology, so if you have ideas about areas beyond PeopleTools--like Enterprise Components or the Interaction Hub, you can submit them here as well.


PeopleTools Idea Pages

PeopleSoft Technology Blog - Tue, 2017-02-21 16:26

We're doing a lot to enhance PeopleTools, and we have many avenues for gathering requirements: focus groups, conferences, research, advisory boards, and so on.  One area that we would like to promote particularly is the PeopleSoft Idea pages.  There is an idea page for PeopleTools specifically.  We are monitoring these pages regularly, so if you have suggestions for enhancements regardless of size or complexity, please feel free to submit them here.  This is your chance to guide us in the direction of PeopleSoft technology.  In addition to submitting your own ideas, you can vote on the suggestions of others to give them more weight.  Take a look at these pages and submit your ideas and suggestions.  This area is really for ideas about any area of PeopleSoft technology, so if you have ideas about areas beyond PeopleTools--like Enterprise Components or the Interaction Hub, you can submit them here as well.


Pages

Subscribe to Oracle FAQ aggregator