Home > Database > Mysql Tutorial > 解决Oracle 11gR2 RAC 无法在客户端通过scanIP连接数据库

解决Oracle 11gR2 RAC 无法在客户端通过scanIP连接数据库

WBOY
Release: 2016-06-07 17:58:03
Original
1428 people have browsed it

安装完Oracle 11g rac后,在10g的客户端的 tnsnames.ora中配置好,scanip,但是无法访问,报错为目标主机不存在,折腾了很久,没弄明白,后面查到,系统初始化参数里有local_listener这一项,在这里可以对host的值加以修改,将scanip注册进来、在监听器中使用v

安装完Oracle 11g rac后,在10g的客户端的 tnsnames.ora中配置好,scanip,但是无法访问,报错为目标主机不存在,折腾了很久,没弄明白,后面查到,系统初始化参数里有local_listener这一项,在这里可以对host的值加以修改,将scanip注册进来、在监听器中使用vip!

--------------------------------------------------------------------------


在racnode1服务器上:
[root@racdb1 ~]# su - Oracle
[Oracle@racdb1 ~]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 21 13:44:12 2010
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> show parameter local_listener;
NAME                                 TYPE        VALUE
--------------------------------------------------------------------------

local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                 DRESS=(PROTOCOL=TCP)(HOST=rac1_vip)(PORT=1521))))


SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=racscan)(PORT=1521))))' scope=both sid='racdb1';
System altered.
SQL>
-------------------------------------------------------------------------

节点二上面也是,一样的修改。
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template