- 问题1
alert日志：
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j000_116120.trc:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 10009 (asmadmin), current egid = 10001 (oinstall)
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_97512.trc:
解决方法：
查看oracle用户下/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle文件权限变为-rwxr-x--x，其正常权限应为-rwsr-s--x（6751）
[root@dg1 31718723]# chown oracle.asmadmin /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
[root@dg1 31718723]# chmod 6751 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
[root@dg1 31718723]#
[root@dg1 31718723]# ll /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 206955988 Jul 22 22:48 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
- 问题2
alert日志：
Sun Jul 31 17:17:14 2022
ASMB started with pid=32, OS id=127687
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATADG/orcldg/controlfile/current.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DATADG/orcldg/controlfile/current.ctl
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 26
Additional information: 1441797
ORA-205 signalled during: ALTER DATABASE MOUNT...
Sun Jul 31 17:17:15 2022
解决方法：
查看grid用户下/u01/app/11.2.0/grid/bin/oracle文件权限变为-rwxr-x--x，其正常权限应为-rwsr-s--x（6751）
[root@dg1 31718723]# ll oracle
-rwxr-x--x 1 grid oinstall 210439832 Jan 7 21:38 oracle
修改/u01/app/11.2.0/grid/bin/oracle文件权限
[root@dg1 31718723]# chmod 6751 oracle
[root@dg1 31718723]# ll oracle
-rwsr-s--x 1 grid oinstall 210439832 Jan 7 21:38 oracle
- 问题3
在主库进行升级后，备库不能开启实时查询alert日志报错：
ORA-10485: Real-Time Query cannot be enabled while applying migration redo.
The
Real-Time Query feature was enabled when an attempt was made to recover
through migration redo generated during primary upgrades or downgrades
解决方法：
-- 1. 停止备库恢复进程
alter database recover managed standby database disconnect ;
-- 2. 停备库，并启动节点1到mount
srvctl stop database -d orcldg
启动备库节点1到mount
sqlplus / as sysdba
startup mount;
-- 3. 在主库可以切换日志，并等待所有重做应用到备库
alter database recover managed standby database disconnect from session;
-- 4. 在备库开启实时应用
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect from session;
节点2启动：
startup
