1 Reply Latest reply: Dec 4, 2012 2:32 PM by P.Forstmann RSS

    Intermittent issues with service

    BlueSkies
      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
          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