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

Home -> Community -> Mailing Lists -> Oracle-L -> URGENT - create database

URGENT - create database

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Thu, 16 Nov 2000 17:45:34 +0530
Message-Id: <10682.122230@fatcity.com> 




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





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'



for this i separately created the orapwd file command and executed still
it is giving the


same problem .


Regards


suganya



"Sackwitz, Antje" wrote:



> Hi,

> we also got a Sybase database in our company and I never worked with Sybase

> before.

> Can anyone recommend some documentation for someone who knows Oracle?

> Is there a Sybase mailing list as well?

> I'm also seekin gfor a document on the differences between Oracle, Sybase,

> Informix, PostGres(, Access  maybe) also and for what situation  which is

> the best database.

>

> Regards,

> Antje

> --

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

> --

> Author: Sackwitz, Antje

>   INET: Sackwitz_at_vst.vossloh.de

>

> 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).



--------------FF33ED0FA2D285B416F5CFAB
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; I didn't get the error number also in the orafaq please any
one help and tel me a solution for it

<br>&nbsp;&nbsp;
<br><font color="#3333FF">SVRMGR> startup nomount pfile =</font>
<br><font color="#3333FF">/sora01/app/oracle8i/product/8.1.5/admin/ford/pf</font>
<br><font color="#3333FF">ile/initgalaxydb.ora</font>
<br><font color="#3333FF">ORACLE instance started.</font>
<br><font color="#3333FF">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="#3333FF">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="#3333FF">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="#3333FF">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="#3333FF">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="#3333FF">SVRMGR> create database galaxydb</font>
<br><font color="#3333FF">&nbsp;&nbsp;&nbsp;&nbsp; 2> controlfile reuse</font>
<br><font color="#3333FF">&nbsp;&nbsp;&nbsp;&nbsp; 3> datafile '/sora01/oradata/galaxydb/gxysystem.dbf'


size 128M</font>

<br><font color="#3333FF">AUTOEXTEND O</font>
<br><font color="#3333FF">FF</font>
<br><font color="#3333FF">&nbsp;&nbsp;&nbsp;&nbsp; 4> maxdatafiles 400</font>
<br><font color="#3333FF">&nbsp;&nbsp;&nbsp;&nbsp; 5> maxinstances 8</font>
<br><font color="#3333FF">&nbsp;&nbsp;&nbsp;&nbsp; 6> maxlogfiles 32</font>
<br><font color="#3333FF">&nbsp;&nbsp;&nbsp;&nbsp; 7> logfile group 1 ('/sora01/oradata/galaxydb/redo1_1.log',</font>
<br><font color="#3333FF">&nbsp;&nbsp;&nbsp;&nbsp; 8> '/sora01/oradata/galaxydb/redo1_2.log')


size 5M REUSE,</font>


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


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

<br><font color="#3333FF">&nbsp;&nbsp;&nbsp; 13> noarchivelog;</font>
<br><font color="#3333FF">create database galaxydb</font>
<br><font color="#3333FF">*</font>
<br><font color="#3333FF">ORA-01501: CREATE DATABASE failed</font>
<br><font color="#3333FF">ORA-01990: error opening password file</font>
<br>'/sora01/app/oracle8i/product/8.1.5/dbs/o
<br>rapw'
<p>for this i separately created the orapwd file command and executed still
<br>it is giving the
<br>same problem .
<br>Regards
<br>suganya
<p>"Sackwitz, Antje" wrote:
<blockquote TYPE=CITE>Hi,
<br>we also got a Sybase database in our company and I never worked with


Sybase

<br>before.
<br>Can anyone recommend some documentation for someone who knows Oracle?
<br>Is there a Sybase mailing list as well?
<br>I'm also seekin gfor a document on the differences between Oracle,


Sybase,


<br>Informix, PostGres(, Access&nbsp; maybe) also and for what situation&nbsp;
which is

<br>the best database.
<p>Regards,
<br>Antje
<br>--
<br>Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a>
<br>--
<br>Author: Sackwitz, Antje
<br>&nbsp; INET: Sackwitz_at_vst.vossloh.de
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;


FAX: (858) 538-5051



<br>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --
Public Internet access / Mailing Lists

<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message
<br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in


<br>the message BODY, include a line containing: UNSUB ORACLE-L
<br>(or the name of mailing list you want to be removed from).&nbsp; You
Received on Thu Nov 16 2000 - 06:15:34 CST












Original text of this message













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