Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\oraclewp.12.08.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Advanced Features</title> <link rel="StyleSheet" href="css/oraclewp.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="oraclewp.12.01.html#454021">8 The Oracle Wire Protocol Driver</a> : Advanced Features</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="454021">Advanced Features</a></div> <div class="Body"><a name="454022">The driver supports the following advanced features: </a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="454023">Failover</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="454024">Client Information</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="454026">Security</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="462265">Connection Pooling</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="462266">DataDirect Bulk Load</a></div> </td> </tr> </table> </div> <div class="head_2"><a name="462313">Failover</a></div> <div class="Body"><a name="462348">The driver supports failover and its related connection options. Failover connection options </a>are located on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109030', '');">Failover tab</a></span> of the driver Setup dialog box. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.2.html#106175', '');">â??Using Failoverâ??</a></span> for a general description of failover and its implementation.</div> <div class="head_2"><a name="462292">Client Information</a></div> <div class="Body"><a name="462293">Oracle provides a client information feature that allows an administrator to define different </a>work load classifications and store client information associated with a connection. These workload classifications can be assigned different priorities and resource allocations. To enable applications to leverage these work load classifications fully, the Connect for ODBC Oracle Wire Protocol driver provides connection options for setting the session properties that are used in identifying a work load. These options are located on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');">Client Monitoring tab</a></span> of the driver Setup dialog box. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.3.html#160782', '');">â??Using Client Informationâ??</a></span> for a general description of client information and its implementation.</div> <div class="head_2"><a name="454516">Security</a></div> <div class="Body"><a name="462504">The driver supports authentication and encryption. Security connection options are located </a>on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');">Security tab</a></span> of the driver Setup dialog box. See<span class="Cross_ref_"> </span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.4.html#118526', '');">â??Using Securityâ??</a></span> for a general description of security and its implementation. The following security information is specific to the Oracle Wire Protocol Driver.</div> <div class="head_3"><a name="454785">Authentication</a></div> <div class="Body"><a name="454520">If you are using Kerberos, verify that your environment meets the requirements listed in </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.08.html#454151', '');">Table 8-3</a></span> before you configure the driver for Kerberos authentication.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 8-3. <a name="454151">Kerberos Authentication Requirements for the Oracle Wire Protocol Driver</a> </div> </caption> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="454155">Component</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="454157">Requirements</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="454159">Database</a> server</div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="454161">The database server must be administered by the same domain controller that administers </a>the client and must be running one of the following databases:</div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="454162">Oracle 11</a><span class="Emphasis">g</span> (R1 and R2)</div> </td> </tr> </table> </div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="454163">Oracle 10</a><span class="Emphasis">g</span> (R1 and R2)</div> </td> </tr> </table> </div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="454164">Oracle 9</a><span class="Emphasis">i</span> (R2)</div> </td> </tr> </table> </div> <div class="table_text"><a name="454165">In addition, Oracle Advanced Security is required.</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="454167">Kerberos server</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="454169">The Kerberos server is the machine where the user IDs for authentication are administered. </a>The Kerberos server is also the location of the Kerberos KDC. </div> <div class="table_text"><a name="454170">Network authentication must be provided by one of the following methods:</a></div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="454171">Windows Active Directory on one of the following operating systems: Windows Server </a>2003 or Windows 2000 Server Service Pack 3 or higher</div> </td> </tr> </table> </div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="454172">MIT Kerberos 1.4.2 or higher</a></div> </td> </tr> </table> </div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="454174">Client</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="454176">The client must be administered by the same domain controller that administers the data</a>base server.</div> </td> </tr> </table> <div class="head_3"><a name="486655">Encryption</a></div> <div class="Body"><a name="454798">To enable support for SSL connections to Oracle, the Oracle database must be configured </a>with the Oracle Advanced Security bundle. This is an option available from Oracle as an add-on to Oracle Enterprise Edition Servers. </div> <div class="Body"><a name="454736">The following link explains the supported configurations and how to configure Oracle </a>Enterprise servers for SSL:</div> <div class="Body" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="http://download.oracle.com/docs/cd/B28359_01/network.111/b28530/asossl.htm#i1013323" target="external_window" name="454738">http://download.oracle.com/docs/cd/B28359_01/network.111/b28530/asossl.htm#i1013323</a></span></div> <div class="head_2"><a name="462754">Connection Pooling</a></div> <div class="Body"><a name="462755">The driver supports connection pooling and its related connection options. Connection </a>pooling connection options are located on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109100', '');">Pooling tab</a></span> of the driver Setup dialog box. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.5.html#113515', '');">â??Using DataDirect Connection Poolingâ??</a></span> for a general description of connection pooling and its implementation.</div> <div class="head_2"><a name="454371">DataDirect Bulk Load</a></div> <div class="Body"><a name="462796">The driver supports DataDirect bulk load and its related connection options. Bulk load </a>connection options are located on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109110', '');">Bulk tab</a></span> of the driver Setup dialog box. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.6.html#109749', '');">â??Using DataDirect Bulk Loadâ??</a></span> for a general description of DataDirect bulk load and its implementation.</div> <div class="Body"><a name="454383">The Oracle Wire Protocol driver uses array binding instead of DataDirect Bulk Load when </a>the Oracle server version is older than Oracle 9<span class="Emphasis">i</span> R1 (9.0.1)</div> <div class="head_3"><a name="472571">Limitations</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="454385">A bulk operation is not allowed in a manual transaction if it is not the first event.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="472567">Once a bulk operation is started, any non-bulk operation is disallowed until the </a>transaction is committed.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="454386">The Oracle Wire Protocol driver currently does not support the use of LONG and LONG </a>RAW data types with array binding.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="454387">Because of Oracle limitations, issuing a SELECT statement to determine a row count </a>may return different results before and after a bulk load operation.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="458622">Oracle does not support literal values in a bulk load operation. You must use parameter </a>markers for all columns being loaded.</div> </td> </tr> </table> </div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de