Portal
Language
 
Home>Knowledge Base>Root>CampaignMax>INIT.ora and SPFile.ora in Oracle 9i
User Login
Username
Password
 
 Login
Information
Article ID122
Created On6/9/2005
Modified9/11/2008

INIT.ora and SPFile.ora in Oracle 9i

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