This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 我现在正在努力学习oracle 9i，碰到一问题,请高手指点：我试着创建一个spfile，没有成功。再次startup数据库时，出现下面的问题：
ora-01078: failure in processing system parameters
lrm-00109: could not open parameter file ‘c:\oracle\ora92\database\init$SID.ora’
可是pfile文件就在哪里啊。为什么不能打开呢？
操作系统：winxp.
-lilyba(Sunshine);
2002-10-20
{272}
(#808401@0)
-
Did you set the environmental variable for $SID?
-ican(apple);
2002-10-20
(#808430@0)
-
这个问题和你的环境有关系，你好好看看Spfile 和 Pfile的关系吧，还有就是启动顺序，如果你要别人帮忙的话就把尽可能详细的信息发出来的，如果你想自己解决的话就好好看书，反正绝对不是什么BUG之类的东西!
-arthurxu(ArthurXu OCP8,9i);
2002-10-20
(#808443@0)
-
天，我咋敢说是否是bug的问题呢。开始是很好。我就是试验创建一个spfile，没有成功。然后数据库就启动不起来了。从网上查，有的说是因为process太多，有的说是因为机器可能原来装过oracle,别的sid也可能存在。但是，我实际上从8i升级到9i,从注册表删除了原来的数据库。而且用的一个sid.
-lilyba(Sunshine);
2002-10-20
{160}
(#808455@0)
-
描述问题要象这样才专业，看看！别没头没脑的问几句，谁也帮不了你
-arthurxu(ArthurXu OCP8,9i);
2002-10-20
{1542}
(#808482@0)
-
Spfile and Init.ora Parameter File Startup of an Oracle9i Instance
-arthurxu(ArthurXu OCP8,9i);
2002-10-20
{4082}
(#808484@0)
-
Check the environmnet step by stepCheck the name of the init file. Maybe type error or file properties.
Make sure that there is no read/write privileges been set up incorrect.
By the way, if your SID is 'TEST', your init file name should be 'initTEST.ora' .
If you don't know whether there is another Oracle Home been set up in your server, run 'REGEDIT' to check your registry for sure.
Hope you do good.
-kew888(西竹);
2002-10-21
{382}
(#809362@0)
-
Thank you very much. I can only try to find the problem after work. Hope tonight I can figure out the problem according to you guys' suggestion. Thanks again.
-lilyba(Sunshine);
2002-10-21
(#809385@0)