In srvctl I have the following parameters:
[root@primrac1 script]# srvctl config database -db orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/18.3.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.291.1001107969
Password file: +DATA/ORCL/PASSWORD/pwdorcl.279.1001107225
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: orcl1,orcl2
Configured nodes: primrac1,primrac2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
When I start database using srvctl I get the following:
[root@primrac1 script]# srvctl start database -db orcl
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/18.3.0/dbhome_1/dbs/initorcl1.ora'
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/primrac1/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.orcl.db' on 'primrac1' failed
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/18.3.0/dbhome_1/dbs/initorcl2.ora'
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/primrac2/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.orcl.db' on 'primrac2' failed
But when I try to start using sqlplus, the dartabase starts without any problem:
SQL> startup
ORACLE instance started.
Total System Global Area 1.5737E+10 bytes
Fixed Size 15754064 bytes
Variable Size 6610223104 bytes
Database Buffers 9093251072 bytes
Redo Buffers 17797120 bytes
Database mounted.
Database opened.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/ORCL/PARAMETERFILE/spfile.291.1001107969