Binary of new process does not match binary which started instance

WARNING: Oracle executable binary mismatch detected.
 Binary of new process does not match binary which started instance
issue alter system set "_disable_image_check" = true to disable these messages
Thu Jun 17 14:36:22 2021
WARNING: Oracle executable binary mismatch detected.
 Binary of new process does not match binary which started instance
issue alter system set "_disable_image_check" = true to disable these messages
Thu Jun 17 14:36:25 2021
License high water mark = 175
USER (ospid: 42615): terminating the instance
Instance terminated by USER, pid = 42615
Thu Jun 17 14:38:29 2021
Adjusting the default value of parameter parallel_max_servers
from 3200 to 1470 due to the value of parameter processes (1500)

 

oracle
sqlplus / as sysdba
shutdown immediate

OS ORACLE

cd $ORACLE_HOME/bin/
relink all

oracle

sqlplus / as sysdba
startup

ERROR: diskgroup DATA was not mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/ycdb3/control.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DATA/ycdb3/control.ctl
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: alter database mount...
Thu Jun 17 15:41:01 2021
alter database mount
Thu Jun 17 15:41:02 2021
ORA-15025: could not open disk "/dev/emcpowerda"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/emcpowerdb"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/emcpowerdc"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/emcpowerdd"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/emcpowerde"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
--More--

 

$ORACLE_HOME/bin/oracle文件的权限问题，应该为-rwsr-s--x，属主应该是oracle:asmadmin。

解决办法：

方法：

1、修改oracle的权限为6751

[root@RAC2 bin]# ll /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

-rwxr-s--x. 1 oracle asmadmin 210823844 May 18  2014 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

[root@RAC2 ~]#  chmod 6751 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

[root@RAC2 bin]# ll /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

-rwsr-s--x. 1 oracle asmadmin 210823844 May 18  2014 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

[root@RAC2 bin]#

 

 

2、重新用setasmgidwrap设置oracle

[root@RAC2 bin]# ll /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

-rwxr-s--x. 1 oracle asmadmin 210823844 May 18  2014 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

[root@RAC2 ~]# /u01/app/11.2.0/grid/bin/setasmgidwrap -o /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

[root@RAC2 bin]# ll /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

-rwsr-s--x. 1 oracle asmadmin 210823844 May 18  2014 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

[root@RAC2 bin]#


[oracle@RAC2 ~]$ cd $ORACLE_HOME/bin
[oracle@RAC2 bin]$ stat oracle
  File: `oracle'
  Size: 239626641       Blocks: 468032     IO Block: 4096   regular file
Device: fd03h/64771d    Inode: 3151572     Links: 1
Access: (6751/-rwsr-s--x)  Uid: ( 1002/  oracle)   Gid: ( 1003/asmadmin)
Access: 2021-06-17 20:54:19.197997712 +0800
Modify: 2021-06-17 14:37:12.203456851 +0800
Change: 2021-06-17 20:54:16.800997717 +0800
 

 

oracle
sqlplus / as sysdba
shutdown immediate
startup