[RAC] : ASMB Exiting And Unable To Start Database 'ORA-27303 additional information ORACLE_HOME uid does not match euid' (Doc ID 2860434.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Unable to start Database,

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 1881
Session ID: 128 Serial number: 8477

From asm alert.log

2022-03-24T11:25:50.103984+05:30
Errors in file <ORACLE_BASE>/diag/asm/+asm/+ASM/trace/+ASM_m000_13348.trc:
ORA-12753: The Oracle home user ID does not match the effective user ID of the local client which connected to the Oracle instance.
ORA-27300: OS system dependent operation:check $ORACLE_HOME ownership failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: spstp:4
ORA-27303: additional information: ORACLE_HOME uid does not match euid. uid: 755 euid: 153
2022-03-24T11:25:51.042356+05:30
Process M000 died, see its trace file
2022-03-24T11:30:03.966735+05:30
Errors in file <ORACLE_BASE>/diag/asm/+asm/+ASM/trace/+ASM_mz00_13548.trc:
ORA-12753: The Oracle home user ID does not match the effective user ID of the local client which connected to the Oracle instance.
ORA-27300: OS system dependent operation:check $ORACLE_HOME ownership failed with status: 0 >>>>>>>>>>>>>>>>>>>>>>>>>>
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: spstp:4 >>>>>
ORA-27303: additional information: ORACLE_HOME uid does not match euid. uid: 755 euid: 153 >>>>>>>>>>>>>>>>>
2022-03-24T11:30:04.906775+05:30
Process MZ00 died, see its trace file
2022-03-24T15:57:18.087478+05:30
NOTE: client HRTEST:HRTEST:ASM deregistered
2022-03-24T16:00:42.191105+05:30
Shutting down ORACLE instance (abort) (OS id: 27946)

asmb is also getting terminated

2022-03-24T16:10:02.929618+05:30
Errors in file <ORACLE_BASE>/diag/asm/+asm/+ASM/trace/+ASM_ora_546.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 2
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 2
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 2
Additional information: -4611686018422455360
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 2
Additional information: -4611686018422455360
2022-03-24T16:10:03.157038+05:30
Errors in file <ORACLE_BASE>/diag/asm/+asm/+ASM/trace/+ASM_ora_546.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 2
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 2
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 2
Additional information: -4611686018422455360
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 2
Additional information: -4611686018422455360
2022-03-24T16:10:03.383044+05:30
NOTE: cache ending mount (success) of group DATA number=1 incarn=0x72ea85ba
2022-03-24T16:10:03.387645+05:30
NOTE: Instance updated compatible.asm to 19.0.0.0.0 for grp 1 (DATA).
2022-03-24T16:10:03.388974+05:30
NOTE: Instance updated compatible.rdbms to 10.1.0.0.0 for grp 1 (DATA).
2022-03-24T16:10:03.391614+05:30
SUCCESS: diskgroup DATA was mounted
2022-03-24T16:10:03.417007+05:30
SUCCESS: ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:2} */
2022-03-24T16:10:03.516582+05:30
NOTE: diskgroup resource ora.DATA.dg is online
2022-03-24T16:10:04.818023+05:30
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.69)(PORT=1521))' SCOPE=MEMORY SID='+ASM';
2022-03-24T16:42:16.806952+05:30
Shutting down ORACLE instance (abort) (OS id: 5909) >>>>>>>>>>
License high water mark = 2
2022-03-24T16:42:16.808566+05:30
USER (ospid: 5909): terminating the instance
2022-03-24T16:42:16.812646+05:30
Process termination requested for pid 540 [source = unknown], [info = 0] [request issued by pid: 540, uid: 153]
2022-03-24T16:42:16.813010+05:30
Process termination requested for pid 500 [source = unknown], [info = 0] [request issued by pid: 500, uid: 153]
2022-03-24T16:42:16.813436+05:30
Process termination requested for pid 5593 [source = unknown], [info = 0] [request issued by pid: 5593, uid: 153]
2022-03-24T16:42:16.814814+05:30
Process termination requested for pid 532 [source = unknown], [info = 0] [request issued by pid: 532, uid: 153]
2022-03-24T16:42:16.815280+05:30
Process termination requested for pid 526 [source = unknown], [info = 0] [request issued by pid: 526, uid: 153]
2022-03-24T16:42:16.815760+05:30
Process termination requested for pid 530 [source = unknown], [info = 0] [request issued by pid: 530, uid: 153]
2022-03-24T16:42:16.815156+05:30
Process termination requested for pid 534 [source = unknown], [info = 0] [request issued by pid: 534, uid: 153]
2022-03-24T16:42:16.816814+05:30

For ASM IO error :

ORA-27090 - Unable to Reserve Kernel Resources for Asynchronous Disk I/O (Doc ID 579108.1)
RAC and Oracle Clusterware Best Practices and Starter Kit (HP-UX) (Doc ID 811303.1)

fixed and still DB start was failing.

Database alert.log shows

ORA-27303: additional information: ORACLE_HOME uid does not match euid

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.