Oracle Not starting for few minutes..

From: Praveen Gaur <pgaur007_at_indiatimes.com>
Date: 11 Dec 2001 04:45:40 -0800
Message-ID: <7d258e52.0112110445.4a1792a7@posting.google.com>

Hello,

Version=7.3.4 on WinNT-4.0
Problem Statement

ORACLE 7.3.4 installed on the machine M2 in E: drive. Already havnig a DB on seperate machine M1 in C: drive. Wish to move the DB from M1 to M2.
Steps followed :
1. Shutdown all the Oracle services on M1 and M2. 2. Create a directory C:\ORANT on M2 and copy E:\ORANT\Database in C:\ORANT

3. Start OracleService<sid> through Services.
4. Login to SVRMGR and connect internal.
5. 'startup mount' the Oracle.
6. issue following commands

alter database rename file 'e:\orant\database\log1orcl.ora' to 'c:\orant\database\log1orcl.ora'

and similar commands to more rest of REDO, SYSTEm, TEMP, RBS etc in to C:
This will mark the Oracle DB in E: to make the files be present in C:
(at this poing, initORCL.ora also modified for Control files paths to
be taken from C:)
7. Shutdown
8. startup
9 through Schema Manager of OEM, saw the path of files, now in C:

10. shutdown
11. login to SVRMGR and connect internal, startup mount.
12. Copy C:\orant\database folder of M1 in C:\orant\database of M2 and

in E:\orant\database of M2 also.
(note that internal passwd on both systems were identical).
13. startup

Everything OK and new db is now viewable.(DB transfer done, but files in C: not in E:)
14. shutdown.
15. connect internal and 'startup mount'. 16 rename datafiles from C: to E:
17. startup

again everything normal and new DB can be seen, with logfile paths in E:

BUT NOW COMES THE PROBLEM. Rebooted the machine.
ORACLE didn't come up till almost 10 minutes. but after 10 mintues, everything is OK.
NT- service DATABASE remain locked during that period. a process ORADIM73.exe remained running during this time.

Why SO MUCH OF DELAY IS THERE???

NOTE : No such delay on M1 was there.

Can somebody help out? or give reasoning for it!!

Thanx in advance. Received on Tue Dec 11 2001 - 06:45:40 CST