oracle 12c rac ora-12545错误解决

最新推荐文章于 2023-11-23 13:04:55 发布

张小秋博客

最新推荐文章于 2023-11-23 13:04:55 发布

阅读量1.7k

点赞数 1

分类专栏：数据库文章标签： oracle

本文链接：https://blog.csdn.net/xqzhang8/article/details/77647832

版权

数据库专栏收录该内容

29 篇文章 0 订阅

订阅专栏

client端连接数据库，使用scan ip，出现ora-12545错误
检查

SQL> show parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (ADDRESS=(PROTOCOL=TCP)(HOST=d
                                                 fmcdb2-vip)(PORT=1521))
parallel_force_local                 boolean     FALSE

修改local_listener主机名为VIP-IP地址

SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST= 10.2.21.13)(PORT=1521))' sid='dfgdb2';

System altered.

SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST= 10.2.21.12)(PORT=1521))' sid='dfgdb1';

System altered.

测试连接已解决问题

[oracle@dfmc-dbaasdg-01 admin]$ sqlplus system/oracle@DFGDB

SQL*Plus: Release 12.2.0.1.0 Production on Mon Aug 28 06:02:27 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Last Successful login time: Mon Aug 28 2017 13:08:44 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production