:

RSSWindows

ORA-01031: insufficient privileges

I encountered another occasion whereby I received the ORA-01031 error message. This time, though, it was not on startup; it was on logging into the database. I think I should start by giving you a little background information relating to how I got this error. Local System Account Services The database was running without error, on Windows […]

Continue Reading

How to use the FINDSTR Command in Windows

After upgrading or patching your Oracle software on a Windows platform it’s necessary to check through the log files for any errors encountered during the process which have not caused the upgrade to fail. In order to do this, I use the findstr command against the log file, and example would be: findstr /B /N […]

Continue Reading

Variables in Batch Files – Using with Oracle SQL Scripts

When writing SQL scripts it is often a requirement to pass in variables like passwords and usernames so that the script is generic and can be used across multiple environments. The same is true when using Windows command files. However, the difference between the two is that you can use 10 or more in SQL […]

Continue Reading

Which Process is my Oracle Service – Task Manager

When you can’t work out which process belongs to which DB service in a Windows environment, there are two easy ways to work it out: 1. PID Identification find PID from task manager. Add the visible column from the options menu if it’s not shown run this command from command prompt tasklist /svc /fi “pid […]

Continue Reading

.patch_storage Consuming Large Amount of Space

The Problem You have multiple Oracle Homes installed on the same DB server and you notice that the size of the software is increasing pretty rapidly. You have patched the homes many times since you installed the base release and it seems to grow with each patch application. In particular, you notice that the .patch_storage […]

Continue Reading

SPFILE, INIT File & PFILE

All of the above are common names which all refer to a configuration file used by the Oracle database to set values for parameters used to start and manage the database instance. Let’s look at them in a little more detail and compare them. Server Parameter File – SPFILE The Oracle Server Parameter File (SPFILE) […]

Continue Reading

Checking operating system version failed; must be 5.0, 5.1, 5.2 or 6.0. Actual 6.1.

The Problem You want to install Oracle version 10.2.0.4 onto a Windows Server 2008 OS machine, which is not actually supported. When you run the executable to start the installer you receive the following message on your screen: Checking installer requirements… Checking operating system version: must be 5.0, 5.1, 5.2 or 6.0. Actual 6.1 Failed […]

Continue Reading

How to logoff a User from a Windows Server

How to logoff a User from a Windows Server

As with so many other things, there are multiple ways to do this. This is the easiest: 1. Log onto another server 2. START -> Administrative Tools -> Terminal Services Manager 3. right click on “All Listed Servers”, and select “Connect to Computer…” 4. Type the name or IP address of the server that you […]

Continue Reading