Re: RAC -- unable to Connect using service name

From: Krishna <krishna.setwin_at_gmail.com>
Date: Wed, 28 Mar 2012 09:37:29 -0400
Message-ID: <CAF6DRCqPrDaCZzdYf1rvObQcpvQ0O2hfs5iVJjXoAeSUE5oN1g_at_mail.gmail.com>

[oracle_at_fl1qsvtibbedb1 ~]$ lsnrctl services LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-MAR-2012 09:33:17

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:647 refused:0 state:ready

LOCAL SERVER
Service "test.domain.com" has 1 instance(s). Instance "tibtst1", status READY, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:52 refused:0 state:ready

LOCAL SERVER
Service "tibco.domain.com" has 1 instance(s). Instance "tibtst1", status READY, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:52 refused:0 state:ready

LOCAL SERVER
Service "tibtst.domain.com" has 1 instance(s). Instance "tibtst1", status READY, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:52 refused:0 state:ready

LOCAL SERVER
Service "tibtstXDB.domain.com" has 1 instance(s). Instance "tibtst1", status READY, has 1 handler(s) for this service... Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready

         DISPATCHER <machine: fl1qsvtibbedb1.domain.com, pid: 14427>
         (ADDRESS=(PROTOCOL=tcp)(HOST=fl1qsvtibbedb1.domain.com

)(PORT=40073))
The command completed successfully

SQL> show parameter %service%

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
service_names                        string      tibco, test

[grid_at_fl1qsvtibbedb1 ~]$ lsnrctl services LISTENER_SCAN2

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-MAR-2012 09:36:59

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))) Services Summary...
Service "test.domain.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=10.1.7.39)(PORT=1521)))

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=10.1.7.40)(PORT=1521)))

Service "tibco.domain.com" has 1 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=10.1.7.39)(PORT=1521)))

Service "tibtst.domain.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=10.1.7.39)(PORT=1521)))

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=10.1.7.40)(PORT=1521)))

Service "tibtstXDB.domain.com" has 2 instance(s). Instance "tibtst1", status READY, has 1 handler(s) for this service... Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready

         DISPATCHER <machine: fl1qsvtibbedb1.domain.com, pid: 14427>
         (ADDRESS=(PROTOCOL=tcp)(HOST=fl1qsvtibbedb1.domain.com

)(PORT=40073))
Instance "tibtst2", status READY, has 1 handler(s) for this service... Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready

         DISPATCHER <machine: fl1qsvtibbedb2.domain.com, pid: 6741>
         (ADDRESS=(PROTOCOL=tcp)(HOST=fl1qsvtibbedb2.domain.com

)(PORT=37597))
The command completed successfully

On Wed, Mar 28, 2012 at 8:43 AM, Chandra Pabba <Chandra_Pabba_at_verizon.net>wrote:

> 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)(PORT 21))))'
> sid='node1' scope=both;****
>
> ** **
>
> alter system set
> local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST
> .1.7
> .40)(PORT 21))))'
> 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)(PORT 21))))
> 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)(PORT 21))))
> 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)(PORT 21)))**
> **
>
>  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)(PORT 21)))**
> **
>
> ** **
>
> 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-l

Received on Wed Mar 28 2012 - 08:37:29 CDT

This message: [ Message body ]
Next message: De DBA: "Re: process M000 holds library cache lock"
Previous message: De DBA: "ZFS or UFS? Solaris 11 or better stay with Solaris 10?"
In reply to: Chandra Pabba: "RE: RAC -- unable to Connect using service name"
Next in thread: kathryn axelrod: "Re: RAC -- unable to Connect using service name"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message