RE: RAC -- unable to Connect using service name
- From: "Chandra Pabba" <Chandra_Pabba@xxxxxxxxxxx>
- To: <krishna.setwin@xxxxxxxxx>, "'Oracle List'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Mar 2012 07:43:54 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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@node1 ~]$ sqlplus system/******@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@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@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 ****
** **
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
