Good old BIN_TO_NUM to check the overall status

A good while ago Chris Saxon, member of the AskTom answer team, asked on twitter which datatype you use when defining tables when you need a Boolean-representation. As you might know there is no Boolean datatype in SQL.
A lot of discussion followed which I'm not going to repeat.
Usually I use a VARCHAR2(1) with a check constraint for Y and N, but for a recent requirement I decided to use a NUMBER instead.

(more...)

Secured Credit Cards – Credit Cards Reader – Credit Cards for…



Secured Credit Cards - Credit Cards Reader - Credit Cards for Bad Credit

Please Subscribe, Like and Comment if you like the video.
https://goo.gl/z9A6kl
Twitter: http://twitter.com/beyondreliable
Facebook: http://facebook.com/BeyondReliable
Thanks

What Oracle DBAs Need to Learn in Oracle Cloud Platform?

The transition from Oracle on-premises DBA to Oracle Cloud DBA is imminent for many of us. In fact, IMHO; the existing Oracle DBAs would have to manage database both on-premises and in cloud for a long time.

So what Oracle DBA needs to learn in Oracle Cloud Platform? If you visit the Oracle Cloud website, it's a mouthful and more. Its very easy to get bogged down as there are lots of things to (more...)

12.2 Online Conversion of a Non-Partitioned Table to a Partitioned Table (A Small Plot Of Land)

In my previous post, I discussed how you can now move heap tables online with Oracle Database 12.2 and how this can be very beneficial in helping to address issues with the Clustering Factor of key indexes. A problem with this technique is that is requires the entire table to be effectively reorganised when most of […]

Oracle Linux Vagrant boxes

I use Vagrant a lot. It is an awesome tool when it comes to quickly spin up a local VM for some testing. All my boxes are stored on Hashicorp’s Atlas. Atlas provides a lot more functionality than just being a box repository, but I only use it for just that. I try to create one […]

Nokia 6 Price 2017 – Nokia 5 Price 2017 – Nokia Price 3 2017 -…



Nokia 6 Price 2017 - Nokia 5 Price 2017 - Nokia Price 3 2017 - Nokia 3310 Price 2017
Please Subscribe, Like and Comment if you like the video.
https://goo.gl/z9A6kl
Twitter: http://twitter.com/beyondreliable
Facebook: http://facebook.com/BeyondReliable
Thanks

Is Oracle Database in Cloud PaaS, IaaS, SaaS, or DBaaS?

Question: Is Oracle Database in Cloud PaaS, IaaS, SaaS, or DBaaS?
Answer:
  • If you install and manage Oracle database in cloud by yourself, then you are using it on IaaS.
  • If you are just using it in cloud without installing or managing it, then it's PaaS.
  • If you are configuring the database instance and have access to it through SQL*Net, then its DBaaS. 
  • SaaS not really relevant when it comes to Oracle (more...)

Nokia 3310 – The Original Mobile Phone, UpdatedNokia 3310 for…



Nokia 3310 – The Original Mobile Phone, Updated
Nokia 3310 for Sale
Please Subscribe, Like and Comment if you like the video.
https://goo.gl/z9A6kl
Twitter: https://twitter.com/beyondreliable
Facebook: https://facebook.com/BeyondReliable
Thanks

Nokia 3 2017 – Android Phone with All The Smartphone…



Nokia 3 2017 – Android Phone with All The Smartphone Essentials
Nokia 3 2017 - United we make memories
Please Subscribe, Like and Comment if you like the video.
https://goo.gl/z9A6kl
Twitter: https://twitter.com/beyondreliable
Facebook: https://facebook.com/BeyondReliable
Thanks

Nokia 5 – Perfectly Balanced Android PhoneHow Nokia Design Their…



Nokia 5 - Perfectly Balanced Android Phone
How Nokia Design Their Devices
Please Subscribe, Like and Comment if you like the video.
https://goo.gl/z9A6kl
Twitter: https://twitter.com/beyondreliable
Facebook: https://facebook.com/BeyondReliable
Thanks

Oracle Weblogic: Tackling Class Loading Issues for SOA Infra

This blog article discusses how to address class loading issues with the Oracle SOA Infra. It's prime "raison d'etre" being a memory dump of something I don't do often, but may spend significant time in finding out how to do it again.

Some time ago I lost valuable time because some library being deployed twice, once in the wrong place ([SOA_HOME]/lib folder) and once in the right place ([SOA_HOME]/soa/modules/oracle.soa.ext_11.1.1). In this (more...)

Creditcard and Bank Account Decryption No Longer Possible in Oracle E-Business Suite

In January 2014 Integrigy published extensive research and recommendations on how best to secure credit cards and bank accounts within the Oracle E-Business Suite. This research is available here Oracle E-Business Suite: Credit Cards and PCI Compliance

With Release 12 of the Oracle E-Business Suite, Oracle consolidated into the new Payments module, new functionality to encrypt credit cards and external bank accounts. Integrigy’s recommendation in January 2014 was that if encryption was enabled, that (more...)

Announcing Trivadis Performance Days 2017

Trivadis Performance Days 2017

It is a great pleasure to announce the next Performance Days! This year the event will take place the 13-14 September in Zurich.

Given that detailed information about the event as well as online subscription are available at https://trivadis.com/performance-days-2017, in this short post I limit myself to thanking and pointing out who the speakers that accepted my invitation are:

(more...)

Deploying Oracle E-Business Suite 12.2 SOAP Web Services

This is the fifth posting in a blog series summarizing the new Oracle E-Business Suite 12.2 Mobile and web services functionality and recommendations for securing them.

Physically deploying SOAP-based web services for the Oracle E-Business Suite is more complicated than for REST. SOAP interfaces are best used to support heavy-duty solutions such as Business-to-Business (B2B) interfaces. To deploy SOAP services for the Oracle E-Business Suite, the Oracle SOA Suite must be licensed and configured. (more...)

Upgrade of Oracle GI 11.2.0.3 to Oracle 12.1.0.2 Steps

Just noting down the high level steps which were performed for the Upgrade of Oracle GI 11.2.0.3 to Oracle 12.1.0.2 on RHEL 64bit Linux.

Create a backup of 11G GI HOME as root user:

. oraenv <<< +ASM
 sudo su -
cd /oracle/backup
tar -cvf backup_GI.tar /u01/grid/product/11.2.0.3
tar -cvf backup_inventory.tar  /var/opt/ora/oraInventory/



Stop all DB instances and listener

run the GI 12c runInstaller in silent mode (more...)

Nokia 6 and Nokia Edge – How Nokia Design Their DevicesNokia 6…



Nokia 6 and Nokia Edge - How Nokia Design Their Devices
Nokia 6 at MWC 2017
Please Subscribe, Like and Comment if you like the video.
https://goo.gl/z9A6kl
Twitter: https://twitter.com/beyondreliable
Facebook: https://facebook.com/BeyondReliable
Thanks

#fakecode

Unless you've managed to somehow filter out everything about US politics over the last few months (and if you have, please let me know your secret), then you've likely heard about "fake news".  From a high level, my basic understanding of "fake news" is that it refers to stories or websites that are fabricated to advance the political beliefs and/or ideologies of one site or the other.  Your definition may differ.

So what is fake (more...)

Camera 360 – MySight360 | Wearable VR Camera for Smooth…



Camera 360 - MySight360 | Wearable VR Camera for Smooth Panoramic Videos
Please Subscribe, Like and Comment if you like the video.
https://goo.gl/z9A6kl
Twitter: https://twitter.com/beyondreliable
Facebook: https://facebook.com/BeyondReliable
Thanks

12cR2 tightens up ORA-01841 for zero year ANSI dates, but not for Oracle SQL syntax

In moving some more code from an 11gR2 database to a 12cR2 database, I found another change where a piece of code that works in 11gR2 doesn’t compile in 12cR2.

In this instance a view was being created with a projected date column which used the ANSI DATE syntax. Here is a simplified test script:

CREATE OR REPLACE VIEW test1 AS
SELECT date '0000-01-01' date_col
FROM dual
/
DROP VIEW test
/

CREATE OR REPLACE  (more...)

Enable HyperFIDO U2F Key on Linux

Recently, I bought the Hypersecu HyperFIDO K5 Key to help me secure access to several websites and services with U2F (“Universal Two-Factor Authorization”). This works fine on Windows, but with Linux things get a little complicated: The key isn’t accessible to all users by default. This has to be activated using udev rules, which is widely […]