Feed aggregator

February 2019 Updates to EBS Technology Codelevel Checker (ETCC)

Steven Chan - Wed, 2019-02-13 09:51

The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify application or database tier overlay patches that need to be applied to your Oracle E-Business Suite Release 12.2 system. ETCC maps any missing overlay patches to the default corresponding Database Patch Set Update (PSU) patches, and displays them in a patch recommendation summary.

The ETCC tool was designed to be self-documenting, but you can find an introduction to it in Section 3 of Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (MOS Note 1594274.1).

What’s New

ETCC has been updated to include bug fixes and patching combinations for the following recommended versions of the following updates:

  • Oracle Database Proactive BP 12.1.0.2.190115
  • Oracle Database PSU 12.1.0.2.190115
  • Oracle JavaVM Component Database PSU 12.1.0.2.190115
  • Oracle Database Patch for Exadata BP 11.2.0.4.190115
  • Oracle Database PSU 11.2.0.4.190115
  • Oracle JavaVM Component Database PSU 11.2.0.4.190115
  • Microsoft Windows Database PSU 11.2.0.4.190115
  • Oracle JavaVM Component 2.1.0.2.180417 on Windows
  • Microsoft Windows Database BP 11.2.0.4.180417
  • Oracle JavaVM Component 11.2.0.4.180417 on Windows

Obtaining ETCC

We recommend always using the latest version of ETCC, as new bugfixes will not be checked by older versions of the utility. The latest version of the ETCC tool can always be downloaded via Patch 17537119 from My Oracle Support.

References

Related Articles

Categories: APPS Blogs

[Blog] Oracle GoldenGate: Supplemental Logging & Its Importance

Online Apps DBA - Wed, 2019-02-13 06:05

Do you want to learn about Supplemental Logging and its Importance in GoldenGate?   If yes, then visit: https://k21academy.com/goldengate18 and learn about: ✔ Supplemental Logging Levels ✔Why is Supplemental Logging Required & much more… Do you want to learn about Supplemental Logging and its Importance in GoldenGate?   If yes, then visit: https://k21academy.com/goldengate18 and learn […]

The post [Blog] Oracle GoldenGate: Supplemental Logging & Its Importance appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Best practices for keeping passwords hidden

Tom Kyte - Wed, 2019-02-13 03:26
Can you recommend best practices for keeping passwords hidden in command lines for impdp/expdp, shell scripts etc.?
Categories: DBA Blogs

Object View To Manipulate Data In Tables

Tom Kyte - Wed, 2019-02-13 03:26
Hi, I have been using Object View, User Defined Types in Oracle for sometime. I tried to follow the approach here. <code>https://docs.oracle.com/cd/A64702_01/doc/server.805/a58241/ch_ov.htm</code> I am wondering if we put all the data manipul...
Categories: DBA Blogs

Lob: Basic - Secure

Tom Kyte - Wed, 2019-02-13 03:26
We observed frequent wait event 'enq HW - contention' in performance reports with SQL includes LOB Objects. Lob object Details ? Object - WF_WORKFLOW Owner - IBMUCD What changes we can face if we convert LOB from basic to secure?...
Categories: DBA Blogs

Distinct count across multiple tables

Tom Kyte - Wed, 2019-02-13 03:26
I have three possible places where accounts data can be requested. On the MONTHLY USAGE, HISTORY USAGE or ENROLLMENT tables. The same account(s) could be on all three tables, or on the table(S) multiple times, but some accounts could be on one or ...
Categories: DBA Blogs

lost update

Tom Kyte - Wed, 2019-02-13 03:26
Tom, I was reading your book expert one-on-one and in Chapter 3: Locking and Concurrency, you have mentioned a scenario of lost update. I was trying to simulate that and I did not succeed in doing the test. I tried to update emp table in session...
Categories: DBA Blogs

Update a column after multiple criteria

Tom Kyte - Wed, 2019-02-13 03:26
Hello, I have the following data: Id AMAOUNT NO_PRATITION ID_STRATEGY 1 100 99 XXX 2 200 99 XXX 3 0 99 YYY 4 100 99 YYY 5 200 99 YYY 6 0 99 ZZZ 7 100 99 ZZZ 8 200 99 ...
Categories: DBA Blogs

How Oracle Database gets the data from multiple left joins

Tom Kyte - Wed, 2019-02-13 03:26
Hi Tom, I came across a scenario today. table1 id integer name varchar table2 id integer name varchar designation varchar table3 id integer name varchar relation_status varchar I have the query as below which is working fine ...
Categories: DBA Blogs

Source Oracle Environment Easily

Michael Dinh - Tue, 2019-02-12 21:50

I have been patching a lot lately and wanted a fast and easy method to source Oracle environment.

The objective is to copy, paste from action plan vs having to selectively copy, edit, paste.

Example: . /media/patch/gi.env vs . oraenv — +ASM[n]

Started by creating gi.env which will be used to source GI for all RAC hosts.

You are probably thinking, isn’t it a PITA to have to edit and maintain all the gi.env per host, e.g. 6 nodes RAC cluster?

Rightfully so and it’s a PITA unless it’s dynamic.

There is one requirement: host# = instance#

Hence, +ASM1 is running on host05 will not work.

Next step would probably be to script the tasks.

DEMO1:

[oracle@racnode-dc1-1 ~]$ ps -ef|grep [p]mon
oracle 10818 1 0 03:58 ? 00:00:00 asm_pmon_+ASM1
oracle 11456 1 0 03:58 ? 00:00:00 ora_pmon_hawk1
oracle 11763 1 0 03:58 ? 00:00:00 mdb_pmon_-MGMTDB

[oracle@racnode-dc1-1 ~]$ . /media/patch/gi.env
ORACLE_SID = [+ASM1] ? The Oracle base remains unchanged with value /u01/app/oracle
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/oracle
GRID_HOME=/u01/app/12.2.0.1/grid
ORACLE_HOME=/u01/app/12.2.0.1/grid
Oracle Instance alive for sid “+ASM1”

[oracle@racnode-dc1-1 ~]$ . /media/patch/hawk.env
ORACLE_SID = [+ASM1] ? The Oracle base remains unchanged with value /u01/app/oracle
ORACLE_UNQNAME=hawk
ORACLE_SID=hawk1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/11.2.0.4/db1
Oracle Instance alive for sid “hawk1”

[oracle@racnode-dc1-1 ~]$ srvctl status database -d $ORACLE_UNQNAME
Instance hawk1 is running on node racnode-dc1-1
Instance hawk2 is running on node racnode-dc1-2

[oracle@racnode-dc1-1 ~]$ df -h /media/patch/
Filesystem Size Used Avail Use% Mounted on
media_patch 3.7T 413G 3.3T 12% /media/patch

[oracle@racnode-dc1-1 ~]$

[oracle@racnode-dc1-2 ~]$ ps -ef|grep [p]mon
oracle 7339 1 0 03:56 ? 00:00:00 asm_pmon_+ASM2
oracle 8904 1 0 03:57 ? 00:00:00 ora_pmon_hawk2

[oracle@racnode-dc1-2 ~]$ . /media/patch/gi.env
ORACLE_SID = [oracle] ? The Oracle base has been set to /u01/app/oracle
ORACLE_SID=+ASM2
ORACLE_BASE=/u01/app/oracle
GRID_HOME=/u01/app/12.2.0.1/grid
ORACLE_HOME=/u01/app/12.2.0.1/grid
Oracle Instance alive for sid “+ASM2”

[oracle@racnode-dc1-2 ~]$ . /media/patch/hawk.env
ORACLE_SID = [+ASM2] ? The Oracle base remains unchanged with value /u01/app/oracle
ORACLE_UNQNAME=hawk
ORACLE_SID=hawk2
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/11.2.0.4/db1
Oracle Instance alive for sid “hawk2”

[oracle@racnode-dc1-2 ~]$ srvctl status database -d $ORACLE_UNQNAME
Instance hawk1 is running on node racnode-dc1-1
Instance hawk2 is running on node racnode-dc1-2

[oracle@racnode-dc1-2 ~]$ cat /media/patch/gi.env
set +x
unset ORACLE_UNQNAME
h=$(hostname -s)
n=1
. oraenv <<< +ASM${h:${#h} – $n}
export GRID_HOME=$ORACLE_HOME
env|egrep ‘ORACLE|GRID’
sysresv|tail -1

[oracle@racnode-dc1-2 ~]$

[oracle@racnode-dc1-2 ~]$ cat /media/patch/hawk.env
set +x
h=$(hostname -s)
n=1
export ORACLE_UNQNAME=hawk
. oraenv <<< $ORACLE_UNQNAME${h:${#h} – $n}
env|grep ORACLE
sysresv|tail -1
[oracle@racnode-dc1-2 ~]$

DEMO2:

[oracle@racnode-dc1-1 ~]$ export PATCH_TOP_DIR=/u01/stage/patch/Jan2019
[oracle@racnode-dc1-1 ~]$
[oracle@racnode-dc1-1 ~]$ . /media/patch/gi.env
ORACLE_SID = [+ASM1] ? The Oracle base remains unchanged with value /u01/app/oracle
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/oracle
GRID_HOME=/u01/app/12.2.0.1/grid
ORACLE_HOME=/u01/app/12.2.0.1/grid
Oracle Instance alive for sid “+ASM1”
[oracle@racnode-dc1-1 ~]$
[oracle@racnode-dc1-1 ~]$ export PREPATCH_LOG=$PATCH_TOP_DIR/`echo $ORACLE_HOME | awk -F/ ‘{print $NF}’`_prepatch_”$(hostname -s)”_lsinv.log
[oracle@racnode-dc1-1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail > $PREPATCH_LOG; echo $?
0
[oracle@racnode-dc1-1 ~]$ ls -l $PREPATCH_LOG
-rw-r–r– 1 oracle oinstall 205889 Feb 13 04:41 /u01/stage/patch/Jan2019/grid_prepatch_racnode-dc1-1_lsinv.log
[oracle@racnode-dc1-1 ~]$
[oracle@racnode-dc1-1 ~]$ . /media/patch/hawk.env
ORACLE_SID = [+ASM1] ? The Oracle base remains unchanged with value /u01/app/oracle
ORACLE_UNQNAME=hawk
ORACLE_SID=hawk1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/11.2.0.4/db1
Oracle Instance alive for sid “hawk1”
[oracle@racnode-dc1-1 ~]$
[oracle@racnode-dc1-1 ~]$ export PREPATCH_LOG=$PATCH_TOP_DIR/`echo $ORACLE_HOME | awk -F/ ‘{print $NF}’`_prepatch_”$(hostname -s)”_lsinv.log
[oracle@racnode-dc1-1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail > $PREPATCH_LOG; echo $?
0
[oracle@racnode-dc1-1 ~]$ ls -l $PREPATCH_LOG
-rw-r–r– 1 oracle oinstall 118180 Feb 13 04:41 /u01/stage/patch/Jan2019/db1_prepatch_racnode-dc1-1_lsinv.log
[oracle@racnode-dc1-1 ~]$

 

 

One query in MySQL Performance Schema

Bobby Durrett's DBA Blog - Tue, 2019-02-12 16:48

I am learning about MySQL performance tuning. I read the Performance Schema chapter of the MySQL 5.7 manual and I have a MySQL 5.7.20 database running under Linux. I have a test table and I am running a simple query that does a full scan of the table and returns the sum of a couple of columns. The goal was to look at some Performance Schema tables to see what they would tell me about this simple query. I bounce the MySQL database service before running my test script so that the query pulls data from disk and not memory. A zip of my test script and its output is here: zip

I looked at the tables that had this pattern events_*_history_long. These are the four tables:

There seems to be a hierarchical relationship among these tables something like this:

  • statements->transactions
  • statements->stages->waits->waits

There may be other relationships that my simple test did not capture. If you look at the zip you will see all the levels of the hierarchy that I explored but, in this case, the bottom level seems the most interesting. Here is the query that explores the bottom of the statements->stages->waits->waits path:

select * from events_waits_history_long
where
NESTING_EVENT_ID in 
(select EVENT_ID from events_waits_history_long
where
NESTING_EVENT_ID in 
(select EVENT_ID from events_stages_history_long
where
NESTING_EVENT_ID in 
(select EVENT_ID from events_statements_history_long
where SQL_TEXT like concat('%te','st%'))
and NESTING_EVENT_TYPE = 'STATEMENT')
and NESTING_EVENT_TYPE = 'STAGE')
and NESTING_EVENT_TYPE = 'WAIT'
order by EVENT_ID;

The output reminds me of a trace in Oracle. It shows the individual disk reads and waits for internal locks and mutexs.

+-----------+----------+--------------+-------------------------------------------+-----------------+---------------+---------------+------------+-------+---------------+-------------------------------+------------+-------------+-----------------------+------------------+--------------------+----------------+-----------------+-------+
| THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME                                | SOURCE          | TIMER_START   | TIMER_END     | TIMER_WAIT | SPINS | OBJECT_SCHEMA | OBJECT_NAME                   | INDEX_NAME | OBJECT_TYPE | OBJECT_INSTANCE_BEGIN | NESTING_EVENT_ID | NESTING_EVENT_TYPE | OPERATION      | NUMBER_OF_BYTES | FLAGS |
+-----------+----------+--------------+-------------------------------------------+-----------------+---------------+---------------+------------+-------+---------------+-------------------------------+------------+-------------+-----------------------+------------------+--------------------+----------------+-----------------+-------+
|        28 |    11162 |        11162 | wait/io/file/innodb/innodb_data_file      | fil0fil.cc:5778 | 5744476160960 | 5744479752316 |    3591356 |  NULL | NULL          | /var/lib/mysql/bobby/test.ibd | NULL       | FILE        |       139648405042752 |              203 | WAIT               | read           |           16384 |  NULL |
|        28 |    11163 |        11163 | wait/synch/mutex/innodb/buf_pool_mutex    | buf0lru.cc:1320 | 5744479934370 | 5744479974470 |      40100 |  NULL | NULL          | NULL                          | NULL       | NULL        |              66655496 |              203 | WAIT               | lock           |            NULL |  NULL |
|        28 |    11164 |        11164 | wait/synch/mutex/innodb/buf_pool_mutex    | buf0buf.cc:5150 | 5744480619278 | 5744480646546 |      27268 |  NULL | NULL          | NULL                          | NULL       | NULL        |              66655496 |              203 | WAIT               | lock           |            NULL |  NULL |
|        28 |    11165 |        11165 | wait/synch/sxlock/innodb/hash_table_locks | buf0buf.cc:5153 | 5744480749202 | 5744480858274 |     109072 |  NULL | NULL          | NULL                          | NULL       | NULL        |              70197752 |              203 | WAIT               | exclusive_lock |            NULL |  NULL |
|        28 |    11166 |        11166 | wait/synch/mutex/innodb/fil_system_mutex  | fil0fil.cc:1032 | 5744481202332 | 5744481236016 |      33684 |  NULL | NULL          | NULL                          | NULL       | NULL        |              66654712 |              203 | WAIT               | lock           |            NULL |  NULL |
|        28 |    11167 |        11167 | wait/io/file/innodb/innodb_data_file      | fil0fil.cc:5778 | 5744481464586 | 5744485206718 |    3742132 |  NULL | NULL          | /var/lib/mysql/bobby/test.ibd | NULL       | FILE        |       139648405042752 |              203 | WAIT               | read           |           16384 |  NULL |
|        28 |    11168 |        11168 | wait/synch/mutex/innodb/buf_pool_mutex    | buf0lru.cc:1320 | 5744485374336 | 5744485415238 |      40902 |  NULL | NULL          | NULL                          | NULL       | NULL        |              66655496 |              203 | WAIT               | lock           |            NULL |  NULL |
|        28 |    11169 |        11169 | wait/synch/mutex/innodb/buf_pool_mutex    | buf0buf.cc:5150 | 5744485590876 | 5744485618144 |      27268 |  NULL | NULL          | NULL                          | NULL       | NULL        |              66655496 |              203 | WAIT               | lock           |            NULL |  NULL |
|        28 |    11170 |        11170 | wait/synch/sxlock/innodb/hash_table_locks | buf0buf.cc:5153 | 5744485730424 | 5744485815436 |      85012 |  NULL | NULL          | NULL                          | NULL       | NULL        |              70197624 |              203 | WAIT               | exclusive_lock |            NULL |  NULL |
|        28 |    11171 |        11171 | wait/synch/mutex/innodb/fil_system_mutex  | fil0fil.cc:1032 | 5744486328716 | 5744486357588 |      28872 |  NULL | NULL          | NULL                          | NULL       | NULL        |              66654712 |              203 | WAIT               | lock           |            NULL |  NULL |
|        28 |    11172 |        11172 | wait/io/file/innodb/innodb_data_file      | fil0fil.cc:5778 | 5744486586960 | 5744490523176 |    3936216 |  NULL | NULL          | /var/lib/mysql/bobby/test.ibd | NULL       | FILE        |       139648405042752 |              203 | WAIT               | read           |           16384 |  NULL |
|
... edited for length...

Most of the time seems to be taken up on reads from a file, which is what I expected. If you look at the wait/io/file/innodb/innodb_data_file waits they seem to be 16384 byte reads from the file associated with the table. I could use this information to build a query to show a profile of the time spent by the query based on EVENT_NAME. It would be kind of like a tkprof of an Oracle trace.

This post is just a simple first test. I am new to MySQL tuning so feel free to leave a comment or email me if you have suggestions or corrections related to this post.

Bobby

Categories: DBA Blogs

November 2018 Report Manager Recommended Patch Collection Available for EBS R12.2

Steven Chan - Tue, 2019-02-12 11:04

Oracle Report Manager is an online report distribution system that allows you to produce and manage point-in-time reports. Oracle Report Manager users can be either report producers or report consumers. Report producers submit, publish, and set security for reports. Report consumers view and approve reports.

We have released a new Report Manager Recommended Patch Collection (RPC) for EBS 12.2. This RPC is cumulative: that is, it includes all bug fixes and updates released previously, including the last patch collection released in February 2016 (as Patch 22642639:R12.FRM.C).

You can download this latest Report Manager for EBS R12.2 update as Patch 28727121:R12.FRM.C, available from My Oracle Support:

References

Related Articles
Categories: APPS Blogs

Please help understand expiration_secs in sys.dbms_lock.allocate_unique

Tom Kyte - Tue, 2019-02-12 09:06
Please help understand the meaning of the param <b>expiration_secs</b> in <code>sys.dbms_lock.allocate_unique</code> Does it represent the time till which the named DB lock stays on, if not unlocked/commit/rollback by the same session? https:/...
Categories: DBA Blogs

Cautions using GMT/UTC in AWS RDS instance when located in EST region

Tom Kyte - Tue, 2019-02-12 09:06
Background: 1. I have just created a Database out on an AWS RDS instance on the East Coast. 2. I noted that the TimeZone was set to GMT/UTC (Greenwich Mean Time) when I setup DB in AWS. 3. I note that when I query <select sysdate from dual;> from ...
Categories: DBA Blogs

Log Stored Procedure calls

Tom Kyte - Tue, 2019-02-12 09:06
Our solution exposes a Stored Procedure to a DB user having the right grants to execute it. We need to know the date and time for each execution for that stored procedure. We are in production, so we can not instrument the running code of the store...
Categories: DBA Blogs

Unable to read trace file generated by EXPDP

Tom Kyte - Tue, 2019-02-12 09:06
HI THERE, We are running EXPDP on a daily basis and size for the schema is only 14GB but the job is taking around 6 hours to complete. so yesterday i executed the expdp with TRACE=480300 and i got One trace file for the master processes testd...
Categories: DBA Blogs

How to create a cursor of select * from dual with input arguments?

Tom Kyte - Tue, 2019-02-12 09:06
Hi Tom, Recently I am using the rqEval function which is part of Oracle Advanced Analytics. The input of this function includes a cursor such as SELECT * FROM table(rqEval(cursor(SELECT 50 "divisor", 500 "numDots" FROM dual), 'SELECT 1 ...
Categories: DBA Blogs

Oracle Accelerates Adoption of Enterprise Blockchain Worldwide

Oracle Press Releases - Tue, 2019-02-12 07:05
Press Release
Oracle Accelerates Adoption of Enterprise Blockchain Worldwide Blockchain platform delivers new capabilities that accelerate business benefits

Redwood Shores, Calif.—Feb 12, 2019

Businesses around the world have already reaped the benefits of blockchain applications built on Oracle Blockchain Platform. Companies using Oracle’s business-ready blockchain have been able to move from experimentation to production by creating new blockchain applications from scratch or adding blockchain functionality to an existing solution. To support its customers, Oracle has added new features to the platform that help users speed up the development, integration, and deployment of new blockchain applications.

While blockchain can greatly streamline many existing processes surrounding supply chain, identity, cross-border payments, and fraud detection, businesses have struggled to implement blockchain networks within their existing ecosystems. Oracle Blockchain Platform addresses this challenge by streamlining the process of building and integrating blockchain applications across diverse business networks and connecting them into the relevant business processes within these ecosystems.

“Oracle’s continued leadership and investment in enterprise blockchain technology ensures that the platform has all of the critical capabilities organizations need to build blockchain applications to handle their most important business transactions,” said Frank Xiong, group vice president, Blockchain Product Development, Oracle. “The number of customers already running blockchain applications based on Oracle’s blockchain platform is testament to the strength of the technology and the value it brings to a broad range of industries.”

Worldwide Customers with Blockchain Apps in Use

Using blockchain applications, Oracle customers are establishing new ways to increase trust in diverse ecosystems and increasing the speed, security and efficiency of a wide range of business processes. Oracle’s rapidly growing list of global customers with production deployments on its enterprise-grade blockchain platform include:

  • China Distance Education Holdings Limited (CDEL) uses blockchain to share educational records and professional certifications across many educational institutions to help employers and recruiters verify the educational credentials claimed by individuals.
  • Circulor uses blockchain to track conflict minerals from their origin at the mines to processing and use in electronic components to ensure ethical sourcing of raw materials.
  • SERES uses blockchain to bring greater trust and efficiency to electronic invoicing in franchise networks, which share ordering and fulfillment data between franchisors and franchisees.
  • Additionally, Arab Jordan Investment Bank, CargoSmart, Certified Origins, HealthSync, ICS Financial Systems, NeuroSoft, Nigeria Customs, OriginTrail, SDK.Finance, and TradeFin have built or integrated production-ready blockchain applications on Oracle Blockchain Platform.
 

“Oracle’s blockchain solution delivers enterprise performance, security and scalability right out-of-the-box,” said Doug Johnson-Poensgen, CEO and founder of Circulor. “We started with the Oracle Blockchain Platform four months ago and were able to go from zero to a production system spanning multiple organizations involved in ethical sourcing of minerals within a matter of months. Another key advantage is that we were able to integrate Oracle’s blockchain platform into a hybrid blockchain network spanning multiple clouds and easily integrate with our existing systems and applications.”

“Blockchain improves the trust relationship between franchisor and the franchises by including best practices and decentralized access to the transactions.  Normally, merchandise acceptance processes are manual and require an operator entering the data into the system. But, for example when a franchise has economic problems, it can repudiate that delivery, saying that it never received the merchandise. They can manipulate the database and, on the other hand, also the franchisor can manipulate it,” said José María Mínguez Gutiérrez, Transactional Services Manager of SERES. “With blockchain and its immutability and traceability of information, all these problems disappear and all parties can trust the data and the transactions.”

Enhances Security, Developer Productivity and DevOps Capabilities

With this latest release, Oracle has added unique developer-oriented productivity enhancements and consortium-oriented identity management features, which are critical to diverse organizations conducting business transactions via a blockchain network. New DevOps capabilities make the platform easier to integrate with existing business and IT systems. Additionally, as blockchain becomes an important data store in the enterprise, the platform enables Oracle Autonomous Data Warehouse customers to transparently capture blockchain transaction history and current state data for analytics and to integrate it with other data sources. New features include:

  • Enhanced world state database to support standard SQL-based ledger queries reducing the complexity of developing chaincode using readily available programming skills, ensure smart contracts can safely rely on the query results, which are verified at transaction commit, and significantly boost performance of rich data queries.
  • Rich history database shadows transaction history into a relational database schema in the Autonomous Data Warehouse or other Oracle databases, which transparently enables analytics integration for interactive dashboards and reports.
  • Enhanced REST APIs for event subscription, blockchain administration/configuration, and monitoring of network health, transaction rates, and other statistics, which simplify integration with existing enterprise IT tools.
  • Identity federation further extends authentication capabilities to work with external identity providers to facilitate consortium blockchains with many diverse participants using their existing identity management systems.
  • Third-party certificate support for registering client organizations on the blockchain network to enable them to use existing certificates issued by trusted third parties.
  • Hyperledger Fabric 1.3 support, which adds many new features based on the evolving open source version, including chaincode development in Java, further leveraging existing enterprise skills, and support for private transactions among a subset of members, preserving privacy and business confidentiality. This demonstrates Oracle’s commitment to stay current with the Hyperledger community by leveraging new releases and contributing to the open source community.
  About Oracle Blockchain

Only Oracle provides a comprehensive blockchain offering, including business-ready Oracle Blockchain Applications Cloud and Oracle Blockchain Platform for developers who need to build or integrate their applications. Oracle’s blockchain applications are built with Oracle Blockchain Platform and seamlessly connect with Oracle Supply Chain Management (SCM) Cloud, Oracle Enterprise Resource Planning (ERP) Cloud and other Oracle Cloud Applications. Oracle Blockchain Platform is production ready with enterprise-grade capabilities, easy to adopt, and quick to develop upon, accelerating customer’s blockchain journeys and saving their costs.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly-Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. 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.

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Oracle Blockchain Helps Czech Financial Firm, SDK.finance, Transform Payment Industry

Oracle Press Releases - Tue, 2019-02-12 07:00
Press Release
Oracle Blockchain Helps Czech Financial Firm, SDK.finance, Transform Payment Industry Oracle Blockchain Platform streamlines cross-border payments and cuts fees

Redwood Shores, Calif.—Feb 12, 2019

SDK.finance is using Oracle Blockchain Platform to help the company transform the rapidly evolving payments industry. By integrating Oracle Blockchain Platform into its core payment platform for banks and financial institutions, SDK.finance provides a secure payment system that removes the need for intermediaries, such as correspondent banks and clearing houses. This helps facilitate faster, more cost effective and secure payments, and as a result, can improve the overall customer experience.

Pavlo Sidelov, Chief Technical Officer, SDK.finance said, “Despite the considerable disruption of the financial services industry, cross-border payments are still very slow, the associated fees are expensive, and there is an inherent lack of trust, especially around peer-to-peer payments. We are removing these pain points by providing a platform that drives highly secure, affordable, and fast transactions. Oracle’s enterprise-grade blockchain cloud platform is critical to helping us achieve these goals.”

Using Oracle’s reliable and high performing distributed ledger technology, SDK.finance provides its customers with trusted real-time verification of transactions. Replacing intermediary financial institutions with the new system means that transactions only need to be confirmed through the blockchain, which has the potential to reduce the time needed for cross-border transactions from days or even weeks to a matter of seconds. It also removes the associated transaction fees, benefitting both end users and merchants, as they gain an alternative way to accept payments without the heavy fees charged by banks and payment processing companies on transactions and chargebacks. This allows them to provide better value and improve the experience for their customers.

Frank Xiong, group vice president, Blockchain Development Platform, Oracle said, “Blockchain has the power to impact all industries, including financial services and organizations like SDK.finance. Using Oracle Blockchain Platform, SDK.finance can change the future of digital payment processing, improving the user experience, security, speed, and cost of each payment dramatically.”

Oracle provides a comprehensive blockchain offering, including business-ready Oracle Blockchain Applications Cloud and a pre-assembled Oracle Blockchain Platform for developers building or integrating their own applications. Oracle Blockchain Platform is production-ready with enterprise-grade capabilities, easy to adopt, and quick to develop upon, helping to save customers’ time and costs and accelerating their blockchain journeys.

Blockchain technology can reduce the security issues in mobile payments and online purchases. The inherent trust factor related with blockchain is most important when dealing with peer-to-peer payments. With blockchain technology, the digitally signed transaction requests, results verification via smart contracts and multi-party consensus helps to protect the users’ digital transactions. Blockchain technology has the potential to solve security concerns by providing a permissioned platform that ensures full transparency between transacting parties.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
About SDK.finance

SDK.finance is a fully-fledged finance platform wrapped in 340+ APIs. It enables PSPs, EMIs & banks to launch payment or loyalty products saving time 10x, and decreasing 90% of CAPEX. SDK.finance allows customers to build Payment Services, E-wallet, P2P Money Transfer, Currency Exchange, and much more.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly-Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. 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.

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Cloud Company NetSuite Helps UAE Organizations Scale and Grow

Oracle Press Releases - Tue, 2019-02-12 02:00
Press Release
Cloud Company NetSuite Helps UAE Organizations Scale and Grow NetSuite introduces new product capabilities and expands partner ecosystem to meet growing customer demand

GROW LIVE DUBAI, UNITED ARAB EMIRATES—Feb 12, 2019

To support growing customer demand in the United Arab Emirates (UAE), Oracle NetSuite has expanded its partner ecosystem in the region and introduced new innovations to help organizations gain the visibility and control needed to navigate change and accelerate growth. The new partnerships and innovations are designed to help UAE organizations drive growth, reduce costs and quickly and easily achieve the benefits of cloud computing.

“The UAE is putting a huge focus on business growth and economic development and this is creating a unique opportunity for innovation,” said Nicky Tozer, VP of EMEA, Oracle NetSuite. “With our new innovations and expanded partner ecosystem, we are strongly placed to help UAE customers capitalize on this opportunity.”

Growing Customer Base

NetSuite is helping UAE organizations and international subsidiaries operating in-region gain the visibility and control needed to navigate change and accelerate growth.

Dubai-based smartphone manufacturer Condor Middle East has reduced the time spent on business processes by 75 percent since adopting NetSuite. “We wanted to increase visibility into our operations and improve the outputs we get from our system. With NetSuite, we’ve streamlined operations and now have a unified and flexible business platform that can support our objectives,” said Ayman Samy, General Manager, Condor Middle East.

UAE healthy snack company Munchbox credits NetSuite with enabling it to meet its triple digit growth goals. “We found NetSuite best suited to our needs—minimal upfront investment, positive testimonials from customers and passionate customer care from the team,” said Mahmoud Adham, CEO, Munchbox.

UAE-based retail distributor Denaster General Trading LLC, which helps international brands reach consumers across the Middle East, selected NetSuite to support its international expansion into India and the UK. “To support our international expansion, we need a flexible business platform that can give us a real-time view into our business. NetSuite meets this need and its proven track record of helping companies like ours scale internationally will be a huge advantage,” said Deep Bhogal, Managing Director, Denaster General Trading LLC.

New SuiteSuccess Industry Cloud Solution

The latest innovations within the NetSuite platform include new SuiteSuccess Financials First capabilities that help organizations operating in the UAE automate financial processes, improve reporting and gain real-time visibility into key business metrics. Built on industry-leading practices and deep domain knowledge, SuiteSuccess includes pre-defined roles, KPIs, dashboards and workflows for finance departments.

The functionality allows for VAT support, enabling organizations to comply with tax rules from the Unified Value Added Tax (VAT) agreement signed by Gulf Cooperation Council (GCC) countries. The highly flexible tax engine supports over 110 countries for VAT—including rules and reporting—creating a solid foundation for GCC VAT functionality.

Bolstered Partner Ecosystem

To meet growing customer demand for cloud business management solutions in the UAE, NetSuite has expanded the NetSuite Alliance Partner Program with the addition of seven new partners to help customers across industries adapt to change and achieve faster time to value.

“We’ve partnered with NetSuite on over 400 implementations. We view NetSuite as the number one cloud ERP company in the UAE as it enables organizations of all sizes to adapt to this fast-changing market,” said Amit Prabhu, General Manager of Aarialife Technologies.

“We’re delighted to join forces with NetSuite. This investment will allow us to apply our advanced ERP implementation capabilities to NetSuite’s world-leading business management software skills so we can support customers across the region to achieve greater efficiency in their organization,” Farhan Al Bastaki, CEO, Sharaf HQ Investment.

Contact Info
Samuel Jamieson
PR Manager, EMEA
+44 (0)7468 752231
sjamieson@netsuite.com
About Oracle NetSuite

For more than 20 years, Oracle NetSuite has helped organizations grow, scale and adapt to change. NetSuite provides a suite of cloud-based applications, which includes financials/Enterprise Resource Planning (ERP), HR, professional services automation and omnichannel commerce, used by more than 16,000 customers in 203 countries and dependent territories.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly-Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. 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.

Talk to a Press Contact

Samuel Jamieson

  • +44 (0)7468 752231

Pages

Subscribe to Oracle FAQ aggregator