startup with pfile specified works. But what i want to knw is
---If i give startup(w/o pfile specified), it is luking into Oraclehome(oracle\ora81\database\init.ora) but in registry i've specifed another path(oradmin\orgs\init.ora) for pfile.
Since it is looking into wrong place for pfile, database is unable to startup.
Jim, if u want me to copy init.ora into oraclehome\database n then specify ifile = 'remote filename'...then guess i can as well have my pfile in oracle home itself but that is not the solution am looking for.
1.Where will the path for parameter file be taken from(if we dont specify it during startup)?
2.Should i place pfile only in Oraclehome\database?
3.Or is it ok if i place it in a different directory and give that path in the registry.
You need to disabuse yourself of the notion that you "need" to do anything with the registry. Find an Oracle installation guide or pretty much any other documentation that tells you to go dinking around in the registry. It's not like the registry is a sacred Indian burial ground, and if you mess with it, you're going to have 20 years of bad luck. However, as there is no valid reason for you to alter anything in there, well, it is just plain dumb.
And again, what does this question have to do with certification, this being the certification forum?