Oracle Database 188.8.131.52 is released for Windows, just 2 weeks after the Linux release, and this is a very good news. Let’s see something new you will encounter in the first screens of Oracle 12.2 installer. Don’t worry, the default choice is the right one. But better understand it.
On Linux, you don’t install Oracle Database as root. You create a user, usually called oracle, which will be the owner of the database files and the instance processes and shared memory. This looks obvious be before 12c the Oracle Instance is running as the root equivalent, the built-in SYSTEM user. This was very bad from a security point of view: running a software with the most powerful user on the system.
I just built out my own EM13c environment so I can answer many questions that I won’t be able to ignore just because I no longer work at Oracle.
UltraEdit 23 for Windows has been released. Followers of the blog will know I’m an UltraEdit junkie, so as soon as I got the email telling me UltraEdit 23 had arrived I installed it instantly. Fools rush in where angels fear to tread!
The glaring hideousness you are presented with is a ribbon! For ***** sake! Hasn’t the whole world spent enough time moaning about the Office ribbons already?
Captain Support was getting pretty sick of supporting the crappy old laptops his brother and mother were using, so he selfishly bought them 2 shiny new laptops to make his own life easier. The only slight flaw in the plan was they came with Windows 8. Although Captain Support had some previous experience of Windows 8 (Developer Preview, Consumer Preview, Windows Blue beta), he was a little nervous about unleashing it on his unsuspecting family members…
After having a play with Oracle 12c on Windows 8, I decided to give Windows Server 2012 a go. Here is the resulting virtual RAC installation.
As you would expect, much of the process is pretty similar to the 11gR2 RAC installation on Windows 2008.
If you manage Oracle on Windows, you probably have wondered why it is so difficult to work out which Oracle instances are running and which ORACLE_HOMEs they use. On Unix or Linux, this is a very simple task. Oracle services and their ORACLE_HOMEs are listed in the oratab file, located in /etc/ on most platforms and in /var/opt/oracle/ on Solaris. To find what is running, we would usually use the ‘ps’ command and pipe it through grep to find and run PMON processes.
On Windows, it just isn’t this easy. Each Oracle instance runs in a single monolithic oracle.exe process. Nothing about the process indicates the name of the instance. When we want to find all of the configured Oracle services, we can use the ‘sc’ command, and pipe the results through find (I have added emphasis to the ASM and database instances):
Followers of the blog know I’m a Linux fan, but over the weekend I needed to fix some stuff on a Windows server at work and I took my first tentative steps into the world of Windows PowerShell. It was very much a case of “scripting by Google”, but I managed to get the job done pretty quickly. That episode prompted this tweet.
That resulted in two little exchanges. The first from Niall Litchfield, who must have been a little under the weather.
At least one of the apps at work will be moving to Forms 11gR2, so I thought I better do a run through of the desktop developer installation before someone asks me how it is done.
Our standard desktop environment is still Windows XP (32-bit), hence the archaic choice here.
I mentioned this when I blogged about my 11gR2 Virtual RAC install on Windows 2008. It came up in a conversation with Niall Litchfield at UKOUG 2011 and I’m reminded of it again today, after doing an 11gR2 install on Windows XP to double-check my answer to a question. Oracle database installs on Windows are so incredibly easy!
Now I’m not saying I would want to run Oracle on Windows out of choice. I’m a Linux fanboy, as you probably know, but even the most staunch Linux fan would have to agree that Oracle installs on Linux require quite a few prerequisite steps, even with the oracle-validated package. There is just nothing to do on Windows except put in the CD (iso image) and go…