Re: Startup, help.

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: 1997/07/22
Message-ID: <01bc96d4$74582c60$b482f1c3@worldonline>#1/1

Hello Georget,
Are you sure qaora is the owner, and did you start the DB as qaora ?

You might try to fix it with a copy and rename:

$cp /rdbms/oracle7/dbs/systQA1.dbf' /rdbms/oracle7/dbs/system.dbf

and rename it:

SVRMGR>startup mount
alter database rename file '/rdbms/oracle7/dbs/systQA1.dbf'

to '/rdbms/oracle7/dbs/system.dbf'

Good luck,

Roelof

-- 
R. Schierbeek, DBA
The Hague, Holland
email: bytelife@worldonline.nl     http://www.worldonline.nl/~bytelife

georget <georget_at_genesyslab.com> wrote in artikel
<33D426B0.523110C9_at_genesyslab.com>...


> SVRMGR> startup 

> ORACLE instance started.

> Total System Global Area       6517740 bytes

> Fixed Size                       39696 bytes

> Variable Size                  4397276 bytes

> Database Buffers               2048000 bytes

> Redo Buffers                     32768 bytes

> Database mounted.

> ORA-01157: cannot identify data file 1 - file not found

> ORA-01110: data file 1: '/rdbms/oracle7/dbs/systQA1.dbf'

> SVRMGR> exit

> 

> bash$ ls -l /rdbms/oracle7/dbs/systQA1.dbf 

> -rw-r--r--   1 qaora    dba      1638912 Jul 21 17:56

> /rdbms/oracle7/dbs/systQA1.dbf

> 

> I'm clueless, what's up???

> Thanks.

Received on Tue Jul 22 1997 - 00:00:00 CDT