Step 1: 登录sqlplus /as sysdba,开始启动报如下错误显示如下:
[oracle@MaxwellDBA ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 17 10:58:11 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLPDB1.ora'
SQL>
解决方案:
root用户:
find /opt -name pfile
cd /opt/oracle/admin/ORCLCDB/pfile
cp init.ora.52920225470 /opt/oracle/product/19c/dbhome_1/dbs/
cd /opt/oracle/product/19c/dbhome_1/dbs/
chown oracle:oinstall init.ora.52920225470
oracle用户:
[root@MaxwellDBA ~]# find /opt -name pfile
/opt/oracle/admin/ORCLCDB/pfile
[root@MaxwellDBA ~]# cd /opt/oracle/admin/ORCLCDB/pfile
[root@MaxwellDBA pfile]# ls -ltr
total 4
-rw-r----- 1 oracle oinstall 1971 Jun 29 05:28 init.ora.52920225470
[root@MaxwellDBA pfile]# cp init.ora.52920225470 /opt/oracle/product/19c/dbhome_1/dbs/
[root@MaxwellDBA pfile]# cd /opt/oracle/product/19c/dbhome_1/dbs/
[root@MaxwellDBA dbs]# ls -ltr
total 24
-rw-r--r-- 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r----- 1 oracle oinstall 24 Jun 29 05:28 lkORCLCDB
-rw-r----- 1 oracle oinstall 2048 Jun 29 09:49 orapwORCLCDB
-rw-rw---- 1 oracle oinstall 1544 Oct 17 10:29 hc_ORCLCDB.dat
-rw-r----- 1 oracle oinstall 3584 Oct 17 10:29 spfileORCLCDB.ora
-rw-r----- 1 root root 1971 Oct 17 11:13 init.ora.52920225470
[root@MaxwellDBA dbs]# chown oracle:oinstall init.ora.52920225470
[root@MaxwellDBA dbs]# ll
total 24
-rw-rw---- 1 oracle oinstall 1544 Oct 17 10:29 hc_ORCLCDB.dat
-rw-r--r-- 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r----- 1 oracle oinstall 1971 Oct 17 11:13 init.ora.52920225470
-rw-r----- 1 oracle oinstall 24 Jun 29 05:28 lkORCLCDB
-rw-r----- 1 oracle oinstall 2048 Jun 29 09:49 orapwORCLCDB
-rw-r----- 1 oracle oinstall 3584 Oct 17 10:29 spfileORCLCDB.ora
[oracle@MaxwellDBA dbs]$ mv init.ora.52920225470 initORCLPDB1.ora
[oracle@MaxwellDBA dbs]$ ls -l
total 24
-rw-rw---- 1 oracle oinstall 1544 Oct 17 10:29 hc_ORCLCDB.dat
-rw-r--r-- 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r----- 1 oracle oinstall 1971 Oct 17 11:13 initORCLPDB1.ora
-rw-r----- 1 oracle oinstall 24 Jun 29 05:28 lkORCLCDB
-rw-r----- 1 oracle oinstall 2048 Jun 29 09:49 orapwORCLCDB
-rw-r----- 1 oracle oinstall 3584 Oct 17 10:29 spfileORCLCDB.ora
[oracle@MaxwellDBA dbs]$