Multiple APEX Workspaces in one Oracle Exadata Express Cloud account now possible

Last night my Oracle Exadata Express Cloud account was updated to APEX 5.1.2, but there was more updated once I looked closer into the dashboard.


Before we could already create multiple Oracle schemas, but from now on within one Oracle Exadata Express account you can create multiple APEX Workspaces.

Go to Instance Administration under the Application Express setting in Manage:


Clicking on Manage Workspaces > Create Workspace


Just follow the wizard; you (more...)

Integrigy at Oracle Open World 2017

Integrigy will be presenting again this year on database security at Oracle Open World 2017 (San Francisco, October 1-5).  If you will be attending Open World, please join us for this informative session on database security.

The Thrifty DBA Does Database Security

Sunday, Oct 01, 10:45 a.m. - 11:30 a.m. | Moscone South - Room 159

Stephen Kost, Founder and CTO, Integrigy Corporation

Properly securing an Oracle Database requires significant effort and (more...)

Nextcloud configuration

Nextcloud configuration issues on Debian 9 Stretch In an attempt to get email and storage fixed, I am trying to get dovecot, postfix and nextcloud to integrate. With varying levels of success - what else is new? Anyway, nextcloud greets with the fact I do not have OPcache enabled, and I should add to php.ini. WRONG NOT php.ini So, I did... I added opcache.enable=1 opcache.enable_cli=1

Webinar: Version Control for the Oracle Database


Version control of tables and PL/SQL code in the Oracle Database has always been challenging. Database programmers lack the tools that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams avoid schemas and writing code in the database.

In this presentation you will learn how Gitora 3 can help you use Git, the (more...)

Decrypt any encrypted password in your WebLogic Server Domain

It happens regularly, that you configure a WebLogic Domain and you forgot after some time the given password for the WebLogic Administration User or you have configured a JDBC Data Source and you forgot the password of the used Oracle Database User.

All you need is following small Python Script called decrypt.py:

#/bin/python
#=====================================================================
#
# $Id: decrypt.py $
#
# PURPOSE: Script to decrypt any Password or Username
# within a WebLogic (more...)

EXADATA Essentials For Oracle DBAs: Hands-on 4-Week Saturday Workshop by Gavin Soorma (OCM)

My friend and fellow Oracle Certified Master Gavin Soorma, after his recent popular Oracle RAC workshop (over 100 registrants) is now offering a new hands-on 4-week Saturday workshop on "Exadata Essentials For Oracle DBA’s", so you can fast track your path towards becoming an Oracle Database Machine (DMA) administrator.

In this new workshop, instructions will be provided by Gavin on how to install and configure an Exadata Storage Server on your own individual VirtualBox platform.

(more...)

Some Numbers on SaaS

It's money that matters
You know that it's true
It's money that matters
Whatever you do
               --From "It's Money That Matters" by Randy Newman

So we've just gotten through earnings announcements for several SaaS companies, including my own employer (Oracle).  And as the numbers come out, I see lots of different voices interpreting those numbers inaccurately.  Because SaaS has an entirely different business model from that of (more...)

My Oracle Open World 2017 Presentations

Oracle Open World 2017 will be happening very soon (1st-5th October). Still lots to do before I can get on that plane to San Francisco.

This year I'll be giving 2 presentations (see table below). One on the Sunday during the User Groups Sunday sessions. I've been accepted on the EMEA track. I then get a few days off to enjoy and experience OOW until Thursday when I have my second presentation that is part (more...)

Idempotent and Nullipotent in Cloud

I was going through the documentation of Oracle Cloud IaaS, when I came across the vaguely familiar term Idempotent.



One great thing which I have felt very strongly with all this Cloud-mania is the recall of various theoretical computing concepts which we learned/read in university courses way back. From networking through web concepts to operating system; there are plethora of concepts which are coming back to be in practice very actively in everyday life (more...)

Oracle Installer fails with [EXCEPTION]:java.lang.reflect.InvocationTargetException under RedHat 7.4

I recently had a customer with a fresh installed RedHat 7.4 system on which we wanted to install different Oracle Software in graphical mode, like Oracle Database 12.1.0.2.0, Oracle WebLogic Server 12.2.13.0 and Oracle Data Integrator 12.2.1.3.0.

Following error occured when we were starting the Oracle Installers, either runInstaller or java -jar fmw_12.2.1.3.0_odi.jar:

export JAVA_HOME=/u00/app/oracle/product/jdk1.8.0_131
export (more...)

SRVCTL Status Doesn’t Show RAC instances Running Unlike SQLPLUS

Yesterday, I converted a single instance 12.1.0.2.0 physical standby database to a cluster database with 2 nodes.

After converting that to RAC database, I brought both instances up in mount state on both nodes and they came up fine and I started managed recovery on one node and it started working perfectly fine and got in sync with the primary.


Then I added them as a cluster resource by srvctl like (more...)

And the idiocy continues…

Been a while since my last post.  Then again, Oracle administration has become such a small part of my work that I hardly find the motivation... But the latest idiocy from the Larry Ellison camp is just too much! Yeah sure: another iteration of the "let's get rid of all those DBAs" nonsense that has essentially killed the company here in NSW Australia, since the days of release9! This one is

Super-Sizing PGA Workareas in Oracle 12c

After a customer asked me for possibilities of super-sizing PGA workareas in version 12c, I took the chance to revisit the topic and perform some tests. Great material has already been posted by Alex Fatkulin (Hotsos Symposium 2014) and Norbert Debes (Secrets of the Oracle Database, Apress), but I wanted to verify, how the current release is behaving and I found some interesting things.

Super-Sizing PGA Workareas in 12c

Oracle preps autonomous database at OpenWorld

Oracle preps autonomous database at OpenWorld 

https://goo.gl/snEi7c

IMHO The new database version will probably use the Oracle Management Cloud (OMC) to monitor and tune, the OMC has machine learning using big data analytics to aid performance tuning. Since version 10g, the Oracle DB has had self-tuning capabilities, i.e. auto application of SQL profiles using the Tuning pack license. Everything else was done by the DBA, perhaps with advice gained from the Tuning Advisor, but (more...)

Debian Stretch and opendkim: connection refused, no listener at port 8891

Debian stretch opendkim behaviour changed opendkim fails to sign! In a nutshell... if you face this: postfix/submission/smtpd[17385]: warning: connect to Milter service inet:localhost:8891: Connection refused and you cannot find a listener process at port 8891: netstat -nltp | grep 8891 returns nothing, and you find this in the /var/log/mail.log: opendkim[18055]: OpenDKIM Filter v2.11.0

Beware of ORA-19721 on 12c using Transportable Tablespace (Oracle changed behavior)

Almost every big database has it's hot data which is used often, and cold data which is rarely touched. From version 9i I have used transportable tablespace feature to exclude cold (archive) data from database and keep it on cheap storage or tapes.

If someone needs to query some of archive tables it was very easy to plug in tablespace for few days and after archive data is not needed anymore tablespace could be easily (more...)

How to install and configure Oracle Traffic Director 12c – fully unattended

As I am not a fan of clicking through several Configuration Wizards, I am trying to script as much as possible.
Here is a fully unattended way of how to install and configure Oracle Traffic Director 12.2.1.3.0.

Following pre requirements are necessary:
  • you need a certified Linux Server, e.g. with Oracle Enterprise Linux 7.3
  • an oracle user on the Linux Server
  • all required packages as per documentation and the (more...)

Using Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot Application

The following demo shows how to inject the Spring Security username/password credentials from a User Provided service on PCF, hence using the VCAP_SERVICES env variable to inject the values required to protect the application using HTTP Basic Authentication while running in PCF. Spring Boot automatically converts this data into a flat set of properties so you can easily get to the data as shown below.

The demo application can be found as follows

https://github.com/papicella/springsecurity-cf-cups

(more...)

Demo App for REST enabled SQL

Getting Started  The new Oracle REST Data Services SQL over REST.  How to enable that is on my last blog post here: http://krisrice.blogspot.com/2017/09/ords-173-beta-introducing-rest-enabled.html cURL Examples The simplest way to test this new feature out is with a curl command sending over the SQL. $ curl -X "POST" "http://localhost:9090/ords/hr/_/sql" \ -H "Content-Type:

Oracle Code – Recap

Oracle Code 2017

March 1, San Francisco, USA – August 30, Seoul, South Korea
183 days (exactly 6 months), 20 cities around the world
thousands of speakers, OTN staff and local consultants
hundreds of thousands of participants and coders

That’s the Oracle Code 2017 tour, presenting current and upcoming technologies in packed sessions, providing Oracle cloud services lab for hands-on experience, and a relaxing and fun Code Lounge to be inspired! It is a large (more...)