Feed aggregator

Video : Oracle REST Data Services (ORDS) : OAuth Implicit

Tim Hall - Mon, 2019-11-25 02:21

In today’s video we look at the OAuth Implicit flow for Oracle REST Data Services.

This goes together with a previous video about first-party authentication here.

Both videos are based on parts of this article.

There are loads of other ORDS articles here.

The star of today’s video is Bob Rhubart, who amongst other things is the host of the Oracle Groundbreakers Podcast.

Cheers

Tim…

Video : Oracle REST Data Services (ORDS) : OAuth Implicit was first posted on November 25, 2019 at 9:21 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Believer | Keyboard Performance | by Dharun at Improviser Music Studio

Senthil Rajendran - Sun, 2019-11-24 07:08

My Son Dharun Performing at Improviser Music Studio

Believer



Please subscribe to our channel Improviser Music Studio

How to run a java software which needs RXTX on a raspberry pi

Dietrich Schroff - Sat, 2019-11-23 12:35
In my last posting i wrote about migrating my aircraft noise measurement station to alpine linux. There i had some problems with getting the RXTX library for Java running on a linux, which uses musl and not GNU libc6.

Why does my java application require RXTX? As stated on the RXTX page:
RXTX is a Java library, using a native implementation (via JNI), providing serial and parallel communication for the Java Development Toolkit (JDK).Now i wanted to move to a raspberry pi. But this runs on ARM and the RXTX is only provided for x86/x64 systems.

But there is another way: ser2net


With this proxy /dev/ttyUSB0 can be mapped to a tcp port and java can access this without using RXTX.

DOAG 2019: Cloud or Kubernetes on premise and CI/CD pipeline at the top of (my) interest

Yann Neuhaus - Fri, 2019-11-22 11:33

The DOAG 2019 is just over now and if I check the subject of sessions I was attending, I have the feeling the Cloud and Kubernetes on-premise deployments and CI/CD pipelines were the top subjects interesting people or may be just me !!

I started by a devOps session and then followed a lot of Kubernetes or containers related sessions. The three following sessions are those I directly think about when trying to summarize.

“The Pillars of Continuous Delivery” – Lykle Thijssen

A very interesting session about continuous delivery.

“How to create a solid foundation for Continuous Delivery, based on four pillars: Agile, Microservices, Automation and Cloud. Lykle explained how agile development can reduce time to production by short development cycles, how Microservices make the deployment process easier with less dependencies, how automation can improve test, build and deployment and how cloud can help with the necessary infrastructure. It all hangs together and without a solid foundation, there is always the risk of building a house of cards.”

“Containers Demystified” – Jan Karremans and Daniel Westermann

“If you are looking at implementing Dev/Ops, infrastructure as a code, if you want to adopt the Cloud or seeking to go with Microservices, you will find Containers on you path. After the opportunities that virtualization brought, Containers are the next best thing! Also (and perhaps specifically) looking at databases with containers, it brings specific challenges. Where containers infrastructures are built to fail and database rely on persistency, you have challenges.”

Watch My Services: Prometheus in Kubernetes – Thorsten Wussow

“The monitoring of microservices is a special challenge. In the lecture the problem of a monitoring of microservices will be discussed. Furthermore, various products are briefly considered, with which one can still carry out such a monitoring. Then a demo shows how to set up monitoring in a Kubernetes cluster with the help of Prometheus and Grafana and what to look for.”

A Kubernetes cluster was used in the Oracle Infrastructure Cloud to demonstrate the deployment and the configuration of Promotheus and Grafana.
With Thorsten, it always looks simple when following the demonstration. Now it is is time to implement it.

Kubernetes im Vergleich: Google, AWS, Oracle, Microsoft – Michael Schulze & Borys Neselovskyi

“The presentation gives a brief overview of the architecture and construction of Kubernetes. In addition, useful application scenarios are presented in selected use cases. Later in the talk, we will compare existing Kubernetes cloud solutions from leading vendors (Google, AWS, Oracle and Microsoft). Here, a customer scenario is used as the basis for the comparison. The following criteria play a role: installation, maintenance, performance, monitoring and, of course, costs.”

A nice comparison between the different cloud solutions.

There were some other very interesting sessions but I will not list all of them now.

DOAG 2019 is over. See you next year there in Nuremberg

Cet article DOAG 2019: Cloud or Kubernetes on premise and CI/CD pipeline at the top of (my) interest est apparu en premier sur Blog dbi services.

Oracle Database 18c: New Features asmcmd

Michael Dinh - Fri, 2019-11-22 11:11
============================================================
NEW:
============================================================

[oracle@ol7-19-rac1 ~]$ asmcmd showversion
ASM version         : 19.4.0.0.0
[oracle@ol7-19-rac1 ~]$ 

============================================================
OLD:
============================================================

[oracle@ol7-19-rac1 ~]$ asmcmd -V
asmcmd version 19.4.0.0.0
[oracle@ol7-19-rac1 ~]$

============================================================
NEW:
============================================================

[oracle@ol7-19-rac1 ~]$ asmcmd showpatches
---------------
List of Patches
===============
29401763
29517242
29517247
29585399
29834717
29850993
29851014

[oracle@ol7-19-rac1 ~]$ asmcmd showpatches -l
Oracle ASM release patch level is [2037353368] and 
the complete list of patches [29401763 29517242 29517247 29585399 29834717 29850993 29851014 ] have been applied on the local node. 
The release patch string is [19.4.0.0.0].
[oracle@ol7-19-rac1 ~]$

============================================================
OLD:
============================================================

### MISSING from OLD are previous 19.3 version:
29517247; ACFS RELEASE UPDATE 19.3.0.0.0	
29585399; OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242; Database Release Update : 19.3.0.0.190416 (29517242)

[oracle@ol7-19-rac1 ~]$ crsctl query crs releasepatch
Oracle Clusterware release patch level is [2037353368] and 
the complete list of patches [29401763 29517242 29517247 29585399 29834717 29850993 29851014 ] have been applied on the local node. 
The release patch string is [19.4.0.0.0].
[oracle@ol7-19-rac1 ~]$

[oracle@ol7-19-rac1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
29851014;ACFS RELEASE UPDATE 19.4.0.0.0 (29851014)
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)

OPatch succeeded.
[oracle@ol7-19-rac1 ~]$

============================================================
NEW:
============================================================

[oracle@ol7-19-rac1 ~]$ asmcmd showversion --softwarepatch
ASM version         : 19.4.0.0.0
Software patchlevel : 2037353368
[oracle@ol7-19-rac1 ~]$

============================================================
OLD:
============================================================

[oracle@ol7-19-rac1 ~]$ crsctl query crs softwarepatch
Oracle Clusterware patch level on node ol7-19-rac1 is [2037353368].
[oracle@ol7-19-rac1 ~]$

============================================================
NEW:
============================================================

[oracle@ol7-19-rac1 ~]$ asmcmd showversion --active
Oracle ASM active version on the cluster is [19.0.0.0.0]. 
The cluster upgrade state is [NORMAL]. 
The cluster active patch level is [2037353368].
[oracle@ol7-19-rac1 ~]$

============================================================
OLD:
============================================================

[oracle@ol7-19-rac1 ~]$ crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. 
The cluster upgrade state is [NORMAL]. 
The cluster active patch level is [2037353368].
[oracle@ol7-19-rac1 ~]$

============================================================
NEW:
============================================================

[oracle@ol7-19-rac1 ~]$ asmcmd showversion --releasepatch
ASM version         : 19.4.0.0.0
Information about release patchlevel is unavailable since no ASM instance connected

[oracle@ol7-19-rac1 ~]$ asmcmd
ASMCMD> showversion --releasepatch
ASM version         : 19.4.0.0.0
Release patchlevel  : 2037353368
ASMCMD>

============================================================
OLD:
============================================================

[oracle@ol7-19-rac1 ~]$ crsctl query crs releasepatch
Oracle Clusterware release patch level is [2037353368] and 
the complete list of patches [29401763 29517242 29517247 29585399 29834717 29850993 29851014 ] have been applied on the local node. 
The release patch string is [19.4.0.0.0].
[oracle@ol7-19-rac1 ~]$

Basically, the new features for asmcmd existed for crsctl query and use the ones best suited.

