Re: UNIX create database problems HELP!!!

mandrew_at_my-dejanews.com wrote:

>I want to create a new database and I will list every step I have done.
>
>$ ORACLE_SID=devl
>$ export ORACLE_SID
>$ echo $ORACLE_SID
>devl
>$ svrmgrl
>Server Manager version ...
>
>SVRMGR>connect internal
>connected to an idle instance
>SVRMGR>startup pfile=/oracle/product/732/dbs/initdevl.ora nomount;
>ORACLE instance started.
>Total System Global Area 4424576 bytes
>Fixed Size 38904 bytes
>Variable Size 4086664 bytes
>Database Buffers 102400 bytes
>Redo Buffers 196608 bytes
>SVRMGR> create database;
>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 trying to just create a simple database. Before I was running scripts
>that specified logfiles and datafiles, now I just want to see if it works and
>so far it does not.
>
>I would really appreciate help and advice. As you probably can tell I am not
>at all comfortable with UNIX and would much rather accomplish this using
>ORADIM73.
>
>Thank You in advance.
>Mike
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

This looks like it might be a privilege problem. Are you logged in as ORACLE when trying to start up the database? If so, make sure you have access to the ORACLE_HOME directory tree.

David
David Greensmith :-)
(david_at_green1.demon.co.uk) Received on Wed Jul 01 1998 - 00:00:00 CDT