kurtcabin 发表于 2004-10-18 14:38:24

oracle安装成功后碰到的问题

$ sqlplus " / as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 18 14:30:18 2004

Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/ora9/product/9.2/dbs/initora9i.ora'
SQL>



不知道
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/ora9/product/9.2/dbs/initora9i.ora'
的错误是怎么搞的。initora9i.ora这个文见在我的文件夹里没有。可我安装ORACLE的时候没有出错啊

xf3177 发表于 2004-10-18 14:42:55

自己造一个空的initora9i.ora
看可不可以正常使用
不行再想其他办法吧

kurtcabin 发表于 2004-10-18 15:09:53

I put in the directory /data/opt/ora9/product/9.2/dbs/ the file initora9i.ora like copy of init.ora that there was in the directory.

Now the DB start but I have this error:

ORACLE instance started.

Total System Global Area 46936124 bytes
Fixed Size 450620 bytes
Variable Size 46137344 bytes
Database Buffers 204800 bytes
Redo Buffers 143360 bytes
ORA-00205: error in identifying controlfile, check alert log for more info


接下去怎么办啊。

kurtcabin 发表于 2004-10-18 15:10:51

网上有说

Login using the "oracle" id.
Open the ".bashrc" file and
edit the "export ORACLE_SID=ora9i" line .
Replace "ora9i" with the database name you have created using "dbca".

我也改了。似乎还是不行啊。高手帮忙了

kurtcabin 发表于 2004-10-18 15:33:05

自己造一个空的initora9i.ora
看可不可以正常使用
不行再想其他办法吧

我当时安装数据库的时候没有创建数据库,选择SOFTONLY安装的。现在正在创建数据库。不知道兄台的方法是否可行。
页: [1]
查看完整版本: oracle安装成功后碰到的问题