Nightly process slowing down.

Tom Kyte - Thu, 2019-11-21 11:50
Hi. We have a process that runs every night that is beginning to slow down and we need some help to find the resources to analyse the problem. In our setup, unfortunately both transaction schemas and warehousing (statistics) schemas are kept on...
Categories: DBA Blogs

Golden Signals for performance

Tom Kyte - Thu, 2019-11-21 11:50
Hello Tom I am a member of an site reliability team (SRE) and we are trying to develop SRE "golden signals" for an Oracle 11g/12c database. These signal are: 1) Throughput 2) Latency 3) Response Time 4) Error rate (not sure about this one...
Categories: DBA Blogs

Difference between DBRM and IORM

Tom Kyte - Thu, 2019-11-21 11:50
Dear Sir, Please help me to know below points. 1)difference between DBRM and IORM? 2)difference between ACFS,ADVM and DBFS? Thanks Pradeep
Categories: DBA Blogs

SQL*Loader-503 in 19c for UNC names

Tom Kyte - Thu, 2019-11-21 11:50
Hi TOM, next Month we are migrating from Oracle 12.1.0.2 to Oracle 19, so I installed the new Oracle Client 19c on my PC. Using SQLLDR with (all in one line) sqlldr userid=user/passwd@server control=\\server\share$\folder\controlfile.ini ...
Categories: DBA Blogs

future of dba

Tom Kyte - Thu, 2019-11-21 11:50
Dear, I am Core Oracle DBA. I do not have experience in RAC,Golden Gate. Sometimes I worried about future of oracle dba in upcoming years in India for all industry like medium and large company. Can you give some recommendation or new technology n...
Categories: DBA Blogs

questions about sampling

Tom Kyte - Thu, 2019-11-21 11:50
<b>a. how does sampling work internally ?</b> meaning: how is it determined by Oracle which blocks are read by a sample-query and which not ? <code>create table t as select level i, rpad('a', 1000, 'a') s from dual connect by level <= 1e5; cre...
Categories: DBA Blogs

Local temporary tablespace

Tom Kyte - Thu, 2019-11-21 11:50
Since Oracle 12.2, Oracle has introduced a new feature of local temporary tablespace. The documentation does not provide any information on the pros and cons of this new feature. Can you please provide some information on why this feature was introdu...
Categories: DBA Blogs

Is Your Print Screen not Working? We are here to help!

VitalSoftTech - Thu, 2019-11-21 09:54

Print Screen is a hotkey present on your keyboard that helps you take the snapshot of your desktop screen and save it on the computer. All you have to do is press this button, open Paint, press ‘Ctrl+V,’ crop the image to your setting and Voila! Computers make everything we do more comfortable, including the […]

The post Is Your Print Screen not Working? We are here to help! appeared first on VitalSoftTech.

Categories: DBA Blogs

Oracle Security Training Manuals for Sale

Pete Finnigan - Wed, 2019-11-20 20:50
We have one set of Manuals for the recent training we held here in York and one from 2018. These can be bought as individual books as follows: This manual is from the York class in October 2019 and can....[Read More]

Posted by Pete On 19/11/19 At 03:05 PM

Categories: Security Blogs

Installing Oracle GoldenGate Microservices – Part 2 of 2

DBASolved - Wed, 2019-11-20 14:32

In the my last post, I showed you how to install the binaries for Oracle GoldenGate Microservices.  Then at the end of the post, I mentioned that you will need to run Oracle GoldenGate Configuration Assistant to finish the configuration of Oracle GoldenGate Microservices.  Let’s take a look at how to do this. After installing […]

The post Installing Oracle GoldenGate Microservices – Part 2 of 2 appeared first on DBASolved.

Categories: DBA Blogs

Installing Oracle GoldenGate Microservices – Part 1 of 2

DBASolved - Wed, 2019-11-20 10:43

Recently I was exchanging emails with a few community members about Oracle GoldenGate Microservices.  One of them commented on that Oracle GoldenGate Microservices was difficult to install; at the time, I was puzzled.  The reason I was puzzled was due to the install process for Oracle GoldenGate hasn’t changed since Oracle GoldenGate 12.1 came out […]

The post Installing Oracle GoldenGate Microservices – Part 1 of 2 appeared first on DBASolved.

Categories: DBA Blogs

What’s Taking So Long For Autoupgrade

Michael Dinh - Wed, 2019-11-20 08:53

Directory for autoupgrade/log: $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log, where $ORACLE_UNQNAME=db_unique_name

Create upgrade.config as shown: $ORACLE_BASE/admin/$ORACLE_UNQNAME/${ORACLE_UNQNAME}_upgrade.config

global.autoupg_log_dir=$ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log
upg1.log_dir=$ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log
upg1.dbname=$ORACLE_UNQNAME
upg1.sid=$ORACLE_SID
upg1.start_time=NOW
upg1.source_home=/oracle/app/product/11.2/dbhome_1
upg1.target_home=/oracle/app/product/12.2/dbhome_1
upg1.upgrade_node=localhost
upg1.target_version=12.2
upg1.timezone_upg=no
upg1.restoration=yes

Let’s take a took at summary for autograde job process 102.
Find autoupgrade directories.

$ export JOBNO=102
$ ls -l $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log/*/*/*
-rwx------    1 oracle   dba           73349 Nov 04 12:46 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/100/autoupgrade_20191104.log
-rwx------    1 oracle   dba             233 Nov 04 12:46 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/100/autoupgrade_20191104_user.log
-rwx------    1 oracle   dba               0 Nov 04 12:46 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/100/autoupgrade_err.log
-rwx------    1 oracle   dba           71390 Nov 04 13:07 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/101/autoupgrade_20191104.log
-rwx------    1 oracle   dba             233 Nov 04 13:06 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/101/autoupgrade_20191104_user.log
-rwx------    1 oracle   dba               0 Nov 04 13:06 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/101/autoupgrade_err.log
-rwx------    1 oracle   dba          891207 Nov 04 16:01 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/autoupgrade_20191104.log
-rwx------    1 oracle   dba           12371 Nov 04 16:01 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/autoupgrade_20191104_user.log
-rwx------    1 oracle   dba             245 Nov 04 15:50 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/autoupgrade_err.log
-rwx------    1 oracle   dba            1118 Nov 04 12:46 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/after_upgrade_pfile_ORACLE_SID.ora
-rwx------    1 oracle   dba               0 Nov 04 14:05 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/ORACLE_SID.restart
-rwx------    1 oracle   dba            2236 Nov 04 15:48 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/ORACLE_SID_autocompile.sql
-rwx------    1 oracle   dba           16805 Nov 04 13:52 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/ORACLE_SID_catnoamd.sql
-rwx------    1 oracle   dba            3685 Nov 04 13:56 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/ORACLE_SID_catnoexf.sql
-rwx------    1 oracle   dba           19753 Nov 04 13:56 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/ORACLE_SID_catnorul.sql
-rwx------    1 oracle   dba           20740 Nov 04 13:54 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/ORACLE_SID_emremove.sql
-rwx------    1 oracle   dba             883 Nov 04 15:48 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/ORACLE_SID_objcompare.sql
-rwx------    1 oracle   dba            1118 Nov 04 12:46 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/before_upgrade_pfile_ORACLE_SID.ora
-rwx------    1 oracle   dba            1168 Nov 04 14:00 ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/temp/during_upgrade_pfile_ORACLE_SID.ora

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/100/prechecks:
total 376
-rwx------    1 oracle   dba            2781 Nov 04 12:46 ORACLE_SID_checklist.cfg
-rwx------    1 oracle   dba            9328 Nov 04 12:46 ORACLE_SID_checklist.json
-rwx------    1 oracle   dba            9962 Nov 04 12:46 ORACLE_SID_checklist.xml
-rwx------    1 oracle   dba           25980 Nov 04 12:46 ORACLE_SID_preupgrade.html
-rwx------    1 oracle   dba           10018 Nov 04 12:46 ORACLE_SID_preupgrade.log
-rwx------    1 oracle   dba          121687 Nov 04 12:46 prechecks_ORACLE_SID.log

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/101/prechecks:
total 376
-rwx------    1 oracle   dba            2781 Nov 04 13:07 ORACLE_SID_checklist.cfg
-rwx------    1 oracle   dba            9328 Nov 04 13:07 ORACLE_SID_checklist.json
-rwx------    1 oracle   dba            9962 Nov 04 13:07 ORACLE_SID_checklist.xml
-rwx------    1 oracle   dba           25980 Nov 04 13:07 ORACLE_SID_preupgrade.html
-rwx------    1 oracle   dba           10018 Nov 04 13:07 ORACLE_SID_preupgrade.log
-rwx------    1 oracle   dba          121687 Nov 04 13:07 prechecks_ORACLE_SID.log

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/dbupgrade:
total 446064
-rwx------    1 oracle   dba           13059 Nov 04 15:48 autoupgrade20191104135121ORACLE_SID.log
-rwx------    1 oracle   dba           12042 Nov 04 15:48 ORACLE_SID_autocompile20191104135121ORACLE_SID0.log
-rwx------    1 oracle   dba             551 Nov 04 15:48 ORACLE_SID_autocompile20191104135121ORACLE_SID_catcon_10617264.lst
-rwx------    1 oracle   dba       208215073 Nov 04 15:48 catupgrd20191104135121ORACLE_SID0.log
-rwx------    1 oracle   dba         7481470 Nov 04 15:46 catupgrd20191104135121ORACLE_SID1.log
-rwx------    1 oracle   dba         5527017 Nov 04 15:46 catupgrd20191104135121ORACLE_SID2.log
-rwx------    1 oracle   dba         7040784 Nov 04 15:46 catupgrd20191104135121ORACLE_SID3.log
-rwx------    1 oracle   dba             527 Nov 04 14:01 catupgrd20191104135121ORACLE_SID_catcon_17039806.lst
-rwx------    1 oracle   dba               0 Nov 04 15:23 catupgrd20191104135121ORACLE_SID_datapatch_normal.err
-rwx------    1 oracle   dba            1050 Nov 04 15:46 catupgrd20191104135121ORACLE_SID_datapatch_normal.log
-rwx------    1 oracle   dba               0 Nov 04 15:17 catupgrd20191104135121ORACLE_SID_datapatch_upgrade.err
-rwx------    1 oracle   dba             702 Nov 04 15:18 catupgrd20191104135121ORACLE_SID_datapatch_upgrade.log
-rwx------    1 oracle   dba            9877 Nov 04 15:18 during_upgrade_pfile_catctl.ora
-rwx------    1 oracle   dba           32649 Nov 04 14:01 phase.log
-rwx------    1 oracle   dba            1489 Nov 04 15:48 upg_summary.log
-rwx------    1 oracle   dba              46 Nov 04 15:48 upg_summary_report.log
-rwx------    1 oracle   dba             408 Nov 04 15:48 upg_summary_report.pl

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/drain:
total 16
-rwx------    1 oracle   dba            4952 Nov 04 14:01 drain_ORACLE_SID.log

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/postchecks:
total 104
-rwx------    1 oracle   dba             969 Nov 04 15:50 ORACLE_SID_checklist.cfg
-rwx------    1 oracle   dba            3202 Nov 04 15:50 ORACLE_SID_checklist.json
-rwx------    1 oracle   dba            3395 Nov 04 15:50 ORACLE_SID_checklist.xml
-rwx------    1 oracle   dba           16916 Nov 04 15:50 ORACLE_SID_postupgrade.html
-rwx------    1 oracle   dba            3383 Nov 04 15:50 ORACLE_SID_postupgrade.log
-rwx------    1 oracle   dba           14861 Nov 04 15:50 postchecks_ORACLE_SID.log

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/postfixups:
total 40
-rwx------    1 oracle   dba           14864 Nov 04 16:00 postchecks_ORACLE_SID.log
-rwx------    1 oracle   dba            3262 Nov 04 15:59 postfixups_ORACLE_SID.log

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/postupgrade:
total 24
-rwx------    1 oracle   dba           10177 Nov 04 16:01 postupgrade.log

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/prechecks:
total 376
-rwx------    1 oracle   dba            2781 Nov 04 13:52 ORACLE_SID_checklist.cfg
-rwx------    1 oracle   dba            9328 Nov 04 13:52 ORACLE_SID_checklist.json
-rwx------    1 oracle   dba            9962 Nov 04 13:52 ORACLE_SID_checklist.xml
-rwx------    1 oracle   dba           25980 Nov 04 13:52 ORACLE_SID_preupgrade.html
-rwx------    1 oracle   dba           10018 Nov 04 13:52 ORACLE_SID_preupgrade.log
-rwx------    1 oracle   dba          121687 Nov 04 13:51 prechecks_ORACLE_SID.log

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/prefixups:
total 304
-rwx------    1 oracle   dba          121708 Nov 04 14:00 prechecks_ORACLE_SID.log
-rwx------    1 oracle   dba           32727 Nov 04 14:00 prefixups_ORACLE_SID.log

ORACLE_BASE/admin/ORACLE_UNQNAME/autoupgrade/102/preupgrade:
total 8
-rwx------    1 oracle   dba              98 Nov 04 13:51 preupgrade.log

/orahome/oracle/app/admin/ORACLE_SID/autoupgrade/log/cfgtoollogs/upgrade/auto:
total 880
-rwx------    1 oracle   dba          414589 Nov 04 16:01 autoupgrade.log
-rwx------    1 oracle   dba             780 Nov 04 13:00 autoupgrade_err.log
-rwx------    1 oracle   dba            3113 Nov 04 16:01 autoupgrade_user.log
drwx------    2 oracle   dba            4096 Nov 04 14:01 config_files
drwx------    2 oracle   dba             256 Nov 04 16:01 lock
-rwx------    1 oracle   dba           12381 Nov 04 16:01 state.html
drwx------    2 oracle   dba            4096 Nov 04 16:01 status
$

Find timing for autoupgrade process.

$ tail -12 `ls $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log/$ORACLE_UNQNAME/$JOBNO/autoupgrade*.log|egrep -v 'user|err'`
2019-11-04 16:01:21.082 INFO ----------------------Stages  Summary------------------------ - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.082 INFO     SETUP             1 min                                  - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.083 INFO     PREUPGRADE        1 min                                  - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.083 INFO     PRECHECKS         1 min                                  - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.083 INFO     GRP               1 min                                  - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.084 INFO     PREFIXUPS         8 min                                   - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.084 INFO     DRAIN             1 min                                  - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.084 INFO     DBUPGRADE         108 min                                 - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.085 INFO     POSTCHECKS        1 min                                  - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.085 INFO     POSTFIXUPS        9 min                                   - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.086 INFO     POSTUPGRADE       1 min                                  - DispatcherOSHelper.writeStageSummary
2019-11-04 16:01:21.086 INFO End of dispatcher instance for ORACLE_SID - AutoUpgDispatcher.run

Find timing for database upgrade.

$ tail -35 $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log/$ORACLE_UNQNAME/102/dbupgrade/catupgrd*${ORACLE_UNQNAME}0.log
========== PROCESS ENDED ==========
SQL&gt; Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Start of Summary Report
------------------------------------------------------

Oracle Database 12.2 Post-Upgrade Status Tool           11-04-2019 15:46:14

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.2.0.1.0  00:19:53
JServer JAVA Virtual Machine           UPGRADED      12.2.0.1.0  00:07:34
Oracle Workspace Manager               UPGRADED      12.2.0.1.0  00:02:16
OLAP Analytic Workspace                UPGRADED      12.2.0.1.0  00:00:23
Oracle OLAP API                        UPGRADED      12.2.0.1.0  00:00:23
Oracle XDK                             UPGRADED      12.2.0.1.0  00:01:15
Oracle Text                            UPGRADED      12.2.0.1.0  00:01:24
Oracle XML Database                    UPGRADED      12.2.0.1.0  00:05:28
Oracle Database Java Packages          UPGRADED      12.2.0.1.0  00:00:25
Oracle Multimedia                      UPGRADED      12.2.0.1.0  00:03:25
Spatial                                UPGRADED      12.2.0.1.0  00:09:03
Oracle Application Express             UPGRADED     5.0.4.00.12  00:23:17
Final Actions                                                    00:04:44
Post Upgrade                                                     00:00:09

