Message-Id: <10682.122230@fatcity.com> From: Suganya Date: Thu, 16 Nov 2000 17:45:34 +0530 Subject: URGENT - create database --------------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@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@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 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@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@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