List hi!
Oracle 8.1.7 on WinNT.
Our Windows guys want to rename disc drives for some administration reasons.
I'm really in UNIX so I'm wondering could you give me some advices on this
matter.
As far as I know, I have to recreate control files, with new drives. Is
there anything else I should do?
Sonja,
It is a complicated process to rename disk drives in the Oracle environment.
Depending in the drives that Oracle uses and what are changes(renamed) could really
cause you frustration.
The initxxx.ora lists the current location of the controlfiles, logfiles, dump dirs,
trace dirs, etc.
Ron,
When you say log files in the init.ora I assume you mean archive log files.
(Mr. P. Dantic)
Anyway, getting back to the task at hand, a far easier way to do it is to
issue a backup controlfile to trace. Change the location of the files in the
trace file you have generated, shutdown the DB,
If by "rename disk drives" means changing the drive letter where Oracle is
installed. You may have to re-install Oracle since the regisry will now
have the wrong values.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio
]
Sent by: cc:
root@fatcity.Subject: Oracle8i on WinNT - renaming
disc drives
If they're just renaming the disks where the datafiles reside, then the
backup controlfile is the way to go.
However, if they're renaming the disk where the Oracle Home resides, then
you need to go edit the registry. Be sure and make a backup of the
registry before you start the edit.
Unasked,