Collation and Case-Insensitive Database in Oracle 12.2

A little while ago Jeff Smith asked me if I had done anything with the collation functionality in Oracle Database 12c Release 2 (12.2). At the time my response was I was letting it stew a little before I released anything about it.

For some functionality the manuals contain a lot of information, but it’s not always obvious how much you will really care about. The collation functionality is exactly like that. You can get (more...)

Oracle buys Moat (advertizing verification)

Oracle has signed an agreement to acquire Moat, the fastest-growing digital measurement cloud company. Moat will join Oracle DataCloud, which uses data and analytics to enhance media for leading marketers and publishers. More info

How to create dashboard for Hadoop Hive Database

HiveServer2 is a service that enables clients to execute queries against Hive. It supports multi-client concurrency and authentication.

Are you using Hadoop Hive for your data marts or data-warehouse? If so, build your Free Hadoop Hive web dashboard software.

A Hadoop Hive dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Hiveserver2 SQL reporting reporting, it's a live view (more...)

JShell Integration in NetBeans IDE

I've blogged about the integration of the Java 9 JShell in NetBeans IDE before, here and here.

In the latest daily builds, assuming you're running the daily build on top of Java 9, you'll see the top part of the JShell looks the way you'd like it, i.e., there's a nice code fold and the first statement is numbered 1, rather than 9 as it was initially, as can can be seen (more...)

Understand the importance of OFSAA Loan Loss Forecasting and Provisioning


Are you an implementation consultant who needs to understand the importance of OFSAA Loan Loss Forecasting and Provisioning (LLFP) as part of IFRS9 (International Financial Reporting Standards) to the banking industry? And would you prefer to learn exactly what you need, when you can, at your own pace?

Oracle University has recently released the following course (with a standard duration of 2 days) in a Training On Demand format:

OFSAA 8.x Loan Loss (more...)

Better track the Usage of Database Options and Management Packs, or it will cost you

So here it is:
Oracle announces a license audit, some urgency kicks in and this familiar but also really serious question comes up from management: “Are we using any unlicensed database features“. The seriousness is quite understandable, because if so, the company can look forward to some negotiations with Oracle over license fees, possibly resulting in considerable and unforeseen extra costs.

Tracking… why:
To be able to provide a swift and correct answer (more...)

Vagrant? Again? …Really?

(Yes. And Ansible. And Oracle…) TL;DR. This is the repo I’ll be talking about. It can use Ansible to provision Oracle (SI/RAC). Like I’ve said before, I use Vagrant quite a lot and I basically have 2 configs that I use every time. One that uses an external ‘hosts.yml’ to define the hosts (ip, ram etc) […]

Oracle E-Business Suite 12.2 Web Services Security for Oracle Supplier Network

This is the ninth posting in a blog series summarizing the new Oracle E-Business Suite 12.2 Mobile and web services functionality and recommendations for securing them.

The most common use of web services with the Oracle E-Business Suite is the Oracle Suppler Network (OSN). Do not confuse OSN with the Oracle Social Network (also referred to as OSN) or when configuring OSN, do not confuse the Oracle Transport Agent (OXTA) web services with Oracle (more...)

Moving your Oracle Data to the Cloud with Minimal Downtime


Moving from an on-premise Oracle database to the Cloud can mean a whole host of different challenges, and these are different for every business. One of the things we’ve tackled for larger companies is the problem of migrating a lot of data, with not much time to play with. Big businesses come with big sets of data, and often don’t have time to spare for a lengthy window of downtime. Systems down means money spent, (more...)

Adding a Column with a Default Value and a Constraint

The Constraint Optimization series:


In the previous parts of this series I showed that Oracle does a nice optimization – that may save plenty of time – when we add in a (more...)

postgres Statistiken: pg_stat_all_tables

Alexey Lesovsky hat bereits eine ganze Reihe interessanter Artikel im Rahmen einer Serie "Deep dive into postgres stats" veröffentlicht. Bisher hatte ich mich davor gedrückt, diese Ausführungen zusammenzufassen, aber heute ist ein ruhiger Tag und die pg_stat_all_tables scheint mir eine besonders interessante Quelle zu sein...

Die View pg_stat_all_tables enthält eine ganze Reihe interessanter Informationen zur Nutzung von Tabellen. Unter anderem weist sie hin auf:
  • Zugriffsinformationen: die View enthalt Informationen zur Anzahl sequentieller Scans (also Full (more...)

Setting up Oracle Database on Docker

A couple of days ago it was announced that several Oracle images were available on the Docker Store.

This is by far the easiest Oracle Database install I have every done !

You simply have no excuse now for not installing and using an Oracle Database. Just go and do it now!

The following steps outlines what I did you get an Oracle 12.1c Database.

1. Download and Install Docker

There isn't much to say (more...)

OracleCode London 2017

My colleague & boss Ace Director Luis Weir and I where invited to present at Thursday 20th’s Oracle Code London.

oracle_codeThe request to present came late as we where needed to cover someone who had to cancel (not that we aren’t grateful for the opportunity). This did mean getting the presentation together was a little bit of a scramble, unfortunately I missed a couple of sessions as I needed to assemble an environment, work out how (more...)

Undo Understood

It’s hard to understand all the ramifications of Oracle’s undo handling, and it’s not hard to find cases where the resulting effects are very confusing. In a recent post on the OTN database forum resulted in one response insisting that the OP was obviously updating a table with frequent commits from one session while querying it from another thereby generating a large number of undo reads in the querying session.

It’s a possible cause of (more...)

Top tweets SOA Partner Community – April 2017

image

April 2017 top tweets by soaCommunity

Send your tweets @soacommunity #soaCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog (more...)

Save Time and Headache – Automate Your WebLogic Data Source Configurations by Chandresh Patel

image


FlexDeploy’s WebLogic plugin provides various operations to automate the management of domain configurations. Similar to build and deploy of J2EE applications, you can utilize SCM repositories like Subversion, Git, TFS, CVS etc. to maintain configuration files and setup Build and Deploy workflows in FlexDeploy.

Let me show you show it works: 

See a very simple Data Source configuration file below, which defines two Data Sources.

Notice the use of variables like ${{FLX_DB_PASSWORD_FDADMIN}}, which will be (more...)

Understand the importance of OFSAA Loan Loss Forecasting and Provisioning


Are you an implementation consultant who needs to understand the importance of OFSAA Loan Loss Forecasting and Provisioning (LLFP) as part of IFRS9 (International Financial Reporting Standards) to the banking industry? And would you prefer to learn exactly what you need, when you can, at your own pace?

Oracle University has recently released the following course (with a standard duration of 2 days) in a Training On Demand format:

OFSAA 8.x Loan Loss (more...)

オラクル サポート・ニュースレター 号外(Critical Patch Update – April 2017) 公開のお知らせ

| Apr 20, 2017

オラクル サポート・ニュースレター 号外(Critical Patch Update - April 2017)の内容はこちらをご覧ください。

※ My Oracle Support へのログインが必要です。


【関連情報】

Breaking News! Dodeca Spreadsheet Management System Certified on Oracle Analytics Cloud!

Now that the Oracle Analytics Cloud, or "OAC", has been released, we had to get serious about our work with one of the Oracle Analytics Cloud components, the Essbase Cloud Service, or "EssCS" for short.  You would think that we should have been working hard on EssCS for quite some time, but we had been assured by Oracle product management that the Essbase Java API would be available in EssCS.  Of course, Dodeca was built (more...)

对数据库的“比特币攻击”及防护

ALERT: 数据库存在遭受比特币攻击的风险 ________________________________________ In this Document Description Occurrence Symptoms Workaround Solution References ________________________________________ APPLIES TO: Oracle Database - any Edition - any Version Information in this document applies to any platform. DESCRIPTION 用户使用客户端连接数据库或者数据库Alert日志中出现ORA-20312/ORA-20313/ORA-20315等报错信息,描述数据库已被锁死,需要发送比特币到某个地址来解锁数据库。 OCCURRENCE 客户使用被恶意篡改的绿色版或破解版的客户端软件(如破解的PL/SQL Developer或者Toad等软件)去连接数据库,在此类软件中,在连接成功后,调用注入的SQL脚本(Login.sql、AfterConnect.sql、toad.ini等)执行恶意代码,在数据库中生成三个触发器和四个存储过程。 当数据库重启或者用户连接数据库时,触发器会调用相应的存储过程操作数据库。这些存储过程会可能会破坏数据库,并抛出错误信息和提示信息。 SYMPTONS 用户使用客户端连接数据库或者数据库Alert日志中出现ORA-20312/ORA-20313/ORA-20315等报错信息,描述数据库已被锁死,需要发送比特币到某个地址来解锁数据库。这些注入脚本伪装成Oracle内部程序: -- -- Copyright (c) 1988, 2011, Oracle and/or its affiliates. -- All rights reserved. -- -- NAME -- login.sql -- -- DESCRIPTION -- PL/SQL global login "site profile" file -- -- Add (more...)