Re: Create Database Error - UNIX

I have applied every permission thinkable to the directories and files that are used. In article <01bd9ec1$91014c20$5b0437a6_at_raghus-computer>, "rok" <rok_at_MCI2000.com> wrote:

>
> Make sure that you have write permissions to create the files.
>
> raghuvir
>
> mandrew_at_my-dejanews.com wrote in article
> <6mog6f$j7r$1_at_nnrp1.dejanews.com>...
> > an echo $ORACLE_HOME returns the path, so the environment variable has
 been
> > set. This problem is absolutely killing me !!
> >
> > In article <6mmbbm$1bs$1_at_news-2.news>,
> > jrinusa_at_don't-send-spam.gte.net wrote:
> > >
> > > I think you don't have the ORACLE_HOME environment variable set
> > > correctly ... depending on the shell you're running on UNIX, this OS
> > > level command might help if you run it first:
> > >
> > > export ORACLE_HOME=/oracle/product/732/
> > >
> > > Note : THIS IS SPACE CRITICAL - don't put any spaces around the =
> > > sign!
> > >
> > > Hope that helps
> > >
> > > JR
> > >
> > > mike_andrew_at_usiva.com wrote:
> > >
> > > >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
> > >
> > >
> >
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/ Now offering spam-free web-based newsreading
> >
>

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