<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Transitional//EN">
<HTML>
<HEAD>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

      For third-party license citations, please see the bottom of this file.
    *************************************************************************************
  -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="TEMPLATEBASE" content="vx_vxhelp_2005c">
<meta name="LASTUPDATED" content="06/13/05 10:41:44">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="01_intro.fm">
     
<title>Handling Oracle Error Codes During Detail Monitoring</title>

</HEAD>

<BODY bgcolor="#FFFFFF" link="#000066" vlink="#0000ff" marginheight="0" topmargin="0">
<basefont=1>

<a name="106578"></a>

<div align="left">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
   <td height="2" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#000000">
   </td>
 </tr>
 <tr>
   <td height="15" width="50%" border="0" cellspacing="0" cellpadding="0" bgcolor="#cccccc">
    <img src="images/vxsymbol.gif" height="20" width="31" border="0" cellspacing="0" cellpadding="0" align="left">
     
     
   </td>
   <td align="right" width="50%" bgcolor="#cccccc">

<!-- Header Breadcrumbs -->
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="01_intro_vcs_agents36_101087.html" title="Previous - Additional Information About the Agent">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="01_intro_vcs_agents38_101681.html" title="Next - Action Entry Point">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
   </td>
 </tr>

 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="vcs_agents_splashpage_docCD_vcs_agents1_103036.vxhd" title="Cluster Server Enterprise Agents Guides title page ">Cluster Server Enterprise Agents Guides</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>
 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="vcshp_ora_titlepage_docCD_vcs_agents27_73700.vxhd" title="Cluster Server 4.1 Enterprise Agent for Oracle Installation and Configuration Guide title page ">Cluster Server 4.1 Enterprise Agent for Oracle Installation and Configuration Guide</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>


</table>
</div>

<div align="left">
 <table border="0" width="100%" bgcolor="#FFFFFF">
  <tr>
   <td width="100%" valign="top" bgcolor="#FFFFFF">

<!-- Start Main Topic Content -->
        <a name="startcontent"></a>
	
<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="106578"></a> Handling Oracle Error Codes During Detail Monitoring</font>
</h2>

        
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="101728"></a>The VCS enterprise agent for Oracle comes with enhanced handling of Oracle errors during detail monitoring. The agent classifies Oracle errors according to their severity and associates predefined actions with each error code. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="101589"></a>The agent includes a reference file called <font face="Courier New, Courier, sansserif, sans serif" size="2">oraerror.dat</font>, which lists Oracle errors and the action to be taken when the error is encountered. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="101632"></a>The file stores information in the following format: </font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="101633"></a>Oracle_error_string:action_to_be_taken
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="101590"></a>For example: </font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="101591"></a>01035:WARN&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="101592"></a>01034:FAILOVER
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="101316"></a>The agent supports the following actions:</font>
</p>

<a name="no_figure_caption0"> </a>
<Table width="100%" border="1" cellpadding="2" cellspacing="0" >
<tr bgcolor="#CCCCCC"><th align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"><b><a name="102768"></a>Action</b>
</font></th>

<th align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"><b><a name="102770"></a>Description</b>
</font></th>

</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="102824"></a>IGNORE</font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="102774"></a>Ignores the error.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="102776"></a>UNKNOWN</font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="102778"></a>Marks the resource state as <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">UNKNOWN</font> and sends a notification if the Notifier resource is configured. See the <em>VERITAS Cluster Server User's Guide</em> for more information about VCS notification.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="104298"></a>This action is typically associated with configuration errors or program interface errors.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="102780"></a>WARN</font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="102988"></a>Marks the resource state as <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">ONLINE </font>and sends a notification if the Notifier resource is configured. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="104315"></a>This action is typically associated with errors due to exceeded quota limits, session limits/restricted sessions so on. </font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="102784"></a>FAILOVER</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="104640"></a>(Default)</font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="104793"></a>Marks the resource state as <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">OFFLINE</font>. This faults the service group, which fails over to the next available system.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="104647"></a>This is agent's default behavior. If the file <font face="Courier New, Courier, sansserif, sans serif" size="2">oraerror.dat</font> is not available, the agent assumes this default behavior for every Oracle error encountered.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103026"></a>NOFAILOVER</font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103042"></a>Freezes the service group temporarily and marks the resource state as<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"> OFFLINE</font>. The agent also sends a notification if the Notifier resource is configured. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103043"></a>This action is typically associated with errors that are not system-specific. For example, if a database does not open from a node due to corrupt Oracle files, failing it over to another node will not help. </font>
</p>
</td>
</tr>

</table>


<Table width="100%" border="0" cellpadding="1" cellspacing="0">
<tr><td>
</Table>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="101666"></a>Handling Attribute of Type Password</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="105327"></a>User passwords used for detail monitoring of the Oracle database are no longer 'clear-text'. The Oracle agent supports encryption of user passwords. See <a href="04_config_agent_vcs_agents60_194791.html#194791">Encrypting Passwords</a> for further information.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="105343"></a>Configuring 'listener' passwords is introduced in the Netlsnr agent. This password is considered for querying the status of the listener and stopping the listener. This password is also encrypted. See <a href="04_config_agent_vcs_agents60_194791.html#194791">Encrypting Passwords</a> for further information.</font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="105322"></a>Info Entry Point</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="101674"></a>The VCS enterprise agent for Oracle supports the Info entry point, which provides static and dynamic information about the state of the database. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="101790"></a>The entry point retrieves the following static information: </font>
</p>

<a name="no_figure_caption1"> </a>
<Table width="100%" border="0" cellpadding="1" cellspacing="0" >
<tr valign="top"><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103152"></a>Version</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103154"></a>InstanceNo</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103156"></a>InstanceName</font>
</li>
</ul></td></tr><tr valign="top"><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103158"></a>DatabaseName</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103160"></a>HostName</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103162"></a>StartupTime</font>
</li>
</ul></td></tr><tr valign="top"><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103164"></a>Parallel</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103166"></a>Thread</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103168"></a>InstanceRole</font>
</li>
</ul></td></tr>
</Table>


<Table width="100%" border="0" cellpadding="1" cellspacing="0">
<tr><td>
</Table>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106649"></a>The entry point retrieves the following dynamic information:</font>
</p>

<a name="no_figure_caption2"> </a>
<Table width="100%" border="0" cellpadding="1" cellspacing="0" >
<tr valign="top"><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106605"></a>InstanceStatus</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106607"></a>Logins</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106609"></a>OpenMode</font>
</li>
</ul></td></tr><tr valign="top"><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106611"></a>LogMode</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106613"></a>ShutdownPending</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106615"></a>DatabaseStatus</font>
</li>
</ul></td></tr><tr valign="top"><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106617"></a>TotalDBfileSize</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106619"></a>FreeDBfileSize</font>
</li>
</ul></td><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106621"></a>Shared Pool Percent free</font>
</li>
</ul></td></tr><tr valign="top"><td><ul compact><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106623"></a>Buffer Hits Percent</font>
</li>
</ul></td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106625"></a></font>
</p>
</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="106627"></a></font>
</p>
</td></tr>
</Table>


<Table width="100%" border="0" cellpadding="1" cellspacing="0">
<tr><td>
</Table> 

<a name="no_figure_caption3"> </a>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="111116"></a>You can add additional attributes by adding <font face="Courier New, Courier, sansserif, sans serif" size="2">sql</font> statements to the file <font face="Courier New, Courier, sansserif, sans serif" size="2">$VCS_HOME/bin/Oracle/resinfo.sql</font>. For example:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="101832"></a>select&nbsp;'static:HostName:'||host_name&nbsp;from&nbsp;v$instance;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="101833"></a>select&nbsp;'dynamic:ShutdownPending:'||shutdown_pending&nbsp;from&nbsp;v$instance;
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="101835"></a>The format of the selected record must be as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="101836"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><i>attribute_type</i></font>:userkey_name:userkey_value
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="104334"></a>The variable <font face="Courier New, Courier, sansserif, sans serif" size="2"><i>attribute_type</i></font> can take the value <font face="Courier New, Courier, sansserif, sans serif" size="2">static</font> and/or <font face="Courier New, Courier, sansserif, sans serif" size="2">dynamic</font>.</font>
</p>


<!-- End Main Topic Content -->

   </td>
  </tr>
 </table>
</div>

<div>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
  <td height="18" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
  </td>
 </tr>
  <td align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&nbsp;&#94;&nbsp;<a href="01_intro_vcs_agents37_106578.html" title="Handling Oracle Error Codes During Detail Monitoring">Return to Top</a></font>

  </td>
  <td align="right"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="01_intro_vcs_agents36_101087.html" title="Previous - Additional Information About the Agent">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="01_intro_vcs_agents38_101681.html" title="Next - Action Entry Point">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
  </td>
 <tr>
   <td height="9" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
   </td>
 </tr>

<!-- Footer Breadcrumbs -->
<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="vcs_agents_splashpage_docCD_vcs_agents1_103036.vxhd" title="Cluster Server Enterprise Agents Guides title page ">Cluster Server Enterprise Agents Guides</a>&nbsp;&nbsp;</font></td>
</tr>

<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="vcshp_ora_titlepage_docCD_vcs_agents27_73700.vxhd" title="Cluster Server 4.1 Enterprise Agent for Oracle Installation and Configuration Guide title page ">Cluster Server 4.1 Enterprise Agent for Oracle Installation and Configuration Guide</a>&nbsp;&nbsp;</font></td>
</tr>


 <tr>
  <td colspan="2" align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" color="#000000" align="right" size="-2">
<em>VERITAS Software Corporation
</em></font><br>

<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">www.veritas.com</font><br>
  </td>
 </tr>
</table>
</div>

</BODY>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

    VERITAS, VERITAS SOFTWARE, the VERITAS Logo, and VERITAS Software Documentation 
    are trademarks or registered trademarks of VERITAS Software Corporation 
    or its affiliates in the U.S. and other countries. Other names may be 
    trademarks of their respective owners. 

    Apache Jakarta Lucene:
    Apache Software License
    Version 1.1

    Copyright (c) 2000 The Apache Software Foundation. All rights reserved.

    Redistribution and use in source and binary forms, with or without modification, 
    are permitted provided that the following conditions are met:

    1. Redistributions of source code must retain the above copyright notice, this 
    list of conditions and the following disclaimer.

    2. Redistributions in binary form must reproduce the above copyright notice, this 
    list of conditions and the following disclaimer in the documentation and/or other 
    materials provided with the distribution.

    3. The end-user documentation included with the redistribution, if any, must include 
    the following acknowledgment: "This product includes software developed by the Apache 
    Software Foundation (http://www.apache.org/)." Alternately, this acknowledgment may 
    appear in the software itself, if and wherever such third-party acknowledgments 
    normally appear.

    4. The names "Apache" and "Apache Software Foundation" must not be used to endorse or 
    promote products derived from this software without prior written permission. For 
    written permission, please contact apache@apache.org.

    5. Products derived from this software may not be called "Apache", nor may "Apache" 
    appear in their name, without prior written permission of the Apache Software Foundation.

    THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, 
    BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A 
    PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION 
    OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, 
    OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS 
    OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 
    ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF 
    ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

    This software consists of voluntary contributions made by many individuals on behalf 
    of the Apache Software Foundation. For more information on the Apache Software Foundation, 
    please see <http://www.apache.org/>. Portions of this software are based upon public domain 
    software originally written at the National Center for Supercomputing Applications, University 
    of Illinois, Urbana-Champaign.
    
    This product includes WebWindow Software developed by Horst Heistermann.
    *************************************************************************************
  -->
</HTML>
