Feed aggregator

Find if a string is Upper, Lower or Mixed Case, numeric, Alpha Numeric etc

Tom Kyte - Wed, 2018-10-17 21:46
Dear Experts, I populated a table with few rows of strings that are Upper/ Lower/ Mixed case, alpha-numeric, numeric etc. 1. Now I would like to evaluate they type of string using a case statement. I tried using regexp_like, but it fails when ...
Categories: DBA Blogs

Deadlock issue came while using set based sql

Tom Kyte - Wed, 2018-10-17 21:46
Hi Tom, We are using set based sql in my process, In that we are creating so many GTT tables in a package. And we are executing this package concurrently in more than ten sessions, these sessions will create temporary tables with different name a...
Categories: DBA Blogs

Foreign Keys with default values

Tom Kyte - Wed, 2018-10-17 21:46
Hello. I'm designing a database in Oracle 12.2 in Toad Data Modeler. It would get lots of inserts. I'm using identity columns as PK (basically I create a sequence and use it as default value in the column, sequence.nextval). When I connect the...
Categories: DBA Blogs

Migration of 6i Forms to APEX

Tom Kyte - Wed, 2018-10-17 21:46
Hi Team, I am trying to migrate forms 6i to APEX, but problem that i pose here is that i cannot completely migrate all the functionalities of my forms to Apex even after trying to correct Metadata it does not migrate forms completely. So, my q...
Categories: DBA Blogs

Critical Patch Update for October 2018 Now Available

Steven Chan - Wed, 2018-10-17 11:57

The Critical Patch Update (CPU) for October 2018 was released on 16 October 2018. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents. 

Supported products not listed in the "Supported Products and Components Affected" Section of the advisory do not require new patches to be applied.

The Critical Patch Update Advisory is available at the following location:

It is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches.

The next four Critical Patch Update release dates are:

  • 15 January 2019
  • 16 April 2019
  • 16 July 2019
  • 15 October 2019
References Related Articles
Categories: APPS Blogs

Problem Solving

Jonathan Lewis - Wed, 2018-10-17 10:11

Here’s a little question that popped up on the Oracle-L list server a few days ago:

I am facing this issue running this command in 11.2.0.4.0 (also in 12c R2 I got the same error)

SQL> SELECT TO_TIMESTAMP('1970-01-01 00:00:00.0','YYYY-MM-DD HH24:MI:SS.FF') + NUMTODSINTERVAL(2850166802000/1000, 'SECOND') FROM DUAL;
SELECT TO_TIMESTAMP('1970-01-01 00:00:00.0','YYYY-MM-DD HH24:MI:SS.FF') + NUMTODSINTERVAL(2850166802000/1000, 'SECOND') FROM DUAL
ORA-01873: a precisão precedente do intervalo é pequena demais

 

How do you go about finding out what’s going on ? In my case the first thing is to check the translation the error message (two options):

SQL> execute dbms_output.put_line(sqlerrm(-1873))
ORA-01873: the leading precision of the interval is too small

SQL> SELECT TO_TIMESTAMP('1970-01-01 00:00:00.0','YYYY-MM-DD HH24:MI:SS.FF') + NUMTODSINTERVAL(2850166802000/1000, 'SECOND') FROM DUAL;
SELECT TO_TIMESTAMP('1970-01-01 00:00:00.0','YYYY-MM-DD HH24:MI:SS.FF') + NUMTODSINTERVAL(2850166802000/1000, 'SECOND') FROM DUAL
                                                                                                       *
ERROR at line 1:
ORA-01873: the leading precision of the interval is too small

That didn’t quite match my guess, but it was similar, I had been guessing that it was saying something about precision – but it doesn’t really strike me as an intuitively self-explanatory message, so maybe a quick check in $ORACLE_HOME/rdbms/mesg/oraus.msg to find the error number with cause and action will help:


01873, 00000, "the leading precision of the interval is too small"
// *Cause: The leading precision of the interval is too small to store the
//  specified interval.
// *Action: Increase the leading precision of the interval or specify an
//  interval with a smaller leading precision.

Well, that doesn’t really add value – and I can’t help feeling that if the leading precision of the interval is too small it won’t help to make it smaller. So all I’m left to go on is that there’s a precision problem of some sort and it’s something to do with the interval, and probably NOT with adding the interval to the timestamp. So let’s check that bit alone:


SQL> SELECT NUMTODSINTERVAL(2850166802000/1000, 'SECOND') FROM DUAL;
SELECT NUMTODSINTERVAL(2850166802000/1000, 'SECOND') FROM DUAL
                                    *
ERROR at line 1:
ORA-01873: the leading precision of the interval is too small


So the interval bit is the problem. Since the problem is about “precision”, let’s try messing about with the big number. First I’ll do a bit of cosmetic tidying by doing the division to knock off the trailing zeros, then I’ll see what happens when I divide by 10:

SQL> SELECT NUMTODSINTERVAL(285016680, 'SECOND') from dual;

NUMTODSINTERVAL(285016680,'SECOND')
---------------------------------------------------------------------------
+000003298 19:18:00.000000000

So 285 million works, but 2.85 billion doesn’t. The value that works give an interval of about 3,298 days, which is about 10 years, so maybe there’s an undocumented limit of 100 years on the input value; on the other hand the jump from 285 million to 2.85 billion does take you through a critical computer-oriented limit: 231 – 1, the maximum signed 32 bit integer (2147483647) so lets try using that value, and that value plus 1 in the expression:


SQL> SELECT NUMTODSINTERVAL(power(2,31), 'SECOND') from dual;
SELECT NUMTODSINTERVAL(power(2,31), 'SECOND') from dual
                       *
ERROR at line 1:
ORA-01873: the leading precision of the interval is too small


SQL> SELECT NUMTODSINTERVAL(power(2,31)-1, 'SECOND') from dual;

NUMTODSINTERVAL(POWER(2,31)-1,'SECOND')
---------------------------------------------------------------------------
+000024855 03:14:07.000000000

1 row selected.

Problem identified – it’s a numeric limit of the numtodsinterval() function. Interestingly it’s not documented in the Oracle manuals, in fact the SQL Reference manual suggests that this shouldn’t be a limit because it says that “any number value or anything that can be cast as a number is legal” and in Oracle-speak a number allows for roughly 38 digits precision.

Whilst we’ve identified the problem we still need a way to turn the input number into the timestamp we need – the OP didn’t need help with that one: divide by sixty and convert using minutes instead of seconds:


SQL> SELECT TO_TIMESTAMP('1970-01-01 00:00:00.0','YYYY-MM-DD HH24:MI:SS.FF') + NUMTODSINTERVAL(2850166802000/1000/60, 'MINUTE') FROM DUAL;

TO_TIMESTAMP('1970-01-0100:00:00.0','YYYY-MM-DDHH24:MI:SS.FF')+NUMTODSINTER
---------------------------------------------------------------------------
26-APR-60 01.00.02.000000000 AM

1 row selected

Job done.

Oracle Buys goBalto

Oracle Press Releases - Wed, 2018-10-17 07:00
Press Release
Oracle Buys goBalto Adds Leading Solution for Accelerating Clinical Trial Site Selection and Activation to Oracle Health Sciences Cloud

Redwood Shores, Calif.—Oct 17, 2018

Oracle today announced that it has entered into an agreement to acquire goBalto, which delivers leading cloud solutions to accelerate clinical trials by streamlining and automating the selection and set up of the best performing clinical research sites to conduct trials.

goBalto’s study startup solutions are activated at over 90,000 research sites across 2,000+ studies in over 80 countries to deliver significant savings to customers with over 30 percent quantifiable reduction in study startup cycle times.

Today, Oracle Health Sciences offers customers the industry's most advanced cloud solution for clinical trial planning, data collection, trial execution and safety management. goBalto adds the leading industry cloud solution that significantly reduces clinical trial startup time.  Together, Oracle and goBalto will provide the most complete end-to-end cloud platform dedicated to unifying action and accelerating results for the Life Sciences industry. 

“Clinical trial site selection and activation is one of the most manual and time-consuming processes for our customers,” said Steve Rosenberg, Senior Vice President and General Manager of Oracle Health Sciences Global Business Unit. “Oracle Health Sciences is designed to provide the industry with the best end-to-end clinical trial experience and the addition of goBalto will further allow our customers to remove another barrier from delivering treatments to patients faster.”

“We set out on a mission to streamline the clinical trial study startup process ten years ago because we saw how untenable it was for pharmaceutical companies and contract research organizations to track 1,000+ sites by 1,000+ specialists on spreadsheets,” said Jae Chung, Founder and President of goBalto.  

“We are delighted to join forces with Oracle as the benefits offered to both our customers and employees as a broader clinical trial continuum are unparalleled in the industry,” said Sujay Jadhav, CEO of goBalto.

More information about this announcement is available at www.oracle.com/gobalto.

Contact Info
Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com
Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

Oracle is currently reviewing the existing goBalto product roadmap and will be providing guidance to customers in accordance with Oracle’s standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle’s review of goBalto’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by goBalto or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements
This document contains certain forward-looking statements about Oracle and goBalto, including statements that involve risks and uncertainties concerning Oracle’s proposed acquisition of goBalto, anticipated customer benefits and general business outlook. When used in this document, the words “anticipates”, “can”, “will”, “look forward to”, “expected” and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or goBalto, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business may deteriorate and/or Oracle or goBalto may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or goBalto. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor goBalto is under any duty to update any of the information in this document.

Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

[BLOG] Oracle Critical Patch Update October 2018 Now Available

Online Apps DBA - Wed, 2018-10-17 06:32

Do you know that Oracle has released Critical Patch Update (CPU) for October 2018 with wide-ranging security update? Visit: https://k21academy.com/appsdba36 to check: ✔Affected Products and Patch Information ✔Doc to Refer to Apply CPU October patches & much more… Do you know that Oracle has released Critical Patch Update (CPU) for October 2018 with wide-ranging security […]

The post [BLOG] Oracle Critical Patch Update October 2018 Now Available appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Connect to DV Datasets and explore many more new features in OAC / OAAC 18.3.3.0

Tim Dexter - Wed, 2018-10-17 05:26

Greetings !

Oracle Analytics Cloud (OAC) and Oracle Autonomous Analytics Cloud (OAAC) version 18.3.3.0 (also known as V5) got released last month. A rich set of new features have been introduced in this release across different products (with product version 12.2.5.0.0) in the suite. You can check all the new features of OAC / OAAC in the video here.

The focus for BI Publisher on OAC / OAAC in this release has been to compliment Data Visualization for pixel perfect reporting, performance optimizations and adding self service abilities. Here is a list of new features added this release:

BI Publisher New Features in OAC V5.0

New Feature Description 1. DV Datasets

Now you can leverage a variety of data sources covered by Data Visualization data sets, including Cloud based data sources such as Amazon Redshift, Autonomous Data Warehouse Cloud; Big Data sources such as Spark, Impala, Hive; and Application data sources such as Salesforce, Oracle Applications etc. BI Publisher is here to compliment DV to create pixel perfect reports using DV datasets.

Check the documentation for additional details. Also, check this video to see how this feature works.

2. Upload Center

Now upload all files for custom configuration such as fonts, ICC Profile, Private Keys, Digital Signature etc.from the Upload Center as a self service feature available in the Administration page.

Additional details can be found in the documentation here.

3. Validate Data Model

Report Authors can now validate a data model before deploying the report in a production environment. This will help during a custom data model creation where data sets, LOVs and Bursting Queries can be validated against standard guidelines to avoid any undesired performance impact to the report server. 

Details available here.

4. Skip unused data sets

When a data model contains multiple data sets for different layouts, each layout might not use all the data sets defined in the data model. Now Report Authors can select data model property to skip the execution of the unused data sets in a layout. Setting this property reduces the data extraction time, memory usage and improves overall report performance.

Additional details can be found here.

5. Apply Digital Signature to PDF Documents

Digital Signature is widely used feature in on-prem deployments and now this has been added in OAC too, where in Digital Signature can be applied to a PDF output. Digital Signatures can be uploaded from the Upload Center, required signature can be selected under security center, and then applied to PDF outputs by configuring attributes under report properties or run-time properties. 

You can find the documentation here. Also check this video for a quick demonstration.

6. Password protect MS Office Outputs - DocX, PPTX, XLSX

Now protect your MS Office output files with a password defined at report or server level.

Check the PPTX output properties, DocX output properties, Excel 2007 output properties

7. Deliver reports in compressed format

You can select this option to compress the output by including the file in a zip file before delivery via email, FTP, etc.

Additional details can be found here.

8. Request read-receipt and delivery confirmation notification 

You can opt to get delivery and read-receipt notification for scheduled job delivery via email.

Check documentation for additional details. 

9. Add scalability mode for Excel Template to handle large data size

Now you can set up scalability mode for an excel template. This can be done at system level, report level or at template level. By setting this attribute to true, the engine will flush memory after a threshold value and when the data exceeds 65K rows it will rollover data into multiple sheets.

You can find the documentation here.

 

Stay tuned to hear more updates on features and functionalities ! Happy BIP'ing ...

 

Categories: BI & Warehousing

Fixing* Baseline Validation Tool** Using Network Sniffer

Rittman Mead Consulting - Wed, 2018-10-17 05:22

* Sort of
** Not exactly

In the past, Robin Moffatt wrote a number of blogs showing how to use various Linux tools for diagnosing OBIEE and getting insights into how it works (one, two, three, ...). Some time ago I faced a task which allowed me to continue Robin's cycle of posts and show you how to use Wireshark to understand how a certain Oracle tool works and how to search for the solution of a problem more effectively.

To be clear, this blog is not about the issue itself. I could simply write a tweet like "If you faced issue A then patch B solves it". The idea of this blog is to demonstrate how you can use somewhat unexpected tools and get things done.

Obviously, my way of doing things is not the only one. If you are good in searching at My Oracle Support, you possibly can do it even faster, but what is good about my way (except for it is mine, which is enough for me) is that it doesn't involve uneducated guessing. I do an observation and get a clarified answer.

Most of my blogs have disclaimers. This one is not an exception, while its disclaimer is rather small. There is still no silver bullet. This won't work for every single problem in OBIEE. I didn't say this.

Now, let's get started.

The Task

The problem was the following: a client was upgrading its OBIEE system from 11g to 12c and obviously wanted to test for regression, making sure that the upgraded system worked exactly the same as the old one. Manual comparison wasn't an option since they have hundreds or even thousands of analyses and dashboards, so Oracle Baseline Validation Tool (usually called just BVT) was the first candidate as a solution to automate the checks.

Using BVT is quite simple:

  • Create a baseline for the old system.
  • Upgrade
  • Create a new baseline
  • Compare them
  • ???
  • Profit! Congratulations. You are ready to go live.

