Database Administration (MOSC)

MOSC Banner

Oracle 19.3 ASM won't start if spfile is in asm

edited Jun 20, 2019 11:28AM in Database Administration (MOSC) 13 commentsAnswered

Hi

Oracle 19.3

Oracle Enterprise Linux 7.6

Using ASM

Single instance

I have tried creating parameterfile to asm, but having problems starting ASM instance after that.

[oracle@dev-dc1-rkoradb1 dbs]$ grid_env  ORACLE_HOME=/oracle/19.3/grid  ORACLE_SID=+ASM[oracle@dev-dc1-rkoradb1 dbs]$ sqlplus / as sysasmSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 14 11:03:59 2019Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle.  All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0SQL> show parameter spfileNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               stringSQL> exitDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0[oracle@dev-dc1-rkoradb1 dbs]$ cat /oracle/19.3/grid/dbs/init+ASM.ora############################################################################### Copyright (c) 1991, 2013 by Oracle Corporation########################################################################################################################## <null>###########################################asm_diskstring='AFD:*','AFD:*'asm_power_limit=1############################################ Pools###########################################large_pool_size=12M############################################ Security and Auditing###########################################remote_login_passwordfile=EXCLUSIVE [oracle@dev-dc1-rkoradb1 dbs]$sqlplus / as sysasmSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 14 11:04:55 2019Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle.  All rights reserved.Connected to:Oracle Database 19c Enterprise

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center