Feed aggregator

Index rebuild is taking long time before partition exchange

Tom Kyte - Wed, 2020-02-12 06:04
Hi Tom, I have a work table where I will do all the calculations and do partition exchange to main table. This work table is truncate & load. This process has couple of steps. 1. I will copy few records from main table to work table and ca...
Categories: DBA Blogs

Autotrace traceonly

Tom Kyte - Wed, 2020-02-12 06:04
Hi, Could you please help to understand: How can I get the execution plan with all details like A rows E rows, etc when trace only enabled. I always get basic plan details like rows bytes and cpu% only. It would be helpful if you could share an...
Categories: DBA Blogs

UPDATE scenario - facing ORA-01427

Tom Kyte - Wed, 2020-02-12 06:04
Hello Pls see the UPDATE statement below ... I am faced with ORA-01427 when running this Have also tried "... WHERE EXISTS (SELECT 1 ..." but have not got it right I need to update the TAXINV and TAXINVDATE columns in TBLTARGET where TAXINV i...
Categories: DBA Blogs

Oracle DataFox Expands Pool of European Company Data by 135 Percent

Oracle Press Releases - Wed, 2020-02-12 03:00
Press Release
Oracle DataFox Expands Pool of European Company Data by 135 Percent Insights into more than one million businesses in Europe help global organizations boost the personalization of AI-powered applications and sell, market, and trade more efficiently

Oracle OpenWorld London—Feb 12, 2020

To help organizations realize the potential of AI-powered applications in sales, marketing, and other business applications, Oracle DataFox has expanded its pool of AI-sourced and managed data. Since being acquired by Oracle in 2018, Oracle DataFox has extended its global coverage by more than 70 percent with rapid growth in Europe, where Oracle DataFox coverage has increased by 135 percent to cover more than one million businesses in the region.

Oracle DataFox is an AI-powered data engine that includes data on millions of organizations worldwide, including most public companies. This includes data on company headcount, funding, revenue, growth signals and awards. To ensure data is up-to-date, Oracle DataFox constantly cleans and enriches the data so that customers can benefit from accurate “smart” data within their applications, which improves the effectiveness of AI and machine learning algorithms. In addition, Oracle DataFox’s pool of company data is constantly being expanded by its AI-driven data engine that continuously extracts detailed data on public and private businesses.

“Good data leads to better recommendations and good business decisions,” said Clive Swan, senior vice president of applications development, Oracle. “The ability to feed AI-powered applications from a larger pool of high-quality and accurate data helps our customers better prioritize sales, marketing and other business activities and drive more revenue growth.”

With native integrations across Oracle’s SaaS offerings, Oracle DataFox sources more than 1 billion data points each year to improve data quality in Oracle Eloqua and Oracle Sales Cloud, as well as other third party customer experience applications. For example, Oracle DataFox helps customers increase fill rates for key sales and marketing data points for company revenue and headcount to 99 percent. Similarly, Oracle DataFox’s real-time signal data (time-based data points) helps organizations understand when their customers and prospects have a higher propensity to buy and enables sales teams to prioritize and assign accounts dynamically.

InnovationQuarter is the regional economic development agency for the Province of Zuid-Holland, also known as the greater Rotterdam—The Hague area. To target and build a strong business network, it needed to look beyond its first party CRM data and gain visibility into other organizations in the region.

“Our mission is to stimulate innovation and economic growth in the greater Rotterdam-The Hague area. To achieve this we needed to have a more complete view of the Dutch business community,” said Chris Van Voorden, Director Foreign Investment & Internationalization at InnovationQuarter, a regional economic development agency in The Netherlands. “Oracle DataFox has significantly improved our efficiency and enabled us to better target and connect with businesses internationally, to drive valuable partnerships.”

Contact Info
Bill Rundle
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.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle Corporation.

Talk to a Press Contact

Bill Rundle

  • 415.990.3348

New Study: AI Helps Organizations Grow Profits 80 Percent Faster

Oracle Press Releases - Wed, 2020-02-12 02:00
Press Release
New Study: AI Helps Organizations Grow Profits 80 Percent Faster Global research highlights how organizations are capitalizing on emerging technologies to enhance finance and operations for competitive advantage

