InitSID.ora is a parameter file.But which Parameter file SPfile or Pfile?

Interview Candidate
Jun 26th, 2006
4
2941

Showing Answers 1 - 4 of 4 Answers

skumarpenugonda
Profile Answers by skumarpenugonda

Jul 7th, 2006

Obviously init.ora file is always text-based pfile. The spfile has name spfileSID.ora which can be readable/updatable only by oracle

Chiranjeevi Manne

Mar 30th, 2007

SPFILE is the binary version of INIT.ORA file and the advantage of using the SPFILE is that there won't be any necessity to bounce the database in case if we want to change some dynamic parameter while in case of INIT.ORA the instance should be bounced to make the changes effective.

hkrishna
Profile Answers by hkrishna

Jul 28th, 2008

Hi Friend,

Here is simple defination
initSID.ora will tell you SID is the database name where you are going to creating a new database.

when you create database it'll take you as pfile and spfile is the system parameter file which you can convert if you required use in database.