This discussion is archived
1 Reply Latest reply: Dec 4, 2012 12:32 PM by P.Forstmann RSS

Intermittent issues with service

BlueSkies Newbie
Currently Being Moderated
Grid Version:11.2.0.3
DB version : 11.2.0.3
OS : RHEL 5.4



We have a 3 node RAC. This is how we usually create services.

In the below example , we are creating a service with Instance3 as the preferred instance and Instance2 as the available one.

-- setting the env variables for DB Home
$ . oraenv
ORACLE_SID = [APPTCP3] ? APPTCP3
The Oracle base remains unchanged with value /optware/app/oracle/global
$
$
$
$ srvctl add service -d APPTCP -s EMPREL_ST -r APPTCP3 -a APPTCP2
$
$ srvctl start service -d APPTCP -s EMPREL_ST
$
$
$
-- Tested connection using the service. Its working fine
$ sqlplus scott/tiger@syptex-scan.ap.renduit.com:1628/EMPREL_ST.ap.renduit.com

SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 4 11:35:52 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>
All the 3 SCAN listeners know about this service. ie. The service is listed in output of lsnrctl status <SCAN ListenerName>
But only the preferred instance's node listener knows about this service.

Below is the output of lsnrctl status <ListenerName> for each node's SCAN and Node listeners.
The node listener's name in all nodes is LISTENER.
lsnrctl status <ListenerName> -- after setting the GI Home

--- Node3 (This is where preferred Instance APPTCP3 is running )
     
     SCAN listener's output
     =========================
     Service "EMPREL_ST.ap.renduit.com" has 1 instance(s).
       Instance "APPTCP3", status READY, has 1 handler(s) for this service...

     Node listener's output
     =======================
     Service "EMPREL_ST.ap.renduit.com" has 1 instance(s).
       Instance "APPTCP3", status READY, has 1 handler(s) for this service...


-- Node2

       SCAN listener's output
       =========================
       Service "EMPREL_ST.ap.renduit.com" has 1 instance(s).
       Instance "APPTCP3", status READY, has 1 handler(s) for this service...

       
       
       Node listener's output
       =======================
       This service is missing in Node Listener' lsnrctl status LISTENER output
       
-- Node1

     SCAN listener's output
     =========================
     Service "EMPREL_ST.ap.renduit.com" has 1 instance(s).
       Instance "APPTCP3", status READY, has 1 handler(s) for this service...
       
       
     Node listener's output
     =======================
     This service is missing in Node Listener' lsnrctl status LISTENER output
Is this expected ?
The reason why I ask is that services cofigured like above becomes 'unusable' sometimes and
the client connections and even test connections from within RAC DB servers are getting ORA-12514 error.
  • 1. Re: Intermittent issues with service
    P.Forstmann Guru
    Currently Being Moderated
    BlueSkies wrote:

    Is this expected ?
    Yes.
    The reason why I ask is that services cofigured like above becomes 'unusable' sometimes and
    the client connections and even test connections from within RAC DB servers are getting ORA-12514 error.
    Did you check SCAN listener log for error ORA-12514 (check that connect string is OK) and for possible other errors ?
    About SCAN listener log location, please read http://oraganism.wordpress.com/2012/01/23/controlling-the-scan-listener-log-location/.

    Edited by: P. Forstmann on 4 déc. 2012 21:32

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points