Right? Well, almost. The problem that we faced was that BVT Dashboards plugin for 11g (a very old 11.1.1.7.something) gave exactly what was expected. But for 12c (12.2.1.something) we got all numbers with a decimal point even while all analyses had "no decimal point" format. So the first feeling we got at this point was that BVT doesn't work well for 12c and that was somewhat disappointing.

SPOILER That wasn't true.

I made a simple dashboard demonstrating the issue.

OBIEE 11g

11g-dash-vs-bvt
Measure values in the XML produced by BVT are exactly as on the dashboard. Looks good.

OBIEE 12c

12c-dash-vs-bvt-1
Dashboard looks good, but values in the XML have decimal digits.

failed

As you can see, the analyses are the same or at least they look very similar but the XMLs produced by BVT aren't. From regression point of view this dashboard must get "DASHBOARDS PASSED" result, but it got "DASHBOARDS DIFFERENT".

Reading the documentation gave us no clear explanation for this behaviour. We had to go deeper and understand what actually caused it. Is it BVT screwing up the data it gets from 12c? Well, that is a highly improbable theory. Decimals were not simply present in the result but they were correct. Correct as in "the same as stored in the database", we had to reject this theory.
Or maybe the problem is that BVT works differently with 11g and 12c? Well, this looks more plausible. A few years have passed since 11.1.1.7 was released and it would not be too surprising if the old version and the modern one had different APIs used by BVT and causing this problem. Or maybe the problem is that 12c itself ignores formatting settings. Let's find out.

The Tool

Neither BVT, nor OBIEE logs gave us any insights. From every point of view, everything was working fine. Except that we were getting 100% mismatch between the source and the target. My hypothesis was that BVT worked differently with OBIEE 11g and 12c. How can I check this? Decompiling the tool and reading its code would possibly give me the answer, but it is not legal. And even if it was legal, the latest BVT size is more than 160 megabytes which would give an insane amount of code to read, especially considering the fact I don't actually know what I'm looking for. Not an option. But BVT talks to OBIEE via the network, right? Therefore we can intercept the network traffic and read it. Shall we?

There are a lot of ways to do it. I work with OBIEE quite a lot and Windows is the obvious choice for my platform. And hence the obvious tool for me was Wireshark.

Wireshark is the world’s foremost and widely-used network protocol analyzer. It lets you see what’s happening on your network at a microscopic level and is the de facto (and often de jure) standard across many commercial and non-profit enterprises, government agencies, and educational institutions. Wireshark development thrives thanks to the volunteer contributions of networking experts around the globe and is the continuation of a project started by Gerald Combs in 1998.

What this "About" doesn't say is that Wireshark is open-source and free. Which is quite nice I think.

Installation Details

I'm not going to go into too many details about the installation process. It is quite simple and straightforward. Keep all the defaults unless you know what you are doing, reboot if asked and you are fine.

If you've never used Wireshark or analogues, the main question would be "Where to install it?". The answer is pretty simple - install it on your workstation, the same workstation where BVT is installed. We're going to intercept our own traffic, not someone else's.

A Bit of Wireshark

Before going to the task we want to solve let's spend some time familiarizing with Wireshark. Its starting screen shows all the network adapters I have on my machine. The one I'm using to connect to the OBIEE servers is "WiFi 2".

Screenshot-2018-10-09-13.50.44

I double-click it and immediately see a constant flow of network packets flying back and forth between my computer and local network machines and the Internet. It's a bit hard to see any particular server in this stream. And "a bit hard" is quite an understatement, to be honest, it is impossible.

wireshark

I need a filter. For example, I know that my OBIEE 12c instance IP is 192.168.1.226. So I add ip.addr==192.168.1.226 filter saying that I only want to see traffic to or from this machine. Nothing to see right now, but if I open the login page in a browser, for example, I can see traffic between my machine (192.168.1.25) and the server. It is much better now but still not perfect.

Screenshot-2018-10-09-14.08.52

If I add http to the filter like this http and ip.addr==192.168.1.226, I definitely can get a much more clear view.

For example, here I opened http://192.168.1.226:9502/analytics page just like any other user would do. There are quite a lot of requests and responses. The browser asked for /analytics URL, the server after a few redirects replied what the actual address for this URL is login.jsp page, then browser requested /bi-security-login/login.jsp page using GET method and got the with HTTP code 200. Code 200 shows that there were no issues with the request.

startpage

Let's try to log in.

login

The top window is a normal browser and the bottom one is Wireshark. Note that my credentials been sent via clear text and I think that is a very good argument in defence of using HTTPS everywhere.

That is a very basic use of Wireshark: start monitoring, do something, see what was captured. I barely scratched the surface of what Wireshark can do, but that is enough for my task.

Wireshark and BVT 12c

The idea is quite simple. I should start capturing my traffic then use BVT as usual and see how it works with 12c and then how it works with 11g. This should give me the answer I need.

Let's see how it works with 12c first. To make things more simple I created a catalogue folder with just one analysis placed on a dashboard.

bvt-dashboard-1

It's time to run BVT and see what happens.

Screenshot-2018-10-11-17.49.59

