RE: 9i upgrade problems

Charlie,

The error indicates that the OS does no believe that the file exists. Have you verified its existence from the OS?

If it exists.... make sure permissions are set correctly so that it can be opened by 'oracle'.

I have not tried the migration to 9i, so I am not sure if this a known issue on your platform. You may want to try Metalink if that is an option.

My guess, would be that after performing the necessary transactions, the migration script attempted to drop the tablespace and something went wrong.

Since the tablespace was only used for migration... can you drop it? Try startup mount, alter database datafile <datafile name> offline drop... then try dropping the tablespace including contents.

If you cannot drop the tablespace, then check the status of the data file in dba_data_files. If it still shows as available, you can trick oracle be telling it to create the data file again with the alter database create datafile.... and then drop the tablespace.

HTH -Ron-

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Charlie
> Mengler
> Sent: Saturday, October 20, 2001 3:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 9i upgrade problems
>
>
> I am/was trying to upgrade an 8.1.7 to 9i.
> The odma wizard process seemed to have completed without errors.
> However when I try to start the instance I get the message below.
>
> It appears ODMA created its own Roll Back Segment, but did not
> completely clean up after itself.
>
> Any suggestions WRT how I can get the instance up?
>
> sys_at_EDWDEV.WORLD> ORA-01116: error in opening database file 52
> ORA-01110: data file 52:
> '/u01/app/oracle/product/9.0.1/assistants/dbma/log/EDWDEV/ODMA_RBS.dbf'
> ORA-27041: unable to open file
> SVR4 Error: 2: No such file or directory
> Additional information: 3
> sys_at_EDWDEV.WORLD> Disconnected from Oracle9i Enterprise Edition Release
> 9.0.1.0.0 - Production
> With the Partitioning option
> JServer Release 9.0.1.0.0 - Production
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron  Yount
  INET: ronwy_at_swbell.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).