Oracle-L: RE: Unable to start database, Oracle 8.16 on Windows NT 4.0 Serv

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Wed, 19 Jun 2002 13:04:02 -0800
Message-ID: <F001.00481E79.20020619130402@fatcity.com>

Do a startup mount, rename the datafile and open the database.

SQL> startup mount;
SQL> alter database rename 'H:\oracle\retail.dbf' to 'I:\oracle\retail.dbf';
SQL> alter database open;

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456

-----Original Message-----
Sent: Wednesday, June 19, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L

Hey all,
I have an oracle database Oracle 8.1.6 installed on Windows NT 4.0 server. Recently I reorganized my hard disk to add more logical drives and in the process the operating system moved my existing logical drive (H:) to new drive (I:) and drive H: now represent my CD-ROM drive.

When I try to start oracle database using svrmgrl. I get the error messages as it tries to read a tablespace file from H:\oracle\retail.dbf, but as now the new H: drive represents local CD-ROM, so the process fails. Please note that I have the same required tablespace file available on drive I:\oracle\retail.dbf. Incidentally there is only one tablespace (H:\oracle\retail.dbf) causing the problem and rest of the tablespaces are on the other drive for which the drive number has not changed. As this tablespace is not very important to me, so I would like to start database somehow even if it is without this tablespace in question.

Any suggestion.
Thanks in advance.

Dharminder Kumar

<FONT SIZE =

1>**************************************************************************

**
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer.</FONT>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kumar, Dharminder
INET: Dharminder.Kumar_at_bmonb.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: Fink, Dan
INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------