Total Upgrade Time: 01:20:32

Database time zone version is 14. It is older than current release time
zone version 26. Time zone upgrade is needed using the DBMS_DST package.

Grand Total Upgrade Time:    [0d:1h:47m:34s]

End of Summary Report
------------------------------------------------------
$

Find timing for datapatch.

$ cat $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log/$ORACLE_UNQNAME/$JOBNO/dbupgrade/catupgrd*datapatch_normal.log
SQL Patching tool version 12.2.0.1.0 Production on Mon Nov 4 15:23:22 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.

Log file for this invocation: /orahome/oracle/app/cfgtoollogs/sqlpatch/sqlpatch_14221746_2019_11_04_15_23_22/sqlpatch_invocation.log

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series DBRU:
ID 190716 in the binary registry and not installed in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
29757449 (DATABASE JUL 2019 RELEASE UPDATE 12.2.0.1.190716)

Installing patches...
Patch installation complete. Total patches installed: 1

Validating logfiles...
Patch 29757449 apply: SUCCESS
logfile: /orahome/oracle/app/cfgtoollogs/sqlpatch/29757449/23013437/29757449_apply_ORACLE_SID_2019Nov04_15_24_11.log (no errors)
SQL Patching tool complete on Mon Nov 4 15:46:00 2019
$

Might be better to use grep -A vs tail; however, I was on AIX and was not able to find option.

Jordan’s Top Bank Becomes Regional Blockchain Leader with Oracle

Oracle Press Releases - Wed, 2019-11-20 08:00
Blog
Jordan’s Top Bank Becomes Regional Blockchain Leader with Oracle

By Guest Author, Oracle—Nov 20, 2019

Arab Jordan Investment Bank (AJIB) provides retail, corporate, and investment banking services in Jordan, Cyprus, and Qatar. Sending money between subsidiaries has historically relied on a network of correspondent banking relationships and third-party intermediaries, leading to slow and costly transactions for both AJIB and its customers. In addition, it required sharing customer information with third parties—a process involving strict regulatory requirements with occasional conflicts between different jurisdictions. AJIB aimed to reduce the costs and time required for cross-border payments, while making the entire process more secure and efficient.

In order to boost speed, security, and reliability of cross-border money transfers with distributed ledger technology, AJIB deployed Oracle Blockchain Platform in what has become the largest blockchain deployment in the Middle East.

Before using blockchain, money transfers between AJIB subsidiaries were processed by third-party intermediaries that charged fees at each stage of a cross-border transfer transaction. AJIB needed to reduce the costs and the time required for cross-border payments, while making the entire process more secure and efficient.

“Oracle delivers an enterprise-grade blockchain platform with high resiliency, scalability and security. The built-in features, such as identity management and data encryption, made it an ideal choice given our industry requirements and compliance needs,” said Ayman Qadoumi, Deputy General Manager, Information Technology and Security, Arab Jordan Investment Bank.

With Oracle Blockchain Platform, AJIB is now able to make the same transfers in real time without paying those fees. Senders and receivers can now track money transfers while the funds are in transit, providing transparency to both parties about the exact timing and amount of the transfer.

Watch the Video

Watch this video to learn how Arab Jordan Investment Bank is using Oracle Blockchain Platform to become a leader in banking innovation.

 

Read More Stories from Oracle Cloud

Arad Jordan Investment Bank is one of the thousands of innovative customers succeeding in the cloud. Read about others in Stories from Oracle Cloud: Business Successes

Urban Leaders Power the Future with Oracle

Oracle Press Releases - Wed, 2019-11-20 07:00
Press Release
Urban Leaders Power the Future with Oracle Global Research Highlights Cloud and Advanced Technologies as the Driver of Innovation among Smart Cities

SMART CITIES EXPO WORLD CONGRESS, Barcelona—Nov 20, 2019

Data is at the core of successful smart city innovation, according to new research from Oracle and economic and urban research consultancy ESI ThoughtLab. The Building a Hyperconnected City study found that cities are drowning in data from advancements such as Internet of Things (IoT). The survey projected that there will be more than 30 billion connected devices generating data by 2020. The study notes that for cities to become truly ‘smart’, they must have a cloud infrastructure in place to extract, integrate, and analyze this data to glean the insights needed to enhance everything from citizen services to building projects.