Oracle OpenWorld London—Feb 12, 2020

Organizations that are adopting Artificial Intelligence (AI) and other emerging technologies in finance and operations are growing their annual profits 80 percent faster, according to a new study from Enterprise Strategy Group and Oracle. The global study, Emerging Technologies: The competitive edge for finance and operations, surveyed 700 finance and operations leaders across 13 countries and found that emerging technologies—AI, Internet of Things (IoT), blockchain, digital assistants—have passed the adoption tipping point, exceed expectations, and create significant competitive advantage for organizations.

AI and Digital Assistants Improve Accuracy and Efficiency in Finance

Organizations embracing emerging technologies in finance are experiencing benefits far greater than anticipated:

  • Errors in finance organizations have been reduced by 37 percent on average.
  • 72 percent of organizations using AI have a better understanding of overall business performance.
  • 83 percent of executives believe AI will completely automate financial close processes within the next five years.
  • Digital assistants increase productivity by 36 percent and accelerate financial analysis by 38 percent.
  AI, IoT, and Blockchain Drive More Responsive Supply Chains

AI, IoT, blockchain and digital assistants are helping organizations improve accuracy, speed and insight in operations and the supply chain, and respondents expect additional business value as blockchain applications become mainstream.

  • Organizations using AI in their supply chains have seen order fulfillment reduction by an average of 6.7 business days.
  • Applying IoT data to supply chain processes helps organizations reduce fulfillment errors by 26 percent on average.
  • AI is helping organizations reduce fulfillment errors by 25 percent, stock-outs by 30 percent, and manufacturing downtime by 26 percent.
  • Organizations using digital assistants in their supply chains have increased employee productivity by 28 percent and the speed of analysis by 26 percent.
  • 87 percent of organizations using blockchain have achieved or exceeded ROI expectations; 82 percent expect to see significant business value within the next year.
  • 78 percent of executives believe the ability to verify supply chain monitoring with blockchain will reduce incidents of fraud in their supply chain by 50 percent or more over the next five years.
  • 68 percent of respondents see increased business intelligence as a key advantage of emerging technology in supply chain operations.
  Emerging Tech Equals Competitive Advantage

The vast majority of organizations have now adopted emerging technologies and early adopters (those using three or more solutions) are seeing the greatest benefit and are more likely to outperform competitors.

  • Emerging technologies have become mainstream and 84 percent of organizations are using at least one of these technologies (AI, IoT, blockchain, digital assistants) in production.
  • 82 percent of organizations using three or more emerging technologies are ahead of competitors, compared to only 45 percent of organizations using none.
  • Organizations using multiple emerging technologies are 9.5 times more likely to have market-leading financial and operational accuracy.
  • Organizations are 2-3 times more likely to purchase prebuilt emerging technology solutions than build them on their own (percentage varies depending on technology solution).
  • Almost all respondents (91 percent) considered SaaS applications to be a key enabler of emerging technology.
  Supporting quotes

“AI, IoT, blockchain and digital assistant capabilities enable organizations to innovate faster, creating significant competitive advantage and driving increased profit for companies embracing those technologies more decisively than their competitors,” said Juergen Lindner, senior vice president, SaaS product marketing, Oracle. “The research finds that these technologies have become mainstream and organizations that sit on the sidelines risk their business relevance. To help our customers outpace change and consequently the competition, we continuously infuse emerging technologies directly into the business processes to ensure they can harness these business-changing technologies.”

“This study makes it clear that emerging technologies have passed the trial phase and are moving toward a state of widespread adoption,” said John McKnight, EVP of Research and Analyst Services of Enterprise Strategy Group. “The business case for these technologies in areas such as finance and operations is maturing at a rapid pace—and in most cases benefits exceed expectations. Furthermore, the research shows that emerging technologies complement and amplify the benefits of one another, which underscores the importance of taking a holistic approach.”

Download a free copy of the summary report here, and the full report here.

Additional Resources   Methodology

Research findings are based on a global survey of 700 finance and operations managers and executives conducted by Enterprise Strategy Group between September 19 to October 16, 2019. The study was administered online and fielded in 13 countries. All respondents were managers and executives in the finance or operations functional units of their organizations, and were required to be frequent users of ERP, EPM or SCM applications. Additionally, only respondents working at organizations with 1,000 or more employees or with annual revenues of $100M of more were considered qualified. The survey was complemented by 10 in-depth interviews with finance and operations leaders from various industries. All respondents were provided an incentive to complete the survey in the form of cash awards and/or cash equivalents.

Contact Info
Rachael Walker
About Enterprise Strategy Group (ESG)

Enterprise Strategy Group is a technology analyst, research, validation, and strategy firm that provides market intelligence and actionable insight to the global technology community. www.esg-global.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.


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

Rachael Walker

  • 704.728.3179

Modify VAGRANT_HOME For Windows

Michael Dinh - Tue, 2020-02-11 19:21

I know what you are thinking, “Why make it so complicated!”

Unfortunately, C: drive is only 500G while other attached drives are 1TB.

Download vagrant box from outside of VAGRANT_HOME

resetlogs@ghost MINGW64 /d/VirtualBoxVMs
$ vagrant box add --name ol77 https://yum.oracle.com/boxes/oraclelinux/ol77/ol77.box
==> box: Box file was not detected as metadata. Adding it directly...
==> box: Adding box 'ol77' (v0) for provider:
    box: Downloading: https://yum.oracle.com/boxes/oraclelinux/ol77/ol77.box
==> box: Successfully added box 'ol77' (v0) for 'virtualbox'!

resetlogs@ghost MINGW64 /d/VirtualBoxVMs
$ ls -l
total 0

resetlogs@ghost MINGW64 /d/VirtualBoxVMs

Verify vagrant box is downloaded to VAGRANT_HOME

resetlogs@ghost MINGW64 /d/vagrant.d
$ ls -l
total 5
drwxr-xr-x 1 dinh 197121    0 Feb 11 20:00 boxes/
drwxr-xr-x 1 dinh 197121    0 Feb 11 19:49 data/
drwxr-xr-x 1 dinh 197121    0 Feb 11 19:49 gems/
-rw-r--r-- 1 dinh 197121 1675 Feb 11 19:49 insecure_private_key
drwxr-xr-x 1 dinh 197121    0 Feb 11 19:49 rgloader/
-rw-r--r-- 1 dinh 197121    3 Feb 11 19:49 setup_version
drwxr-xr-x 1 dinh 197121    0 Feb 11 20:00 tmp/

resetlogs@ghost MINGW64 /d/vagrant.d
$ cd boxes

resetlogs@ghost MINGW64 /d/vagrant.d/boxes
$ ls -l
total 0
drwxr-xr-x 1 dinh 197121 0 Feb 11 20:00 ol77/

resetlogs@ghost MINGW64 /d/vagrant.d/boxes
$ env|grep -i vagrant
PATH=/c/Users/Michael Dinh/bin:/mingw64/bin:/usr/local/bin:/usr/bin:/bin:/mingw64/bin:/usr/bin:/c/Users/Michael Dinh/bin:/c/Windows/system32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0:/c/Windows/System32/OpenSSH:/c/Program Files/WinMerge:/cmd:/c/Program Files/PuTTY:/c/Program Files (x86)/Intel/Intel(R) Management Engine Components/DAL:/c/Program Files/Intel/Intel(R) Management Engine Components/DAL:/c/Program Files/Intel/WiFi/bin:/c/Program Files/Common Files/Intel/WirelessCommon:/d/HashiCorp/Vagrant/bin:/c/Users/Michael Dinh/AppData/Local/Microsoft/WindowsApps:/c/Program Files/Java/jdk-12.0.1/bin:/usr/bin/vendor_perl:/usr/bin/core_perl
ORIGINAL_PATH=/mingw64/bin:/usr/bin:/c/Users/Michael Dinh/bin:/c/Windows/system32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0:/c/Windows/System32/OpenSSH:/c/Program Files/WinMerge:/cmd:/c/Program Files/PuTTY:/c/Program Files (x86)/Intel/Intel(R) Management Engine Components/DAL:/c/Program Files/Intel/Intel(R) Management Engine Components/DAL:/c/Program Files/Intel/WiFi/bin:/c/Program Files/Common Files/Intel/WirelessCommon:/d/HashiCorp/Vagrant/bin:/c/Users/Michael Dinh/AppData/Local/Microsoft/WindowsApps:/c/Program Files/Java/jdk-12.0.1/bin
***** VAGRANT_HOME=D:\vagrant.d *****

