The INIT.ora is only used to create the SPFILE.ORA during instance creation. It is NOT read each time the instance starts up.

The initORCL.ora.xxx file is usually in \douglas\oracle\admin\db_name\pfile.

The SPFileORCL.ora file is usually in \douglas\oracle\database.

To create a PFILE from the SPFile:
1) Login as SYSDBA using SQL*Plus
2) CREATE PFILE FROM SPFILE;

The file will be in the \douglas\oracle\database directory.

To create a SPFILE from PFILE in the SAME directory:
1) Login as SYSDBA using SQL*Plus
2) SHUTDOWN (can't overwrite SPFILE when database is using it)
3) CREATE SPFILE FROM PFILE;
4) STARTUP

REMEMBER! startup parms are now read from SPFILEorcl.ORA

This is new with Oracle 9i and applies to both CampaignMax and CampaignCSi