Oracle

SQLcl connect target depends on previous connection

By Franck Pachot . I thought it was a bug for two reasons: first, because I don't like that my connect destination depends on the context, and then because it is a different behavior than in SQL*Plus. But finally, it(…)

OpenShift on my Windows 10 laptop with MiniShift

By Franck Pachot . If you want to play with OpenShift on your laptop, you can, in a Virtual Machine. I have VirtualBox installed on my laptop. I'll install Minishift here, which will create the VM to run OpenShift with(…)

Which Bitnami service to choose in the Oracle Cloud Infrastructure?

By Franck Pachot . In the Oracle Cloud PaaS you have a marketplace where you can choose your service. Some are packaged from Bitnami and available on multiple OS. My first idea is that in PaaS you do not care(…)

ADWC – System and session settings (DWCS lockdown profile)

By Franck Pachot . The Autonomous Data Warehouse Cloud service is a PaaS managed service where we have a PDB and an ADMIN user which has most of the system privileges. For example, we have the privilege to change initialization(…)

12c upuserxt.lst, upobjxt.lst & Oracle Maintained objects/users

By Franck Pachot . Mike Dietrich has blogged recently about upuserxt.lst and upobjxt.lst and how to query them with external table. The first time I've seen those '.lst' files, the default extension(…)

ADWC – connect from your premises

By Franck Pachot . In the previous post about the Autonomous Data Warehouse Service, I've run queries though the Machine Learning Notebooks. But you obviously want to connect to it from your premises, with SQL*Net.

SQL Developer Web on the Oracle Cloud

By Franck Pachot . You like SQL Developer because it is easy to install (just unzip a jar) and has a lot of features? Me too. It can be even easier if it is provided as a web application: no(…)

Some ideas about Oracle Database on Docker

By Franck Pachot . This is not a 'best practice' but just some ideas about building Docker images to provide an Oracle Database. I started with the images provided by Oracle: https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance and this is great(…)

ADWC – the hidden gem: Zepplin Notebook

By Franck Pachot . In the previous blog posts I explained how to create, and stop/start the Autonomous Data Warehouse Cloud service. And I didn't show yet how to connect to it. It is(…)

ADWC – a Docker container to start/stop Oracle Cloud services

By Franck Pachot . In the previous post, I've explained how to start and stop the Autonomous Data Warehouse Cloud service from PSM (PaaS Service Manager). There's a setup phase, and a run phase starting with(…)