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

Home -> Community -> Usenet -> c.d.o.server -> Create Database Error - UNIX

Create Database Error - UNIX

From: <mike_andrew_at_usiva.com>
Date: 1998/06/22
Message-ID: <6mm7me$s3f$1@nnrp1.dejanews.com>#1/1

I am trying to create a database, being unfamiliar with UNIX systems, I usually use ORADIM73 on Windows NT. Anyway, I connected internally and startup nomount the instance and ran the create database script and got the following error:

ORA-01501: CREATE DATABASE failed
ORA-01526: error in opening file '?/dbs/sql.bsq'
ORA-07391: sftopn: fopen error, unable to open text file.

I am running Oracle (Workgroup) Server 7.2.3.2.0 and an HP-UX Server version B.10.20

Here is the following script I tried to execute:

connect internal
startup pfile=/oracle/product/732/dbs/initdev110.ora nomount

create database "DEV1"

    maxinstances 1
    maxlogfiles 16
    character set "US7ASCII"
    datafile

'/oracle/product/732/dbs/sys01.dbf' size 20M reuse
    logfile

'/oracle/product/732/dbs/redo01dev1.dbf' size 2M reuse,
'/oracle/product/732/dbs/redo02dev1.dbf' size 2M reuse,
'/oracle/product/732/dbs/redo03dev1.dbf' size 2M reuse;

Any insight would be a great help.

Thanks in advance !!

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 22 1998 - 00:00:00 CDT

Original text of this message

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