RAC -- unable to Connect using service name
Date: Wed, 28 Mar 2012 08:17:46 -0400
Message-ID: <CAF6DRCohY1dsYykC=WVekQu=h88_4CSucBxvMhLYDxKGXb7VsQ_at_mail.gmail.com>
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-lReceived on Wed Mar 28 2012 - 07:17:46 CDT