Oracle Blogs | Oracle Developers Blog

 

24th May 2019 |

Latest Blog Posts by Oracle ACE Associates - May 5-11, 2019
Magic Beans?

This is the last of three posts that list blog posts published by members of the Oracle ACE Program, May 5-11, 2019. Normally I publish the complete list of all posts by ACE Program members during a given week. But during that particular week these folks must have been hyper-caffeinated or revved up on particularly effective nutritional supplements. Whatever the cause, they generated an unusually large number of posts -- more than 70 in a single week. Whatever it takes!

 

Oracle ACE Associate Alfredo AbateAlfredo Abate
Senior Oracle Systems Architect, Brake Parts Inc LLC
McHenry, Illinois

 

Oracle ACE Associate Omar ShubeilatOmar Shubeilat
Cloud Solution Architect EPM, PrimeQ (ANZ)
Sydney, Australia

 

Oracle ACE Associate Robin ChatterjeeRobin Chatterjee
Head of Oracle Exadata Centre of Excellence, Tata Consultancy Services
Kolkata, India

 

Sandra Flores
Arquitecto de soluciones, DevX MX
Mexico City, Mexico

 

Oracle ACE Simo VilmunenSimo Vilmunen
Technical Architect, Uponor
Toronto, Canada

 
Additional Resources

 

23rd May 2019 |

Latest Blog Posts by Oracle ACEs - May 5-11, 2019
Skills on display...

As I explained in Tuesday's blog post, members of the Oracle ACE Program were extraordinarily busy blogging the week of May 5-11, 2019, so much so that I've had to break the list of the latest posts into separate lists for the three levels in the program: ACE Directors , ACEs , and ACE Associates . Tuesday's post featured the ACE Director posts. Today it's the ACE's turn. Posts from ACE Associates will soon follow.

 

Oracle ACE Anoop JohnyAnoop Johny
Senior Developer, Wesfarmers Chemicals, Energy & Fertilisers
Perth, Australia

Oracle ACE Anton ElsAnton Els
VP Engineering, Dbvisit Software Limited
Auckland, New Zealand

 

Oracle ACE Atul KUmarAtul Kumar
Founder & CTO, K21 Academy
London, United Kingdom

 

Oracle ACE Jhonata LamimJhonata Lamim
Senior Oracle Consultant, Exímio IT Solutions
Brusque, Brazil

 

Oracle ACE Kyle GoodfriendKyle Goodfriend
Vice President, Planning & Analytics, Accelytics Inc.
Columbus, Ohio

 

Oracle ACE Laurent LeturgezLaurent Leturgez
President/CTO, Premiseo
Lille, France

 

Oracle ACE Marcelo OchoaMarcelo Ochoa
System Lab Manager, Facultad de Ciencias Exactas - UNICEN
Buenos Aires, Argentina

 

Oracle ACE Marko MischkeMarco Mischke
Group Lead, Database Projects, Robotron Datenbank-Software GmbH
Dresden.Germany

 

Oracle ACE Martin BergerMartin Berger
Database Teamleader, Hutchison Drei Austria GmbH
Vienna, Austria

 

Oracle ACE Miguel PalaciosMiguel Palacios
Gerente General, Global Business Solutions Perú
Peru

 

Oracle ACE Peter ScottPeter Scott
Principal/Owner, Sandwich Analytics
Marcillé-la-Ville, France

 

Oracle ACE Rodrigo MufalaniRodrigo Mufalani
Principal Database Architect, eProseed
Luxembourg

 

Oracle ACE Rodrigo DeSouzaRodrigo De Souza
Solutions Architect, Innive Inc.
Tampa, Florida

 

 

Additional Resources

 

23rd May 2019 |

Run SQL Developer in Oracle Cloud Infrastructure and Connect to Autonomous Database

In a previous blog post, I described how to quickly create an Autonomous Database and connect to it via SQLcl. By using the the most recent Cloud Developer Image —which includes SQLcl- I was able to save a time installing and configuring. Cloud Developer Image also comes with Oracle SQL Developer pre-installed. In this post I describe how to run SQL Developer and connect it to Autonomous Database.

Steps
  1. Launch Cloud Developer Image
  2. Set up OCI cli
  3. Create Autonomous Transaction Processing Database using CLI
  4. Download Wallet using CLI
  5. Configure VNC server and connect from a VNC Client
  6. Launch SQL Developer and add Wallet
  7. Connect to the database
Step 1-4: See previous blog post

The steps to create an Autonomous Database and download the Wallet are covered in the previous blog post and apply to this tutorial as well.

5. Configure VNC server and connect from a VNC client

