安装好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.