resetlogs@ghost MINGW64 /d/vagrant.d/boxes

Delete vagrant box.

resetlogs@ghost MINGW64 /d/vagrant.d/boxes
$ vagrant box remove ol77
Removing box 'ol77' (v0) with provider 'virtualbox'...

resetlogs@ghost MINGW64 /d/vagrant.d/boxes

Here are the modifications from Windows registry and environments

Bug Bounty

Pete Finnigan - Tue, 2020-02-11 18:04
There has been a rise on bug bounty programs and websites that help researchers find and disclose bugs to website and other owners with the hope of a payout from the owner of the vulnerable wesbsites. Some big well known....[Read More]

Posted by Pete On 11/02/20 At 10:09 AM

Categories: Security Blogs

Oracle Entity Framework Core 3.x

Tom Kyte - Tue, 2020-02-11 18:04
When will the https://www.nuget.org/packages/Oracle.EntityFrameworkCore/ support dotnet core sdk 3.1 ?
Categories: DBA Blogs

Truncate Partition is very slow

Tom Kyte - Tue, 2020-02-11 18:04
Hi Tom We got a table which is partitioned on Range (date), Each partition holds approximately 5 Million records, there are 60 partitions. There are 4 Indexes on this table and they are Global Indexes. To remove old data we truncate partition. ...
Categories: DBA Blogs

Scheduling Queries

Tom Kyte - Tue, 2020-02-11 18:04
Hi Connor, Chris, Could you please have a look at below scenario related to dbms_scheduler program and job setu: <code> -------------- Start Use Case Setup -------------- -----------------------------------------------------------------------...
Categories: DBA Blogs

Labs for Multitenant

Tom Kyte - Tue, 2020-02-11 18:04
Hi All: I have a question on the Multitenant Fundamentals hands on session scheduled for Thu, Feb 13, 2020 16:00-17:00 UTC: Will these labs be making use of VMs based on https://cloudmarketplace.oracle.com/marketplace/listing/69658839? * I'm a...
Categories: DBA Blogs

Oracle Sequence expiry

Tom Kyte - Tue, 2020-02-11 18:04
I have few sequences which are about to expires and I need notification over emails when last_number increases. Can you suggest how to do it.
Categories: DBA Blogs

ORA-30926 not raised in merge statement for non-deterministic set of rows

Tom Kyte - Tue, 2020-02-11 18:04
Hi Connor, Chris et al, Could you please kindly help me better understand when ORA-30926 is to be raised for non-deterministic set of rows on input? Up to 12.1 it worked as a charm , regardless of sort order and number duplicate rows on input O...
Categories: DBA Blogs

ORA-06553: PLS-306: wrong number or types of arguments when selecting object type instance

Tom Kyte - Tue, 2020-02-11 18:04
We're experiencing this when testing upgrade from Ora 12.1 to 19. What's wrong with the code?
Categories: DBA Blogs

Unable to find or delete BIN$ Tables

Tom Kyte - Tue, 2020-02-11 18:04
While I was examining the space used on my free ADW i found lots of tables with a prefix of BIN$ in my DATA tablespace. I found these being referenced in the user_segments The recyclebin is empty, and I cant find the tables using a select on the u...
Categories: DBA Blogs

Long Running PROC takes over 7 hours

Tom Kyte - Tue, 2020-02-11 18:04
Hi Tom, I have a PROC that will be run infrequently. It will be used to delete rules from a table. There are 75,000 rules and over 14,000 will be deleted in the first run of the proc with another 1200 potentially deleted. I need to check if ...
Categories: DBA Blogs

Node switchover data loss

