Database - RAC/Scalability (MOSC)

MOSC Banner

Manually mount the diskgroups on the +ASM2 instance

This command effect database or request restart cluster ?

command :

export ORACLE_SID=+ASM2

sqlplus "/as sysdba"

SQL> alter diskgroup DATA mount;

SQL> alter diskgroup FRA mount;

We use Oracle database RAC 2 node

Node1 can start database , Node2 Can't start database .

Error

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/ORCL/spfileORCL.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/spfileORCL.ora
ORA-15077: could not locate ASM instance serving a required diskgroup

Ref :

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=402713011631942&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=744479.1&_afrWindowMode=0&_adf.ctrl-state=eclzt38e0_290

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