红联Linux门户
Linux帮助

centos下安装oracle10g后,无法读取spfile(LRM-00109)

发布时间:2008-04-07 00:18:20来源:红联作者:Sednol
今天在centos5上安装了oracle10g,发现启动时无法读取参数文件,检查路径和权限都没有问题,仔细查看错误信息,才知道是参数文件大小写敏感的问题。

使用mv将参数文件改名就可以启动了。

[oracle@localhost dbs]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 6 20:48:22 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect / as sysdba;
Connected to an idle instance.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/product/10.2.0/db_1/dbs/initORCL.ora'
SQL> host
[oracle@localhost dbs]$ cd $ORACLE_HOME
[oracle@localhost db_1]$ cd dbs
[oracle@localhost dbs]$ ls
hc_orcl.dat hc_ORCL.dat initdw.ora init.ora lkORCL orapworcl spfileorcl.ora
[oracle@localhost dbs]$ mv spfileorcl.ora spfileORCL.ora
[oracle@localhost dbs]$ exit
exit

SQL> startup open;
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
文章评论

共有 2 条评论

  1. firefishfly 于 2008-04-14 17:27:36发表:

    太无耻了!!

  2. firefishfly 于 2008-04-14 17:27:05发表:

    这是我的文章!!!!
    http://blog.sina.com.cn/s/blog_493b5aa80100a8nh.html