To access a GUI via VNC, do the following:

  • Install a VNC viewer on your local computer
    • On MacOS you can use the built-in VNC viewer in the Screen Sharing app
  • Use SSH to connect to the compute instance running the Oracle Cloud Developer Image: ssh -i <path to your ssh keys> opc@<IP address>
  • Configure a VNC password by typing vncpasswd
  • When prompted, enter a new password and verify it
  • Optionally, enter a view-only password
  • After the vncpasswd utility exits, start the VNC server by typing vncserver
  • This will start a VNC server with display number 1 for the opc user, and the VNC server will start automatically if your instance is rebooted
  • On your local computer, connect to your instance and create an ssh tunnel for port 5901 (for display number 1):
    • $ ssh -L 5901:localhost:5901 -i <path to your ssh keys> opc@<IP Address>
  • On your local computer, start a VNC viewer and establish a VNC connection to localhost:1
    • On MacOS, from Finder, hit Command-K to Connect to Server and enter vnc://localhost:5901
  • Enter the VNC password you set earlier
  • Acknowledge the welcome dialogs until you see the Oracle Linux desktop

 

1. Connecting to VNC Server using MacOS built-in VNC Viewer, Screen Sharing

 

 

2. Oracle Linux Desktop

 

Launch SQL Developer and add Wallet

Launch SQL Developer via the Applications > Programming menu. See figure 3.

 

3. Launching SQL Developer

 

Connect to the database

To create a database connection (See figure 4.):

  • In the connections panel, click the (+) icon to create a New Database Connection…
  • Name your connection
  • For Connection Type, choose Cloud Wallet
  • Browse for the wallet.zip you downloaded earlier
  • You can leave the default Service unless you have other Autonomous Databases in this tenancy

 

4. Creating the Database Connection

 

You are now ready to connect:

 

5. SQL Developer connected to Autonomous Database

 

Conclusion

The Oracle Linux-based Cloud Developer image includes all the tools you need to get started with Autonomous Database and Oracle SQL Developer via VNC. In this blog post I explained the steps create an Autonomous Dababase and access it via SQL Developer displayed via VNC.

 

21st May 2019 |

Support for Oracle Java SE now Included with Oracle Cloud Infrastructure

Today we are excited to announce that support for Oracle Java, Oracle’s widely adopted and proven Java Development Kit, is now included with Oracle Cloud Infrastructure subscriptions at no extra cost. This includes the ability to log bugs, to get regular stability, performance, and security updates, and more for Oracle Java 8, 11, and 12. With Oracle Java you can develop portable, high-performance applications for the widest range of computing platforms possible, including all of the major public cloud services. By making Oracle Java available as part of any Oracle Cloud Infrastructure subscription, we are dramatically reducing the time and cost to develop enterprise and consumer applications.

This is an important announcement as Java is the #1 programming language and #1 developer choice for the cloud. It’s used widely for embedded applications, games, web content, and enterprise software. 12 million developers run Java worldwide and its usability is growing as options for cloud deployment of Java increase.

Oracle Java in Oracle Cloud helps developers write more secure applications, with convenient access to updates and a single vendor for support – for cloud and Oracle Java use – same subscription, no additional cost. We also ensure that you will have signed software from Oracle and the latest stability, performance, and security updates addressing critical vulnerabilities. 

All of this is supported on Oracle Linux and on other operating systems you run in your Oracle Cloud Infrastructure Virtual Machine or Bare Metal instance. Microsoft Windows? Of course. Ubuntu? Yep. Red Hat Enterprise Linux?  Sure!

Easy Peasy Cloud Developer Image

How can you get the Oracle Java bits? They are a breeze to install on Oracle Linux using Oracle Cloud Infrastructure yum repositories. But with the Oracle Cloud Developer Image available in the Oracle Cloud Marketplace, it’s even easier to get started. Simply click to launch the image on an Oracle Cloud Infrastructure compute instance. The Oracle Cloud Developer Image is a Swiss army knife for developers that includes Oracle Java and a whole bunch of other valuable tools to accelerate development of your next project. You can have this image installed and ready to go within minutes.

Get started with the Oracle Cloud Developer Image.

 

21st May 2019 |

Latest Blog Posts by Oracle ACE Directors - May 5-11, 2019
Weighing in...

Given the extraordinary number of blog posts recently published between May 5 and May 11 by members of the Oracle ACE program , I'm publishing separate lists for posts by ACE Directors, ACEs, and ACE Associates. Today's list features recent posts by Oracle ACE Directors.

Oracle ACE Director David KurtzDavid Kurtz
Consultant, Accenture Enkitec Group
London, United Kingdom

 

Oracle ACE Director Oren NakdimonOren Nakdimon
Database Architect & Developer, Moovit
Tzurit, HaZafon (North) District, Israel

 

Oracle ACE Director Edward RoskeEdward Roske
CEO, interRel Consulting Partners
Arlington, Texas

 

Oracle ACE Director Franck PachotFranck Pachot
Data Engineer, CERN
Lausanne, Switzerland

 

Oracle ACE Director John ScottJohn Scott
Director, Apex Evangelists
Leeds, United Kingdom

 

Oracle ACE Director Opal AlapatOpal Alapat
Vision Team Practice Lead, interRel Consulting
Arlington, TX

 
Additional Resources

 

16th May 2019 |

Using YAML for Build Configuration in Oracle Developer Cloud

In the April release, we introduced support for YAML-based build configuration in Oracle Developer Cloud. This blog will introduce you to scripting YAML-based build configurations in Developer Cloud.

Before I explain how to create your first build configuration using YAML on Developer Cloud, let’s take a look at a few things.

Why do we need YAML configuration?

A YAML-based build configuration allows you to define and configure build jobs by creating YAML files that you can push to the Git repository where the application code that the build job will be building resides.

This allows you to version your build configuration and keep the older versions, should you ever need to refer back to them.  This is different from user interface-based build job configuration where once changes are saved there is no way to refer back to an older version.

Is YAML replacing the User Interface based build configuration in Developer Cloud?

No, we aren’t replacing the existing UI-based build configuration in Developer Cloud with YAML. In fact, YAML-based build configuration is an alternative to it. Both configuration methods will co-exist going forward.

Are YAML and User Interface-based build configurations interchangeable in Developer Cloud?

No, not at the moment. What this means for the user is that a build job configuration created as a YAML file will always exist as and can only be edited as a YAML file. A build job created or defined through the user interface will not be available as a YAML file for editing.

Now let’s move on to the fun part, scripting our first YAML-based build job configuration to build and push a Docker container to Docker registry.

 

Set Up the Git Repository for a YAML-Based Build

To start, create a Git repository in your Developer Cloud project and then create a .ci-build folder in that repository. This is where the YAML build configuration file will reside. For this blog, I named the Git repository NodeJSDocker, but you can name it whatever you want.

In the Project Home page, under the Repositories tab, click the +Create button to create a new repository.

 

Enter the repository Name and a Description, leave the default values for everything else, and click the Create button.

 

 

In the NodeJSDocker Git repository root, use the +File button and create three new files: Main.js, package.json, and Dockerfile.  Take a look at my NodeJS Microservice for Docker blog for the code snippets that are required for these files.

Your Git repository should look like this.

 

Create a YAML file in the .ci-build folder in the Git repository. The .ci-build folder should always be in the root of the repository.

In the file name field, enter .ci-build/my_first_yaml_build.yml, where .ci-build is the folder and my_first_yaml_build.yml is the YAML file that defines the build job configuration. Then add the code snippet below and click the Commit button.

Notice that the structure of the YAML file is very similar to the tabs for the Build Job configuration. The root mapping in the build job configuration YAML is “job”, which consists of “name”, “vm-template”, “git”, “steps”, and “settings”. The following list describes each of these:

  • name”: Identifies the name of the build job and must be unique within the project.
  • vm-template”: Identifies the VM template that is used for building this job.
  • git”: Defines the Oracle Developer Git repository url, branch, and repo-name.
  • steps”:  Defines the build steps. In YAML, we support all the same build steps as we support in a UI-based build job.

 

In the code snippet below, we define the build configuration to build and push the Docker container to DockerHub registry. To do this, we need to include the Docker Login, Docker Build, and Docker Push build steps in the steps mapping.

Note:

For the Docker Login step, you’ll need to include your password. However, storing your password in plain text in a readable file, such as in a YAML file, is definitely not a good idea. The solution is to use the named password functionality in Oracle Developer Cloud.

To define a named password for the Docker registry, we’ll to click Project Administration tab in the left navigation bar and then the Build tile, as shown below.

 

In the Named Password section, click the +Create button.

 

Enter the Name and the Password for the Named Password. You’ll refer to it in the build job. Click the Create button and it will be stored.

You’ll be able to refer this Named Password in the YAML build job configuration by using #{DOCKER_HUB}.

 

docker-build: Under source, put DOCKERFILE and, if the Dockerfile does not reside in the root of the Git repository, include the mapping that defines the path to it. Enter the image-name (required) and version-tag information.

docker-push: You do not need the registry-host entry if you plan to use DockerHub or Quay.io. Otherwise, provide the registry host. Enter the image-name (required) and version-tag information.

**Similarly for docker-login, You do not need the registry-host entry if you plan to use DockerHub or Quay.io

job: name: MyFirstYAMLJob vm-template: Docker git: - url: "https://alex.admin@devinstance4wd8us2-wd4devcs8us2.uscom-central-1.oraclecloud.com/devinstance4wd8us2-wd4devcs8us2/s/devinstance4wd8us2-wd4devcs8us2_featuredemo_8401/scm/NodeJSDocker.git" branch: master repo-name: origin steps: - docker-login: username: "abhinavshroff" # required password: "#{DOCKER_HUB}" # required - docker-build: source: "DOCKERFILE" image: image-name: "abhinavshroff/nodejsmicroservice" # required version-tag: "latest" - docker-push: image: image-name: "abhinavshroff/nodejsmicroservice" # required version-tag: "latest" settings: - discard-old: days-to-keep-build: 5 builds-to-keep: 10 days-to-keep-artifacts: 5 artifacts-to-keep: 10

Right after you commit the YAML file in the .ci-build folder of the repository, a job named MyFirstYAMLJob will be created in the Builds tab. Notice that the name of the job that is created matches the name of the job you defined in the my_first_yaml_build.yml file.

Click the MyFirstYAMLJob link and then, on the Builds page, click the Configure button. The Git tab will open, showing the my_first_yaml_build.yml file in the .ci-build folder of the NodeJSDocker.git repository. Click the Edit File button and edit the YAML file.

 

After you finish editing and commit the changes, return to the Builds tab and click the Build Job link. Then click the Build Now button.

 

When the build job executes, it builds the Docker image and then pushes it to DockerHub.

You’ll also be able to create and configure pipelines using YAML. To learn more about creating and configuring build jobs and pipelines using YAML, see the documentation link.

To learn more about other new features in Oracle Developer Cloud, take a look at the What's New in Oracle Developer Cloud Service document and explore the links it provides to our product documentation. If you have any questions, you can reach us on the Developer Cloud Slack channel or in the online forum.

Happy Coding!

 

16th May 2019 |

ACE-Organized Meet-Ups: May 17-June 13, 2019
The meet-ups below were organized by the folks in the photos. But those people will necessarily present the content. And in many cases the events consist of multiple sessions. For additional detail on each event please click the links provided.
 

Oracle ACE Christian PfundtnerChristian Pfundtner
CEO, DB Masters GmbH
Austria


Host Organization: DB Masters
Friday, May 17, 2019
MA01 - Veranstaltungszentrum 
1220 Vienna, Stadlauerstraße 56 
 

Oracle ACE Laurent LeturgezLaurent Leturgez
President/CTO, Premiseo
Lille, France


Host Organization: Paris Province Oracle Meetup
Monday, May 20, 2019
6:30pm - 8:30pm
Easyteam
39 Rue du Faubourg Roubaix
Lille, France
 

Oracle ACE Associate Mathias MagnussonMathias Magnusson
CEO, Evil Ape
Nacka, Sweden

 
Host Organization: Stockholm Oracle
Thursday, May 23, 2019
6:00pm - 8:00pm
(See link for location details)
 

Oracle ACE Ahmed AboulnagaAhmed Aboulnaga
Principal, Attain
Washington D.C.

 
Host Organization: Oracle Fusion Middleware & Oracle PaaS of NOVA
Tuesday, May 28, 2019
4:00pm - 6:00pm
Reston Regional Library
11925 Bowman Towne Dr.
Reston, VA
 

Oracle ACE Richard MartensRichard Martens
Co-Owner, SMART4Solutions B.V.
Tilburg, Netherlands

 
Host Organization: ORCLAPEX-NL
Wednesday, May 29, 2019
5:30pm - 9:30pm
Oracle Netherlands
Hertogswetering 163-167,
Utrecht, Netherlands
 

Oracle ACE Associate Jose RodriguesJosé Rodrigues
Business Manager for BPM & WebCenter, Link Consulting
Lisbon, Portugal

 
Host Organization: Oracle Developer Meetup Lisbon
Thursday, May 30, 2019
6:30pm - 8:30pm
Auditorio Link Consulting
Avenida Duque Ávila, 23
Lisboa
 

Oracle ACE Director Rita NunezRita Nuñez
Consultora IT Sr, Tecnix Solutions
Argentina

 
Host Organization: Oracle Users Group of Argentina (AROUG)
Thursday, June 13, 2019
Aula Magna UTN.BA - Medrano 951
 
Additional Resources

 

15th May 2019 |

Podcast: Do Bloody Anything: The Changing Role of the DBA

In August of 2018 we did a program entitled Developer Evolution: What’s Rocking Roles in IT. That program focused primarily on the forces that are reshaping the role of the software developer. In this program we shift the focus to the DBA -- the Database Administrator -- and the evolve-or-perish choices that face those in that role.

Bringing their insight to the discussion is an international panel of experts who represent years of DBA experience, and some of the forces that are transforming that role.

The Panelists

In alphabetical order

Maria ColganMaria Colgan
Master Product Manager, Oracle Database
San Francisco, California


 “Security, especially as people move more towards cloud-based models, is something DBAs should get a deeper knowledge in.”

 

Oracle ACE Director Julian DontcheffJulian Dontcheff
Managing Director/Master Technology Architect, Accenture
Helsinki, Finland

 

"Now that Autonomous Database is here, I see several database administrators being scared that somehow all their routine tasks will be replaced and they will have very little to do. As if doing the routine stuff is the biggest joy in their lives."

 

Oracle ACE Director Tim HallTim Hall
DBA, Developer, Author, and Trainer
Birmingham, United Kingdom


 “I never want to do something twice if I can help it. I want to find a way of automating it. If the database will do that for me, that’s awesome.”

 

Oracle ACE Director Lucas JellemaLucas Jellema
CTO/Consulting IT Architect, AMIS
Rotterdam,Netherlands


 “By taking heed of what architects are coming up with, and how applications and application landscapes are organized and how the data plays a part in that, I think DBAs can prepare themselves and play a part in putting it all together in a meaninful way.”

 

