:

The Latest Oracle Posts

The Oracle DBCA

The DataBase Configuration Assisstant (DBCA) is a utility  provided by Oracle which allows you to create, configure, re-configure, delete  and manage templates of databases. Prior to release 10G, I heard many a DBA speak badly of the  DBCA. Why? Because it was clunky, unreliable and installed components that were  not needed which meant that you […]

Continue Reading

Oracle MAXLOGMEMBERS and MAXLOGFILES Values

When you create an Oracle database, two of the parameters  that you are required to specify are the MAXLOGFILES and MAXLOGMEMBERS values.  These two values determine how many redo log groups you can have and how many  redo log members per group you can have, respectively. Now, when changing the redo logs in your database […]

Continue Reading

Oracle 10g Agent Doesn’t Start on Windows Server

I ran into a problem the other day where the Oracle  Enterprise Manager 10g Agent would not start. This was on a Windows Server ia64,  which was dual homed; Oracle 9i & Oracle 10g homes. I had only just installed the Oracle 10g agent, and I  already had a 9i agent installed and running. This […]

Continue Reading

The Specified Management Service is Unreachable

Background Information If you have not done it before and are unfamiliar with the  Oracle Enterprise Manager set-up and configuration, it can be quite a challenge  to install and configure correctly – that’s my opinion anyway. It’s not just a case of installing the software and away you  go. You have to know where your […]

Continue Reading

ADRCI

When I upgraded my Oracle database from 10g to 11g one of the new features I discovered was the Automatic Diagnostic Repository (ADR), which can be used from the Command Interface, also known as ADRCI. ADRCI is an executable which sits in the bin directory of the ORACLE_HOME. Note: If you have a dual homed […]

Continue Reading

LRM-00109: could not open parameter file

The Problem You are trying to create an SPFILE from a PFILE and you get the following error: create spfile from pfile * ERROR at line 1: ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\INITTEST.ORA’ The Cause The SPFILE needs to be in the default location, which on Windows is […]

Continue Reading

Execute a script in SQLPlus

Execute a script in SQLPlus

To put it simply, you execute SQL from the command line using the @ command, for example: SQL> @script01.sql However, there are other areas which need to be considered so let’s take a look at them: Does your script call other scripts from within it, like a harness file? Have you copied the contents of […]

Continue Reading

Create SQL from SQL

In this article I would like to demonstrate the power of generating SQL statements from a SQL another SQL statement. This kind of tool is invaluable for any Oracle DBA or Oracle developer. I say Oracle because the dynamic SQL statements which follow are all written for the Oracle database. However, the same principles apply […]

Continue Reading

ORA-04045: errors during recompilation/revalidation of…

ORA-04045: errors during recompilation/revalidation of…

The Problem After re-compiling objects within the database I got the following error: ORA-04045: errors during recompilation/revalidation of PUBLIC.STATS$PGA_TARGET_ADVICE ORA-00980: synonym translation is no longer valid You can use the following SQL to find out what the problems were. SELECT * FROM UTL_RECOMP_ERRORS; The Cause The PERFSTAT user may have been dropped without using the […]

Continue Reading

SP2-0618 Cannot find the Session Identifier. Check PLUSTRACE role is enabled

SP2-0618: Cannot find the Session Identifier. Check  PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report This error was produced when logging in as a specific user  from a certain SQLPlus client version. To give you an example, when logging in  as USERA with a 9.2.0.1.0 client, the above error was produced. If I logged […]

Continue Reading