The report surveyed 100 cities across the United States, APAC, EMEA and LATAM.

The hyper-connected multiplier effect

According to the study, the average return on investments in hyper-connected initiatives ranges from three - four percent. As cities become more interlinked, their ROI grows: cities just starting out realize a return of 1.8 percent for implementers and 2.6 percent for advancers, while hyper-connected leaders see a 5.0 percent boost. That can translate into enormous returns ranging from $19.6 million for implementers to $40.0 million for advancers and $83 million for hyper-connected leaders. 

Other key findings from the study include:

  • AI, Blockchain and biometrics are increasingly pervasive: Cities are using these technologies in key urban areas, such as IT infrastructure and telecoms, mobility and transportation, payment and financial systems, and physical and digital security. City leaders need the right technology platforms and applications to implement and leverage these tools and capabilities.
  • Cybersecurity requires careful planning and is expensive when not implemented properly: The study revealed that half of the 100 city leaders surveyed do not feel adequately prepared for cyberattacks.
  • Smart initiatives are bolstering constituent satisfaction: While physical and digital security top the list of priorities, citizen engagement and satisfaction have risen as a top five goal. 33 percent of innovative leaders in North America have appointed Chief Citizen Experience Officers.
 

“The public sector, particularly at local level, is dealing with seismic technological, demographic and environmental shifts. Data is the rocket fuel for this transformation, and progressive cities are turning to cloud, data platforms, mobile applications and IoT as a way to scale and prepare for the future,” said Susan O’Connor, global director for Smart Cities, Oracle. “In contrast, not taking advantage of emerging technologies such as AI, Blockchain or virtual and augmented reality comes at a cost. Cities of the future need strategic, long-term investments in cloud data architecture, along with the right expertise to guide them through.”

Customer Commitment to Smarter Cities:

“As a data driven organization, we integrate, manage and use data to inform how we improve services for our constituents,” said Hamant Bharadia, assistant director of finance at the London Borough of Lambeth. “Oracle Cloud Applications for financial planning and payroll are an integral part of our digital strategy, setting us up for a modern way of working and engaging with our communities. They are an essential enabler for us to support innovation, improve public safety and realize our vision of making Lambeth a connected, inclusive place to thrive.” 

“Approximately 50% of Buenos Aires sidewalks are in poor condition, and we previously used spreadsheets to plan the routes for our crew to fix them,” said Alejandro Naon, chief of staff of planning of the undersecretariat of pedestrian ways, City of Buenos Aires. “Today, with Oracle CX Field Service Cloud, we can identify and fix the sidewalks exponentially faster because we receive images and information in real time. Our sidewalks are safer, our workers are more productive, and we recovered our Oracle technology investment in 18 months.”

“At the foundation of our smart government innovation is Oracle Analytics Cloud. It is both the heartbeat and hub for sharing information, enabling us to deliver data-driven citizen services and engagement with maximum impact,” said Chris Cruz, director and chief information officer, San Joaquin County. “Our entities throughout San Joaquin County, such as hospitals, law enforcement, transportation and public works, now partner more effectively and are better equipped to meet the health, social, safety and economic needs of our constituents.” 

Oracle's Smart City solutions transform the ways cities can harness and process the power of data through the integration of modern digital technologies and channels. The platform integrates technologies spanning cloud, digital outreach, omni-channel service, case management, mobility, social, IoT, Blockchain, and artificial intelligence while helping ensure comprehensive security and information privacy.

For more information, go to https://www.oracle.com/applications/customer-experience/industries/public-sector/

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Kristin Reeves
Oracle
+1.925.787.6744
kris.reeves@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

Katie Barron

  • +1.202.904.1138

Kristin Reeves

  • +1.925.787.6744

Despacito | Keyboard Performance | by Dharun at Improviser Music Studio

Senthil Rajendran - Tue, 2019-11-19 10:39
My Son Dharun Performing at Improviser Music Studio

Despacito



Please subscribe to our channel Improviser Music Studio

Pages

Subscribe to Oracle FAQ aggregator