could not open parameter file -Urgent

[dsr]

Hi all,

I have tried to start Oracle8i in svrmgrl

Getting following errors.
LRM-00109: could not open parameter file 'E/oracle/ora81/initorgs.ora'
ORA-01078: failure in processing system parameters

I've specified pfile path in the registry as 'E\oraadmin\orgs\initorgs.ora' but it is seraching in the oracle home for the pfile and so am unable to startup the database.

Plz help me in solving this problem.

Thanks,
dsr

[jovery]

You can put a init.ora file in $ORACLE_HOME/database which has an IFILE='remote_file_name' parameter to point to your remote parameter file.

Also I think you may need to restart the service on NT for it to re-read the registry entries (not 100% on this one)

Regards

[adewri]

Hi
Try this

c:\winnt>svrmgrl

svrmgrl> connect internal
svrmgrl> startup pfile='E\oraadmin\orgs\initorgs.ora'

Regards
Amar

[dsr]

Hi,

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.

Thanx 4 ur responses.

dsr.

[stecal]

Why are you playing with the registry? And what does this have to do with certification?

[dsr]

well...am not playing with the registry.

Can any please answer my questions.

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.

Waiting for ur responses,
dsr.

[Sameer]

Originally posted by dsr
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?

1. In Windows it will be taken from ORA_%ORACLE_SID%_PFILE reg parameter.

2. Not necessary.. Good practice will be to place in
?\ADMIN\%ORACLE_SID%\PFILE\init%ORACLE_SID%.ora

Originally posted by dsr
3.Or is it ok if i place it in a different directory and give that path in the registry.

3. Its okay.. Not a good practice

[stecal]

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?