Tom Kyte - Tue, 2020-02-11 18:04
Hi , We faced one issue, I have explained the scenario > Our table has multiple rows with primary key as number for an entity For ex: assuming employeeid for an employee > We have a status column which suggests calculation status of the current...
Categories: DBA Blogs

Python 3.8.1 Linux Install Without Root

Bobby Durrett's DBA Blog - Tue, 2020-02-11 11:40

I wanted to install the latest Python on Linux in a low powered user’s home directory and not have the install interfere with the Python that comes with Linux. I wanted my own local copy of Python that I could install Python packages to without interfering with anything else. I was willing to use root to install the needed Linux packages, but everything else was done with my low powered user.

I did a yum update on my Oracle Enterprise Linux 7.7 install before I started to get everything on the latest version. As root I used yum to install the Linux packages I needed to install Python 3.8.1 from source:

[root@pythonvm ~]# yum install gcc openssl-devel bzip2-devel libffi-devel tcl* tk* -y
Loaded plugins: langpacks, ulninfo
mysql-connectors-community                                                   | 2.5 kB  00:00:00
mysql-tools-community                                                        | 2.5 kB  00:00:00
mysql57-community                                                            | 2.5 kB  00:00:00
ol7_UEKR4                                                                    | 2.5 kB  00:00:00
ol7_latest                                                                   | 2.7 kB  00:00:00
Package gcc-4.8.5-39.0.3.el7.x86_64 already installed and latest version
Package 1:openssl-devel-1.0.2k-19.0.1.el7.x86_64 already installed and latest version
Package bzip2-devel-1.0.6-13.el7.x86_64 already installed and latest version
Package libffi-devel-3.0.13-18.el7.x86_64 already installed and latest version
Package 1:tcl-devel-8.5.13-8.el7.x86_64 already installed and latest version
Package 1:tcl-8.5.13-8.el7.x86_64 already installed and latest version
Package tcl-pgtcl-2.0.0-5.el7.x86_64 already installed and latest version
Package 1:tk-devel-8.5.13-6.el7.x86_64 already installed and latest version
Package 1:tk-8.5.13-6.el7.x86_64 already installed and latest version
Nothing to do

I must have already installed these on this VM. I did the rest of these steps as my low powered user “bobby”. The next thing I did was download the latest Python source, the 3.8.1 version. I had to use the -k option to get around certificate issues:

[bobby@pythonvm ~]$ curl -k -O https://www.python.org/ftp/python/3.8.1/Python-3.8.1.tgz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 22.8M  100 22.8M    0     0  7830k      0  0:00:02  0:00:02 --:--:-- 7828k

For some reason I had to do this twice. The first download failed. Next I gunzipped and untarred this archive under my home directory:

tar zxfv Python-3.8.1.tgz

[bobby@pythonvm ~]$

I created a directory called “python” under my home directory to use as the top-level directory for my Python install. This directory tree will hold the binaries and any Python packages that I install.

[bobby@pythonvm ~]$ mkdir python

After changing directory to where I untarred the source files I configured the Python make and install to use the directory I just created as a “prefix”:

[bobby@pythonvm ~]$ cd Python-3.8.1

[bobby@pythonvm Python-3.8.1]$ pwd

./configure --prefix=/home/bobby/python

config.status: creating Misc/python-embed.pc
config.status: creating Misc/python-config.sh
config.status: creating Modules/ld_so_aix
config.status: creating pyconfig.h
creating Modules/Setup.local
creating Makefile

If you want a release build with all stable optimizations active (PGO, etc),
please run ./configure --enable-optimizations

Then I did the make and make altinstall from the same directory:

renaming build/scripts-3.8/idle3 to build/scripts-3.8/idle3.8
renaming build/scripts-3.8/2to3 to build/scripts-3.8/2to3-3.8
/usr/bin/install -c -m 644 ./Tools/gdb/libpython.py python-gdb.py
gcc -pthread -c -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O3 -Wall    -std=c99 -Wextra -Wno-unused-result -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration  -I./Include/internal  -I. -I./Include    -DPy_BUILD_CORE -o Programs/_testembed.o ./Programs/_testembed.c
gcc -pthread     -Xlinker -export-dynamic -o Programs/_testembed Programs/_testembed.o libpython3.8.a -lcrypt -lpthread -ldl  -lutil -lm   -lm
sed -e "s,@EXENAME@,/home/bobby/python/bin/python3.8," < ./Misc/python-config.in >python-config.py
LC_ALL=C sed -e 's,\$(\([A-Za-z0-9_]*\)),\$\{\1\},g' < Misc/python-config.sh >python-config
[bobby@pythonvm Python-3.8.1]$

make altinstall
Looking in links: /tmp/tmpdrnzr3vb
Collecting setuptools
Collecting pip
Installing collected packages: setuptools, pip
Successfully installed pip-19.2.3 setuptools-41.2.0
[bobby@pythonvm Python-3.8.1]$

So, now Python 3.8.1 is installed in /home/bobby/python but I want to put the bin directory in the path so I can run python or pip and by default have them be this version. The install created python and pip as python3.8 and pip3.8 but I created links to them so that I could access them without 3.8 at the end of their names:

[bobby@pythonvm Python-3.8.1]$ cd /home/bobby/python/bin
[bobby@pythonvm bin]$ ls -al
total 16704
drwxr-xr-x. 2 bobby bobby     4096 Feb 10 15:36 .
drwxrwxr-x. 6 bobby bobby       52 Feb 10 15:36 ..
-rwxrwxr-x. 1 bobby bobby      109 Feb 10 15:36 2to3-3.8
-rwxrwxr-x. 1 bobby bobby      249 Feb 10 15:36 easy_install-3.8
-rwxrwxr-x. 1 bobby bobby      107 Feb 10 15:36 idle3.8
-rwxrwxr-x. 1 bobby bobby      231 Feb 10 15:36 pip3.8
-rwxrwxr-x. 1 bobby bobby       92 Feb 10 15:36 pydoc3.8
-rwxr-xr-x. 1 bobby bobby 17075312 Feb 10 15:35 python3.8
-rwxr-xr-x. 1 bobby bobby     3095 Feb 10 15:36 python3.8-config

[bobby@pythonvm bin]$ ln -s python3.8 python
[bobby@pythonvm bin]$ ln -s pip3.8 pip

Then I added/home/bobby/python/bin to the front of the path to keep these new python and pip links ahead of the python links or binaries in the rest of the path.

[bobby@pythonvm bin]$ cd
[bobby@pythonvm ~]$ vi .bashrc

export ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0/client_1
export LD_LIBRARY_PATH=/home/oracle/app/oracle/product/12.1.0/client_1/lib
export PATH=/home/bobby/python/bin:$PATH

".bashrc" 17L, 451C written     

I logged out and in as bobby and tried python and pip to see that they were the correct version:

[bobby@pythonvm ~]$ python
Python 3.8.1 (default, Feb 10 2020, 15:33:01)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-39.0.3)] on linux
Type "help", "copyright", "credits" or "license" for more information.
[bobby@pythonvm ~]$ pip list
Package    Version
---------- -------
pip        19.2.3
setuptools 41.2.0
WARNING: You are using pip version 19.2.3, however version 20.0.2 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
[bobby@pythonvm ~]$   

Finally, I updated pip just to show that we can update something in this new install. Then I installed numpy to see if I could install a new package.

[bobby@pythonvm ~]$ pip install --upgrade pip
Collecting pip
  Downloading https://files.pythonhosted.org/packages/54/0c/d01aa759fdc501a58f431eb594a17495f15b88da142ce14b5845662c13f3/pip-20.0.2-py2.py3-none-any.whl (1.4MB)
     |¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦| 1.4MB 863kB/s
Installing collected packages: pip
  Found existing installation: pip 19.2.3
    Uninstalling pip-19.2.3:
      Successfully uninstalled pip-19.2.3
Successfully installed pip-20.0.2

[bobby@pythonvm ~]$ pip list
Package    Version
---------- -------
pip        20.0.2
setuptools 41.2.0

