Re: Create Database Error - UNIX

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 Received on Tue Jun 23 1998 - 00:00:00 CDT