Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: password file relocation
Hi,
I had the same problem when I initially installed NT on an NT box.
I saw it has a potential security hole.
After quite a bit of work, I was able to make changes in the registry.
The registry key location is 'HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE' the key (for the default database) is 'ORA_ORCL_PWFILE'. For an instance named TEST, the key would be 'ORA_TEST_PWFILE'. The value of this key is the absolute path to the password file.
The thing I had to be careful about was to shut down the database, and associated services before 1) changing the registry, and 2) physically moving the password file. Restart the services and the database after making these changes. I am not clear why that is necessary.
On a separate note, I also tried to move the STRTORCL.CMD file but have not been able to do it. I have the services and the database setup to start when I turn the machine on and if these file is not in the default location, the database does not start. The service seems to. However, I can run the STRTORCL.CMD file from a DOS window and the database does start.
If anybody has any ideas on the STRTORCL.CMD file, I would appreciate hearing them.
Thanks,
DBAS wrote:
>
> Hi.
>
> I have an oracle 7.3.4 database installed on an NT server, on the c: drive.
> I have moved it to another server on its d: drive by backing up the control
> file to trace and copying the database files.
>
> When running the modified script from above backup to recreate the control
> files I get an ora 01991 error saying that the password file is invalid. The
> REMOTE_LOGIN_PASSWORD file entry in the original init.ora file was set to
> exclusive.
>
> Please help, I can't work this out at all. How do I move password files from
> one location to another.
>
> Cheers for any help .... Dave
Received on Fri Mar 19 1999 - 21:59:43 CST