X

Step Up to Modern Cloud Development

Recent Posts

Database

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 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.”   Julian 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."   Tim 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.”   Lucas 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.”   Brendan 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 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 Podcast: Developer Evolution: What's rockin’ roles in IT? Vibrant and Growing: The Current State of API Management Lifecycle Management and DevOps for Oracle Databases - The Cloud Way

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...

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. Christian Antognini Senior Principal Consultant and Partner, Trivadis AG Monte Carasso, Switzerland   How Well Do Relational Database Engines Support JSON? Martin Bach Principal Consultant, Accenture Enkitec Group Germany   Container Orchestration for Oracle DBAs Heli Helskyaho CEO, Miracle Finland Oy Finland   Machine Learning Explained with Examples Oren Nakdimon Database Expert, Moovit Acre, Israel   Oracle SQL Pattern Matching Made Easy Franck Pachot Data Engineer, CERN Lausanne, Switzerland   Microservices: Get Rid of Your DBA and Send the DB into Burnout Kamil Stawiarski Owner/Partner, ORA-600 Warsaw, Poland   Performance Tricks Learned From Low Level Developers That Can Be Used in Practically Any Language Øyvind Isene Consultant, Sysco AS Oslo, Norway   5 Things Developers Do That Drive Me Crazy Piet De Visser Independent Oracle Database Consultant The Hague, Netherlands   We are Serverless – Software and Databases Still Functioning Related Resouorces About the Oracle ACE Program Oracle ACE Program: A High-Five for New Members and Category Climbers Oracle ACE Sessions at the Great Lakes Oracle Conference (GLOC) Oracle ACEs at APEX Connect 2019, May 7-9 in Bonn

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...

Cloud

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 Launch the Cloud Developer Image from the Console Set up OCI CLI Create Autonomous Transaction Processing Database using CLI Download Wallet using CLI 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: From the Console, choose Create a VM Instance Click Change Image Source Click Oracle Images, next to Platform Image Check Oracle Cloud Developer Image and review and accept the terms and conditions Click Select Image Paste in your ssh public key 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.

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...

ACEs in Action

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. Alex Nuijten Director/Senior Oracle Developer, allAPEX Oosterhout, Netherlands   De EECS is dood, Lang Leve de EECS Alex Zaballa Infrastructure Senior Principal, Accenture Brasil São Paulo Area, Brazil   Utilizando o Oracle Autonomous Transaction Processing Paul Guerin Database Service Delivery Leader, Hewlett-Packard Philippines   Gain on the roundabout, but lose on the swings You take the high road, and I’ll take the unload Umair Mansoob Senior Database Architect, Sirius Computer Solutions Skokie, Illinois   Use Cases for Virtualizing Your Exadata Database Machine Borys Neselovskyi Solution Architect, OPITZ Consulting Dortmund, Germany   Datenbank in der Wolke – Teil 1: Abrechnungsmodelle in der Oracle Cloud Emad Al-Mousa Senior IT Consultant, Saudi Aramco Dhahran, Saudi Arabia   Guide to Modify Pluggable CDB Name, PDB Name, and DBID in Oracle 18c Multitenant Architecture Mathias Magnusson CEO, Evil Ape Stockholm, Sweden   The APEX Tour — Or the Power of a Good Mojito Related Resources Latest Blog Posts from Oracle ACEs: April 14-20, 2019 Latest Blog Posts from Oracle ACEs: April 7-13, 2019 Latest Blog Posts from Oracle ACEs: March 31 - April 6, 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...

ACEs in Action

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   Gary Crisci Principal Architect, General Electric Norwalk, Connecticut   PBCS 101 Master Your Master Data with Oracle DVD Jim Czuprynski Senior Enterprise Data Engineer, Viscosity North America Bartlett, Illinois   Conquer Big Data with Oracle 18c, In-Memory External Tables & Analytic Functions Vote Early, Vote Often: From Napkin to Canvassing Application in a Single Weekend Gustavo Gonzalez Chief Technology Officer, IT Convergence Argentina   Revitalize Your Visualizations with Oracle Autonomous Analytics Cloud Learn How to Unlock Your EBS Data for Free Running in Days! Janice Griffin Senior Sales Engineer, Quest Software Longmont, Colorado   Oracle 12c, 18c, Now 19c! Oh My! What Are the Changes? Cary Millsap Vice President, User Experience Services and Solutions, Cintra Software and Services Dallas, Texas   Pre-conference Workshop: How to Write Better Technical Reports Innovative Specifications for Better Performance Logging & Monitoring Scott Spendolini Vice President, Viscosity North America Austin, Texas   Pre-conference Workshop: APEX Developer Day At Your Service: APEX & Web Services APEX Security Checklist Mike Gangler Senior Database Specialist / Database Architect, Secure-24 Southfield, Michigan   We Don’t Need No Stinkin’ Audit Logs: Using Kafka to Analyze Audit Logs Karen Cannell President/Consultant, TH Technology Rockport, Massachusetts   APEX Interactive Grid & API Essentials: The Stuff You’ll Really Use Voyage to Visual Builder Cloud Service: First Impressions from an APEX Gal Michael Messina Senior Managing Consultant, Rolta-AdvizeX Owensburg, Indiana   The Oracle Database Security Assessment Tool: Know Your Security Risks Anuj Mohan Technical Account Manager, Data Intensity, LLC Covington, Kentucky   DBA 101: Multitenant for Beginners Anton Nielsen Vice President, Insum Solutions Boston, Massachusetts   Two Very Social Applications Jorge Rimblas Senior APEX Consultant, Insum Minneapolis, Minnesota   Pre-conference Workshop: APEX Developer Day Yes, You Can Do That with APEX! Report Templates: The Definitive Guide Maze Runner: The Cure for APEX Confusion Michel Schildmeijer Lead Software Architect for Justis, SSC-I DJI Gouda, Netherlands   Application Workloads to the Oracle Cloud with Kubernetes   Related Content Oracle ACEs at APEX Connect 2019, May 7-9 in Bonn Presentation Persuasion: Calls for Proposals for Upcoming Events

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...