Here is the dataset I got from OBIEE 12c. I slightly edited and formatted it to make easier to read, but didn't change anything important.

dataset12--1

What did BVT do to get this result? What API did it use? Let's look at Wireshark.

Screenshot-2018-10-11-19.09.27

First three lines are the same as with a browser. I don't know why it is needed for BVT, but I don't mind. Then BVT gets WSDL from OBIEE (GET /analytics-ws/saw.dll/wsdl/v6/private). There are multiple pairs of similar query-response flying back and forth because WSDL is big enough and downloaded in chunks. A purely technical thing, nothing strange or important here.
But now we know what API BVT uses to get data from OBIEE. I don't think anyone is surprised that it is Web Services API. Let's take a look at Web Services calls.

First logon method from nQSessionService. It logs into OBIEE and starts a session.

Screenshot-2018-10-11-19.36.59

Next requests get catalogue items descriptions for objects in my /shared/BVT folder. We can see a set of calls to webCatalogServce methods. These calls are reading my web catalogue structure: all folders, subfolders, dashboard and analysis. Pretty simple, nothing really interesting or unexpected here.

ws01

Then we can see how BVT uses generateReportSQLResult from reportService to get logical SQL for the analysis.

Screenshot-2018-10-11-19.42.07

And gets analysis' logical SQL as the response.

Screenshot-2018-10-11-19.45.10

And the final step - BVT executes this SQL and gets the data. Unfortunately, it is hard to show the data on a screenshot, but the line starting with [truncated] is the XML I showed before.

Screenshot-2018-10-12-12.19.58

And that's all. That's is how BVT gets data from OBIEE.

I did the same for 11g and saw absolutely the same procedure.

Screenshot-2018-10-11-21.01.35

My initial theory that BVT may have been using different APIs for 11g and 12c was busted.

From my experiment, I found out that BVT used xmlViewService to actually get the data. And also I know now that it uses logical SQL for getting the data. Looking at the documentation I can see that xmlViewService has no options related to any formatting. It is a purely data-retrieval service. It can't preserve any formatting and supposed to give only the data. But hey, I've started with the statement "11g preserves formatting", how is that possible? Well, that was a simple coincidence. It doesn't.

In the beginning, I had very little understanding of what keywords to use on MoS to solve the issue. "BVT for 12c doesn't preserve formatting"? "BVT decimal part settings"? "BVT works differently for 11g and 12c"? Now I have something much better - "executeSQLQuery decimal". 30 seconds of searching and I know the answer.

mos-1

This was fixed in 11.1.1.9, but there is a patch for 11.1.1.7.some_of_them. The patch fixes an 11g issue which prevents BVT from getting decimal parts of numbers.

pass

As you may have noticed I had no chance of finding this using my initial problem description. Nether BVT, nor 12g or 11.1.1.7 were mentioned. This thread looks completely unrelated to the issue, I had zero chances to find it.

Conlusion

OBIEE is a complex software and solving issues is not always easy. Unfortunately, no single method is enough for solving all problems. Usually, log files will help you. But when something works but not the way you expect, log files can be useless. In my case BVT was working fine, 11g was working fine, 12c was working fine too. Nothing special to write to logs was happening. That is why sometimes you may need unexpected tools. Just like this. Thanks for reading!

Categories: BI & Warehousing

Error while opening Database

Tom Kyte - Wed, 2018-10-17 03:26
HI,THERE I HAVE A SITUATION HERE,DUE TO POWER OUTAGE, DATABASE KEEP GIVING ERROR <code> <code> select name,open_mode from v$database; NAME OPEN_MODE --------- -----------------...
Categories: DBA Blogs

Automatic Memory Management or manual SGA & PGA setup?

Tom Kyte - Wed, 2018-10-17 03:26
Hi Tom, I need some clarification regarding the pros & cons of Oracle's AMM compare to us manually configuring SGA_TARGET & PGA_Aggregate. I read from quite a number of blogs & posts that doesn't recommend Oracle AMM on mission critical product...
Categories: DBA Blogs

Meaning of object_id and data_object_id in dba_objects.

Tom Kyte - Wed, 2018-10-17 03:26
Hi Tom, For some objects in dba_objects, I see object_id is not matching with data_object_id even when that object is not part of the cluster. 21:35:49 SQL> select count(*) from dba_objects where data_object_id is not null and object_name not...
Categories: DBA Blogs

Latest News, Updates, and Roadmaps--Oracle Premier Support at Oracle OpenWorld

Chris Warticki - Tue, 2018-10-16 15:57

Our conference sessions give you security, and how-to information that you can apply when you are back on the job. Hear directly from Oracle Support experts and Oracle Support customers and learn how you can maximize the value Oracle Premier Support provides your company.

Bookmark the Focus on Oracle Premier Support document for quick reference on your cell phone and you will have all the Premier Support sessions and activities available at your fingertips. Click on the + button for a session to pre-register and add the session to your Oracle OpenWorld schedule.

Oracle Premier Support—Hear from Customers

