Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: urgent help needed

RE: urgent help needed

From: GP2Z/INF/RAHAL <hrahale_at_lth.sonatrach.dz>
Date: Wed, 8 Nov 2000 14:48:07 -0000
Message-Id: <10674.121417@fatcity.com> 





This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.



------_=_NextPart_000_01C04992.7EEEB580


Content-Type: text/plain;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



hello,


please find joined here a document ABOUT "ADMINISTERING A DATABASE", I =
hope


that to be going to find you an interest,   =20
 <<ch6.htm>>=20


good courage?



> -----Message d'origine-----

> De:	Allan Nelson [SMTP:anelson_at_houston.rr.com]

> Date:	mercredi 8 novembre 2000 03:20

> =C0:	Multiple recipients of list ORACLE-L

> Objet:	Re: urgent help needed



>=20


> Try the O'Reilly book Oracle Database Administration Essentials or =

some


> thing like that.

> Allan

> ----- Original Message -----

> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>

> Sent: Tuesday, November 07, 2000 8:35 AM


>=20
>=20


> > hi

> >

> > could anyone help me on where to start for oracle dba,

> > where can i find a checklist to see the items i should

> > follow starting from installing oracle to configuring,

> > fine tuning the database.

> >

> > appreciate ur help

> >

> > dave

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Thousands of Stores.  Millions of Products.  All in one Place.

> > http://shopping.yahoo.com/

> > --

> > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > --

> > Author: david mccoll

> >   INET: david123_1111_at_yahoo.com

> >

> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > San Diego, California        -- Public Internet access / Mailing =

Lists




> > =





> > To REMOVE yourself from this mailing list, send an E-Mail message

> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > the message BODY, include a line containing: UNSUB ORACLE-L

> > (or the name of mailing list you want to be removed from).  You may

> > also send the HELP command for other information (like =

subscribing).

>=20




> --=20

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> --=20

> Author: Allan Nelson

>   INET: anelson_at_houston.rr.com


>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------



> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).




------_=_NextPart_000_01C04992.7EEEB580


Content-Type: application/octet-stream;


        name="ch6.htm"


Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;


        filename="ch6.htm"



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from =


url=3D(0067)http://technet.oracle.com/doc/netware/netware.803/a56083_01/=
ch6.htm -->


<HTML><HEAD><TITLE>Administering a Database</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<META content=3DDefaultSingle name=3DNewFiles>
<META content=3D"                  Administering a Database" =
name=3DTitle><LINK=20




href=3D"../../../products.htm" rel=3Dhome title=3DLibrary <LINK><LINK =
href=3D"index.htm"=20


rel=3Dindex title=3DIndex><LINK href=3D"../../../dcommon/html/cpyr.htm" =
rel=3Dcopyright=20


title=3DCopyright><LINK href=3D"ch6.htm" rel=3Dup title=3DUp><LINK =
href=3D"ch7.htm"=20

rel=3Dnext title=3DNext><LINK href=3D"ch5.htm" rel=3Dprevious =
title=3DPrevious></HEAD>
<BODY bgColor=3D#ffffff><A name=3Dtop></A>


<TABLE cellPadding=3D0 cellSpacing=3D0 width=3D"100%">
  <TBODY>


  <TR>


    <TD align=3Dleft vAlign=3Dtop><FONT color=3D#330099=20
      face=3D"Helvetica, Arial"><B>Oracle8 User's Guide for =
NetWare<BR>Release=20


      8.0.3 for NetWare</B><BR>A56083_01</FONT></B></TD>
    <TD align=3Dright vAlign=3Dbottom>

      <TABLE cellPadding=3D0 cellSpacing=3D0>
        <TBODY>
        <TR>
          <TD align=3Dmiddle vAlign=3Dtop width=3D"25%"><A=20
            href=3D"http://technet.oracle.com/doc/products.htm"><IMG =
alt=3D""=20
            border=3D0 height=3D30 src=3D"ch6_fichiers/prodicon.gif"=20
            width=3D30><BR><FONT size=3D-2>Library</FONT></A></TD>
          <TD align=3Dmiddle vAlign=3Dtop width=3D"25%"><A=20
            href=3D"http://technet.oracle.com/doc/netware.htm"><IMG =
alt=3D""=20
            border=3D0 height=3D30 src=3D"ch6_fichiers/bookicon.gif"=20
            width=3D30><BR><FONT size=3D-2>Product</FONT></A></TD>
          <TD align=3Dmiddle vAlign=3Dtop width=3D"25%"><A=20
            =




href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/toc.=
htm"><IMG=20


            alt=3D"" border=3D0 height=3D30 =
src=3D"ch6_fichiers/conticon.gif"=20

            width=3D30><BR><FONT size=3D-2>Contents</FONT></A></TD>
          <TD align=3Dmiddle vAlign=3Dtop width=3D"25%"><A=20
            =




href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/inde=
x.htm"><IMG=20


            alt=3D"" border=3D0 height=3D30 =
src=3D"ch6_fichiers/indxicon.gif"=20


            width=3D30><BR><FONT=20


  =


size=3D-2>Index</FONT></A></TD></TR></TBODY></TABLE></TD></TR></TBODY></=
TABLE>



<HR>



<P><A=20


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch5.=
htm"><IMG=20


alt=3DPrev border=3D0 height=3D30 src=3D"ch6_fichiers/larrow.gif" =
width=3D30></A> <A=20


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch7.=
htm"><IMG=20


alt=3DNext border=3D0 height=3D30 src=3D"ch6_fichiers/rarrow.gif" =
width=3D30></A>=20


<DIV><!-- End Header --><A =


name=3D1034342></A><!--TOC=3DTitle-"1034342"-->
<H1><FONT color=3D#330099 face=3D"Helvetica, Arial">6<BR>Administering =
a=20


Database</FONT></H1><!--/TOC=3DTitle--><A name=3D1027353></A>
<P>This chapter describes how to administer Oracle8. </P><A =
name=3D1034271></A>


<P>Specific topics discussed are: </P>


<UL>


  <P>


  <LI><A name=3D1034272></A>Starting and Shutting Down a Database with =
Server=20


  Manager=20

  <P>
  <P></P>
  <LI><A name=3D1034276></A><A=20




  =


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1031186">Starting=20


  and Shutting Down a Database with Oracle Enterprise Manager</A>=20

  <P>
  <P></P>
  <LI><A name=3D1031052></A><A=20




  =


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1029098">Running=20


  Multiple Instances</A>=20

  <P>
  <P></P>
  <LI><A name=3D1031056></A>Using Novell Directory Services (NDS)=20
  <P>
  <P></P>
  <LI><A name=3D1035088></A><A=20




  =


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1024781">Authenticating=20


  Database Administrators</A>=20

  <P>
  <P></P>
  <LI><A name=3D1035096></A><A=20




  =


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1024884">Encrypting=20


  Database Passwords</A>=20

  <P>
  <P></P>
  <LI><A name=3D1031072></A><A=20




  =


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1031566">Using=20


  the Oracle Enterprise Manager Console</A>=20
  <P></P></LI></UL><A name=3D1031149></A><!--TOC=3Dh1-"1031149"-->
<H2><FONT color=3D#330099 face=3D"Helvetica, Arial">Starting and =
Shutting Down a=20


Database with Server Manager</FONT></H2><!--/TOC=3Dh1--><A =
name=3D1033172></A><!--TOC=3Dh2-"1033172"-->
<H3><FONT color=3D#330099 face=3D"Helvetica, Arial">Starting Server=20
Manager</FONT></H3><!--/TOC=3Dh2--><A name=3D1032172></A>
<P>To start or shut down an Oracle8 database with Server Manager: </P>
<OL>


  <LI value=3D1><A name=3D1031152></A>Start Server Manager at the =
MS-DOS command=20


  prompt:=20


  <P><PRE><A name=3D1031153></A>C:\&gt;SVRMGR
</PRE><A name=3D1034281></A>


  <P>or from the NetWare Console prompt: </P><PRE><A =
name=3D1034284></A>:LOAD SVRMGR


</PRE></LI></OL>


<OL>


  <LI value=3D2><A name=3D1034362></A>Connect to the Oracle8 database =
using your=20


  user name:=20


  <P><PRE><A name=3D1034366></A>SVRMGR&gt; CONNECT =
INTERNAL/<EM>PASSWORD</EM>


</PRE>

  <LI value=3D3><A name=3D1034386></A>Follow the instructions below:=20
  <H5><FONT face=3DHelvetica,Arial,sans-serif><EM></EM></FONT></H5>
  <TABLE border=3D1 cellPadding=3D3 cellSpacing=3D0 width=3D"100%">


    <TBODY>


    <TR>

      <TH align=3Dleft vAlign=3Dbottom><A name=3D1034369></A><FONT=20
        face=3D"Helvetica, Arial">To...</FONT> &nbsp;</TH>
      <TH align=3Dleft vAlign=3Dbottom><A name=3D1034371></A><FONT=20
        face=3D"Helvetica, Arial">Go to Section...</FONT> =


&nbsp;</TH></TR>


    <TR align=3Dleft vAlign=3Dtop>

      <TD><A name=3D1034373></A>
        <P>Start a database &nbsp;</P></TD>
      <TD><A name=3D1034378></A>
        <P><A=20
        =




href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1033070">Starting=20


        a Database with Server Manager</A> &nbsp;</P></TD></TR>
    <TR align=3Dleft vAlign=3Dtop>

      <TD><A name=3D1034380></A>
        <P>Shut down a database &nbsp;</P></TD>
      <TD><A name=3D1034385></A>
        <P><A=20
        =




href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1033071">Shutting=20


        Down a Database with Server Manager</A> =
&nbsp;</P></TD></TR></TBODY></TABLE>


  <TABLE cellPadding=3D3 cellSpacing=3D0 width=3D"100%">
    <TBODY>


    <TR align=3Dleft vAlign=3Dtop>


      <TD></TD></TR></TBODY></TABLE>


  <P></P></LI></OL><A name=3D1033070></A><!--TOC=3Dh2-"1033070"-->
<H3><FONT color=3D#330099 face=3D"Helvetica, Arial">Starting a Database =
with Server=20


Manager</FONT></H3><!--/TOC=3Dh2--><A name=3D1033177></A>
<P>Before starting the database, ensure that a database instance has =
been=20


created. </P>


<OL>


  <LI value=3D1><A name=3D1032712></A>Start up the database by entering =
one of the=20


  following commands:=20


  <H5><FONT face=3DHelvetica,Arial,sans-serif><EM></EM></FONT></H5>
  <TABLE border=3D1 cellPadding=3D3 cellSpacing=3D0 width=3D"100%">
    <TBODY>


    <TR>

      <TH align=3Dleft vAlign=3Dbottom><A name=3D1032720></A><FONT=20
        face=3D"Helvetica, Arial">Command</FONT> &nbsp;</TH>
      <TH align=3Dleft vAlign=3Dbottom><A name=3D1032722></A><FONT=20
        face=3D"Helvetica, Arial">Description</FONT> &nbsp;</TH></TR>
    <TR align=3Dleft vAlign=3Dtop>
      <TD><A name=3D1032724></A>
        <P>SVRMGR&gt; STARTUP &nbsp;</P></TD>
      <TD><A name=3D1032726></A>
        <P>Uses the default INIT<EM>SID</EM>.ORA file located in your=20
        <EM>ORACLE_HOME</EM>\DATABASE directory to start the Oracle8 =
database.=20
        &nbsp;</P></TD></TR>
    <TR align=3Dleft vAlign=3Dtop>
      <TD><A name=3D1032728></A>
        <P>SVRMGR&gt; STARTUP PFILE=3D<EM>PATH\FILENAME</EM> =
&nbsp;</P></TD>
      <TD><A name=3D1032730></A>
        <P>Uses an initialization file other than the default to start =
your=20
        database. <EM>PATH</EM>\<EM>FILENAME</EM> specifies an =
initialization=20
        parameter file other than the default, INIT<EM>SID</EM>.ORA. =
The=20
        following example starts the database using a file named =
INIT2.ORA. <A=20
        name=3D1034247></A>
        <P>SVRMGR&gt; STARTUP PFILE=3D%ORACLE_HOME%\DATABASE\INIT2.ORA=20
      &nbsp;</P></TD></TR></TBODY></TABLE>


  <TABLE cellPadding=3D3 cellSpacing=3D0 width=3D"100%">
    <TBODY>


    <TR align=3Dleft vAlign=3Dtop>


      <TD></TD></TR></TBODY></TABLE>


  <P><A name=3D1031184></A>


  <P>After completing these steps, you can connect to the Oracle8 =
database.=20


  </P></LI></OL><A name=3D1033071></A><!--TOC=3Dh2-"1033071"-->
<H3><FONT color=3D#330099 face=3D"Helvetica, Arial">Shutting Down a =
Database with=20


Server Manager</FONT></H3><!--/TOC=3Dh2--><A name=3D1033076></A>
<P>To shut down a database using Server Manager: </P>
<OL>


  <LI value=3D1><A name=3D1033077></A>Connect to the Oracle8 database =
using your=20


  username:=20


  <P><PRE><A name=3D1034399></A>SVRMGR&gt; CONNECT =
INTERNAL/<EM>PASSWORD</EM>


</PRE></LI></OL>


<OL>


  <LI value=3D2><A name=3D1034395></A>Enter the following command:=20
  <P><PRE><A name=3D1033104></A>SVRMGR&gt; SHUTDOWN <EM>[MODE]</EM>
<P>


<TABLE border=3D1 cellPadding=3D3 cellSpacing=3D0 =

width=3D"100%"><TBODY><TR align=3Dleft vAlign=3Dtop><TD colSpan=3D2><A =
name=3D1033080></A><P>where <EM>MODE</EM> is one of the following: =
&nbsp;</P></TD></TR><TR align=3Dleft vAlign=3Dtop><TD><A =
name=3D1033084></A><P>Normal &nbsp;</P></TD><TD><A =
name=3D1033086></A><P>The database waits for all currently connected =


users to disconnect and disallows any new connections before shutting =
down. This is the <EM>default</EM> mode. &nbsp;</P></TD></TR><TR =
align=3Dleft vAlign=3Dtop><TD><A name=3D1033088></A><P>Immediate =
&nbsp;</P></TD><TD><A name=3D1033090></A><P>The database terminates and =
rolls back active transactions, disconnects clients, and shuts down. =

&nbsp;</P></TD></TR><TR align=3Dleft vAlign=3Dtop><TD><A =
name=3D1033092></A><P>Abort &nbsp;</P></TD><TD><A =
name=3D1033094></A><P>The database terminates active transactions and =


disconnects users; it does not roll back transactions. The database =
performs automatic recovery and rollback the next time it is started. =
Use this mode only in emergencies. &nbsp;</P></TD></TR><TR align=3Dleft =
vAlign=3Dtop><TD><A name=3D1034407></A><P>Transactional =
&nbsp;</P></TD><TD><A name=3D1034409></A><P>Prevents clients from =
losing work, and at the same time, does not require all users to log =
off. After submitting this statement, no client can start a new =
transaction on this particular instance. If a client attempts to start =
a new transaction, they are disconnected. After all transactions have =
either committed or aborted, any client still connected to the instance =
is disconnected. At this point, the instance shuts down just as it =
would when a SHUTDOWN IMMEDIATE statement is submitted. =
&nbsp;</P></TD></TR></TBODY></TABLE>



<TABLE cellPadding=3D3 cellSpacing=3D0 width=3D"100%"><TBODY><TR =
align=3Dleft vAlign=3Dtop><TD></TD></TR></TBODY></TABLE>



</P></PRE></LI></OL><A name=3D1031186></A><!--TOC=3Dh1-"1031186"-->
<H2><FONT color=3D#330099 face=3D"Helvetica, Arial">Starting and =
Shutting Down a=20


Database with Oracle Enterprise Manager</FONT></H2><!--/TOC=3Dh1--><A=20
name=3D1031317></A>


<P>Oracle Enterprise Manager enables you to start and shut down your =
Oracle8=20


database in several different ways. This section describes how to use =
the=20


Navigator. You can also use: </P>


<OL>


  <UL>


    <LI><A name=3D1031866></A>SQL Worksheet=20
    <LI><A name=3D1031867></A>Instance Manager </LI></UL></OL><A =
name=3D1033185></A>


<P>See the <EM><A=20


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/"></=
EM><EM>Oracle=20


Enterprise Manager Administrator's Guid</A>e</EM> for information on =
using these=20


tools to start your database.=20

<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>

      <HR>
      <A name=3D1033448></A><FONT=20
      face=3D"Helvetica, Arial"><STRONG>Note:</STRONG></FONT>=20
      <P><A name=3D1033452></A>
      <P>This section assumes you have configured Oracle Enterprise =
Manager. If=20
      you have not, see the section "<A=20
      =




href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#">Configuring=20


      Oracle Enterprise Manager</A>" in Chapter 3, "Configuration =
Tasks" for=20

      instructions. </P>&nbsp;=20
      <HR>




    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV>
<P></P>


<OL>


  <LI value=3D1><A name=3D1032974></A>Choose =
Start&gt;Programs&gt;Oracle Enterprise=20
  Manager&gt;Enterprise Manager.=20


  <P><A name=3D1033589></A>


  <P>The <EM>Repository Login Information</EM> dialog box appears.<IMG=20
  src=3D"ch6_fichiers/ch6a.gif"> </P></LI></OL>
<OL>


  <LI value=3D2><A name=3D1033590></A>Enter your repository user login =
information.=20

  <DIV align=3Dcenter>
  <P>
  <TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


    <TBODY>


    <TR>

      <TD>
        <HR>
        <A name=3D1033616></A><FONT=20
        face=3D"Helvetica, Arial"><STRONG>Note:</STRONG></FONT>=20
        <P><A name=3D1033617></A>
        <P>A Net8 service name entry is only necessary if you are =
connecting=20
        from a client Console machine to the Oracle8 repository =
database. If the=20
        repository database is on your Console, you do not need to =
enter a=20
        service name. </P>&nbsp;=20
        <HR>
      </TD></TR></TBODY></TABLE>




  <TABLE cellPadding=3D3>


    <TBODY>


    <TR align=3Dleft vAlign=3Dtop>


      <TD></TD></TR></TBODY></TABLE></P></DIV>
  <P><A name=3D1033591></A>


  <P>The Oracle Enterprise Manager Console appears. The =
<EM>Navigator</EM>=20


  Window displays in the upper-left portion of the console.<IMG=20
  src=3D"ch6_fichiers/ch6a1.gif"> </P>

  <LI value=3D3><A name=3D1032978></A>Double-click Databases in the=20
  <EM>Navigator</EM> window of the Oracle Enterprise Manager Console.=20
  <P><A name=3D1033669></A>
  <P>The list of databases in your Oracle Enterprise Manager network =


appears.=20

  </P>
  <LI value=3D4><A name=3D1033622></A>Select the appropriate database.=20
  <P></P>
  <LI value=3D5><A name=3D1033623></A>Choose =


Tools&gt;Applications&gt;Oracle=20


  Instance Manager from the main menu.=20

  <P><A name=3D1033625></A>
  <P>The <EM>Login Information</EM> dialog box appears.=20
  <DIV align=3Dcenter>
  <P>
  <TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


    <TBODY>


    <TR>

      <TD>
        <HR>
        <A name=3D1034124></A><FONT=20
        face=3D"Helvetica, Arial"><STRONG>Note:</STRONG></FONT>=20
        <P><A name=3D1034128></A>
        <P>If this is the first time you have used Oracle Instance =
Manager, the=20
        <EM>Login Information</EM> dialog box appears. If you have =
previously=20
        logged in, the Oracle Instance Manager opens without prompting =
you to=20
        log on. Go to Step <A=20
        =




href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1033653">8</A>.=20

        </P>&nbsp;=20
        <HR>
      </TD></TR></TBODY></TABLE>




  <TABLE cellPadding=3D3>


    <TBODY>


    <TR align=3Dleft vAlign=3Dtop>


      <TD></TD></TR></TBODY></TABLE></P></DIV>
  <P></P>


  <LI value=3D6><A name=3D1033624></A>Enter the INTERNAL user name and =
password, and=20


  Net8 service name for the Oracle8 database.=20

  <P></P>
  <LI value=3D7><A name=3D1034010></A>Click OK.=20
  <P><A name=3D1033654></A>
  <P>The <EM>Oracle Instance Manager</EM> window appears. </P>
  <LI value=3D8><A name=3D1033653></A>Double-click Initialization =


Parameters in the=20


  Navigator tree.=20


  <P><A name=3D1033655></A>


  <P>The initialization parameters appear for the Oracle8 database. =
</P>

  <LI value=3D9><A name=3D1033663></A>Click Save.=20
  <P><A name=3D1033664></A>
  <P>The <EM>Save Configuration</EM> dialog box appears. </P>
  <LI value=3D10><A name=3D1033665></A>Enter an appropriate =


configuration name for=20


  the initialization parameters (for example, SALES_DB) and click OK.=20
  <P></P>


  <LI value=3D11><A name=3D1034015></A>Choose File&gt;Exit to Console =
from the main=20


  menu.=20

  <P><A name=3D1033704></A>
  <P>You are returned to the Oracle Enterprise Manager Console. </P>
  <LI value=3D12><A name=3D1033673></A>Double-click Databases in the=20
  <EM>Navigator</EM> window of the Oracle Enterprise Manager Console.=20
  <P></P>
  <LI value=3D13><A name=3D1033215></A>Follow the instructions below:=20
  <H5><FONT face=3DHelvetica,Arial,sans-serif><EM></EM></FONT></H5>
  <TABLE border=3D1 cellPadding=3D3 cellSpacing=3D0 width=3D"100%">


    <TBODY>


    <TR>

      <TH align=3Dleft vAlign=3Dbottom><A name=3D1033198></A><FONT=20
        face=3D"Helvetica, Arial">To...</FONT> &nbsp;</TH>
      <TH align=3Dleft vAlign=3Dbottom><A name=3D1033200></A><FONT=20
        face=3D"Helvetica, Arial">Go to Section...</FONT> =


&nbsp;</TH></TR>


    <TR align=3Dleft vAlign=3Dtop>

      <TD><A name=3D1033202></A>
        <P>Start a database &nbsp;</P></TD>
      <TD><A name=3D1033207></A>
        <P><A=20
        =




href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1033116">Starting=20


        a Database with Oracle Enterprise Manager</A> =
&nbsp;</P></TD></TR>


    <TR align=3Dleft vAlign=3Dtop>

      <TD><A name=3D1033209></A>
        <P>Shut down a database &nbsp;</P></TD>
      <TD><A name=3D1033214></A>
        <P><A=20
        =




href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1033117">Shutting=20


        Down a Database with Oracle Enterprise Manager</A>=20
    &nbsp;</P></TD></TR></TBODY></TABLE>
  <TABLE cellPadding=3D3 cellSpacing=3D0 width=3D"100%">
    <TBODY>


    <TR align=3Dleft vAlign=3Dtop>


      <TD></TD></TR></TBODY></TABLE>


  <P></P></LI></OL><A name=3D1033116></A><!--TOC=3Dh2-"1033116"-->
<H3><FONT color=3D#330099 face=3D"Helvetica, Arial">Starting a Database =
with Oracle=20


Enterprise Manager</FONT></H3><!--/TOC=3Dh2-->
<OL>


  <LI value=3D1><A name=3D1033024></A>Right-click the database in the =
Navigator tree=20


  that you want to start.=20


  <P></P></LI></OL>


<OL>


  <LI value=3D2><A name=3D1033685></A>Choose Connect from the menu that =
appears.=20

  <P><A name=3D1033703></A>
  <P>The <EM>Login Information</EM> dialog box appears. </P>
  <LI value=3D3><A name=3D1033690></A>Enter the INTERNAL user name and =


password, and=20


  click OK.=20


  <P></P>


  <LI value=3D4><A name=3D1033033></A>Choose Startup from the menu that =
appears:<IMG=20


  src=3D"ch6_fichiers/ch6a4.gif">=20


  <P><A name=3D1033042></A>


  <P>The <EM>Startup</EM> dialog box appears.<IMG =
src=3D"ch6_fichiers/ch6a5.gif">=20


  </P>


  <LI value=3D5><A name=3D1033251></A>Provide the appropriate =
information and choose=20


  OK.=20


  <P><A name=3D1033469></A>


  <P>Your Oracle8 database starts. </P></LI></OL><A =
name=3D1033117></A><!--TOC=3Dh2-"1033117"-->
<H3><FONT color=3D#330099 face=3D"Helvetica, Arial">Shutting Down a =
Database with=20


Oracle Enterprise Manager</FONT></H3><!--/TOC=3Dh2-->
<OL>


  <LI value=3D1><A name=3D1033711></A>Right-click the database in the =
Navigator tree=20


  that you want to shut down.=20


  <P></P></LI></OL>


<OL>


  <LI value=3D2><A name=3D1033722></A>Choose Connect from the menu that =
appears.=20

  <P><A name=3D1033723></A>
  <P>The <EM>Login Information</EM> dialog box appears. </P>
  <LI value=3D3><A name=3D1033724></A>Enter the INTERNAL user name and =


password, and=20


  click OK.=20


  <P></P>


  <LI value=3D4><A name=3D1033739></A>Choose Shutdown from the menu =
that=20


  appears:<IMG src=3D"ch6_fichiers/ch6a2.gif">=20
  <P><A name=3D1033747></A>


  <P>The <EM>Shutdown Options</EM> dialog box appears: <IMG=20
  src=3D"ch6_fichiers/ch6a3.gif"> </P>


  <LI value=3D5><A name=3D1033252></A>Provide the appropriate =
information and choose=20


  OK.=20


  <P><A name=3D1033480></A>


  <P>Your Oracle8 database shuts down. </P></LI></OL><A =
name=3D1029098></A><!--TOC=3Dh1-"1029098"-->
<H2><FONT color=3D#330099 face=3D"Helvetica, Arial">Running Multiple=20
Instances</FONT></H2><!--/TOC=3Dh1--><A name=3D1032198></A>
<P>To run multiple instances, it is assumed that you have already done =
steps=20


1,2, and 3: </P>


<OL>


  <LI value=3D1><A name=3D1026566></A>Add a new SID name to the =
listener in=20


  LISTENER.ORA.=20



  <P></P></LI></OL>


<OL>


  <LI value=3D2><A name=3D1032211></A>Setup a new service name in =
TNSNAMES.ORA that=20


  uses the IPC protocol.=20


  <P></P>


  <LI value=3D3><A name=3D1034442></A>Create a new parameter file in =
the=20


  ORACLE_HOME\DATABASE directory of the form initSID.ora. Be sure that =
the=20


  control_file parameter specifies a new control file name , and the =
db_name=20


  points to the new database name.=20

  <P></P>
  <LI value=3D4><A name=3D1034443></A>Start Server Manager=20
  <P><PRE><A name=3D1034452></A>LOAD SVRMGR


</PRE>


  <LI value=3D5><A name=3D1034444></A>Connect as INTERNAL.=20
  <P><PRE><A name=3D1032205></A>SVRMGR&gt;CONNECT =
INTERNAL/<EM>&lt;PASSWORD_at_service_name that was created in =
Step2&gt;</EM>


</PRE>


  <LI value=3D6><A name=3D1032225></A>Start up the database with the =
new instance:=20


  <P><PRE><A name=3D1033534></A>SVRMGR&gt;STARTUP =
PFILE=3D%ORACLE_HOME%DATABASE\INIT<EM>SID</EM>.ORA
</PRE><A name=3D1033539></A>


  <P>where <EM>SID</EM> is the name of the instance. </P></LI></OL><A=20
name=3D1034466></A><!--TOC=3Dh1-"1034466"-->
<H2><FONT color=3D#330099 face=3D"Helvetica, Arial">Using Novell =
Directory=20


Services</FONT></H2><!--/TOC=3Dh1--><A name=3D1034470></A>
<P>Novell Directory Services (NDS) is an object-oriented implementation =
of=20


directory services that allows you to build sophisticated naming =
schemes that=20


model business organizational structures and is consistent with the =
emerging=20


X.500 Standard for a directory. </P><A name=3D1034471></A>
<P>Novell Directory Services (NDS) first became available with NetWare =
4,=20


providing users with global access to network resources such as =
servers, shared=20


drives and databases regardless of where they are physically located. =
This=20


feature allows users from multiple locations to use a single login to =
access a=20


multi-server and multi-database network, and to view the entire network =
in a=20


single directory. </P><A name=3D1034472></A>
<P>A user logged in to NDS can be automatically authenticated to use an =
Oracle=20


database running on any server in the directory. </P><A =
name=3D1034474></A>


<P>Oracle DBAs working in an NDS environment can: </P>
<UL>


  <P>


  <LI><A name=3D1034475></A>Create an Oracle database object (known as =
an=20


  instance) in the directory.=20

  <P>
  <P></P>
  <LI><A name=3D1034476></A>Map NDS users, groups, and organizational =


units to a=20


  database user. This allows NDS users (individually, in groups, or in=20
  organizational units) automatic access to a single database user =
account.=20

  <P>
  <P></P>
  <LI><A name=3D1034478></A>Map NDS groups to database roles. This =


allows members=20


  of these NDS groups to automatically inherit the privileges of the =
database=20


  role to which they are mapped.=20

  <P>
  <P></P>
  <LI><A name=3D1034481></A>Create Oracle users.=20
  <P>
  <P></P>
  <LI><A name=3D1034482></A>Assign database roles to users and other =


database=20


  roles.=20

  <P>
  <P></P>
  <LI><A name=3D1034483></A>Assign privileges to users and database =


roles.=20

  <P>
  <P></P>
  <LI><A name=3D1034484></A>Modify default and temporary tablespace =


values and=20


  user profile information.=20


  <P></P></LI></UL><A name=3D1034485></A>
<P>Instructions for performing these tasks are provided in online help =
format=20


within the NWADMIN Oracle Snap-In for NetWare Administrator dialog =
boxes.=20

<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>

      <HR>
      See in this chapter and your Novell documentation for a complete=20
      discussion of NDS features. &nbsp;=20
      <HR>




    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV>
<P></P><A name=3D1034491></A><!--TOC=3Dh3-"1034491"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, =
Arial">Requirements</FONT></H4><!--/TOC=3Dh3--><A=20
name=3D1034494></A>


<P><STRONG></STRONG>To use NDS with Oracle8 Server, you must do the =
following:=20


</P>


<UL>

  <P>
  <LI><A name=3D1034495></A>Run NetWare 4.1.=20
  <P>
  <P></P>
  <LI><A name=3D1034496></A>Run the NWADMIN utility on a Windows 3.1 =


workstation.=20

  <P>
  <P></P>
  <LI><A name=3D1034497></A>Install SQL*Net 2.3 server networking =


software.=20

  <P>
  <P></P>
  <LI><A name=3D1034498></A>Install the following SQL*Net 2.2.2.0.3 or =


later=20


  client networking software:=20


  <P>


  <UL>


    <LI><A name=3DAUTOTAG;></A>If running Windows, install SQL*Net =
2.2.2.0.3 or=20


    later networking software.=20


    <LI><A name=3DAUTOTAG;></A>If running OS/2, install SQL*Net =
2.2.2.0.0 or later=20


    networking software. </LI></UL>


  <P></P>


  <LI><A name=3D1034501></A>Install the Oracle Snap-In for NetWare =
Administrator.=20


  <P></P></LI></UL><A name=3D1034505></A>
<P><A=20


href=3D"http://technet.oracle.com/doc/netware/netware.803/a56083_01/ch6.=
htm#1034516">Table=20


6-1, "The INIT%SID%ORA Parameters to set to Enable NDS Mapping"</A> =
lists the=20


INIT%SID%.ORA parameters that must be set to enable NDS mapping.=20

<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>

      <HR>
      <A name=3D1034524></A>
      <P>An NDS user or group to a database user &nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034526></A>
      <P>OS_AUTHENT_PREFIX=3D"" &nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>

      <HR>
      <A name=3D1034528></A>
      <P>An NDS group to a database role &nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034530></A>
      <P>OS_ROLES=3DTRUE &nbsp;=20
      <HR>




    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV>

<P></P><A name=3D1034536></A>
<P>
<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>

      <HR>
      Do <EM>not</EM> put a space between the double quotes for=20
      OS_AUTHENT_PREFIX. &nbsp;=20
      <HR>




    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV>
<P></P><A name=3D1034537></A><!--TOC=3Dh3-"1034537"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, Arial">Working with the =
Directory=20


Tree</FONT></H4><!--/TOC=3Dh3--><A name=3D1034541></A>
<P>The Oracle Snap-In for NetWare Administrator allows you to create an =
Oracle=20


database instance object in an NDS directory tree. The Oracle Instance =
Object=20


looks and behaves just as any other NDS object and is subject to =
exactly the=20


same security features, such as, the ability to control the access =
rights to the=20


object itself. Once this object has been created, a DBA can provide =
groups and=20


users with access and privileges to the database instance which it =
represents.=20


The Oracle Snap-In for NetWare Administrator is described fully in=20
context-sensitive online help. </P><A =


name=3D1034542></A><!--TOC=3Dh3-"1034542"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, Arial">Using the Oracle =
Snap-in for=20


NetWare Administrator</FONT></H4><!--/TOC=3Dh3--><A name=3D1034543></A>
<P>During database instance object creation, you should define =
additional=20


properties of your database instance, which allow a DBA to perform =
tasks such as=20


assigning NDS groups and users to a database login and assigning NDS =
groups to=20


database roles.=20

<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>

      <HR>
      This section describes how to create a database instance object =
in a=20
      container object called DESKTOP. Create your database instance =
object=20
      under a container object appropriate to your environment. Before =
you=20
      access the online help procedures, you should review your NetWare =
4.1=20
      documentation for information on logging on to a NetWare server =
and=20
      running NWADMIN. &nbsp;=20
      <HR>




    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV>
<P></P><A name=3D1034606></A>


<H4><FONT face=3D"Helvetica, Arial">To create a database instance =
object in a=20


container object:=20

<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D1><A name=3D1034563></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034567></A>
      <P>Start NWADMIN. The NetWare Administrator screen appears. =
&nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D2><A name=3D1034569></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034571></A>
      <P>Select Tools-&gt;Browse in the main menu bar (if necessary). =
The [Root]=20
      screen appears (depending upon your current context or setting) =
.<IMG=20
      src=3D"ch6_fichiers/ch6a6.gif"> &nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D3><A name=3D1034576></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034578></A>
      <P>Double-click on the object under which you will create the =
database. <A=20
      name=3D1034579></A>
      <P>For example, double-click on "oracle" to access the object =
"desktop".=20
      Then double-click on "desktop" to see the following objects: <IMG =

      src=3D"ch6_fichiers/ch6a7.gif"> &nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D4><A name=3D1034584></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034586></A>
      <P>Select Object-&gt;Create from the NetWare Administrator main =
menu bar=20
      to create a database under "desktop". The New Object dialog box =
appears.=20
      &nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D5><A name=3D1034588></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034590></A>
      <P>Select Oracle Instance from the Class of New Object list and =
choose=20
      [OK]. The Create Instance dialog box appears. <A =
name=3D1034591></A>
      <P>The Create Instance dialog box contains a check box called =
Define=20
      Additional Properties. &nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D6><A name=3D1034593></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034595></A>
      <P>Select this option to assign groups and roles. The Oracle =
Instance=20
      dialog box appears. <IMG src=3D"ch6_fichiers/ch6a8.gif"> <A=20
name=3D1034599></A>
      <P>This dialog box contains a list of "pages" that access =
individual=20
      property sheets where you can assign access privileges. The types =
of=20
      properties that you can assign include: Identification, User =
Mappings,=20
      Role Mappings, Privileges, User Storage, and Connect Address. <A=20
      name=3D1034600></A>
      <P>It is essential that you assign the correct Oracle SID in the =
"SID=20
      Name" field, and that you assign the correct NetWare Server on =
which this=20
      instance is running in the 'Host' field. It is best to use the =
directory=20
      browsing facility to ensure that the name and full directory =
context of=20
      this server is correctly entered. &nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D7><A name=3D1034602></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034604></A>
      <P>Click on Help under each "page" for context-sensitive =
instructions on=20
      using that feature of the Oracle Instance Object. Attention: If =
you move a=20
      database from one server to another server in an NDS tree, you =
must also=20
      specify the new server name. Failing to do so will cause all =
automatic=20
      authentication to fail. &nbsp;=20
      <HR>




    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV></FONT></H4><A =
name=3D1034607></A><!--TOC=3Dh3-"1034607"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, Arial">Operating System =
Authentication=20


for Database Administration</FONT></H4><!--/TOC=3Dh3--><A =
name=3D1034611></A>


<P>To take advantage of secure operating system authentication for =
database=20


administration privilege, Database administrators who use CONNECT =
INTERNAL or=20


CONNECT <EM>username</EM> as SYSDBA from a client workstation must =
belong to the=20


NetWare group that controls the list of authorized Oracle DBAs. This =
group name=20


must be assigned to the "Admin Group" field of the Oracle Instance=20
identification page shown above, for example: </P><PRE><A =
name=3D1034614></A>ORACLE_DBA.context_name
</PRE><A name=3D1034615></A>


<P>where <EM>&lt;context_name&gt;</EM> is the position of an object =
within the=20


NDS directory tree, for example, DESKTOP.ORACLE. It is best to use the =
directory=20


browsing facility to ensure that the name and full directory context of =
this=20


group is correctly entered. In the same way, the 'Operator Group' field =
allows=20


you to select the NDS group which will be used to authenticate users =
who use=20


CONNECT <EM>username</EM> as SYSOPER. </P><A name=3D1034616></A>
<P>The NetWare group ORACLE_DBA<EM>.</EM><EM>&lt;context name&gt;</EM> =
is=20


created without any members during installation at the root of the =
directory.=20


You may choose to use this group or any other group for controlling =
Database=20


Administrator privileges. </P><A name=3D1034617></A>
<P>To add or delete users from the group, use a NetWare 4.1 utility =
such as=20


NWADMIN or NETADMIN from a client workstation. To change the membership =
of the=20


group, you must be the group manager, or be logged in as ADMIN or an =
equivalent=20


user. </P><A name=3D1034618></A>


<P>To use the Oracle8 Database Administration Tools for Windows or =
OS/2, you=20


must be a member of the ORACLE_DBA.<EM>&lt;context_name&gt;</EM> group =
and be=20


logged in to the NetWare directory service, or you must supply the =
appropriate=20


password so that Oracle can use the password file to authenticate you. =
</P><A=20


name=3D1034619></A>


<P>The CONFIG.ORA file parameter ORACLE_GROUP is not used with NetWare =
4.1 with=20


NDS. Specify the database administration group name in the Admin Group =
text box=20


on the Identification page of the Oracle Instance dialog box. </P><A=20
name=3D1034622></A><!--TOC=3Dh2-"1034622"-->
<H3><FONT color=3D#330099 face=3D"Helvetica, Arial">End User=20
Authentication</FONT></H3><!--/TOC=3Dh2--><A name=3D1034623></A>
<P>The Oracle Instance dialog box shown earlier allows the =
administrator to=20


create users within the Oracle database and completely manage these =
users'=20


properties. NDS users, groups, and organizational units may be mapped =
to Oracle=20


users to allow a one-to-one mapping between operating system users and =
Oracle=20


users or to allow a many-to-one mapping between operating system users =
and=20


Oracle users. In addition, NDS groups can be mapped to Oracle database =
roles to=20


allow the operating system to be used to grant roles to users =
connecting to the=20


Oracle Server. By using the features of the security integration =
between the=20


Oracle Server and Novell Directory Services, administrators have =
maximum=20


flexibility in managing the security of the database or the =
applications which=20


are built to use the database. Security management can also be safely =
delegated=20


to the Network Administrator. </P><A =


name=3D1034626></A><!--TOC=3Dh2-"1034626"-->
<H3><FONT color=3D#330099 face=3D"Helvetica, =
Arial">Troubleshooting</FONT></H3><!--/TOC=3Dh2--><A=20
name=3D1034627></A>


<P>If you have problems installing the Oracle Snap-In for NetWare =
Administrator,=20


there are several troubleshooting procedures to perform. </P><A=20
name=3D1034628></A><!--TOC=3Dh3-"1034628"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, Arial">On the Oracle8=20
Server</FONT></H4><!--/TOC=3Dh3--><A name=3D1034629></A>
<P>Oracle fails to extend the NDS schema if you install the Oracle8 =
Server=20


<EM>before</EM> installing NDS for NetWare 4.1. If this occurs, you =
must do the=20


following:=20

<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D1><A name=3D1034643></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034645></A>
      <P>Install NDS on your NetWare 4.1 server. &nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D2><A name=3D1034647></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034649></A>
      <P>Load the following NLM on the server containing the root NDS =
database:=20
      : LOAD ORASCHEM <A name=3D1034653></A>
      <P>ORASCHEM extends the NDS schema to add the Oracle objects =


class. &nbsp;=20



      <HR>


    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV>
<P></P><A name=3D1034654></A>


<P>Oracle fails to extend the NDS schema if you install the Oracle8 =
Server on a=20


NetWare server which does not contain a read-write or master partition =
of the=20


directory database. If this occurs, you mut do the following:=20

<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D1><A name=3D1034668></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034670></A>
      <P>Copy the ORASCHEM NLM file to a server which does contain a =
read-write=20
      or master partition of the directory database. &nbsp;=20
      <HR>




    </TD></TR>


  <TR>


    <TD>


      <HR>


      <OL>
        <LI value=3D2><A name=3D1034672></A>
        <P></P></LI></OL>&nbsp;=20
      <HR>




    </TD>


    <TD>

      <HR>
      <A name=3D1034674></A>
      <P>Execute the NLM on this server by loading it at the console: : =
LOAD=20
      ORASCHEM &nbsp;=20
      <HR>




    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV>
<P></P><A name=3D1034677></A>


<P>Allow time for the directory to re-synchronize and ensure the schema =
changes=20


have propagated to all partitions. </P><A =
name=3D1034678></A><!--TOC=3Dh3-"1034678"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, Arial">On the =
client</FONT></H4><!--/TOC=3Dh3--><A name=3D1034679></A>
<P>When you start NWADMIN, you will receive a message stating that =
NWORACLE.DLL=20



can not be found. This file allows you to create an Oracle database =
instance in=20


an NDS directory tree. </P>


<UL>


  <P>


  <LI><A name=3D1034680></A>You should be sure that an entry similar to =
the=20


  following appears in your NWADMIN.INI file:=20
  <P></P></LI></UL>[Snapin Object DLLs] =
NWORACLE=3Dc:\orawin\bin\nworacle.dll <PRE><A name=3D1034683></A>
</PRE>


<UL>


  <P>


  <LI><A name=3D1034685></A>You should also be sure that the =
NWORACLE.DLL file is=20


  in the directory.=20


  <P></P></LI></UL><A name=3D1034686></A><!--TOC=3Dh2-"1034686"-->
<H3><FONT color=3D#330099 face=3D"Helvetica, Arial">Using Bindery=20
Services</FONT></H3><!--/TOC=3Dh2--><A name=3D1034687></A>
<P>Bindery services are available with NetWare 4.x. </P><A =
name=3D1034688></A>


<P>Bindery-based users can access any object in the directory by using =
multiple=20


accounts. But this can result in more work for the network supervisor,=20
especially if numerous users need several accounts. </P><A =
name=3D1034689></A>


<P>Bindery services users should be grouped within bindery contexts =
defined by=20


workgroups, shared resources, and information usage and exchange. =
</P><A=20


name=3D1034693></A><!--TOC=3Dh3-"1034693"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, Arial">Operating System =
Authentication=20


for Database Administration</FONT></H4><!--/TOC=3Dh3--><A =
name=3D1034697></A>


<P>Database administrators who use CONNECT INTERNAL from a client =
workstation=20


must belong to the NetWare group that controls the list of authorized =
Oracle=20


DBAs and be logged onto the NetWare server which is running the Oracle8 =
Server.=20


By default, this group is named ORACLE_DBA, although it can be changed. =
The=20


OSOPER group is called ORACLE_OPER and can not be changed. For all =
NetWare=20


releases for Oracle8 Server 7.2 or later, these two groups are checked =
by all=20


SIDs, along with each SID checking the ORACLE_SID_DBA and =
ORACLE_SID_OPER groups=20


(where <EM>SID</EM> is each database instance name). </P><A =
name=3D1034699></A>


<P>The NetWare group ORACLE_DBA is created without any members. To add =
or delete=20


users from the group, use the following: </P>
<UL>


  <P>


  <LI><A name=3D1034700></A>an equivalent NetWare 4.1 utility such as =
NWADMIN or=20


  NETADMIN from a client workstation<EM></EM>=20
  <P></P></LI></UL><A name=3D1034704></A>
<P>To change the membership of the group, you must be the group =
manager, or be=20


logged in as SUPERVISOR or as a SUPERVISOR-equivalent user. </P><A=20
name=3D1034705></A>


<P>To use the Oracle8 Database Administration Tools, you must be a =
member of the=20


ORACLE_DBA group and be logged in to the NetWare Server or give the =
database=20


administration password. </P><A name=3D1034706></A>
<P>If you are not using NetWare 4.1 with NDS, you can change the name =
of the=20


ORACLE_DBA NetWare group at any time by specifying the new group name =
in the=20


CONFIG.ORA file. The ORACLE_GROUP CONFIG.ORA parameter specifies the =
name of the=20


NetWare group that controls DBA access to the database. If your =
CONFIG.ORA file=20


does not have the ORACLE_GROUP parameter set, the name of the current =
database=20


administration group defaults to ORACLE_DBA. </P><A name=3D1034711></A>
<P>To change the name of the group, add (or modify) the following line =
to your=20


CONFIG.ORA file: </P><PRE><A name=3D1034718></A>ORACLE_GROUP=3Dgroup=20
</PRE><A name=3D1034727></A>


<P>where <EM>&lt;group&gt;</EM> is the name of the new database =
administration=20


group.=20

<DIV align=3Dcenter>
<P>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 width=3D"80%">


  <TBODY>


  <TR>


    <TD>

      <HR>
      Make sure there are no spaces around the equal sign (=3D) and =
that there is=20
      a carriage return at the end of the last line in the CONFIG.ORA =
file. For=20
      more information about the CONFIG.ORA file and parameters, refer =
to=20
      Appendix B, "Configuration Parameters". &nbsp;=20
      <HR>




    </TD></TR></TBODY></TABLE>


<TABLE cellPadding=3D3>


  <TBODY>


  <TR align=3Dleft vAlign=3Dtop>


    <TD></TD></TR></TBODY></TABLE></P></DIV>
<P></P><A name=3D1034732></A><!--TOC=3Dh3-"1034732"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, Arial">Creating Automatic =
Authorization=20


Accounts</FONT></H4><!--/TOC=3Dh3--><A name=3D1034735></A>
<P><STRONG></STRONG>When enrolling Oracle users, you have the option of =
using=20


NetWare usernames as the basis for Oracle usernames so that database =
users can=20


connect to the Oracle8 Server somewhat faster and more conveniently. =
You can use=20


either Server Manager or SQL*Plus to enroll users. </P><A =
name=3D1034736></A>


<P>When using the NetWare username for authentication, the database=20
administrator should set the OS_AUTHENT_PREFIX parameter in the =
INIT%SID%.ORA=20



file (by default INITORCL.ORA). If this parameter is not set, the =
default value=20


is OPS$. </P><A name=3D1034737></A>


<P>The syntax for granting automatic logins when using the default =
value of=20


OS_AUTHENT_PREFIX is as follows: </P><PRE><A =
name=3D1034740></A>SVRMGR&gt; CREATE USER OPS$sysid IDENTIFIED =
EXTERNALLY;



</PRE><A name=3D1034741></A>


<P>where <EM>&lt;sysid&gt;</EM> is the user's NetWare username. If the =
prefix=20


parameter is set to a value other than OPS$, use that value. For =
example, to=20


enroll a user whose NetWare username is OPUS, when OS_AUTHENT_PREFIX is =
set to=20


XXX, enter: </P><PRE><A name=3D1034742></A>SVRMGR&gt; CREATE USER =
XXXOPUS IDENTIFIED EXTERNALLY;



</PRE><A name=3D1034743></A>


<P>Then, if you are logged on to the NetWare server as OPUS from a =
client=20


workstation and you connect to Oracle, you need not explicitly enter =
your Oracle=20


username. </P><A name=3D1034744></A>


<P>For example, start SQL*Plus. At the prompt, enter your username or a =
/ on the=20


client workstation. Oracle searches the dictionary tables for an =
automatic login=20


username that corresponds to the NetWare username OPUS, verifies it, =
and allows=20


you to connect to Oracle as XXXOPUS. </P><A name=3D1034745></A>
<P>Because the Oracle username is the whole name XXXOPUS, all objects =
created by=20


XXXOPUS (that is, tables, views, indexes, and so on) are prefixed by =
this name.=20


For another user to reference the table FISH owned by XXXOPUS, that =
user enters:=20

</P><PRE><A name=3D1034746></A>SVRMGR&gt; SELECT * FROM XXXOPUS.FISH=20
</PRE><A name=3D1034747></A>
<P>An Oracle user does not have to be logged in to any file server in =


order to=20


connect to the Oracle8 Server unless they are using an automatic =
authorization=20


account. </P><A name=3D1034748></A>


<P>You can set OS_AUTHENT_PREFIX to the null string (a set of double =
quotes with=20


no string included). This eliminates the need for any prefix to the =
NetWare=20


usernames. </P><A name=3D1034753></A><!--TOC=3Dh3-"1034753"-->
<H4><FONT color=3D#330099 face=3D"Helvetica, Arial">Granting Roles with =
NetWare=20


Groups</FONT></H4><!--/TOC=3Dh3--><A name=3D1034934></A>
<P>The Oracle8 Server allows database roles to be granted to users =
directly by=20


NetWare. NetWare groups are created and administered using the NWADMIN =
utility=20


for NetWare 4.1 from client workstations. SUPERVISOR or equivalent =
access is=20


often needed to create groups. </P><A name=3D1034755></A>
<P>You must set one INIT%SID%.ORA parameter (OS-ROLES) to TRUE to use =
NetWare=20


groups to grant a database role. Once set, all roles are managed by the =



operating system. Roles granted explicitly with SQL will not be in =
effect. The=20


default setting for this parameter is FALSE. </P>
<UL>


  <P>


  <LI><A name=3D1034758></A>To use NetWare groups to identify and grant =
user=20


  roles, take the following steps=20


  <H5><FONT face=3DHelvetica,Arial,sans-serif><EM><A=20
  name=3D1034764></A><STRONG><FONT =


face=3DArial,Helvetica,sans-serif><EM>Table 6-5=20
  Steps to Use NetWare Groups to Identify and Grant User Roles=20
  </EM></FONT></STRONG></EM></FONT></H5>
  <TABLE border=3D1 cellPadding=3D3 cellSpacing=3D0 width=3D"100%">
Received on Wed Nov 08 2000 - 08:48:07 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US