安装好oracle后,起动时报如下错误:
[oracle@Oracle-A ~]$ export ORACLE_SID=ORCL
[oracle@Oracle-A ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 12 21:39:26 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. 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/dbhome_1/dbs/initORCL.ora'
复制如下位置的文件,如:
[oracle@Oracle-A dbhome_1]$ cp /u01/app/base/admin/orcl/pfile/init.ora.582018154558 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initORCL.ora
故障排除:
SQL> startup
ORACLE instance started. Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 536874064 bytes
Database Buffers 289406976 bytes
Redo Buffers 6565888 bytes
Database mounted.
Database opened.