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 - create database

Re: URGENT - create database

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Fri, 17 Nov 2000 15:22:47 +0530
Message-Id: <10683.122353@fatcity.com> 




--------------91B09A9E7CB422B1E2897285
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit





Hi all


   Thanks a lot .


   I am able to start the database after making a entry .


               remote_logon_passwordfile = none.




Regards


Suganya



Hi all


>   I didn't get the error number also in the orafaq please any one help and

tel


> me a solution for it

>

> SVRMGR> startup nomount pfile =

> /sora01/app/oracle8i/product/8.1.5/admin/ford/pf

> ile/initgalaxydb.ora

> ORACLE instance started.

> Total System Global Area                         36683152 bytes

> Fixed Size                                          64912 bytes

> Variable Size                                    19668992 bytes

> Database Buffers                                 16777216 bytes

> Redo Buffers                                       172032 bytes

> SVRMGR> create database galaxydb

>      2> controlfile reuse

>      3> datafile '/sora01/oradata/galaxydb/gxysystem.dbf' size 128M

> AUTOEXTEND O


> FF

>      4> maxdatafiles 400

>      5> maxinstances 8

>      6> maxlogfiles 32

>      7> logfile group 1 ('/sora01/oradata/galaxydb/redo1_1.log',

>      8> '/sora01/oradata/galaxydb/redo1_2.log') size 5M REUSE,

>      9> group 2 ('/sora01/oradata/galaxydb/redo2_1.log',

>     10> '/sora01/oradata/galaxydb/redo2_2.log') size 5M REUSE,

>     11> group 3 ('/sora01/oradata/galaxydb/redo3_1.log',

>     12> '/sora01/oradata/galaxydb/redo3_2.log') size 5M REUSE

>     13> noarchivelog;

> create database galaxydb

> *

> ORA-01501: CREATE DATABASE failed

> ORA-01990: error opening password file

> '/sora01/app/oracle8i/product/8.1.5/dbs/o

> rapw'

>









--------------91B09A9E7CB422B1E2897285
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>


Hi all

<br>&nbsp;&nbsp; <font color="#FF0000"><font size=+1>Thanks a lot .</font></font>
<br>&nbsp;&nbsp; I am able to start the database after making a entry .
<br><font color="#660000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


remote_logon_passwordfile = none.</font>

<br><font color="#660000">&nbsp;</font><font color="#660000"></font>
<p><font color="#000000">Regards</font>
<br><font color="#000000">Suganya</font><font color="#660000"></font>
<p><font color="#660000">Hi all</font>
<br><font color="#660000">>&nbsp;&nbsp; I didn't get the error number also


in the orafaq please any one help and</font>

<br><font color="#660000">tel</font>
<br><font color="#660000">> me a solution for it</font>
<br><font color="#660000">></font>
<br><font color="#660000">> SVRMGR> startup nomount pfile =</font>
<br><font color="#660000">> /sora01/app/oracle8i/product/8.1.5/admin/ford/pf</font>
<br><font color="#660000">> ile/initgalaxydb.ora</font>
<br><font color="#660000">> ORACLE instance started.</font>
<br><font color="#660000">> Total System Global Area&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


36683152 bytes</font>


<br><font color="#660000">> Fixed Size&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;&nbsp;&nbsp;&nbsp;
64912 bytes</font>


<br><font color="#660000">> Variable Size&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;
19668992 bytes</font>


<br><font color="#660000">> 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;
16777216 bytes</font>


<br><font color="#660000">> 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;
172032 bytes</font>


<br><font color="#660000">> SVRMGR> create database galaxydb</font>
<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2> controlfile
reuse</font>


<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3> datafile '/sora01/oradata/galaxydb/gxysystem.dbf'
size 128M</font>

<br><font color="#660000">> AUTOEXTEND O</font>
<br><font color="#660000">> FF</font>
<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4> maxdatafiles


400</font>


<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5> maxinstances
8</font>


<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6> maxlogfiles
32</font>


<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7> logfile group
1 ('/sora01/oradata/galaxydb/redo1_1.log',</font>
<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8> '/sora01/oradata/galaxydb/redo1_2.log')
size 5M REUSE,</font>


<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9> group 2 ('/sora01/oradata/galaxydb/redo2_1.log',</font>
<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp; 10> '/sora01/oradata/galaxydb/redo2_2.log')
size 5M REUSE,</font>


<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp; 11> group 3 ('/sora01/oradata/galaxydb/redo3_1.log',</font>
<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp; 12> '/sora01/oradata/galaxydb/redo3_2.log')
size 5M REUSE</font>

<br><font color="#660000">>&nbsp;&nbsp;&nbsp;&nbsp; 13> noarchivelog;</font>
<br><font color="#660000">> create database galaxydb</font>
<br><font color="#660000">> *</font>
<br><font color="#660000">> ORA-01501: CREATE DATABASE failed</font>
<br><font color="#660000">> ORA-01990: error opening password file</font>
<br><font color="#660000">> '/sora01/app/oracle8i/product/8.1.5/dbs/o</font>
<br><font color="#660000">> rapw'</font>
<br><font color="#660000">></font>


Received on Fri Nov 17 2000 - 03:52:47 CST












Original text of this message













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