Oracle ACE Director Brendan TierneyBrendan Tierney
Principal Consultant, Oralytics
Dublin, Ireland


"Look beyond what you're doing in your cubicles with your blinkers on. See what's going on across all IT departments. What are the business needs? How is data being used? Where can you contribute to that to deliver better business value?"

 

Gerald VenzlGerald Venzl
Master Product Manager, Oracle Cloud, Database, and Server Technologies
San Francisco, California

 

"When you talk to anybody outside the administrative roles -- DBA or Unix Admin -- they will tell you that those people are essentially the folks that always say no. That's not very productive."

 

Additional Resources

 

14th May 2019 |

ACEs at Riga DevDays - May 29-31

If you find yourself wandering the Baltic states late in May, why not make your way to Riga, Latvia and drop in on the Riga Dev Days? Held May 29-31 at the Cinema Kino Citadele in Riga, the 3-day DevDays event features 40 speakers, including these members of the Oracle ACE Program.

Oracle ACE Director Christian AntogniniChristian Antognini
Senior Principal Consultant and Partner, Trivadis AG
Monte Carasso, Switzerland

 

Oracle ACE Director Martin BachMartin Bach
Principal Consultant, Accenture Enkitec Group
Germany

 

Oracle ACE Director Heli HelskyahoHeli Helskyaho
CEO, Miracle Finland Oy
Finland

 

Oracle ACE Director Oren NakdimonOren Nakdimon
Database Expert, Moovit
Acre, Israel

 

Oracle ACE Direcctor Franck PachotFranck Pachot
Data Engineer, CERN
Lausanne, Switzerland

 

Oracle ACE Øyvind IseneØyvind Isene
Consultant, Sysco AS
Oslo, Norway

 

Oracle ACE Piet De VisserPiet De Visser
Independent Oracle Database Consultant
The Hague, Netherlands

 
Related Resouorces

 

11th May 2019 |

Get Started with Autonomous Database and SQLcl in No Time Using Cloud Developer Image

In this blog post, I describe how to use a free trial for Oracle Cloud and the recently released, Oracle Linux-based Cloud Developer Image to provision an Autonomous Transaction Processing Database and connect to it via SQLcl, all in a matter of minutes.

Think of the Cloud Developer Image as a Swiss army knife for Cloud developers. It has a ton of tools pre-installed, including:

Languages and Oracle Database Connectors
  • Java Platform Standard Edition (Java SE) 8, 11 and 12
  • Python 3.6 and cx_Oracle 7
  • Node.js 10 and node-oracledb
  • Go 1.12
  • Oracle Instant Client 18.5
Oracle Cloud Infrastructure Client Tools
  • Oracle Cloud Infrastructure CLI
  • Python, Java, Go and Ruby Oracle Cloud Infrastructure SDKs
  • Terraform and Oracle Cloud Infrastructure Terraform Provider
  • Oracle Cloud Infrastructure Utilities
Other
  • Oracle SQL Developer and SQLcl
  • Oracle Container Runtime for Docker
  • Extra Packages for Enterprise Linux (EPEL) via Yum
  • GUI Desktop with access via VNC Server

Here are the steps to provision a fresh Autonomous Transaction Processing Database ad connect to it via SQLcl.

Steps
  1. Launch the Cloud Developer Image from the Console
  2. Set up OCI CLI
  3. Create Autonomous Transaction Processing Database using CLI
  4. Download Wallet using CLI
  5. Launch SQLcl and connect to Autonomous Database
1. Launch Cloud Developer Image

Log in to the Console. If you don't already have an ssh key pair, make sure you generate those firstby following the documentation.
There are several ways to launch an Oracle-provided Marketplace image. Here's one:

  1. From the Console, choose Create a VM Instance
  2. Click Change Image Source
  3. Click Oracle Images, next to Platform Image
  4. Check Oracle Cloud Developer Image and review and accept the terms and conditions
  5. Click Select Image
  6. Paste in your ssh public key
  7. Click Create
2. Set up OCI CLI

Connect to your newly launched image from your local computer via ssh:

ssh -i <path to your ssh keys> opc@<IP address>

Once logged in, run oci setup config and follow the directions, providing the necessary OCIDs as described in the documentation on Required Keys and OCIDs.

$ oci setup config

Remember to upload your API key by following the instructions in the same documentation. If you accepted all the defaults during the oci client setup, the public key to upload is the output of this:

$ cat /home/opc/.oci/oci_api_key_public.pem 3. Create Autonomous Transaction Processing Database using the OCI CLI

A few of the next commands require the compartment-id as input so it's helpful to have a shorthand ready. Get its value and store it in an environment variable by calling the metadata service via oci-metadata

$ export C=`oci-metadata -g compartmentid --value-only`

Next, create the Autonomous Database. Be sure to provide your own admin password.

$ oci db autonomous-database create --compartment-id $C --db-name myadb --cpu-core-count 1 --data-storage-size-in-tbs 1 --admin-password "<YOUR PASSWORD>"

