oracle11g报错 ORA-01078和LRM-00109 解决方法
发布时间:2020-12-12 16:16:29 所属栏目:百科 来源:网络整理
导读:数据库安装完成后启动数据库startup时报错如下: [oracle@Danny ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 16 01:38:13 2016Copyright (c) 1982,2013,Oracle. All rights reserved.Connected to an idle instance.SQL con
数据库安装完成后启动数据库startup时报错如下:
[oracle@Danny ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 16 01:38:13 2016 Copyright (c) 1982,2013,Oracle. All rights reserved. Connected to an idle instance. SQL> conn as sysdba Enter user-name: orcl Enter password: Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db/dbs/initorcl.ora'
[root@Danny ~]# cd /u01/app/oracle/product/11.2.0/db/dbs/ [root@Danny dbs]# ll total 20 -rw-rw---- 1 oracle oinstall 1544 Jul 16 01:28 hc_dbca.dat -rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora -rw-r----- 1 oracle oinstall 24 Jul 16 01:18 lkDBCA -rw-r----- 1 oracle oinstall 1536 Jul 16 01:18 orapwdbca -rw-r----- 1 oracle oinstall 2560 Jul 16 01:28 spfiledbca.ora网上找到方法,可以将pfile参数文件拷贝过来并重新命名为initorcl.ora 查看pfile下果然有这个文件,cp过来
[oracle@Danny pfile]$ cd /u01/app/oracle/admin/dbca/pfile/ [oracle@Danny pfile]$ ll total 4 -rw-r----- 1 oracle oinstall 1760 Jul 16 01:18 init.ora.616201612838 [oracle@Danny pfile]$ cp init.ora.616201612838 /u01/app/oracle/product/11.2.0/db/dbs [oracle@Danny pfile]$ cd /u01/app/oracle/product/11.2.0/db/dbs [oracle@Danny dbs]$ ll total 24 -rw-rw---- 1 oracle oinstall 1544 Jul 16 01:28 hc_dbca.dat -rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora -rw-r----- 1 oracle oinstall 1760 Jul 16 02:04 init.ora.616201612838 -rw-r----- 1 oracle oinstall 24 Jul 16 01:18 lkDBCA -rw-r----- 1 oracle oinstall 1536 Jul 16 01:18 orapwdbca -rw-r----- 1 oracle oinstall 2560 Jul 16 01:28 spfiledbca.ora就OK了 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |