📄 append_b.htm
字号:
<!DOCTYPE html public "-//w3c//dtd html 3.2 transitional//en.us"><HTML lang="en.us"><HEAD><META NAME="Generator" CONTENT="Quadralay WebWorks Publisher 5.0.4"><META NAME="Page" CONTENT="DefaultSingle"><META NAME="Title" CONTENT=" Configuration Files "><TITLE> Configuration Files </TITLE> <LINK REL="toc" HREF="toc.htm" TITLE="Contents"><LINK REL="index" HREF="index.htm" TITLE="Index"><LINK REL="copyright" HREF="../Support/html/cpyr.htm" TITLE="Copyright"><LINK REL="up" HREF="toc.htm" TITLE="Up"><LINK REL="next" HREF="index.htm" TITLE="Next"><LINK REL="previous" HREF="append_a.htm" TITLE="Previous"></HEAD> <BODY BGCOLOR="#ffffff"><A NAME="top"></A><A HREF="#BEGIN">Skip Headers</A><BR><BR><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR> <TD ALIGN="LEFT" VALIGN="TOP"><FONT COLOR="#330099" FACE="Helvetica, Arial, sans-serif"><STRONG>Oracle9<i>i</i> Real Application Clusters Real Applications Clusters Guard I Configuration Guide<BR>Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, and Sun Solaris</STRONG><BR>Part Number A95979-02</FONT></TD><TD VALIGN="BOTTOM" ALIGN="RIGHT" WIDTH="144"><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="../index.htm"><IMG SRC="../Support/gifs/bookicon.gif" ALT="Go To Product List" BORDER="0" HEIGHT="30" WIDTH="30"><BR><FONT SIZE="-2">Product</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="../Support/gifs/conticon.gif" ALT="Go To Table Of Contents" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Contents</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="index.htm"><IMG SRC="../Support/gifs/indxicon.gif" ALT="Go To Index" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Index</FONT></A></TD></TR></TABLE></TD></TR></TABLE><HR><P><A HREF="append_a.htm"><IMG SRC="../Support/gifs/larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="30"></A><A HREF="index.htm"><IMG SRC="../Support/gifs/rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="30"></A> <A NAME="BEGIN"></A><DIV CLASS="IND"><!-- End Header --><A NAME="943366"></A><!--TOC=Title-"943366"--><H1 CLASS="Title"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">B<BR> Configuration Files </FONT></H1><!--/TOC=Title--><A NAME="945826"></A><P CLASS="BP">This appendix contains information on the following configuration files:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="945834"></A><A HREF="append_b.htm#946409">init_ORACLE_SERVICE_HOSTNAME[A|B].ora</a><P><LI CLASS="LB1" TYPE="DISC"><A NAME="945838"></A><A HREF="append_b.htm#946448">ORACLE_SERVICE_config.pfs</a><P><LI CLASS="LB1" TYPE="DISC"><A NAME="945842"></A><A HREF="append_b.htm#946833">ORACLE_SERVICE_config_HOSTNAME[A|B].ded.pfs</a><P><LI CLASS="LB1" TYPE="DISC"><A NAME="945846"></A><A HREF="append_b.htm#947416">ORACLE_SERVICE_config_HOSTNAME[A|B].mts.pfs</a><P></UL><A NAME="946409"></A><!--TOC=h1-"946409"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> init_<EM CLASS="Italic">ORACLE_SERVICE_HOSTNAME[A|B].</EM>ora</FONT></H2><!--/TOC=h1--><A NAME="946410"></A><P CLASS="BP">The <CODE>init_ORACLE_SERVICE_PFS_HOST[</CODE><EM><CODE>A</CODE></EM>|<EM><CODE>B</CODE></EM><CODE>].ora</CODE> file defines the following parameters for each instance:</P> <A NAME="946428"><P><TABLE CLASS="Informal" BORDER="1" FRAME="HSIDES" RULES="GROUPS" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" dir="ltr" title=""><THEAD><TR CLASS="Informal"><TH CLASS="Informal" align="left" valign="bottom" scope="col"><A NAME="946413"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG><STRONG CLASS="Bold">Parameter</STRONG></STRONG></FONT></TH><TH CLASS="Informal" align="left" valign="bottom" scope="col"><A NAME="946415"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG>Definition</STRONG></FONT></TH></TR><TBODY><TR CLASS="Informal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Informal"><A NAME="946417"></A><P CLASS="TB">INSTANCE_NUMBER</TD><TD CLASS="Informal"><A NAME="946419"></A><P CLASS="TB">Unique instance number. Maps the instance to one free list group for each database object created with the storage parameter FREELIST GROUPS. Oracle Corporation recommends setting the INSTANCE_NUMBER to the same value as the THREAD parameter.</TD></TR><TR CLASS="Informal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Informal"><A NAME="946421"></A><P CLASS="TB">THREAD</TD><TD CLASS="Informal"><A NAME="946423"></A><P CLASS="TB">Unique thread number. Specifies the number of the redo thread used by the instance. You can specify any available redo thread number, but an instance cannot use the same thread number as another instance. Also, an instance cannot start when its redo thread is disabled. A value of zero causes an available, enabled public thread to be chosen. An instance cannot mount a database if the thread is used by another instance or if the thread is disabled.</TD></TR><TR CLASS="Informal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Informal"><A NAME="946425"></A><P CLASS="TB">INSTANCE_NAME</TD><TD CLASS="Informal"><A NAME="946427"></A><P CLASS="TB">Unique instance name. Identifies the name of the instance and is used to uniquely identify a specific instance when multiple instances share common service names.</TD></TR></TABLE></A> <A NAME="946435"></A><P CLASS="BP"><A HREF="append_b.htm#946437">Example B-1</a> and <A HREF="append_b.htm#946443">Example B-2</a> show samples of the <CODE>init_</CODE><EM><CODE>ORACLE_SERVICE_HOSTNAME[A|B]</CODE></EM><CODE>.ora</CODE> file that the PFSSETUP utility creates.</P><A NAME="946437"></A><H4 CLASS="ET"><FONT FACE="Arial, Helvetica, sans-serif"><EM>Example B-1  <STRONG CLASS="Bold"><EM CLASS="Italic">init_SALES_nodeA.ora</EM></STRONG></EM></FONT></H4> <PRE CLASS="CE"><A NAME="946438"></A>instance_number=1<A NAME="946439"></A>thread=1<A NAME="946440"></A>instance_name=SALES1<A NAME="946441"></A></PRE> <A NAME="946443"></A><H4 CLASS="ET"><FONT FACE="Arial, Helvetica, sans-serif"><EM>Example B-2  <STRONG CLASS="Bold"><EM CLASS="Italic">init_SALES_nodeB.ora</EM></STRONG></EM></FONT></H4> <PRE CLASS="CE"><A NAME="946444"></A>instance_number=2<A NAME="946445"></A>thread=2<A NAME="946446"></A>instance_name=SALES2</PRE> <A NAME="946448"></A><!--TOC=h1-"946448"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> <EM CLASS="Italic">ORACLE_SERVICE</EM>_config.pfs</FONT></H2><!--/TOC=h1--><A NAME="946449"></A><P CLASS="BP">The <EM><CODE>ORACLE_SERVICE</CODE></EM><CODE>_config.pfs</CODE> file contains the mandatory and recommended settings for selected initialization parameters for Oracle9<EM CLASS="Italic">i</EM> Real Application Clusters Guard. All instances must use the same <EM><CODE>ORACLE_SERVICE</CODE></EM><CODE>_config.pfs</CODE> file.</P><A NAME="946453"></A><P CLASS="BP"><A HREF="append_b.htm#946455">Example B-3</a> shows a sample <EM><CODE>ORACLE_SERVICE</CODE></EM><CODE>_config.pfs</CODE> file created by the PFSSETUP utility:</P> <A NAME="948156"><DIV ALIGN="CENTER"><P><TABLE CLASS="Note" BORDER="0" WIDTH="80%" CELLPADDING="0" CELLSPACING="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"><TR CLASS="Note"><TD CLASS="Note"><HR><A NAME="948159"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG CLASS="NH">Note:</STRONG></FONT><A NAME="948160"></A><P CLASS="NB">In the following example, the settings for the <CODE>db_name</CODE>, <CODE>db_domain</CODE>, and <CODE>service_names</CODE> parameters, are sample values and can vary, depending on your system and requirements.<HR></TD></TR></TABLE></DIV></A> <A NAME="946455"></A><H4 CLASS="ET"><FONT FACE="Arial, Helvetica, sans-serif"><EM>Example B-3  <STRONG CLASS="Bold"><EM CLASS="Italic">SALES_config.pfs</EM></STRONG></EM></FONT></H4> <PRE CLASS="CE"><A NAME="946456"></A>active_instance_count=1<A NAME="946457"></A>compatible=9.0.0<A NAME="946458"></A>db_block_checking=true<A NAME="946459"></A>db_block_checksum=true<A NAME="946460"></A>db_name=SALES<A NAME="946461"></A>db_domain=WORLD<A NAME="946462"></A>service_names=SALES.WORLD<A NAME="946463"></A>max_dump_file_size=unlimited<A NAME="946464"></A>os_authent_prefix=OPS$<A NAME="946465"></A>cluster_database=true<A NAME="946466"></A>remote_os_authent=true<A NAME="946467"></A>timed_statistics=true<A NAME="946881"></A></PRE> <A NAME="947345"></A><P CLASS="BP">The following table describes the parameters in the preceeding example:</P> <A NAME="946882"><P><TABLE CLASS="InformalWide" BORDER="1" FRAME="HSIDES" RULES="GROUPS" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" dir="ltr" title=""><THEAD><TR CLASS="Informal"><TH CLASS="Informal" align="left" valign="bottom" scope="col"><A NAME="946885"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG><STRONG CLASS="Bold">Parameter</STRONG></STRONG></FONT></TH><TH CLASS="Informal" align="left" valign="bottom" scope="col"><A NAME="946887"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG>Requirement</STRONG></FONT></TH><TH CLASS="Informal" align="left" valign="bottom" scope="col"><A NAME="946889"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG><STRONG CLASS="Bold">Value</STRONG></STRONG></FONT></TH><TH CLASS="Informal" align="left" valign="bottom" scope="col"><A NAME="946891"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG><STRONG CLASS="Bold">Description</STRONG></STRONG></FONT></TH></TR><TBODY><TR CLASS="Informal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Informal"><A NAME="946893"></A><P CLASS="TB">ACTIVE_INSTANCE_COUNT</TD><TD CLASS="Informal"><A NAME="946895"></A><P CLASS="TB">Required</TD><TD CLASS="Informal"><A NAME="946897"></A><P CLASS="TB">1</TD><TD CLASS="Informal"><A NAME="946899"></A><P CLASS="TB">A value of 1 designates one instance in a two-instance cluster as the primary instance and the other instance as the secondary instance.</TD></TR><TR CLASS="Informal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Informal"><A NAME="946901"></A><P CLASS="TB">COMPATIBLE</TD><TD CLASS="Informal"><A NAME="946903"></A><P CLASS="TB">Required</TD><TD CLASS="Informal"><A NAME="946905"></A><P CLASS="TB">9.0.0</TD><TD CLASS="Informal"><A NAME="946907"></A><P CLASS="TB">The Oracle server must maintain compatibility with Oracle server Release 2 (9.2.0.1.0).</TD></TR><TR CLASS="Informal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Informal"><A NAME="946909"></A><P CLASS="TB">DB_NAME</TD><TD CLASS="Informal"><A NAME="946911"></A><P CLASS="TB">Required</TD><TD CLASS="Informal"><A NAME="946913"></A><P CLASS="TB">SALES, for example</TD><TD CLASS="Informal"><A NAME="946915"></A>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -