Oracle clients can connect to 11g RAC VIP but cannot connect scan IP issues ____oracle

Source: Internet
Author: User
Resolving Oracle clients can connect to 11g RAC VIP, but cannot connect scan IP issues
Some time ago configured a set of HP ux11.31 oracle11g R2 RAC, after the configuration is completed, the client can connect VIP and Scan IP connection database, remote clients can only connect VIP access to the database, through the scan IP access to the database can not connect, But you can ping scan ip,telnet scan IP 1521 is no problem
Server-side network configuration information is as follows:
[Root@rac1 ~]# cat/etc/hosts
# do don't remove the following line, or various programs
# that require network functionality would fail.
#127.0.0.1 localhost.localdomain localhost
127.0.0.1 localhost
Modified:: 1 localhost6.localdomain6 Localhost6
07
172.16.0.191 Rac1.localdomain Rac1
172.16.0.193 Rac1-vip.localdomain RAC1-VIP
Ten 192.168.93.1 Rac1-priv.localdomain Rac1-priv
11
172.16.0.192 Rac2.localdomain RAC2
172.16.0.194 Rac2-vip.localdomain RAC2-VIP
192.168.93.2 Rac2-priv.localdomain Rac2-priv
15
172.16.0.203 Rac-scan.localdomain Rac-scan
[Root@rac1 ~]#
Server-side scan IP information is as follows:
[root@rac1 ~]#/u01/app/11.2.0/grid/bin/srvctl config scan
SCAN name:172.16.0.203, Network:1/172.16.0.0/255.255.240.0/eth0
SCAN VIP name:scan1, IP:/rac-scan.localdomain/172.16.0.203
[Root@rac1 ~]#/u01/app/11.2.0/grid/bin/srvctl status Scan
SCAN VIP scan1 is enabled
SCAN VIP Scan1 is running on node RAC2
Modified [Root@rac1 ~]#/u01/app/11.2.0/grid/bin/srvctl status Scan_listener
SCAN Listener listener_scan1 is enabled
SCAN Listener Listener_scan1 is running on node RAC2
Ten [Root@rac1 ~]#
Server-side cluster information is as follows:
[Root@rac1 ~]#/u01/app/11.2.0/grid/bin/crs_stat-t
The Name Type Target State Host
------------------------------------------------------------
Ora. DATADG.DG ora....up.type Online Online Rac1
Ora. GRIDDG.DG ora....up.type Online Online Rac1
Ora .... Er.lsnr ora....er.type Online Online Rac1
Modified Ora .... N1.lsnr ora....er.type Online Online Rac2
Ora.asm ora.asm.type Online Online Rac1
Ora.devdb.db ora....se.type Online Online Rac1
Ora.eons ora.eons.type Online Online Rac1
One ORA.GSD ora.gsd.type OFFLINE OFFLINE
Ora....network ora....rk.type Online Online Rac1
ora.oc4j Ora.oc4j.type OFFLINE OFFLINE
Ora.ons ora.ons.type Online Online Rac1
Ora ..... Sm1.asm Application Online Online Rac1
Ora ..... C1.lsnr Application Online Online Rac1
ORA.RAC1.GSD Application OFFLINE OFFLINE
Ora.rac1.ons Application Online Online Rac1
Ora.rac1.vip ora....t1.type Online Online Rac1
Ora ..... Sm2.asm Application Online Online RAC2
Ora ..... C2.lsnr Application Online Online RAC2
ORA.RAC2.GSD Application OFFLINE OFFLINE
Ora.rac2.ons Application Online Online RAC2
Ora.rac2.vip ora....t1.type Online Online Rac2
Ora....ry.acfs ora....fs.type Online Online Rac1
Ora.scan1.vip ora....ip.type Online Online Rac2
[Root@rac1 ~]#
To modify the SCAN parameters of a database by looking for metalink:ora-12545 or ORA-12537 while connecting to RAC through Local_listener name [ID 970619.1] :

Before modification:
[Root@rac1 ~]# Su-oracle
Rac1-> Sqlplus
03
Sql*plus:release 11.2.0.1.0 Production on Tue Mar 13 10:42:58 2012
05
Copyright (c) 1982, 2009, Oracle. All rights reserved.
07
08
Connected to:
Oracle Database 11g Enterprise Edition release 11.2.0.1.0-64bit Production
With the partitioning, real application clusters, Automatic Storage Management, OLAP,
Data Mining and real application testing options
13
Sql> Set line 160
Sql> Show parameter SPFile;
16
The NAME TYPE VALUE
-----------------------------------------------------------------------------
SPFile string +datadg/devdb/spfiledevdb.ora
Sql> show parameter instance_name;
21st
NAME TYPE VALUE
-----------------------------------------------------------------------------
instance_name string devdb1
Sql> Show Parameter Listener
26
The NAME TYPE VALUE
-----------------------------------------------------------------------------
Listener_networks string
Local_listener string (description= address_list= (AD
Dress= (protocol=tcp) (HOST=RAC1
32-VIP)) (port=1521))
Remote_listener string rac-scan:1521
Sql>
To modify the Local_listener parameter:
Sql> alter system set local_listener= ' (Description= (address_list= address= (protocol=tcp) (host=172.16.0.193) (P ort=1521))), ' sid= ' devdb1 ';
02
The System altered.
Sql> alter system set local_listener= ' (Description= (address_list= address= (protocol=tcp) (host=172.16.0.194) (P ort=1521))), ' sid= ' devdb2 ';
05
The System altered.
07
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.