You should see output similar to:

{ "data": { "compartment-id": "ocid1.tenancy.oc1..aaaaaalskdjflsdkjflsdjflsdkflsjdflksjjfqntfkzizeeikohha4oa", "connection-strings": null, "cpu-core-count": 1, "data-storage-size-in-tbs": 1, "db-name": "myadb", "db-version": null, "db-workload": "OLTP", "defined-tags": {}, "display-name": "autonomousdatabase20190511024732", "freeform-tags": {}, "id": "ocid1.autonomousdatabase.oc1.iad.abuwcljrgx2kosiudoisdufoidsufoidsufodsfkdkdd3zprxjzsouzq", "license-model": "BRING_YOUR_OWN_LICENSE", "lifecycle-details": null, "lifecycle-state": "PROVISIONING", "service-console-url": null, "time-created": "2019-05-11T02:47:32.745000+00:00", "used-data-storage-size-in-tbs": null }, "etag": "a133c7fa" }

Export the Database ID in an environment variable as that will come in handy later.

export DB_ID=`oci db autonomous-database list --compartment-id $C | jq -r '.data[] | select( ."db-name" == "myadb" ).id'`

Wait for the Database to be in AVAILABLE state. You can check the database state with the following command. Initially, this command will return PROVISIONING

oci db autonomous-database get --autonomous-database-id $DB_ID | jq -r '.data["lifecycle-state"]' AVAILABLE

For me, it took about 6 minutes from for the database to be available after executing the create command.

4. Download Wallet using CLI $ oci db autonomous-database generate-wallet --autonomous-database-id $DB_ID --password <YOUR PASSWORD> --file wallet.zip

Set TNS_ADMIN and extract wallet.zip

$ export TNS_ADMIN="`cat /etc/ld.so.conf.d/oracle-instantclient.conf`/network/admin" $ sudo -E unzip ~/wallet.zip -d $TNS_ADMIN 5. Launch SQLcl and connect to Autonomous Database

Start SQLcl in /nolog mode and point it to the wallet.zip you downloaded earlier using the set cloudconfig command.

$ sql /nolog SQLcl: Release 19.1 Production on Fri May 10 00:24:29 2019 Copyright (c) 1982, 2019, Oracle. All rights reserved. SQL> set cloudconfig /home/opc/wallet.zip Operation is successfully completed. Operation is successfully completed. Using temp directory:/tmp/oracle_cloud_config2842421108875448254

Connect to your Autonomous database with the admin. For the service name, use one of the entries in $TNS_ADMIN/tnsnames.ora. Each ADB is created with a high, medium and low service.

SQL> connect admin/<YOUR PASSWORD>@myadb_high Connected. SQL> select sysdate from dual; SYSDATE --------- 11-MAY-19 SQL> Conclusion

The Oracle Linux-based Cloud Developer Image comes with wealth of developer tools pre-installed, reducing the time it takes to get started with Oracle Cloud and Autonomoud Database. In this blog post, I showed how you can provision an Autonomous Database and get connected to it in a matter of minutes. The fact that the Cloud Developer Image already has the important bits pre-installed, including OCI client tools an Oracle Instant Client, makes completing this task a breeze.

 

9th May 2019 |

Latest Blog Posts from Oracle ACEs: April 28 - May 4, 2019

The chances of having a movie theater to yourself these days are slim. But while the rest of the world is focused on learning the fates of various Marvel characters in the latest Avengers epic, the members of the Oracle ACE program listed below demonstrated super will power last week by devoting their screen time to hammering out these blog posts.  The least you can do to reward that kind of effort is to take a look, right?

 

Oracle ACE Director  Oracle ACE Directors

Oracle ACE Director Opal AlaphatOpal Alaphat
Vision Team Practice Lead, interRel Consulting
Arlington, TX

 
Oracle ACE  Oracle ACEs

Oracle ACE Ahmed AboulnagaAhmed Aboulnaga
Principal, Attain
Washington D.C.

 

Oracle ACE Anju GargAnju Garg
Corporate Trainer, Author, Speaker, Blogger
New Delhi, India

 

Oracle ACE Bert ScalzoBert Scalzo
Technical Product Manager: Databases
Flower Mound, Texas

 

Oracle ACE Eduardo LegattiEduardo Legatti
Administrador de Banco de Dados - DBA, SYDLE
Belo Horizonte, Brazil

 

Oracle ACE Fabio PradoFabio Prado
Instrutor, Oramaster Treinamentos em Bancos de Dados
Sao Paulo, Brazil

 

Oracle ACE Jhonata LamimJhonata Lamim
Senior Oracle Consultant, Exímio IT Solutions
Brusque, Brazil

 

Oracle ACE Leonardo GonzalezLeonardo Gonzalez Cruz
SOA Architect, Services & Processes Solutions
Mexico

 

Oracle ACE Marcelo OchoaMarcelo Ochoa
System Lab Manager, Facultad de Ciencias Exactas - UNICEN
Buenos Aires, Argentina

 

