18c安装遇到过的问题

---------------18c安装遇到问题-------------------

–问题
prvf-0040 the remote shell /usr/local/bin/ssh request by the client does not exist

解决方法：
cd /usr/local/bin 为空 删除bin目录
ln -s /usr/bin/ /usr/local/bin

–安装grid时

ins-06001 failed to perform operation due to internal deriver error;

解决方法：
检查防火墙，检查两端密码一致，打开22端口

plsqldevelop
----连接问题

ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PASSWORD/pwdorcl.256.1076512329
ORA-28040: No matching authentication protocol

解决方法：

cd $ORACLE_HOME/network/admin/
vi sqlnet.ora
#Generated by Oracle configuration tools. for above i8.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

修改用户密码：

USERNAME	     PASSWORD_VERSIONS
-------------------- -----------------
SYS		          11G 12C
SYSTEM		     10G 11G 12C
C##SUNN 	     10G 11G 12C
C##TEST 	     10G 11G 12C

—重启集群问题
集群日志

2021-06-30 10:34:43.623 [ORAROOTAGENT(26692)]CRS-5818: Aborted command 'start' for resource 'ora.storage'. Details at (:CRSAGF00113:) {0:5:3} in /u01/app/grid/diag/crs/orcl18c-2/crs/trace/ohasd_orarootagent_root.trc.
2021-06-30 10:34:47.156 [ORAROOTAGENT(26692)]CRS-5017: The resource action "ora.storage start" encountered the following error: 
2021-06-30 10:34:47.156+Storage agent start action aborted. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/orcl18c-2/crs/trace/ohasd_orarootagent_root.trc".
2021-06-30 10:34:47.161 [OHASD(26549)]CRS-2757: Command 'Start' timed out waiting for response from the resource 'ora.storage'. Details at (:CRSPE00221:) {0:5:3} in /u01/app/grid/diag/crs/orcl18c-2/crs/trace/ohasd.trc.

2021-06-30 10:27:01.971 : USRTHRD:3981596416: {0:5:3} [ora.storage] 8908 Error 4 querying length of attr ASM_DISCOVERY_ADDRESS
2021-06-30 10:27:01.987 : USRTHRD:3981596416: {0:5:3} [ora.storage] 8908 Error 4 querying length of attr ASM_STATIC_DISCOVERY_ADDRESS
2021-06-30 10:27:02.136 : CLSCRED:3981596416: (:CLSCRED1079:)clsCredOcrKeyExists: Obj dom : SYSTEM.credentials.domains.root.ASM.Self.27eed3a755475f2ebf9047d4cfad4387.root not found
2021-06-30 10:27:02.136 : USRTHRD:3981596416: {0:5:3} [ora.storage] 8626 Error 4 opening dom root in 0x7f35b802f460

–解决方法：

cd $ORACLE_HOME/network/admin/
vi sqlnet.ora
去掉
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

–oracle启动问题

ORA-00210: cannot open the specified control file
ORA-00202: control file: '+ARCH/ORCL/CONTROLFILE/current.256.1076512507'
ORA-17503: ksfdopn:2 Failed to open file +ARCH/ORCL/CONTROLFILE/current.256.1076512507
ORA-15001: diskgroup "ARCH" does not exist or is not mounted
ORA-28040: No matching authentication protocol
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/ORCL/CONTROLFILE/current.261.1076512505'
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/CONTROLFILE/current.261.1076512505
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-28040: No matching authentication protocol

–解决方法：

cd $ORACLE_HOME/network/admin/
vi sqlnet.ora
去掉
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8