readme_sqlplus.htm

来自「Debian中文参考手册,系统介绍了Debian系统」· HTM 代码 · 共 1,507 行 · 第 1/4 页

<A NAME="1011389"></A>
<P CLASS="BP1">
You can edit the <EM CLASS="Italic">i</EM>SQL*Plus configuration file, <EM CLASS="Italic">isqlplus.conf</EM>, to change the hash table size. The syntax of the line to change in the configuration file is: 
</P>
   
<PRE CLASS="CE1">
<A NAME="1011391"></A>FastCgiServer ... -initial-env iSQLPlusHashTableSize=<EM CLASS="Italic">n
</EM></PRE>
   
<A NAME="1011882"></A>
<P CLASS="BP1">
Where <EM CLASS="Italic">n</EM> is the number of entries in the hash table. 
</P>

<A NAME="1011898"></A>
<P CLASS="BP1">

</P>

<A NAME="1011395"></A>
<P CLASS="BP1">
<STRONG CLASS="Bold">Enabling or Disabling Restricted Database Access</STRONG>
</P>

<A NAME="1011396"></A>
<P CLASS="BP1">
The restricted database parameter limits the databases that users can access in <EM CLASS="Italic">i</EM>SQL*Plus. When enabled, a dropdown list of available databases is displayed in place of the Connection Identifier text field on the Login screen. This allows greater security for <EM CLASS="Italic">i</EM>SQL*Plus Servers in hosted environments. Connection identifiers are listed in the order defined in <CODE>iSQLPlusConnectIdList</CODE>. 
</P>

<A NAME="1011398"></A>
<P CLASS="BP1">
You can edit the <EM CLASS="Italic">i</EM>SQL*Plus configuration file, <EM CLASS="Italic">isqlplus.conf</EM>, to restrict database access. The syntax of the line to change in the configuration file is: 
</P>
   
<PRE CLASS="CE1">
<A NAME="1011400"></A>FastCgiServer ... -initial-env "iSQLPlusConnectIdList=SID1, SID2,..."
</PRE>
   
<A NAME="1011402"></A>
<P CLASS="BP1">
where SID1, SID2, ... is a comma separated list of Oracle Net connection identifiers specifying permitted databases. For example: 
</P>
   
<PRE CLASS="CE1">
<A NAME="1011404"></A>FastCgiServer ... -initial-env "iSQLPlusConnectIdList=ABC1, PROD2, DEV3"
</PRE>
   
<A NAME="1011406"></A>
<P CLASS="BP1">
Note the use of quotes in the example. The opening quote must occur before the <CODE>iSQLPlusConnectIdList</CODE> parameter name, the closing quote at the end of the list of SIDs. 
</P>

<A NAME="1011408"></A>
<P CLASS="BP1">
For more information about restricted database access, see "Enabling or Disabling Restricted Database Access". 
</P>

<A NAME="1011410"></A>
<P CLASS="BP1">

</P>

<A NAME="1012036"></A>
<P CLASS="BP1">
<STRONG CLASS="Bold">Setting the <EM CLASS="Italic">i</EM>SQL*Plus Idle Timeout</STRONG>
</P>

<A NAME="1012041"></A>
<P CLASS="BP1">
The FastCGI timeout parameter or idle timeout is the time the Oracle HTTP Server waits for results from <EM CLASS="Italic">i</EM>SQL*Plus. It is set to a value likely to prevent <EM CLASS="Italic">i</EM>SQL*Plus timing out before the web browser. It is sufficient for many long queries to return results before <EM CLASS="Italic">i</EM>SQL*Plus times out. 
</P>

<A NAME="1011413"></A>
<P CLASS="BP1">
The idle timeout should not be confused with the <CODE>iSQLPlusTimeOutInterval</CODE> which manages the lifetime of a user's session. 
</P>