Oracle ACE Peter ScottPeter Scott
Principal/Owner, Sandwich Analytics
Marcillé-la-Ville, France

 

Oracle ACE Ricardo GiampaoliRicardo Giampaoli
EPM Architect Consultant, The Hackett Group
Malahide, Ireland

 

Oracle ACE Rodrigo DeSouzaRodrigo De Souza
Solutions Architect, Innive Inc.
Tampa, Florida

 

Oracle ACE Wataru MorohashiWataru Morohashi
Solution Architect, Hewlett-Packard Japan, Ltd.
Tokyo, Japan

 
Oracle ACE Associates  Oracle ACE Associates

Oracle ACE Associate Abigail Gils-HaighAbigail Giles-Haigh
Chief Data Science Officer, Vertice
United Kingdom

 

Oracle ACE Associate Diana RobeteDiana Robete
Team Lead/Senior Database Administrator, First4 Database Partners Inc
Calgary, Canada

 

Oracle ACE Associate Emad Al-MousaEmad Al-Mousa
Senior IT Consultant, Saudi Aramco
Saudi Arabia

 

Oracle ACE Associate Emiliano FusagliaEmiliano Fusaglia
Principal Oracle RAC DBA/Data Architect, Trivadis
Lausanne, Switzerland

 

Oracle ACE Associate Eugene FedorenkoEugene Fedorenko
Senior Architect, Flexagon
De Pere, Wisconsin

 

Oracle ACE Associate Flora BarrieleFlora Barriele
Oracle Database Administrator, Etat de Vaud
Lausanne, Switzerland

 

Oracle ACE Associate Heema SatapathyHeema Satapathy
Senior Principal Consultant, BIAS Corporation
United States

 

Oracle ACE Associate Lykle ThijssenLykle Thijssen
Principal Architect, eProseed
Utrecht, Netherlands

 

Oracle ACE Associate Omar ShubeilatOmar Shubeilat
Cloud Solution Architect EPM, PrimeQ (ANZ)
Sydney, Australia

 

Oracle ACE Associate Roy SalazarRoy Salazar
Senior Oracle Database Consultant, Pythian
Costa Rica

 

Oracle ACE Associate Mark DaynesMark Daynes
Managing Director, Beyond Systems Ltd
Manchester, United Kingdom

 
Additional Resources

 

8th May 2019 |

Spotlight on Oracle ACE Director Ruben Rodriguez

Oracle ACE Director Ruben Rodriguez is a Cloud and Mobile Solution Specialist with avanttic Consultoría Tecnológica in Madrid, Spain. He graduated from the Universidad Alfonso X El Sabio in Madrid in 2011 with a degree in Computer Science, then made his way through a variety of IT jobs in Spain and the UK before landing at avantic in 2015. Ruben first entered the Oracle ACE program in October 2017 and was confirmed as an Oracle ACE Director in November 2018. Active in the community, Ruben is a blogger and frequent conference speaker. In December 2019 Packt Publishing will publish Professional Oracle Mobile, written by Ruben and co-author Soham Dasgupta.

Watch the video and get the story from Ruben himself.

Additional Resouces

 

7th May 2019 |

Latest Blog Posts from Oracle ACEs: April 21-27, 2019

Blogs in bloom...

Winter is mostly a memory, spring is in the air, and people naturally want to... sit inside and crank out a bunch of blog posts! These members of the Oracle ACE Program resisted the temptation to enjoy some fresh air and sunshine so they could share some of their expertise with you. Take it in.

ACE Directors

Oracle ACE Director Franck PachotFranck Pachot
Data Engineer, CERN
Lausanne, Switzerland

 

Oracle ACE Director Julian DontcheffJulian Dontcheff
Managing Director/Master Technology Architect, Accenture
Helsinki, Finland

 

Oracle ACE Director Kamran Agayev A.Kamran Agayev A.
Oracle DBA Expert, Azercell
Azerbaijan

 

Oracle ACE Director Richard FooteRichard Foote
Director/Principal Consultant, Richard Foote Consulting Pty Ltd
Canberra, Australia

 

Oracle ACE Director Timo HahnTimo Hahn
Principal Software Architect, virtual 7 GmbH
Germany

 
Oracle ACEs

Oracle ACE Bert ScalzoBert Scalzo
Technical Product Manager: Databases
Flower Mound, Texas

 

Oracle ACE Dirk NachbarDirk Nachbar
Senior Consultant, Trivadis AG
Bern, Switzerland

 

Oracle ACE Eduardo LegattiEduardo Legatti
Administrador de Banco de Dados - DBA, SYDLE
Belo Horizonte, Brazil

 

Oracle ACE Emrah MeteEmrah Mete
Solution Architect/Data Engineer, Turkcell Technology
Istanbul, Turkey

 

Oracle ACE Fabio PradoFabio Prado
Instrutor, Oramaster Treinamentos em Bancos de Dados
Sao Paulo, Brazil

 

