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 -> Re: Create Database Error - UNIX

Re: Create Database Error - UNIX

From: Joel Garry <joelga_at_pebble.org>
Date: 1998/06/24
Message-ID: <slrn6p2ngu.94i.joelga@pebble.org>#1/1

On Tue, 23 Jun 1998 18:53:04 GMT, mandrew_at_my-dejanews.com <mandrew_at_my-dejanews.com> wrote:
>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.

and be sure Oracle is:

-rwsr-s--x 1 oracle dba ...

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

-- 
These opinions are my own and not necessarily those of Information Quest
or Pebble In The Sky                     http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.
Received on Wed Jun 24 1998 - 00:00:00 CDT

Original text of this message

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