19c srvctl添加资源报错ORA-12547

问题现象:
srvctl start 方式启动数据库后
sqlplus / as sysdba 登录报错ORA-12547

相关文章:https://blog.dbi-services.com/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact/
MOS:DB started by sqlplus cannot be stopped by srvctl( ORA-12547 ), and vice versa (Doc ID 2612663.1)


1、验证问题

su - oracle
srvctl config database -d racdg

应该会发现 ORACLE_HOME  的 db_1 后面带着 / 

2、解决问题

srvctl modify database -d racdg -oraclehome /u02/app/oracle/product/19.9.0/db_1
srvctl stop database -d racdg
srvctl start database -d racdg


sqlplus / as sysdba  验证即可

posted @ 2022-02-10 09:07  Eddie小陈  阅读(95)  评论(0)    收藏  举报