ASM Alert Log Error ORA-17503 ORA-15173 on MGMTDB Spfile After 12.1.0.2 Upgrade

(Doc ID 1981484.1)

Last updated on OCTOBER 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Oracle Grid Infrastructure is upgraded from 11.2.0.4 to 12.1.0.2 successfully.

After 12.1.0.2 GI upgrade, the ASM alert log started getting the following error:

alert_+ASM1.log

Wed Feb 04 00:03:20 2015
Errors in file /app/oracle/product/diag/asm/+asm/+ASM1/trace/+ASM1_ora_17170846.trc:
ORA-17503: ksfdopn:2 Failed to open file +OCR/_mgmtdb/spfile-mgmtdb.ora
ORA-15173: entry 'spfile-mgmtdb.ora' does not exist in directory '_mgmtdb'
Wed Feb 04 00:03:52 2015
Errors in file /app/oracle/product/diag/asm/+asm/+ASM1/trace/+ASM1_ora_25559524.trc:
ORA-17503: ksfdopn:2 Failed to open file +OCR/_mgmtdb/spfile-mgmtdb.ora
ORA-15173: entry 'spfile-mgmtdb.ora' does not exist in directory '_mgmtdb'
Wed Feb 04 00:05:36 2015

The 'srvctl config mgmtdb' shows a different spfile than the one reported in the ASM alert log.

$ srvctl config mgmtdb

Database unique name: _mgmtdb
Database name:
Oracle home: <CRS home>
Oracle user: oracle
Spfile: +OCR/_MGMTDB/PARAMETERFILE/spfile.268.870720979
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: sgracdb_cluster
PDB service: sgracdb_cluster
Cluster name: sgracdb_cluster
Database instance: -MGMTDB

The MGMTDB alert log also shows it is using the spfile which was registered in 'srvctl config mgmtdb' command.

alert_-MGMTDB.log:

Tue Feb 03 19:00:41 2015
Adjusting the default value of parameter parallel_max_servers
from 320 to 226 due to the value of parameter processes (300)
Starting ORACLE instance (normal) (OS id: 13238370)
Tue Feb 03 19:00:41 2015
CLI notifier numLatches:13 maxDescs:519
Tue Feb 03 19:00:41 2015
..
..
Using parameter settings in server-side spfile +OCR/_MGMTDB/PARAMETERFILE/spfile.268.870720979
System parameters with non-default values:
processes = 300
cpu_count = 8
sga_target = 752M
control_files = "+OCR/_MGMTDB/CONTROLFILE/current.260.870720813"
db_block_size = 8192
compatible = "12.1.0.2.0"
cluster_database = FALSE
db_create_file_dest = "+OCR"
..
..
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Tue Feb 03 19:00:42 2015
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 3.0
Starting background process PMON
Tue Feb 03 19:00:44 2015
..
..
Tue Feb 03 19:01:06 2015
CJQ0 started with pid=36, OS id=17891402
Completed: ALTER DATABASE OPEN /* db agent *//* {1:48367:1167} */
ALTER PLUGGABLE DATABASE ALL OPEN /* mgmtdb agent *//* {1:48367:1167} */
Completed: ALTER PLUGGABLE DATABASE ALL OPEN /* mgmtdb agent *//* {1:48367:1167} */
Tue Feb 03 19:01:08 2015
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1538))','(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.X.XX)(PORT=1578))','(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1555))','(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1535))' SCOPE=MEMORY SID='-MGMTDB';

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms