[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2249
  • Last Modified:

oracle ifile

Hi...in my db init.ora , i see one
file , ifile = /oracle_db/dbs/configSG01.ora

 why must init.ora file map to this
 i file?.

 can all the db parameters be put
 just in init.ora

 tq.
0
maliksl4141
Asked:
maliksl4141
1 Solution
 
chdbaCommented:
hello

It's not a MUST.

You are right, you can put all the parameters just in init.ora.

Often people put parameters that are usefull for several instances in a special file --> ifile.

So this is for organising your mess.

Greatings

chdba
0
 
Daniel StanleyCommented:
sometimes the ORA_%SID%_PFILE registry key is set to look at the ifile. if you have your instance set to autostart this could be a problem.  make sure this key string value has a valid path to your pfile.

good luck,
daniels@asix.com
0
 
Daniel StanleyCommented:
this is in regards to my comment:  it is only applicable if you're install is on a windows box; you may not be after looking at your ifile path.  if so, ignore my comment.

thx,
daniels@asix.com
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
sandeeplkCommented:
It is not necessary to have ifile parameter in your parameter file.

It is mainly used for storing common parameters for multiple instances.

You can very well remove this parameter and put all parameters of ifile in your parameter file.


Hope this satisfy your answer.

Cheers.
Sandeep
0
 
asimkovskyCommented:
Sandeeplk is at it again.. Proposing his comments as an answer with the same information provided by another user.

There's more to life than points.


Andrew
0
 
sandeeplkCommented:
Andrew,

I am sorry... but last time, by mistake it has been done.....

I hvn't repeated the things..

Sorry, if it offended you..

Rgds,
Sandeep
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now