Feed aggregator

TDE Tablespace encryption - assign separate, distinct duties to database administrators and security administrators

Tom Kyte - 6 hours 39 min ago
Hi Tom, Our situation is that we are going to put some sensitive data in an Oracle DB hosted by vendor (external party). To minimize impact to App, we like to choose TDE tablespace encryption. Since the data is highly restricted, we don't allow...
Categories: DBA Blogs

Stored Procedures for insert statements

Tom Kyte - 6 hours 39 min ago
Hello, Ask Tom Team. I have like 20 tables using identity column for pk. Right now, I'm using returning clause to retrieve the pk (identity column using Oracle 12c feature) to be used as fk in the child tables. I have been asked to use stored pr...
Categories: DBA Blogs

Composite Primary Key and Number generated

Tom Kyte - 6 hours 39 min ago
Hello Tom, I have one table Invoice which has 6 columns.Out of which 2 column are composite primary key. <code>create table invoice ( area integer, invoid number generated always as identity, designation varc...
Categories: DBA Blogs

Search by timestamp(6) on big tables (several approaches)

Tom Kyte - 6 hours 39 min ago
Hello Tom, it's always instructive to read your opinion to different topics around Oracle databases. We have a big table with round about 200 million records added a month. On this table there some selects doing some calculation per day and one...
Categories: DBA Blogs

Exadata supports NLS_CHARACTERSET

Tom Kyte - 6 hours 39 min ago
Hi, We are working on DB migration from Solaris to Exadata Linux. The current NLS_CHARACTERSET is AMERICAN_AMERICA.WE8MSWIN1252. Does Exadata on Linux support NLS_CHARACTERSET AMERICAN_AMERICA.WE8MSWIN1252? Is it MUST to migrate to AL32UTF8...
Categories: DBA Blogs

RAC - ASM without clusterware?

Tom Kyte - 6 hours 39 min ago
Hello, I am confused with the requirement needed to setup 2-node (Linux server) RAC with SAN storage, as I am new to this SAN storage. I see that it is recommended to use ASM as volume manager and file system to RAC instance. I heard that conc...
Categories: DBA Blogs

Invalid reply code for Utl_stmp

Tom Kyte - 6 hours 39 min ago
Hi there, I am trying to use utl_smtp to send out email to our customers. How can we tell is the email successful delivered ? Does reply code indicate the successful of delivery ? Below is a testing procedure I had created. I got the same result o...
Categories: DBA Blogs

Solid state disks

Tom Kyte - 6 hours 39 min ago
I recently tested an Oracle database on a Solid state disk. Here is the link http://www.superssd.com/products/ramsan-400/ The performance is really great if you compare it with regular disks. I couldn't find many documents or threads to ge...
Categories: DBA Blogs

Oracle Statement

Oracle Press Releases - 7 hours 15 min ago
Press Release
Oracle Statement

Redwood Shores, Calif.—Jan 23, 2019

"This meritless lawsuit is based on false allegations and a seriously flawed process within the OFCCP that relies on cherry picked statistics rather than reality. We fiercely disagree with the spurious claims and will continue in the process to prove them false. We are in compliance with our regulatory obligations, committed to equality, and proud of our employees."—Oracle Executive Vice President and General Counsel Dorian Daley
Contact Info
Deborah Hellinger
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.


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

Deborah Hellinger

  • 212.508.7935

Introducing Kevin Hudson

Steven Chan - 7 hours 52 min ago

Kevin Hudson will be leading the ATG Product Management team. 

Kevin Hudson is a Senior Director in the Oracle Applications Technology Group.  In addition to his new responsibilities leading the Applications Technology Product Management team, Kevin also works on the architecture of the 12.2 E-Business Suite Technology stack.

Kevin began his career with Oracle UK in 1990 and relocated to Oracle Headquarters in Redwood Shores in 1992, where he worked as an engineer in the Oracle Financials Development team.   In 1995, Kevin transitioned to the E-Business Suite Technology team, where he had responsibility for managing the development of Oracle Workflow and Integration Products, including EDI/XML Gateway, and the Integration Repository.  In 2010, Kevin moved to an architecture role, designing and implementing the 12.2 Online Patching technology.

Kevin holds four software patents for his design work on the 12.2 E-Business Suit Online Patching solution.  Kevin is a two-time recipient of the UK Oracle User Group speaker award (2014, 2015) and received the UK Oracle User Group Lifetime Achievement Award in 2018.

Kevin is British, bald and boisterous.

Categories: APPS Blogs

APEX Office Print (AOP) 19.1: Printing and Exporting made easy in Oracle APEX

Dimitri Gielis - 10 hours 31 min ago
To start the new year in an awesome way, we released APEX Office Print (AOP) 19.1 on January 11th. I typically don't blog about every new AOP release, but this is an important release in our history of the product.

Our dream is that every developer can use AOP, that is why in AOP 18.1 (released September 2018) we made a Free Cloud Tier.

With AOP 19.1 we go one step further... from now on you can run AOP in Developer Mode, which means you can call our cloud as much as you like in this mode. Your number of reports/credits in your plan are not touched at all. When you want to test AOP or are developing some new reports, you can use development mode so you don't need to use your credits for that.

We had been thinking about this setting for some time, but Jon from JMJ Cloud reminded us how important it is for you in his nice blog post: APEX Office Print – Is it the APEX printing solution we have all been waiting for?

Just like in previous versions we added a number of new features, fixed some bugs and made several enhancements. You can view the release notes for every version here.

AOP 19.1 is again a free update for all our users, Cloud and On-Premises (with a valid maintenance contract).

We love to listen to our customers and help them as good as we can to make their projects a success. That is why we like to release frequently, so creating the reports you want is easy, fast and integrated with Oracle APEX.

In this post, I want to highlight some of the APEX Office Print (AOP) features that I believe make a difference, and why AOP became the go-to solution when you want to print and export your data in Oracle APEX. If you want to see AOP in action, definitely check out the AOP Sample App.


Just like BI Publisher or XSL-FO, AOP has a server component. The difference is that AOP is one executable, has a built-in web server which can autoscale depending the number of CPU cores and it listens on incoming requests with a JSON payload. The AOP Server is very simple to install, upgrade and maintain, yet flexible and scalable out-of-the-box.

To make it really easy to do calls to the AOP Server, we built a PL/SQL API on top of the REST interface. As we love Oracle APEX so much, we built an APEX Plug-in on top of the PL/SQL API.

Our idea is that you are up-and-running in less than 5 minutes.

Integration with Oracle APEX

AOP is the most integrated solution for APEX apps on the market. We went much further than the built-in BI Publisher and XSL-FO support. AOP understands your Classic Reports, Interactive Reports, and Grids, Charts and Calendars. AOP lets you print or export your Interactive Report and Grid exactly as you see it on the screen, with highlights, computations, breaks, group by etc.

In the APEX Plug-in you specify the static id of the region(s) and AOP will do the rest.

The APEX Plug-in is really flexible and the easiest way to get your reports done in no time. 
You specify your template, the data source(s) and your output, that's it.

Based on Templates

AOP is template driven, you basically create a template in your favorite editor. AOP supports templates in Word, Excel, Powerpoint, PDF, HTML, Markdown, Text and CSV.
In the template, you use specific tags AOP understands. You find an overview of tags in the AOP documentation.

PDF Tools

As many people generate PDF documents, since AOP 18 we are focussing to include more and more PDF-specific features. AOP allows you to generate PDFs from almost any file format, even images, you can merge PDFs, split them, password protect the PDF and you can even include a watermark.

We also have a special PDF, called Single Page PDF. Some people don't know the size of the document, so they just want a PDF with a variable size. For example when you get a receipt in a restaurant, depending on the number of dishes and drinks the PDF is different in size.

One more thing... AOP Web Editor

We are developers ourselves and have been using AOP since 2015. Sometimes you don't know what's going on, so from day one we heavily instrumented AOP to see exactly what it's doing and give you all the tools to make debugging fun. The Web Editor allows you to create documents really fast, look at debug info, see the different requests and try different options really fast.


We love our customers and find support extremely important as we want you to be successful. You can contact us through our support email or through the new AOP Slack Channel on apex.world.

Final words

The above is just a small set of features I believe make a huge difference compared to any other engine. You don't have to take my word for it, just give AOP a try with our free version and development mode and decide yourself :) And know you are not alone, we are proud of every single customer we have from large customers like Siemens, NASA and even Oracle, to smaller customers like Storm-Petrel (who use AOP extensively!).

Categories: Development

Automated Cell Maintenance

Syed Jaffar - 14 hours 45 min ago
One of the key actives for a DBA is to well maintain the database servers and Oracle environments. In a complex Oracle environment, managing and maintaining file system space plays a very crucial role. When a FS, where Oracle binaries are stored,  runs out of space, it could lead to some sort of consequences and some situations it can cause service interruption.

One of the routine actives for a DBA in a very busy system is to maintain the FS space by regularly purging or cleaning the old log and trace files. Some DBAs perform these activities through a schedule job. However, Oracle does introduced an auto maintain jobs. For example, in a cluster environment, the logs are maintained in terms of size as well as retention of the historical copies. On Exadata too Oracle has automated the Cell maintenance in place.

In this blog post, we will run through some of useful information about automated cell maintenance activities.

The Management Server (MS) component carries the responsibility of auto space management. For example, when there is a shortage of space in ADR, the MS deletes the files as per below default policy:

  • Files which are older than 7 days in ADR and LOG_HOME directories
  • alert.log will be renamed once it reaches to 10MB, and the historical files are kept for 7 days
  • Upon 80% of FS utilization, the MS triggers the deletion policy for / (root) and /var/log/oracle directories
  • Similar, the deletion policy will be activated when the /opt/filesystem 90% utilized
  • Alerts are cleared based on the criteria and policies

The default retention policy is set to 7 days. If you want to modify the default behavior, you will have to change the metricHistoryDays and dragHistoryDays attributes with ALTER CELL command.

Read the below Oracle document for more insights about auto cell maintenance tasks.


Red Hat Forum Switzerland 2019

Yann Neuhaus - 14 hours 53 min ago

Today (actually right now) we are a proud sponsor of the Red Hat Forum Switzerland 2019 in Geneva. With around 300 people attending this is quite a huge event and we had a lot of interesting discussions with other partners as well as existing customers or just people we met and didn’t know before.

First of all we focused on Red Hat’ing our marketing crew, of course. Image is everything:


As expected a lot of discussions and sessions are around cloud, hybrid cloud and containers. OpenShift was a topic everywhere and we really could feel that there is high demand but also many, many questions around that topic. The exhibition area filled quickly during the breaks and that was the great possibility to step into the very interesting discussions:


Even at the event we have been busy and sometimes it is required to have more than one phone. Interesting comments here:


This is when Microsoft meets open source:


Red Hat deserves a big thank you for the organization, everything was well prepared and working, here is our booth:


… and here are the dbi services people who attended today:


See you at the next Red Hat Forum in Zürich later this year.

Cet article Red Hat Forum Switzerland 2019 est apparu en premier sur Blog dbi services.

SharePoint Application Server Role, Web Server IIS Role Error

Yann Neuhaus - 16 hours 43 min ago
Bypassing SharePoint Server 2013 Prerequisites Installation Error On Windows Server 2016



Before running the setup of SharePoint 2013 on Windows Server 2016, the prerequisites as the application server role and the web server role have to be installed and during that process, the following error message appears:

Prerequisite Installation Error


This error occurs when one or more of the following conditions is true:

  • The product preparation tool does not progress past the configuring application server role, web server role stage.
  • The product preparation tool may be unable to configure and install properly the required windows features for SharePoint.
  • The Application Server Role has been deprecated from Windows Server 2016

To workaround this issue, please follow this step:


Install the following software:

Copy and paste the Windows Server AppFabric software (do not install it) on the C drive and run the following PowerShell command:

C:\>.\WindowsServerAppFabricSetup_x64.exe /i CacheClient,CachingService,CacheAdmin /gac

When the installation is done, reboot the server and install the AppFabric cumulative update Server App Fabric CU and reboot again the Windows Server.

Run the setup.exe from the .iso file to complete the installation wizard.










Cet article SharePoint Application Server Role, Web Server IIS Role Error est apparu en premier sur Blog dbi services.

Partner Webcast – Developing new adapters with Oracle Cloud Adapter SDK for Oracle ...

Today’s Modern IT supports new requirements by making IT infrastructure more accessible and available based on demand.  IT infrastructure can be made available both in your datacenter...

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

Is ETL still necessary?

Dylan's BI Notes - Tue, 2019-01-22 23:10
ETL stands for Extract, Transform, and Load. Extract and Load, their existence itself implies that the source data and target data are stored separately, so you need to extract from source and load the data into the target data store. Extract and Load won’t go away if the data used for reporting is not stored […]
Categories: BI & Warehousing

Bite-Sized Chunks of Expertise: The Top Ten 2 Minute Tech Tips for 2018

OTN TechBlog - Tue, 2019-01-22 23:00

The fans can't be wrong, and the numbers don't lie. 

The list of the Top Ten 2 Minute Tech Tips for 2018 includes insight and expertise covering containers, bots, REST APIs, database performance, and more, as contributed by experts from across the community. 

What's a 2 Minute Tech Tip? As the title implies, a 2 Minute Tech Tip is a short video that presents useful technical information for developers, architects, DBAs, and other roles. 2MTTs cover a wide range of topics, and the presentation can be anything from a simple talking head to a full-on presentation with slides and demos. The manner of presentation and topics are chosen entirely by the people delivering the tips. The only rule is that the tip can't take more than two minutes.

I record some 2MTTs at events, as I did with Sergio Leunissen's #1 video, which was recorded at Oracle Open World. But most are recorded by the tipsters themselves at home, on webcams or mobile devices, as is the case with the #2 tip from Kevlin Henney, which was recorded on the streets of London using selfie stick. 

The list below represents the most-watched 2 Minute Tech Tips for 2018. Congratulations to the year's top tipsters!

1 Sergio Leunissen Zero to Docker Sandbox in 2 Minutes
by Sergio Leunissen
Vice President, Open Source and Virtualization Group, Oracle 2 Kevlin Henney Concurrency Versus Locking
By Kevlin Henney
Independent Consultant, Trainer, Writer 3 Guido Schmutz Apache Kafka? Why Should I Care?
By Guido Schmutz
Oracle Groundbreaker Ambassador
Oracle ACE Director
Principal Consultant / Technology Mangager, Trivadis 4 Peter Raganitsch What's Wrong with your APEX Application?
By Peter Raganitsch
Oracle ACE Director
CEO, FOEX GmbH 5 Matt Hornung Setting Up Basic Intents with Oracle Intelligent Bots
By Matt Hornung
Software Consultant, Fishbowl Solutions 6 Mohamed Taman Database Performance Tip
By Mohamed Taman
Java Champion, Oracle Groundbreaker Ambassador
Sr. Enterprise Architect, Comtrade Digital Services
Owner / CEO, SiriusXI d.o.o. 7 Adam Bien Java EE 8 Quick Start
By Adam Bien
Java Champion
Independent Java Architect and Developer
Freelance Author 8 Blaine Carter Securing an Oracle Data Services REST API
By Blaine Carter
Developer Advocate for Open Source, Oracle 9 Chris Saxon Oracle Database: Working with External Tables
By Chris Saxon
Developer Advocate for SQL, Oracle



Mark Williams When Should You Use SQL Bind Variables?
By Mark Williams
Principal Consultant, Method R Advocate, Cintra Software and Services Where is your 2 Minute Tech Tip?

Think you've got an idea for a great tip? Go for it! Anyone is eligible to submit a 2 Minute Tech Tip. All you need is an idea and a a camera. These guidelines will help:

  • 1280x720 minimum resolution (Most cell phone cameras record video in this resolution)
  • MP4 or MOV format.
  • You need to record two segments:
    • Intro: ("Hi, My name is Jane Smith, and I'm a developer with XYZ Corp.") The intro does not count against your 2 minutes.
    • Tip (Must not exceed 120 seconds)
    • Intro and tip segments can be in separate video files, or can be combined in a single file.
  • You don't have to fill the entire 2 minutes, but you can't go over.
  • I have Google Drive and Dropbox accounts to facilitate file transfer.
  • If you absolutely can't be bothered to record yourself, I can record you remotely via Skype. 

Watch the videos above to get a sense of what works. Maybe your tip will make the 2019 Top Ten list

If you have any questions about the process, post a comment, and include your email address. 

Real-Time Materialized Views

Tom Kyte - Tue, 2019-01-22 19:06
Hi, I "think" I saw Maria shown a new feature that allow query rewrite with stale MV + MV Log. (feature similar to IM store + IM trail query rewrite.) What is the name of this feature and how do I use it? Thanks, P.Huang
Categories: DBA Blogs

Uncompressing externally zipped documents

Tom Kyte - Tue, 2019-01-22 19:06
Good morning/afternoon guys. I am loading XML files from Windows into the database as BLOBs via an Apex front-end, however the performance leaves much to be desired (unsurprising, due to the 1Gb file sizes). I have a cunning plan to first zip t...
Categories: DBA Blogs

Oracle Text Substring Search on Encrypted String

Tom Kyte - Tue, 2019-01-22 19:06
Hi, Do Oracle Text have capability to sub string search on encrypted string. The Data resides in table as encrypted string (using DBMS_CRYPTO). The sub string passed from UI is non encrypted and data resides on DB is encrypted. Thanks & Re...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator