Recently I have had an issue with slow unicode migration of the database upgraded from 10g to 188.8.131.52. The main problem was a table with xmltype: we spent about 4 hours for this table(~17GB) during test migration, though all other tables (~190GB) migrated just for about 20 minutes.
We used DMU(Database Migration Assistant for Unicode), and the root cause of the problem was update statement generated by DMU for this table:
I've received a question about client certification for Oracle Database 184.108.40.206 the other day.And this reminded me on this very helpful MOS Note:
MOS Note: 207303.1Client / Server Interoperability
Support Matrix for Different Oracle Versions
It spans the client interoperability back to the... [Read More
The latest release of Big Data Lite is now available on OTN! This 4.7 release contains key components of Oracle's big data platform. It has demos, tutorials and more. Listed below are the products/features that are installed:
Oracle Enterprise Linux 6.8
Oracle Database 12c Release 1... [Read More
Here’s one of those little improvements in 12c (including 12.1) that will probably end up being described as “little known features” in about 3 years time. Arguably it’s one of those little things that no-one should care about because it’s not the sort of thing you should do on a production system, but that doesn’t mean it won’t be seen in the wild.
Rather than simply state the feature I’m going to demonstrate it, (more...)
I keep finding ways to break things because the environments are not consistent.
This parameter is the UNIX group name to be set for the inventory on UNIX platforms.
Note: The UNIX group name is used for first-time installations only.
Details for oraInventory
$ cat /etc/oraInst.loc
Notice the group is dba while /etc/oraInst.loc has oinstall.
Probably because I specified UNIX_GROUP_NAME=dba?
Don’t remembered since this environment is really old.
$ ls -ld (more...)
is no doubt that web [Rest] APIs have become extremely popular and its
usage has gone well beyond just building APIs in support of mobile apps.
We can see the adoption of resource-oriented architectures (ROA)
by probably all SaaS vendors who provide out-of-the-box APIs as the
means to connect and interact with their cloud applications. Take for
example the Oracle Cloud. To discover and consume publicly available Oracle SaaS APIs, all one need to (more...)
One of the optimizer enhancements that appeared in 12.2 for SQL is the “band join”. that makes certain types of merge join much more efficient. Consider the following query (I’ll supply the SQL to create the demonstration at the end of the posting) which joins two tables of 10,000 rows each using a “between” predicate on a column which (just to make it easy to understand the size of the result set) happens (more...)
When using integrated extract, info command does not show Seqno, RBA, e.g. Seqno 3292, RBA 79236752.
Command send status will show Seqno, RBA; is not usable when process is stopped.
For Oracle GoldenGate – Version 220.127.116.11.2 and later, there is now debug option to retrieve Seqno, RBA.
Oracle GoldenGate Command Interpreter for Oracle
Version 18.104.22.168.1 OGGCORE_22.214.171.124.0_PLATFORMS_151211.1401_FBO
$ echo $ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 126.96.36.199.3
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version : 188.8.131.52.3
OUI version : 184.108.40.206.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2017-02-08_15-56-03PM_1.log
List of Homes on this (more...)
12c (220.127.116.11.0) RAC Oracle Linux Server release 7.3
/u01/software/grid/runcluvfy.sh stage -pre crsinst -n node1,node2 -verbose
Starting Clock synchronization checks using Network Time Protocol(NTP)...
Checking existence of NTP configuration file "/etc/ntp.conf" across nodes
Node Name File exists?
The NTP configuration file "/etc/ntp.conf" is available on all nodes
NTP configuration file "/etc/ntp.conf" existence check passed
Checking daemon liveness...
Check: Liveness for "ntpd"
This is new as of 18.104.22.168.
$ srvctl config database -d hawk
Database unique name: hawk
Database name: hawk
Oracle home: /u01/app/oracle/product/12.1.0/db_1
Oracle user: oracle
Password file: +DATA/hawk/orapwhawk
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Mount point paths:
OSDBA group: dba
Database instances: hawk1,hawk2
Configured nodes: hawk01,hawk02
Oracle Service Bus provides a reporting activity called Alert. The OSB pipeline alerts use a persistent store. This store is file based. Changing the persistent store to JDBC based, does not cause pipeline alerts to be stored in a database instead of on disk. When the persistent store on disk becomes large, opening pipeline alerts in the Enterprise Manager (12c) or Service Bus console (11g) can suffer from poor performance. If you put an archive (more...)
The Oracle Database 12c Release 2 (12.2) learning process continues. I’m determined to get to the bottom of all this new multitenant stuff.
Here’s the latest batch of articles.
I’ve written a couple of articles in the past about the problems of ASSM spending a lot of time trying to find blocks with usable free space. Without doing a bit of rocket science with some x$ objects, or O/S tracing for the relevant calls, or enabling a couple of nasty events, it’s not easy proving that ASSM might be a significant factor in a performance problem – until you get to 12c Release 2 (more...)
I don’t know how I missed it but Randolf Geist has been doing writing a series of posts on the performance of Oracle’s DBaaS offering, using a series of long-running tests to capture not only raw performance figures but also an indication of consistency. You can find all of these tests with a search URL on his blog, but I’ve also created a little index here to make it easier for me to access (more...)
A while ago I published a Whitebook (in Dutch) about building OSB 12c releases on resource level using Maven. In the Whitebook, you could read which functionality we were missing in the regular Oracle Service Bus plugin for Maven and how we were able to create this functionality using a custom Maven plugin.
I have added the code of this custom Maven plugin to the following public repository: https://bitbucket.org/whitehorsesbv/servicebusplugin
The custom Maven plugin (more...)
Richard Foote has published a couple of articles in the last few days on the new (licensed under the advanced compression option) compression mechanism in 12.2 for index leaf blocks. The second of these pointed out that the new “high compression” mechanism was even able to compress single-column unique indexes – a detail that doesn’t make sense and isn’t allowed for the older style “leading edge deduplication” mechanism for index compression.
In 12.2 (more...)
If you try the newest version 22.214.171.124 (or maybe earlier versions too) you see, that your managed server does not restart, when
- you have deployed your ADF application(s)
- you try to restart the managed server with ADF
- you use intentionally or not shared libraries in your weblogic-application.xml (see example below)
<?xml version = '1.0' encoding = 'UTF-8'?>
xsi:schemaLocation="http://www.bea.com/ns/weblogic/weblogic-application http://www.bea.com/ns/weblogic/weblogic-application/1.0/weblogic-application. (more...)