[oracle@fl1qsvtibbedb1 ~]$ lsnrctl services LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-MAR-2012 09:33:17 Copyright (c) 1991, 2011, Oracle. All rights reserved. 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@fl1qsvtibbedb1 ~]$ lsnrctl services LISTENER_SCAN2 LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-MAR-2012 09:36:59 Copyright (c) 1991, 2011, Oracle. All rights reserved. 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@xxxxxxxxxxx>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@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)(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@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)(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 **** > > ** ** > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l