Maybe I shouldn’t have written about flexible security, because I immediately starting hitting inflexible security, locking me out.
Today’s fail is courtesy of MailChimp.com, which I use for my newsletters. It’s OK that they decided they want a confirmation when I log on to my account from India, but it is not OK that they require a text message passcode with no other option.
I have my phone in flight mode, because I don’t (more...)
In my previous article, First setup of a connection from Node.js to an Oracle Database, I demonstrated how to make a connection to a remote database using Node.js and the node-oracledb module. I used a dedicated VM with Linux 7 installed and Oracle Instantclient provided the 12.1 client libraries.
Now it’s time to take it a step further.
Let’s create an application container and just start it multiple time running any . (more...)
There are probably many blogs about installation; however, I tend to do things a little different.
$ cat /media/sf_working/oggcore_11gdb.rsp
I like to see installation progress.
$ ./runInstaller -silent -showProgress -waitforcompletion -responseFile /media/sf_working/oggcore_11gdb.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 28152 MB Passed
Checking swap space: must be greater than (more...)
In this article I will demonstrate how to make a connection to a remote Oracle database from Node.js running on linux 7. We will be using the node-oracledb module to accomplish this. Lucas Jellema gave a great explanation about this module in his recent article Running node-oracledb – the Oracle Database Driver for Node.js – in the Pre Built VM for Database Development
As described in that article, the node-oracldb module is depending on (more...)
When using strings such as “FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=9,10″ within the scheduler, sometimes its not readily apparent how this will translate to actual dates and times of the day that the scheduled activity will run. To help you understand, a nice little utility is to use EVALUATE_CALENDAR_STRING”
SQL> set serveroutput on size 999999
2 l_start_date TIMESTAMP;
3 l_next_date TIMESTAMP;
4 l_return_date TIMESTAMP;
6 l_start_date := trunc(SYSTIMESTAMP);
7 l_return_date := l_start_date;
I got a chance to use my onewait Python based graph to help with a performance problem. I’m looking at slow write time from the log writer on Thursday mornings. Here is the graph with the database name erased:
We are still trying to track down the source of the problem but there seems to be a backup on another system that runs at times that correspond to the spike in log file parallel write (more...)
AskTom has been answering questions from the user community for nearly 16 years.
But what if that service could have an even more personal touch ? We are pleased announce the largest advance in AskTom service since it started way back in 2000.
See all the details in the video below for the new service we are launching on April 1st.
I decided to get rid of the Github repository that I had experimented with and to create a new one. The old one had a dump of all my SQL scripts but without any documentation. But, I have updated my Python graphing scripts a bit at a time and have had some recent value from these scripts in my Oracle database tuning work. So, I created a Github repository called PythonDBAGraphs. I think it will (more...)
There are some questions about Oracle that are like the mythical Hydra – you think you’ve killed it, but for every head you cut off another two grow. The claim that “the optimizer will switch between using an index and doing a tablescan when you access more than X% of the data” re-appeared on the OTN database forum a little while ago – it doesn’t really matter what the specific value of X was – (more...)
We have had problems with set of databases over the past few weeks. Our team does not support these databases, but my director asked me to help. These are 18.104.22.168 Windows 64 bit Oracle databases running on Windows 2008. The incident reports said that the systems stop working and that the main symptom was that the oracle.exe process uses all the CPU. They were bouncing the database server when they saw this behavior (more...)
You know there’s a cluster and that means that an HA system exists, but OEM won’t discover it. Of course that means that your RAC databases can’t be discovered either and all of this is making you cranky. Take a deep breath. We can fix this.
The agent can only recognize an HA system when it knows of the clusterware home. For some reason the agents weren’t aware of the CRS_HOME on some of our (more...)
I’m thrilled to be presenting at Collaborate 2016 with my colleague John Sim, on the recently open-sourced Oracle JET! We front-end developers had been seeking a better UI/UX solution from Oracle for quite some time, and they have delivered in a big way.
Just a quick note: I’ll be holding a 1-day APEX training class on April 21st in Vienna, Austria.
In this training I’ll teach you how to debug your APEX applications, how to find problems and bugs and how to speed up your application.
Interested? Go here and sign up: http://www.aoug.at/Event/413
Upgrading opatch utility consists of two steps
- Remove the old copy of opatch by deleting $OH/OPatch directory
- Unzip the replacement file into your Oracle home directory
But when you try to remove the contents of OPatch directory you get slammed with errors like this:
rm: cannot remove `jlib/.nfs0000000005213282002649ad’: Device or resource busy
rm: cannot remove `jlib/.nfs000000000523b2e4002649ae’: Device or resource busy
rm: cannot remove `ocm/lib/.nfs0000000005226a87002649b3′: Device or resource busy
rm: cannot remove (more...)
In the last post I showed how you can upload a custom theme to the instance repository so that all your developers can choose that theme within the create application wizard. And more importantly, subscribe that theme from the theme repository.
Now the next question is how to update that public theme so that all applications can inherit the changes.
My first attempt was to simply go to Instance Administration – Manage Instance – Public (more...)
I’ve received a number of inquiries lately about the support of DB2 on Delphix and yes, Delphix 5.0 now supports full automation of virtual data for DB2. With the addition of DB2, Delphix now supports full automation of virtual data on all three of the major enterprise databases
as well as Sybase, MySQL and Postgres.
For more information on DB2 in Delphix 5.0 see
The Universal Theme introduced with APEX 5 is immensly good looking and comes with a powerful Theme Roller to customize it.
With that new theme most, if not all, older themes are obsolete.
That leaves us just with a few corporate designs which can’t (or don’t want to) be replaced by the UT.
Now ideally you want your developers to use that custom theme in all applications and also subscribe to that.
Historically I recommended (more...)
I feel like I have not been posting very much on this blog lately. I have been focused on things outside of Oracle performance so I haven’t had a lot of new scripts to post. I have been quietly updating my Python source code on GitHub so check that out. I have spent a lot of time educating myself in various ways including through the leadership and communication training program that comes from Toastmasters. My new (more...)
AuraPlayer was thrilled to attend Mobile World Congress (MWC) in Barcelona. It was our first time attending this epic conference, and we can assure you it lived up to all the hype.
Suhas Uliyar, Oracle’s VP Mobile Strategy, visits the AuraPlayer Booth
The conference emphasized the mobile revolution occurring throughout all industries and how organizations need to mobilize their business practices or they’ll be left behind. This further reinforces what Grant Ronald always says, “If (more...)