Re: How to name the password?

Rauf Sarwar wrote:

> tgiridhar_at_yahoo.com (giridhar) wrote in message news:<c7b5ba55.0304240814.5fcdde0f_at_posting.google.com>...
> > The password file is made up of two parts, the prefix orapw and the <sid>. You
> > must make sure the sid's case matches that of the environment variable
> > ORACLE_SID.
> >
> > For example, if the environment variable ORACLE_SID=TEST and the password
> > file is name is orapwtest then you will encounter the ORA-01990. To correct
> > the problem, rename the passwordfile to PWDTEST and then restart the database.
>
> I think you are mixing Unix and Windows... A grave sin by itself.
>
> On Unix it is orapw<sid> and On Windows it is pwd<sid>.ora. Case
> doesn't matter on Windows but it does on *nix.
>
> Regards
> /Rauf Sarwar

That appears to be the case too with respect to the file's location. On windows in $ORACLE_HOME\database, on UNIX at $ORACLE_HOME/dbs.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
(remove one 'x' from my email address to reply)