RE: RAC -- unable to Connect using service name
Date: Wed, 28 Mar 2012 07:43:54 -0500
Message-id: <000001cd0ce0$6fd7e580$4f87b080$_at_verizon.net>
Krishna,
Does "lsnrctl services" list the service named "test"? Did you add "test" to service_names parameter?
Thanks
Chandra
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Krishna
Sent: Wednesday, March 28, 2012 7:18 AM
To: Oracle List
Subject: RAC -- unable to Connect using service name
Hi All,****
** **
We recently built a RAC 2 node Environment. ****
I created a service named "test" and configured 2 nodes as preferred. ****
- **
when I am connecting using sqlplus, I am getting the following error.****
- **
[oracle_at_node1 ~]$ sqlplus system/******_at_test
SQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 28 00:51:07 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in
connect
descriptor****
- **
- configuration -------
alter system set
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST.1.7
.39)(PORT21))))'
sid='node1' scope=both;****
- **
alter system set
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST.1.7
.40)(PORT21))))'
sid='node2' scope=both;****
- **
alter system set
remote_listener='samplescan.domain.com:1521<http://samplescan.hq.chicos.com:
1521/>'
scope=both sid='*';
Node 1:
SQL> show parameter %listen%
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=TCP)(HOST.1
.7.39)(PORT21))))
remote_listener string
samplescan.domain.com<http://samplescan.hq.chicos.com/> :
1521
Node 2:
SQL> show parameter %listen%
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=TCP)(HOST.1
.7.40)(PORT21))))
remote_listener string
samplescan.domain.com<http://samplescan.hq.chicos.com/> :
1521
[grid_at_sampledb1 ~]$ srvctl config scan SCAN name: samplescan.domain.com, Network: 1/10.1.7.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: /samplescan.domain.com/10.1.7.42 SCAN VIP name: scan2, IP: /samplescan.domain.com/10.1.7.41 SCAN VIP name: scan3, IP: /samplescan.domain.com/10.1.7.43
Also, SCAN_listeners have services in there.****
- **
[grid_at_node1 ~]$ lsnrctl services Listener_scan3****
- **
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-MAR-2012 08:09:06** **
- **
Copyright (c) 1991, 2011, Oracle. All rights reserved.****
- **
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))****
Services Summary...****
Service "test.domain.com <http://test.hq.chicos.com/>" has 2 instance(s).*** *
Instance "tibtst1", status READY, has 1 handler(s) for this service...****
Handler(s):****
"DEDICATED" established:0 refused:0 state:ready****
REMOTE SERVER**** (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST.1.7.39)(PORT21)))** **
Instance "tibtst2", status READY, has 1 handler(s) for this service...****
Handler(s):****
"DEDICATED" established:0 refused:0 state:ready****
REMOTE SERVER**** (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST.1.7.40)(PORT21)))** **
- **
can anybody please help me why I am getting that error? ****
- **
Thanks In advance****
- **
Krishna ****
- **
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 28 2012 - 07:43:54 CDT