Oracle Support customers tell the story best—why they rely on Oracle Premier Support and how to get more from your Oracle products—from best practices for security, compliance, and governance to moving Oracle Applications Unlimited products to Oracle Cloud Infrastructure. Whether your Oracle Applications Unlimited run on premises or in the cloud, Oracle Premier Support is there with you.

 

See all the Oracle Premier Support customer sessions.

 

Oracle Premier Support Security—Hear from Security Experts

Oracle Premier Support provides customers with an enhanced security posture. Presented by security experts with operational security experience, these sessions will give you with insight into current security trends, common causes of security breaches, and with specific recommendations to help you secure your environment.

 

See all Oracle Premier Support Security Sessions

 

Oracle Applications Unlimited—Through at Least 2030

Get the latest details on Oracle Applications Unlimited products and their availability—whether you run Applications Unlimited products on premises or in Oracle Cloud Infrastructure. See all the Applications Unlimited sessions.

See all Oracle Applications Unlimited sessions

 

Oracle Platinum Services

See how Oracle Platinum Services helps maximize availability and reduce support complexity through remote fault monitoring, decreased response times, and patching performed by Oracle experts—at no additional cost.

See all the Oracle Platinum Services sessions

 

Find all the Oracle Support sessions, activities, and events on the Support and Services Oracle OpenWorld page.

October 2018 Critical Patch Update Released

Oracle Security Team - Tue, 2018-10-16 14:59

Oracle today released the October 2018 Critical Patch Update

This Critical Patch Update provides security updates for a wide range of product families, including: Oracle Database Server, Oracle Golden Gate, Oracle Big Data Graph, Oracle Fusion Middleware, Oracle Enterprise Manager, Oracle E-Business Suite, Oracle PeopleSoft, Oracle Siebel CRM, Oracle Industry Applications (Construction, Communications, Financial Services, Hospitality, Insurance, Retail), Oracle Java SE, Oracle Virtualization, Oracle MySQL, and Oracle Sun Systems Products Suite.

As with previous Critical Patch Update releases, a significant proportion of the patches is for third-party components (non-Oracle CVEs, including open source components). 

For more information about this Critical Patch Update, customers should refer to the Critical Patch Update Advisory located at https://www.oracle.com/technetwork/security-advisory/cpuoct2018-4428296.html and the executive summary published on My Oracle Support (Doc ID 2456979.1).  

New OA Framework 12.2.6 Update 15 Now Available

Steven Chan - Tue, 2018-10-16 12:41

Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure.

We periodically release updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 15 (Patch 28739010:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

All Oracle E-Business Suite Release 12.2.6 users should apply this patch. Future OAF patches for EBS Release 12.2.6 will require this patch as a prerequisite. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

In addition, this latest bundle patch includes fixes for the following issues:

  • When Rich Table Interaction is set to off, data binding for user-customizable properties does not take effect for classic tables.

  • A script error occurs on clicking the Go button in the Web ADI LOV window when selecting the Web ADI template.

  • An enhancement that allows developers to set an accessibility role attribute to a table HTML element.

  • Claim line level descriptive flexfields are not saved on page update.

Related Articles

Categories: APPS Blogs

Oracle Code One Expands Support for Developers

Oracle Press Releases - Tue, 2018-10-16 11:00
Press Release
Oracle Code One Expands Support for Developers Oracle Code One now covers more technologies and reaches new communities

Redwood Shores, Calif.—Oct 16, 2018

Code One

Visitors to the Groundbreaker Hub at Oracle Code One will be able to get their hands on the Code Card.

To support and empower the developer community, Oracle Code One will take place alongside Oracle OpenWorld on October 22 to 25 at Moscone West in San Francisco. Oracle’s premier event for developers has expanded to include more languages, technologies and developer communities. Oracle Code One will cover a wide range of topics from AI, blockchain, digital assistants and containers to Java and more languages such as Go, Rust and Python. Registration is still open to all developers and available at oracle.com/code-one.

Oracle Code One features daily keynotes at 5:00 PM in Moscone North’s Hall D. In the Java technical keynote on Monday, October 22, Georges Saab, Vice President of Development at Oracle, will share Java SE updates from the last twelve months including recent enhancements made in the latest Java 11 release. They will also share a glimpse into future projects aimed at accelerating user productivity such as Java in container environments and exploration of new code review options for the JDK. This year’s Duke’s Choice Award winners will also be announced during the keynote.

The Oracle Code One keynote on Tuesday, October 23, will explore topics ranging from managed Kubernetes and serverless functions to blockchain and intelligent digital assistants powered by chatbot technology. The keynote will be presented by Matt Thompson, Vice President of Developer Engagement and Evangelism at Oracle; Amit Zavery, Executive, Vice President of Fusion Middleware and PaaS Development at Oracle; and Siddhartha Agarwal, Group Vice President of Product Management and Strategy for Oracle Cloud Platform. The Code One Meetup at 5:00 PM lets developers not registered for Oracle Code attend the keynote, join a fireside chat with iconic leaders who have made groundbreaking developer innovations and explore evening sessions.

The Java Community Keynote will take place October 24 and feature special guest, James Gosling, creator of Java, together with Stephen Chin, Director of Developer Marketing and Heather VanCura, Director at Oracle and Chair of the Java Community Process, the keynote will also include developer groundbreakers from Canoo Engineering AG, Gluon, IT-Beratung, Snyk.

“As developers look to build increasingly complex cloud native applications, Oracle continues to provide new, innovative capabilities like AI and Machine Learning, blockchain and Kubernetes support for developers to leverage,” said Siddhartha Agarwal, Group Vice President of Product Management and Strategy at Oracle. “Oracle Code One is where developers can engage with Oracle’s technical experts and the larger developer ecosystem to learn how to build the next generation of these applications and services. The event features an unrivalled variety of technical sessions and a community of peers with expertise in the tools, tricks and technologies relevant to building for the cloud. Oracle is engaging with developers wherever they are located around the world to enable innovation via learning resources, developer-focused events, hands on hackfests and free Oracle Cloud Trials to help them get started.”

Throughout Oracle Code One, developers will find more of the Java content they expect with extended workshops, talks, sessions and Hands-on-Labs to explore technologies from Oracle and the broader developer ecosystem, including GraalVM, Oracle JET, the Fn Project, OpenJFX and GraphPipe. Developers at Oracle Code One can also expect unexpected demos based on the latest emerging technologies, from AI to blockchain.

Among this year’s exciting demos, sessions and keynotes, attendees will get to experience:

  • The Code Card – With Wi-Fi, buttons and an e-link screen, developers can design their own Code Card IoT device. Visitors to the Groundbreaker Hub at Oracle Code One will be able to get their hands on the Code Card and join a workshop to learn how to program it using Oracle Cloud Functions, serverless technology powered by the Fn Project.

  • Demo: Alpha Zero AI Algorithm Connect Four – The Meet the Experts Lounge on Monday, October 22 at 4:00 PM will feature an interactive demonstration of a neural network trained to play Connect Four using the AlphaZero algorithm and deployed using Oracle’s open source GraphPipe.

  • Demo: Blockchain Beer – An exclusive demo of how a micro-brewery outcompetes big brands with the blockchain.

  • Panel: Groundbreaker Icons – A discussion by thought leaders in software development and open source, including Doug Cutting, (Hadoop), Neha Narkhede (Kafka), Graeme Rocher (Grails), Guido Van Rossum (Python) and Charles Nutter (JRuby).

  • AR Scavenger Hunt Game – Guests in the Developer Lounge can win money for charity by searching for chess pieces with their phone cameras, by downloading a special app. Find the scavenger hunt image and a 3D Java Duke appears on the screen with a quiz on the JavaFX 11 platform. For each correct answer on the scavenger hunt, Oracle will donate money to Iridescent, a science, engineering and technology education nonprofit organization that empowers underrepresented young people to become self-motivated learners, inventors and leaders. A leaderboard in the Oracle Code One Developer Lounge will show the number of players, the number of correct answers and how much money has been raised for Iridescent.

Oracle Code One is also an opportunity for developers to learn about the wide range of open source and open standards which Oracle champions. Since joining the Cloud Native Computing Foundation last year, Oracle has continued to advance key serverless and container projects, including announcing new open serverless standard support on its open source Fn Project and critical new features for Oracle Container Engine for Kubernetes to address key Kubernetes issues. Oracle  also contributed many of its Kubernetes projects to the open source community, including JenkinsX Supported Cloud Provider for OKE, Flexvolume DriverVolume ProvisionerCloud Controller Manager and Terraform Kubernetes Installer. These announcements follow last year’s announcement that Oracle open sourced several container utilities. For developers working on machine learning, Oracle recently announced that it open sourced GraphPipe, to simplify how enterprises deploy and query machine learning models from any framework. Earlier this year, Oracle also released GraalVM, a polyglot virtual machine to run Java and JVM languages with full support for JavaScript and Node.JS, plus early support for Ruby, Python, R and LLVM bitcode.

In 2019, Oracle will host over 300 events around the world to connect with and educate developers with workshops, sessions and keynotes featuring prominent experts. To learn more about Oracle Developer Events, please visit: https://developer.oracle.com/events

Oracle Cloud Platform Momentum

At last year’s OpenWorld, Oracle announced new integrated cloud offerings that made it easier for developers to leverage transformative technologies and create modern applications. These included the launch of the Oracle Container Native Application Development Platform and the Oracle Blockchain Cloud Service, as well as the expansion of the Oracle Mobile Cloud portfolio to include artificial intelligence-powered chatbots.

To accelerate mobile and web application development and deployment, Oracle announced the availability of Oracle Visual Builder Cloud, which enables both business users and developers to build applications with little to no coding. Oracle API Platform Cloud provides full lifecycle API management services. Finally, Oracle Integration Cloud now brings pre-built application integration and process automation to the Oracle Cloud Platform, making the deployment and integration of these applications more seamless than ever.

Contact Info
Alex Shapiro
Oracle
+1 405.608.5044
alex.shapiro@oracle.com
Quentin Nolibois
Burson Cohn & Wolfe
+1.415.591.4097
quentin.nolibois@bm.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle Code One

Oracle Code One is the industry’s most inclusive developer conference, featuring a collection of international and local experts and speakers to explore the latest in developer technologies, languages, practices and leading-edge topics. Expanded from Oracle’s JavaOne, Oracle Code One brings together extensive technical Java content and numerous keynotes, sessions and workshops across 11 tracks covering a wide range of topics from chatbots, microservices, AI, and blockchain to languages such as Go, Rust, Python, JavaScript, SQL, and R. For more information, to register or to watch Oracle Code One keynotes, sessions and more, visit www.oracle.com/code-one. Join the Oracle Code One discussion on Twitter.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

Future Product Disclaimer

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.

Forward-Looking Statements Disclaimer

Statements in this article relating to Oracle’s future plans, expectations, beliefs, and intentions are “forward-looking statements” and are subject to material risks and uncertainties. Such statements are based on Oracle’s current expectations and assumptions, some of which are beyond Oracle’s control. All information in this article is current as of October 16, 2018 and Oracle undertakes no duty to update any statement in light of new information or future events.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Alex Shapiro

  • +1 405.608.5044

Quentin Nolibois

  • +1.415.591.4097

[BLOG] Oracle Integration Cloud Service(ICS): Using ICS to connect to Social Media [Part 1]

Online Apps DBA - Tue, 2018-10-16 10:38

This blog is the first part of 3 part blog series on How we can connect to Social Media using ICS Integration. Visit: http://bit.ly/2AdKw4F to move ahead to: 1) Learn With a Use Case for the practical implementations 2) To know about the Implementation and Testing Phases. 3) Learn, How to create a connector from […]

The post [BLOG] Oracle Integration Cloud Service(ICS): Using ICS to connect to Social Media [Part 1] appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Inheriting super user privileges over a role automatically in PostgreSQL

Yann Neuhaus - Tue, 2018-10-16 09:18

In a recent project at a customer where we synchronize the users and group out of Active Directory we hit a little issue I was not aware of before. Suppose you have created a role in PostgreSQL, you made that role a superuser and then granted that role to another role. What happens when you login using the other role? Will you have the super user privileges by default? Sounds confusing, I know, so lets do a test.

To start with we create a simple role and make that role a super user:

postgres=# create role my_admin;
CREATE ROLE
postgres=# alter role my_admin superuser;
ALTER ROLE

Of course you could also do that in one step:

postgres=# create role my_admin superuser;
CREATE ROLE

As a second step lets create a new user that is a member of the admin group and inherits the permissions of that role automatically:

postgres=# create user my_dba login password 'admin' in role my_admin inherit;
CREATE ROLE
postgres=# \du
                                    List of roles
 Role name |                         Attributes                         | Member of  
-----------+------------------------------------------------------------+------------
 my_admin  | Superuser, Cannot login                                    | {}
 my_dba    |                                                            | {my_admin}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

The questions now is: When we login using the my_dba user are we superuser automatically?

postgres@pgbox:/home/postgres/ [PGDEV] psql -X -U my_dba postgres
psql (12devel)
Type "help" for help.

postgres=> \du
                                    List of roles
 Role name |                         Attributes                         | Member of  
-----------+------------------------------------------------------------+------------
 my_admin  | Superuser, Cannot login                                    | {}
 my_dba    |                                                            | {my_admin}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=> create database db1;
ERROR:  permission denied to create database
postgres=> 

… and we are not. What we can do is:

postgres=> set role my_admin;
SET
postgres=# create database db1;
CREATE DATABASE

The reason for that is that some privileges are not inherited automatically and these are: LOGIN, SUPERUSER, CREATEDB, and CREATEROLE.

What you can do is put something like that into “.psqlrc”:

set role my_admin

… or do it like that:

postgres=# alter user my_dba set role my_admin;
ALTER ROLE

This will explicitly set the role with each login and the super user privileges will be there. When you have a bit more complicated scenario where roles are assigned based on patterns in the username you could do something like this and add it to .psqlrc as well (or put that into a file and then execute that file in .psqlrc):

DO $$
DECLARE
  lv_username pg_roles.rolname%TYPE := current_user;
BEGIN
  if ( substr(lv_username,1,2) = 'xx'
       and
       position ('yy' in lv_username) > 0
     )
  then
    execute 'set role my_admin';
  end if;
  perform 1;
END $$;

… or whatever checks you need to identify the correct user names. Hope that helps …

 

Cet article Inheriting super user privileges over a role automatically in PostgreSQL est apparu en premier sur Blog dbi services.

Query the table in Oracle 12c In-Memory still have physical reads

Tom Kyte - Tue, 2018-10-16 09:06
1. I cached a table in Oracle12C inmemory as following. <code>SQL> SELECT A.SEGMENT_NAME, 2 SUM(A.INMEMORY_SIZE) / 1024 / 1024 / 1024, 3 SUM(BYTES) / 1024 / 0124 / 1024, 4 SUM(A.BYTES_NOT_POPULATED) 5 FROM V$...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator