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: Why do I get this oracle password file error?

RE: Why do I get this oracle password file error?

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Tue, 8 Aug 2000 08:17:12 -0400
Message-Id: <10583.114052@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_001_01C00132.9A207F6C


Content-Type: text/plain;


        charset="iso-8859-1"



Guang, 



Been there, done that.  Comment out REMOTE_LOGIN_PASSWORDFILE in your
init.ora when you create the database.  THen, shutdown the database,
uncomment this parameter in init.ora, recreate your passwordfile, and
startup your database again.  Everything should be ducky. 



Lisa




-----Original Message-----


From: Guang Mei [mailto:zlmei_at_hotmail.com]
Sent: Monday, August 07, 2000 4:46 PM


To: Multiple recipients of list ORACLE-L
Subject: Why do I get this oracle password file error?




Hi:



I am trying to understand why I got this "ORA-01991: invalid password file" 
error during my database creation process.



Here is how I got this error:



I installed Oracle8i (Release 8.1.5) on Sun SPARC Solaris 2.6 (clean 
installation). I chosed the default installation and let the oracle create 
an instance (called "areDev00") on the unix box. Everything is OK. There is 
a password file created by oracle automatically:



$ ls -l /u01/app/oracle/product/8.1.5/dbs/orap*
-rwSr-----   1 oracle   oinstall    1536 Aug  7 12:07 


/u01/app/oracle/product/8.1.5/dbs/orapwareDev00




and in the initareDev00.ora file, the following is set by oracle default 
installation:



remote_login_passwordfile = exclusive




Everything is fine except that I don't like the the file size and storage 
that oracle defult creates.



So, I used svrmgrl to log in as internal, did "shutdown normal" and it shut 
down the instance successfully. I remove all the files in


/u02/oradata/areDev00

/u03/oradata/areDev00

/u04/oradata/areDev00




Now I planning to re-create the the database instance with more tablespaces 
(such as DATA and RBSBIG, etc) and with different storage clause.
But I got this password file error:



$ ./svrmgrl



Oracle Server Manager Release 3.1.5.0.0 - Production



(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.



Oracle8i Release 8.1.5.0.0 - Production


With the Java option


PL/SQL Release 8.1.5.0.0 - Production



SVRMGR> connect internal


Connected.


SVRMGR> startup nomount 


pfile=/u01/app/oracle/admin/areDev00/pfile/initareDev00.ora
ORACLE instance started.

Total System Global Area                         51830160 bytes
Fixed Size                                          64912 bytes
Variable Size                                    18030592 bytes
Database Buffers                                 33554432 bytes
Redo Buffers                                       180224 bytes


SVRMGR> create database areDev00


controlfile reuse


logfile


GROUP 1



(

        '/u03/oradata/areDev00/redog101.log',
        '/u03/oradata/areDev00/redog102.log'


) size 10M reuse,


GROUP 2



(

        '/u04/oradata/areDev00/redog201.log',
        '/u04/oradata/areDev00/redog202.log'


) size 10M reuse


datafile '/u02/oradata/areDev00/system01.dbf'
size 50M reuse autoextend on next 10M maxsize 200M
character set WE8ISO8859P1;

     2>      3>      4>      5>      6>      7>      8>      9>     10>     
11>     12>     13>     14>     15>     16> /


create database areDev00


*


ORA-01501: CREATE DATABASE failed


ORA-01991: invalid password file 


'/u01/app/oracle/product/8.1.5/dbs/orapwareDev00'






At this point,  I tried different ways, such as remove the password file and



re-run the script, and it did not work.



Finally, I opened the initareDev00.ora file and changed "exclusive" to 
"shared":



remote_login_passwordfile = shared



and then :



$ ./svrmgrl



Oracle Server Manager Release 3.1.5.0.0 - Production



(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.



Oracle8i Release 8.1.5.0.0 - Production


With the Java option


PL/SQL Release 8.1.5.0.0 - Production



SVRMGR> connect internal


Connected.


SVRMGR> startup nomount 


pfile=/u01/app/oracle/admin/areDev00/pfile/initareDev00.ora
ORACLE instance started.

Total System Global Area                         51830160 bytes
Fixed Size                                          64912 bytes
Variable Size                                    18030592 bytes
Database Buffers                                 33554432 bytes
Redo Buffers                                       180224 bytes
SVRMGR>  create database areDev00
     2> controlfile reuse
     3> logfile
     4> GROUP 1
     5> (
     6>         '/u03/oradata/areDev00/redog101.log',
     7>         '/u03/oradata/areDev00/redog102.log'
     8> ) size 10M reuse,
     9> GROUP 2
    10> (
    11>         '/u04/oradata/areDev00/redog201.log',
    12>         '/u04/oradata/areDev00/redog202.log'
    13> ) size 10M reuse
    14> datafile '/u02/oradata/areDev00/system01.dbf'


    15> size 50M reuse autoextend on next 10M maxsize 200M
    16> character set WE8ISO8859P1;


/



Statement processed.



Then I preceed to create all the tablespaces, rollback segments etc without 
any problem.





So my questions are:



    
  
  1.   Why the "create database..."  failed when the setting was "exclusive"?
  
  2.   Why it works now with "shared"?
  
  3.   Am I creating any potential problems by setting value to "shared"? (We 
are not using remote client to do startup or shutdown anyway).






I am trying to understand what this password file does (I read oracle 
documentation several times but still could not understand what is does)



Thanks.



Guang




Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


-- 
Author: Guang Mei
  INET: zlmei_at_hotmail.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).

------_=_NextPart_001_01C00132.9A207F6C
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Why do I get this oracle password file error?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Guang, </FONT>
</P>

<P><FONT SIZE=3D2>Been there, done that.&nbsp; Comment out =
REMOTE_LOGIN_PASSWORDFILE in your init.ora when you create the =
database.&nbsp; THen, shutdown the database, uncomment this parameter =
in init.ora, recreate your passwordfile, and startup your database =
again.&nbsp; Everything should be ducky. </FONT></P>

<P><FONT SIZE=3D2>Lisa</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Guang Mei [<A =
HREF=3D"mailto:zlmei_at_hotmail.com">mailto:zlmei_at_hotmail.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, August 07, 2000 4:46 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Why do I get this oracle password file =
error?</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi:</FONT>
</P>

<P><FONT SIZE=3D2>I am trying to understand why I got this =
&quot;ORA-01991: invalid password file&quot; </FONT>
<BR><FONT SIZE=3D2>error during my database creation process.</FONT>
</P>

<P><FONT SIZE=3D2>Here is how I got this error:</FONT>
</P>

<P><FONT SIZE=3D2>I installed Oracle8i (Release 8.1.5) on Sun SPARC =
Solaris 2.6 (clean </FONT>
<BR><FONT SIZE=3D2>installation). I chosed the default installation and =
let the oracle create </FONT>
<BR><FONT SIZE=3D2>an instance (called &quot;areDev00&quot;) on the =
unix box. Everything is OK. There is </FONT>
<BR><FONT SIZE=3D2>a password file created by oracle =
automatically:</FONT>
</P>

<P><FONT SIZE=3D2>$ ls -l =


/u01/app/oracle/product/8.1.5/dbs/orap*</FONT>

<BR><FONT SIZE=3D2>-rwSr-----&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
oinstall&nbsp;&nbsp;&nbsp; 1536 Aug&nbsp; 7 12:07 </FONT>
<BR><FONT =
SIZE=3D2>/u01/app/oracle/product/8.1.5/dbs/orapwareDev00</FONT>
</P>

<P><FONT SIZE=3D2>and in the initareDev00.ora file, the following is =
set by oracle default </FONT>
<BR><FONT SIZE=3D2>installation:</FONT>
</P>

<P><FONT SIZE=3D2>remote_login_passwordfile =3D exclusive</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Everything is fine except that I don't like the the =
file size and storage </FONT>
<BR><FONT SIZE=3D2>that oracle defult creates.</FONT>
</P>

<P><FONT SIZE=3D2>So, I used svrmgrl to log in as internal, did =
&quot;shutdown normal&quot; and it shut </FONT>
<BR><FONT SIZE=3D2>down the instance successfully. I remove all the =
files in</FONT>
<BR><FONT SIZE=3D2>/u02/oradata/areDev00</FONT>
<BR><FONT SIZE=3D2>/u03/oradata/areDev00</FONT>
<BR><FONT SIZE=3D2>/u04/oradata/areDev00</FONT>
</P>

<P><FONT SIZE=3D2>Now I planning to re-create the the database instance =
with more tablespaces </FONT>
<BR><FONT SIZE=3D2>(such as DATA and RBSBIG, etc) and with different =
storage clause.</FONT>
<BR><FONT SIZE=3D2>But I got this password file error:</FONT>
</P>

<P><FONT SIZE=3D2>$ ./svrmgrl</FONT>
</P>

<P><FONT SIZE=3D2>Oracle Server Manager Release 3.1.5.0.0 - =
Production</FONT>
</P>

<P><FONT SIZE=3D2>(c) Copyright 1997, Oracle Corporation.&nbsp; All =
Rights Reserved.</FONT>
</P>

<P><FONT SIZE=3D2>Oracle8i Release 8.1.5.0.0 - Production</FONT>
<BR><FONT SIZE=3D2>With the Java option</FONT>
<BR><FONT SIZE=3D2>PL/SQL Release 8.1.5.0.0 - Production</FONT>
</P>

<P><FONT SIZE=3D2>SVRMGR&gt; connect internal</FONT>
<BR><FONT SIZE=3D2>Connected.</FONT>
<BR><FONT SIZE=3D2>SVRMGR&gt; startup nomount </FONT>
<BR><FONT =
SIZE=3D2>pfile=3D/u01/app/oracle/admin/areDev00/pfile/initareDev00.ora</=
FONT>
<BR><FONT SIZE=3D2>ORACLE instance started.</FONT>
<BR><FONT SIZE=3D2>Total System Global =
Area&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; 51830160 bytes</FONT>
<BR><FONT SIZE=3D2>Fixed =
Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 64912 bytes</FONT>
<BR><FONT SIZE=3D2>Variable =
Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
18030592 bytes</FONT>
<BR><FONT SIZE=3D2>Database =
Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33554432 =
bytes</FONT>
<BR><FONT SIZE=3D2>Redo =
Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; 180224 bytes</FONT>
<BR><FONT SIZE=3D2>SVRMGR&gt; create database areDev00</FONT>
<BR><FONT SIZE=3D2>controlfile reuse</FONT>
<BR><FONT SIZE=3D2>logfile</FONT>
<BR><FONT SIZE=3D2>GROUP 1</FONT>
<BR><FONT SIZE=3D2>(</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
'/u03/oradata/areDev00/redog101.log',</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
'/u03/oradata/areDev00/redog102.log'</FONT>
<BR><FONT SIZE=3D2>) size 10M reuse,</FONT>
<BR><FONT SIZE=3D2>GROUP 2</FONT>
<BR><FONT SIZE=3D2>(</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
'/u04/oradata/areDev00/redog201.log',</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
'/u04/oradata/areDev00/redog202.log'</FONT>
<BR><FONT SIZE=3D2>) size 10M reuse</FONT>
<BR><FONT SIZE=3D2>datafile '/u02/oradata/areDev00/system01.dbf'</FONT>
<BR><FONT SIZE=3D2>size 50M reuse autoextend on next 10M maxsize =
200M</FONT>
<BR><FONT SIZE=3D2>character set WE8ISO8859P1;</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; =
2&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
4&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
6&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
8&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&gt;&nbsp;&nbsp;&nbsp;&nbsp; =
10&gt;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>11&gt;&nbsp;&nbsp;&nbsp;&nbsp; =
12&gt;&nbsp;&nbsp;&nbsp;&nbsp; 13&gt;&nbsp;&nbsp;&nbsp;&nbsp; =
14&gt;&nbsp;&nbsp;&nbsp;&nbsp; 15&gt;&nbsp;&nbsp;&nbsp;&nbsp; 16&gt; =


/</FONT>

<BR><FONT SIZE=3D2>create database areDev00</FONT>
<BR><FONT SIZE=3D2>*</FONT>
<BR><FONT SIZE=3D2>ORA-01501: CREATE DATABASE failed</FONT>
<BR><FONT SIZE=3D2>ORA-01991: invalid password file </FONT>
<BR><FONT =
SIZE=3D2>'/u01/app/oracle/product/8.1.5/dbs/orapwareDev00'</FONT>
</P>

<P><FONT SIZE=3D2>-------------------</FONT>
</P>

<P><FONT SIZE=3D2>At this point,&nbsp; I tried different ways, such as =
remove the password file and </FONT>
<BR><FONT SIZE=3D2>re-run the script, and it did not work.</FONT>
</P>

<P><FONT SIZE=3D2>Finally, I opened the initareDev00.ora file and =
changed &quot;exclusive&quot; to </FONT>
<BR><FONT SIZE=3D2>&quot;shared&quot;:</FONT>
</P>

<P><FONT SIZE=3D2>remote_login_passwordfile =3D shared</FONT>
</P>

<P><FONT SIZE=3D2>and then :</FONT>
</P>

<P><FONT SIZE=3D2>$ ./svrmgrl</FONT>
</P>

<P><FONT SIZE=3D2>Oracle Server Manager Release 3.1.5.0.0 - =
Production</FONT>
</P>

<P><FONT SIZE=3D2>(c) Copyright 1997, Oracle Corporation.&nbsp; All =
Rights Reserved.</FONT>
</P>

<P><FONT SIZE=3D2>Oracle8i Release 8.1.5.0.0 - Production</FONT>
<BR><FONT SIZE=3D2>With the Java option</FONT>
<BR><FONT SIZE=3D2>PL/SQL Release 8.1.5.0.0 - Production</FONT>
</P>

<P><FONT SIZE=3D2>SVRMGR&gt; connect internal</FONT>
<BR><FONT SIZE=3D2>Connected.</FONT>
<BR><FONT SIZE=3D2>SVRMGR&gt; startup nomount </FONT>
<BR><FONT =
SIZE=3D2>pfile=3D/u01/app/oracle/admin/areDev00/pfile/initareDev00.ora</=
FONT>
<BR><FONT SIZE=3D2>ORACLE instance started.</FONT>
<BR><FONT SIZE=3D2>Total System Global =
Area&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; 51830160 bytes</FONT>
<BR><FONT SIZE=3D2>Fixed =
Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 64912 bytes</FONT>
<BR><FONT SIZE=3D2>Variable =
Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
18030592 bytes</FONT>
<BR><FONT SIZE=3D2>Database =
Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33554432 =
bytes</FONT>
<BR><FONT SIZE=3D2>Redo =
Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; 180224 bytes</FONT>
<BR><FONT SIZE=3D2>SVRMGR&gt;&nbsp; create database areDev00</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 2&gt; controlfile =
reuse</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 3&gt; logfile</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 4&gt; GROUP 1</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 5&gt; (</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; =
6&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
'/u03/oradata/areDev00/redog101.log',</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; =
7&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
'/u03/oradata/areDev00/redog102.log'</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 8&gt; ) size 10M =
reuse,</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 9&gt; GROUP 2</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; 10&gt; (</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; =
11&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
'/u04/oradata/areDev00/redog201.log',</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; =
12&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
'/u04/oradata/areDev00/redog202.log'</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; 13&gt; ) size 10M reuse</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; 14&gt; datafile =
'/u02/oradata/areDev00/system01.dbf'</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; 15&gt; size 50M reuse autoextend =
on next 10M maxsize 200M</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; 16&gt; character set =
WE8ISO8859P1;</FONT>
<BR><FONT SIZE=3D2>/</FONT>
<BR><FONT SIZE=3D2>Statement processed.</FONT>
</P>

<P><FONT SIZE=3D2>Then I preceed to create all the tablespaces, =
rollback segments etc without </FONT>
<BR><FONT SIZE=3D2>any problem.</FONT>
<BR><FONT SIZE=3D2>--------</FONT>
</P>

<P><FONT SIZE=3D2>So my questions are:</FONT>
</P>

<P><FONT SIZE=3D2>1. Why the &quot;create database...&quot;&nbsp; =
failed when the setting was &quot;exclusive&quot;?</FONT>
<BR><FONT SIZE=3D2>2. Why it works now with &quot;shared&quot;?</FONT>
<BR><FONT SIZE=3D2>3. Am I creating any potential problems by setting =
value to &quot;shared&quot;? (We </FONT>
<BR><FONT SIZE=3D2>are not using remote client to do startup or =
shutdown anyway).</FONT>
</P>

<P><FONT SIZE=3D2>I am trying to understand what this password file =
does (I read oracle </FONT>
<BR><FONT SIZE=3D2>documentation several times but still could not =
understand what is does)</FONT>
</P>

<P><FONT SIZE=3D2>Thanks.</FONT>
</P>

<P><FONT SIZE=3D2>Guang</FONT>
<BR><FONT =
SIZE=3D2>_______________________________________________________________=
_________</FONT>
<BR><FONT SIZE=3D2>Get Your Private, Free E-mail from MSN Hotmail at <A =
HREF=3D"http://www.hotmail.com" =
TARGET=3D"_blank">http://www.hotmail.com</A></FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Guang Mei</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: zlmei_at_hotmail.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =


Received on Tue Aug 08 2000 - 07:17:12 CDT












Original text of this message













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