Oracle 远程数据库无法重启解决方案

 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]$