[bobby@pythonvm ~]$ pip install numpy
Collecting numpy
  Downloading numpy-1.18.1-cp38-cp38-manylinux1_x86_64.whl (20.6 MB)
     |¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦| 20.6 MB 62 kB/s
Installing collected packages: numpy
Successfully installed numpy-1.18.1
[bobby@pythonvm ~]$ pip list
Package    Version
---------- -------
numpy      1.18.1
pip        20.0.2
setuptools 41.2.0

This is a quick and dirty post, but I want to remember these steps for myself and it might be helpful for someone who uses Redhat/Centos/OEL.


Categories: DBA Blogs

Equinix Taps Oracle Exadata to Help Power Global Interconnection Platform

Oracle Press Releases - Tue, 2020-02-11 07:00
Press Release
Equinix Taps Oracle Exadata to Help Power Global Interconnection Platform Data center and cloud interconnection services rely on Oracle Exadata and Oracle Database

Redwood City, Calif.—Feb 11, 2020

To help power one of the most dynamic data center and global interconnection platforms in the world, Equinix relies on Oracle Exadata Database Machine as a core Oracle Database transaction engine to run its growing business. With a global footprint of more than 200 International Business Exchange™ (IBX®) data centers spanning across more than 50 markets on five continents, Platform Equinix® contains the highest share of the world's public cloud on-ramps and one of the most physically and virtually interconnected ecosystems in the world.

Equinix currently serves nearly 10,000 customers globally, including the world’s largest cloud providers, Fortune 500 enterprises and Global 2000 companies. Equinix has experienced between an estimated 3X and 10X performance improvement for transaction processing and data warehousing analytics, respectively, since implementing Oracle Exadata to support its quote-to-cash business support systems running on Oracle Database and Oracle Applications. With Oracle Exadata, thousands of Equinix users around the world now access their business support systems with ultra-low IO latencies.

Prior to selecting Oracle Exadata, Equinix had implemented a do-it-yourself infrastructure environment comprised of Oracle Database with servers combined with storage and networking products from multiple vendors. With Oracle Exadata, Equinix is achieving up to 24X in estimated greater performance for complex database queries, 4X faster analytics, and 3X faster data replication.

By moving to Oracle Exadata, Equinix is able to run its applications an estimated 30 to 40 percent faster with some workloads showing more than 100 percent improvement. Equinix also eliminated an estimated 12 hours of service downtime for database server patching per year and further reduced application patching downtime by 90 percent.

“Our investment in Oracle Exadata has proven valuable and has exceeded our expectations,” said Milind Wagle, executive vice president and global chief information officer, Equinix. “Not only is Oracle a strategic alliance partner with Equinix, we also consider it an important solution provider trusted to run our mission-critical applications around the world.”

“It’s a strong validation of our strategy to see Equinix, one of the world’s largest providers of interconnected data centers, relying on Oracle Exadata to ensure its customers benefit from superior cloud and infrastructure performance on a 24/7 basis, no matter where they are in the world,” said Juan Loaiza, executive vice president, Mission-Critical Database Technologies, Oracle. “Oracle Exadata powers the Oracle Autonomous Database, Exadata Cloud Service, and Gen 2 Exadata Cloud at Customer, and is the premiere platform for running Oracle Database workloads in the cloud and on-premises.”

In addition to experiencing a reduction in patching requirements, Equinix has also benefitted from net incremental capabilities as a result of Oracle co-engineering, including Automatic Indexing, AI-based Cloud-Scale Performance Management and Hybrid Columnar Compression.

Equinix is implementing Oracle Exadata in a cloud-adjacent architecture environment. This interconnection architecture enables its global user base to access various applications across multiple cloud providers utilizing the exceptional performance of Oracle Database deployed on Exadata systems located in Equinix IBX data center locations and interconnected via Equinix Cloud Exchange Fabric™ (ECX Fabric™).

Oracle and Equinix Global Collaboration

Equinix continues their collaboration as a Gold level member of Oracle PartnerNetwork (OPN) with Oracle Cloud services spanning PaaS, IaaS and SaaS, offering Equinix IBX data centers worldwide. Oracle Cloud Infrastructure FastConnect is also available at Equinix, providing them with high-performance, private access to Oracle Cloud. Joint enterprise customers can also leverage Equinix Network Edge Services to migrate Oracle applications and databases quickly and cost-effectively from legacy cloud providers to Oracle Cloud Infrastructure.