Oracle ACE Kyle GoodfriendKyle Goodfriend
Vice President, Planning & Analytics, Accelytics Inc.
Columbus, Ohio

 

Oracle ACE Martien van den AkkerMartien van den Akker
Contractor: Fusion MiddleWare Implementation Specialist, Immigratie- en Naturalisatiedienst (IND)
The Hague, Netherlands

 

Oracle ACE Scott WesleyScott Wesley
Systems Consultant/Trainer, SAGE Computing Services
Perth, Australia

 

Oracle ACE Sean StuberSean Stuber
Database Analyst, American Electric Power
Columbus, Ohio

 
ACE Associates

AOracle ACE Associate Adrian Pngdrian Png
Senior Consultant/Database Administrator, Insum
Canada

 

Oracle ACE Associate Alfredo AbateAlfredo Abate
Senior Oracle Systems Architect, Brake Parts Inc LLC
McHenry, Illinois

 

Oracle ACE Associate Dayalan PunniyamoorthyDayalan Punniyamoorthy
Oracle EPM Consultant,Vertical Edge Consulting Group
Bengaluru, India

 

Oracle ACE Associate Diana RobeteDiana Robete
Team Lead/Senior Database Administrator, First4 Database Partners Inc
Calgary, Canada

 

Oracle ACE Associate Emad Al-MousaEmad Al-Mousa
Senior IT Consultant, Saudi Aramco
Saudi Arabia

 

Oracle ACE Associate Lisandro FernigriniLisandro Fernigrini
Senior Software Developer/DBA, Kapsch TrafficCom
Argentina

 

Oracle ACE Associate Oliver PykaOliver Pyka
Senior Database Consultant
Germany
 

 

Oracle ACE Simo VilmunenSimo Vilmunen
Technical Architect, Uponor
Toronto, Canada

 
Additional Resources

 

2nd May 2019 |

Articles by Oracle ACEs - April 2019

Who you gonna ask?

While the phrase "wildly famous" may not apply to the Oracle ACE program members listed here, each has their own following, and each has earned a reputation for sharing experience and expertise. And let's face it, if you have a question about Oracle APEX, or about Autonomous Transaction Processing, are you going to ask one of the Kardashians? I don't think so.

Better you should ask one of these people, or read one of their freshly-written articles.

Oracle ACE Director Alex NuijtenAlex Nuijten
Director/Senior Oracle Developer, allAPEX
Oosterhout, Netherlands

 

Oracle ACE Director Alex ZaballaAlex Zaballa
Infrastructure Senior Principal, Accenture Brasil
São Paulo Area, Brazil

 

Oracle ACE Director Paul GuerinPaul Guerin
Database Service Delivery Leader, Hewlett-Packard
Philippines

 

Oracle ACE Umair MansoobUmair Mansoob
Senior Database Architect, Sirius Computer Solutions
Skokie, Illinois

 

Oracle ACE Borys NeselovskyiBorys Neselovskyi
Solution Architect, OPITZ Consulting
Dortmund, Germany

 

Oracle ACE Emad Al-MousaEmad Al-Mousa
Senior IT Consultant, Saudi Aramco
Dhahran, Saudi Arabia

 

Oracle ACE Mathias MagnussonMathias Magnusson
CEO, Evil Ape
Stockholm, Sweden

 
Related Resources

 

30th April 2019 |

Oracle ACE Sessions at the Great Lakes Oracle Conference (GLOC)

On May 15-16, 2019 the Northeast Ohio Oracle Users Group will present the Great Lakes Oracle Conference in the historic Cleveland Public Hall, just about a ten minute walk from the Rock and Roll Hall of Fame and Museum, seen in the photo above.

The following members of the Oracle ACE Program will present sessions at GLOC. So if you're in the neighborhood, come on down.

For more information: Great Lakes Oracle Conference

 

Oracle ACE Director Gary CrisciGary Crisci
Principal Architect, General Electric
Norwalk, Connecticut

 

Oracle ACE Director Janice GriffinJanice Griffin
Senior Sales Engineer, Quest Software
Longmont, Colorado

 

Oracle ACE Director Cary MillsapCary Millsap
Vice President, User Experience Services and Solutions, Cintra Software and Services
Dallas, Texas

 

Oracle ACE Director Scott SpendoliniScott Spendolini
Vice President, Viscosity North America
Austin, Texas

 

Mike Gangler
Senior Database Specialist / Database Architect, Secure-24
Southfield, Michigan

 

Oracle ACE Michael MessinaMichael Messina
Senior Managing Consultant, Rolta-AdvizeX
Owensburg, Indiana

 

Oracle ACE Anuj MohanAnuj Mohan
Technical Account Manager, Data Intensity, LLC
Covington, Kentucky

 

Oracle ACE Anton NielsenAnton Nielsen
Vice President, Insum Solutions
Boston, Massachusetts

 

Oracle ACE Michel SchildmeijerMichel Schildmeijer
Lead Software Architect for Justis, SSC-I DJI
Gouda, Netherlands

 

 

Related Content