<A NAME="1011415"></A>
<P CLASS="BP1">
You can edit the <EM CLASS="Italic">i</EM>SQL*Plus configuration file, <EM CLASS="Italic">isqlplus.conf</EM>, to change the idle timeout value. The syntax of the line to change in the configuration file is: 
</P>
   
<PRE CLASS="CE1">
<A NAME="1011417"></A>FastCgiServer ... -initial-env -idle-timeout=<EM CLASS="Italic">n
</EM></PRE>
   
<A NAME="1011419"></A>
<P CLASS="BP1">
Where <EM CLASS="Italic">n</EM> is the number of seconds of the Oracle HTTP Server waits for results from <EM CLASS="Italic">i</EM>SQL*Plus. The default value is 3600 seconds. 
</P>

<A NAME="1011528"></A>
<P CLASS="BP1">

</P>

<A NAME="1012080"></A>
<P CLASS="BP1">
<STRONG CLASS="Bold">Controlling User Entity Mapping</STRONG>
</P>

<A NAME="1011529"></A>
<P CLASS="BP1">
In HTML, entity mapping replaces characters of special significance with printable representations of those characters. Entity mapping is enabled by default, preventing the use of user defined HTML in <EM CLASS="Italic">i</EM>SQL*Plus output. The entity mapping parameter controls whether an <EM CLASS="Italic">i</EM>SQL*Plus Server permits users to change the entity mapping setting. 
</P>

<A NAME="1011557"></A>
<P CLASS="BP1">
You can edit the <EM CLASS="Italic">i</EM>SQL*Plus configuration file, <EM CLASS="Italic">isqlplus.conf</EM>, to change the <CODE>iSQLPlusAllowUserEntMap</CODE> value. The syntax of the line to change in the configuration file is: 
</P>
   
<PRE CLASS="CE1">
<A NAME="1011558"></A>FastCgiServer ... -initial-env iSQLPlusAllowUserEntMap=all|none
</PRE>
   
<A NAME="1011559"></A>
<P CLASS="BP1">
Where the parameter is set to <CODE>none</CODE>, or if it does not exist or has an invalid value, the use of <CODE>SET MARKUP HTML ENTMAP</CODE> and <CODE>COLUMN ENTMAP</CODE> will generate an error. If the <CODE>MARKUP ENTMAP</CODE> radio button on the System Variables screen is changed to <CODE>Off</CODE>, the value is ignored and reverts to <CODE>On</CODE>. The default value for <CODE>iSQLPlusAllowUserEntMap</CODE> is <CODE>none</CODE>.
</P>

<A NAME="1011827"></A>
<P CLASS="BP1">
Where the parameter is set to <CODE>all</CODE>, users can execute <CODE>SET MARKUP HTML ENTMAP</CODE> and <CODE>COLUMN ENTMAP</CODE> commands to change the status of entity mapping for the <EM CLASS="Italic">i</EM>SQL*Plus session or report column. This enables custom HTML to be included in <EM CLASS="Italic">i</EM>SQL*Plus report output.
</P>
</UL>

<A NAME="1011837"></A>
<!--TOC=h3-"1011837"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">8.1.3&#32; Using <EM CLASS="Italic">i</EM>SQL*Plus</FONT></H4>
<!--/TOC=h3-->
<A NAME="1011716"></A>
<P CLASS="BP">
In <STRONG CLASS="Bold">Username and Password</STRONG>, the following text is incorrect: 
</P>

<UL>

<A NAME="1011095"></A>
<P CLASS="BP1">
Default logins are created and displayed in messages during Oracle9<EM CLASS="Italic">i</EM> installation. The default login username/password combinations created are: 
</P>

<UL CLASS="LB2">

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011086"></A>SYS/CHANGE_ON_INSTALL 
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011154"></A>SYSTEM/MANAGER 
<P>
</UL>

<A NAME="1011164"></A>
<P CLASS="BP1">
Default passwords and your database account password should be changed as soon as possible. You can change your password in the Change Password screen which is accessed from the Preferences screen. See Changing Your Password. 
</P>
</UL>
<A NAME="1011156"></A>
<P CLASS="BP">
It should read:
</P>

<UL>

<A NAME="1011117"></A>
<P CLASS="BP1">
Default logins are created and you are prompted for associated passwords during Oracle9<EM CLASS="Italic">i</EM> installation. The default login usernames created are: 
</P>

<UL CLASS="LB2">

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011118"></A>SYS 
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011119"></A>SYSTEM
<P>
</UL>

<A NAME="1011176"></A>
<P CLASS="BP1">
You can change your password in the Change Password screen which is accessed from the Preferences screen. See Changing Your Password. 
</P>
</UL>

<A NAME="1012101"></A>
<!--TOC=h2-"1012101"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">8.2&#32; SQL*Plus User's Guide and Reference</FONT></H3>
<!--/TOC=h2-->
<A NAME="1012105"></A>
<P CLASS="BP">
The following are known changes to the <EM CLASS="Italic">SQL*Plus User's Guide and Reference</EM> by chapter.
</P>

<A NAME="1012102"></A>
<!--TOC=h3-"1012102"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">8.2.1&#32; Chapter 3, Configuring SQL*Plus</FONT></H4>
<!--/TOC=h3-->
<A NAME="1011263"></A>
<P CLASS="BP">
In <STRONG CLASS="Bold"><EM CLASS="Italic">i</EM>SQL*Plus Configuration</STRONG> &gt; <STRONG CLASS="Bold">Configuring the Middle Tier: <EM CLASS="Italic">i</EM>SQL*Plus Server</STRONG> &gt; <STRONG CLASS="Bold">Editing the <EM CLASS="Italic">i</EM>SQL*Plus Configuration File</STRONG>, the following bullet point should be added:
</P>
<UL>

<UL CLASS="LB2">

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011281"></A><CODE>iSQLPlusAllowUserEntMap</CODE>
<P>
</UL>
</UL>
<A NAME="1011801"></A>
<P CLASS="BP">
The following subsection associated with the bullet point should also be added: 
</P>

<UL>

<A NAME="1011774"></A>
<P CLASS="BP1">
<STRONG CLASS="Bold">Enabling User Entity Mapping</STRONG>
</P>

<A NAME="1012861"></A>
<P CLASS="BP1">
In HTML, entity mapping replaces characters of special significance with printable representations of those characters. Entity mapping is enabled by default, preventing the use of user defined HTML in <EM CLASS="Italic">i</EM>SQL*Plus output. The entity mapping parameter controls whether an <EM CLASS="Italic">i</EM>SQL*Plus Server permits users to change the entity mapping setting. 
</P>

<A NAME="1012871"></A>
<P CLASS="BP1">
You can edit the <EM CLASS="Italic">i</EM>SQL*Plus configuration file, <EM CLASS="Italic">isqlplus.conf</EM>, to change the <CODE>iSQLPlusAllowUserEntMap</CODE> value. The syntax of the line to change in the configuration file is: 
</P>
   
<PRE CLASS="CE1">
<A NAME="1011786"></A>FastCgiServer ... -initial-env iSQLPlusAllowUserEntMap=all|none
</PRE>
   
<A NAME="1012304"></A>
<P CLASS="BP1">
Where the parameter is set to <CODE>none</CODE>, or if it does not exist or has an invalid value, the use of <CODE>SET MARKUP HTML ENTMAP</CODE> and <CODE>COLUMN ENTMAP</CODE> will generate an error. If the <CODE>MARKUP ENTMAP</CODE> radio button on the System Variables screen is changed to <CODE>Off</CODE>, the value is ignored and reverts to <CODE>On</CODE>. The default value for <CODE>iSQLPlusAllowUserEntMap</CODE> is <CODE>none</CODE>.
</P>

<A NAME="1011789"></A>
<P CLASS="BP1">
Where the parameter is set to <CODE>all</CODE>, users can execute <CODE>SET MARKUP HTML ENTMAP</CODE> and <CODE>COLUMN ENTMAP</CODE> commands to change the status of entity mapping for the <EM CLASS="Italic">i</EM>SQL*Plus session or report column. This enables custom HTML to be included in <EM CLASS="Italic">i</EM>SQL*Plus report output.
</P>
</UL>

<A NAME="1011772"></A>
<!--TOC=h3-"1011772"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">8.2.2&#32; Chapter 4, Starting SQL*Plus</FONT></H4>
<!--/TOC=h3-->
<A NAME="1011195"></A>
<P CLASS="BP">
In <STRONG CLASS="Bold">Login Username and Password</STRONG>, the following text is incorrect: 
</P>

<UL>

<A NAME="1011216"></A>
<P CLASS="BP1">
Default logins are created and displayed in messages during Oracle9<EM CLASS="Italic">i</EM> installation. The default login username/password combinations created are: 
</P>

<UL CLASS="LB2">

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011197"></A>SYS/CHANGE_ON_INSTALL 
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011198"></A>SYSTEM/MANAGER 
<P>
</UL>

<A NAME="1011248"></A>
<P CLASS="BP1">
Default passwords and your database account password should be changed as soon as possible. See "Changing your Password" following. For further information about the default logins, see the <EM CLASS="Italic">Oracle9i Database Administrator's Guide</EM>. 
</P>
</UL>
<A NAME="1011201"></A>
<P CLASS="BP">
It should read:
</P>

<UL>

<A NAME="1011202"></A>
<P CLASS="BP1">
Default logins are created and you are prompted for associated passwords during Oracle9<EM CLASS="Italic">i</EM> installation. The default login usernames created are: 
</P>

<UL CLASS="LB2">

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011203"></A>SYS 
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011204"></A>SYSTEM
<P>
</UL>

<A NAME="1011254"></A>
    <p CLASS="BP1"> See "Changing your Password" following. For further information 
      about the default logins, see the <EM CLASS="Italic">Oracle9i Database Administrator's 
      Guide</EM>. </p>
    <p CLASS="BP1">&nbsp;</p>
    <p CLASS="BP1">&nbsp; </p>
</UL>

<A NAME="762987"></A>
<P CLASS="CopyrightBody">
Oracle, Oracle9<EM CLASS="Italic">i</EM>, <EM CLASS="Italic">i</EM>SQL*Plus and SQL*Plus are trademarks or registered trademarks of Oracle Corporation. Other names may be trademarks of their respective owners.
</P>

<A NAME="756138"></A>
<P CLASS="CopyrightBody">
Copyright &#169; 1996, 2002 Oracle Corporation.
</P>

<A NAME="756053"></A>
<P CLASS="CopyrightBody">
All Rights Reserved.
</P>






<!-- Start Footer -->
</DIV>

<DIV CLASS="OUTD">
<HR>



<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD VALIGN="BOTTOM" WIDTH="33%">
<TABLE CELLSPACING="0" CELLPADDING="0">
<TR>



    
</TR>
</TABLE>
</TD>
      <TD ALIGN="CENTER" WIDTH="34%"> 
        <p><A HREF="../dcommon/html/cpyr.htm"><IMG SRC="../dcommon/gifs/oracle.gif" ALT="Oracle" BORDER="0" width="144" height="18"><BR>
          <FONT SIZE="-2">Copyright &copy; 1996&#044; 2002 Oracle Corporation.</FONT></A> <BR>
          <FONT SIZE="-2">All Rights Reserved.</FONT> </p>
        </TD>
<TD VALIGN="BOTTOM" ALIGN="RIGHT" WIDTH="33%"> 
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="144">
<TR>



<TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD>
<TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD>
<TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD>
<TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD>





</TR>
</TABLE>
</TD>
</TR>
</TABLE>
  
</DIV>

</BODY>
</HTML>