Contact Info
Victoria Brown
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.


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

Victoria Brown

  • +1.650.850.2009

Taking VMware Tanzu Mission Control for a test drive this time creating a k8s cluster on AWS

Pas Apicella - Tue, 2020-02-11 04:12
Previously I blogged about how to use VMware Tanzu Mission Control (TMC) to attach to kubernetes clusters and in that example we used a GCP GKE cluster. That blog entry exists here

Taking VMware Tanzu Mission Control for a test drive

In this example we will use the "Create Cluster" button to create a new k8s cluster on AWS that will be managed by TMC for it's entire lifecycle.


Note: Before getting started you need to create a "Cloud Provider Account" and that is done using AWS as shown below. You can create one or more connected cloud provider accounts. Adding accounts allows you to start using VMware TMC to create clusters, add data protection, and much more

1. Click on the "Clusters" on the left hand navigation bar

2. In the right hand corner click the button "New Cluster" and select your cloud provider account on AWS as shown below

3. Fill in the details of your new cluster as shown below ensuring you select the correct AWS region where your cluster will be created.

4. Click Next

5. In the next screen I am just going to select a Development control plane

6. Click Next

7. Edit the default-node-pool and add 2 worker nodes instead of just 1 as shown below

8. Click "Create"

9. This will take you to a screen where your cluster will create. This can take at least 20 minutes so be patient. Progress is shown as per below

10. If we switch over to AWS console we will start to see some running instances and other cloud components being created as shown in the images below

11. Eventually the cluster will create and you are taken to a summary screen for your cluster. It will take a few minutes for all "Agent and extensions health" to show up green so refresh the page serval times until all shows up green as per below.

Note: This can take up to 10 minutes so be patient

12. So to access this cluster using "kubectl" use the button "Access this Cluster" in the top right hand corner and it will take you to a screen as follows. Click the "Download kubeconfig file" and the "Tanzu Mission Control CLI" as you will need both those files and save them locally

13. make the "tmc" CLI executable and save to your $PATH as shown below

$ chmod +x tmc
$ sudo mv tmc /usr/local/bin

14. Access cluster using "kubectl" as follows
$ kubectl --kubeconfig=./kubeconfig-pas-aws-cluster.yml get namespaces
default Active 19m
kube-node-lease Active 19m
kube-public Active 19m
kube-system Active 19m
vmware-system-tmc Active 17m

Note: You will be taken to a web page to authenticate and once that's done your good to go as shown below

15. You can view the pods created to allows access from the TMC agent as follows
$ kubectl --kubeconfig=./kubeconfig-pas-aws-cluster.yml get pods --namespace=vmware-system-tmc
agent-updater-7b47c659d-8h2mh 1/1 Running 0 25m
agentupdater-workload-1581415620-csz5p 0/1 Completed 0 35s
data-protection-769994df65-6cgfh 1/1 Running 0 24m
extension-manager-657b467c-k4fkl 1/1 Running 0 25m
extension-updater-c76785dc9-vnmdl 1/1 Running 0 25m
inspection-extension-79dcff47f6-7lm5r 1/1 Running 0 24m
intent-agent-7bdf6c8bd4-kgm46 1/1 Running 0 24m
policy-sync-extension-8648685fc7-shn5g 1/1 Running 0 24m
policy-webhook-78f5699b76-bvz5f 1/1 Running 1 24m
policy-webhook-78f5699b76-td74b 1/1 Running 0 24m
sync-agent-84f5f8bcdc-mrc9p 1/1 Running 0 24m

So if you got this far you now have attached a cluster and created a cluster from scratch all from VMware TMC and that's just the start.

Soon I will show to add some policies to our cluster now we have them under management

More Information

Introducing VMware Tanzu Mission Control to Bring Order to Cluster Chaos

VMware Tanzu Mission Control
Categories: Fusion Middleware


Subscribe to Oracle FAQ aggregator