I must be missing something: the error message you got was that you couldn't
create the database because you couldn't be authenticated as a privileged
user because the password file was 'missing' (presumed non-existent). So
create the password file, or create the symbolic link, and all should be
well. If it isn't, then something else is going on -but you'll get another
error message (we hope!), and you can let me know what that is if and when
you get it.
Regards
HJR
--
Resources for Oracle: http://www.hjrdba.com
===============================
"stevek" <stefano1_at_att.net> wrote in message
news:3C06FFF6.EC78A7A4_at_att.net...
> Thanks for the input, but what about the error. Do you have any solution
> to that?
>
>
> "Howard J. Rogers" wrote:
> >
> > The file has to be in that location, I'm afraid -unless you start using
> > symbolic links to the actual location, leaving a link behind in the
default
> > one.
> >
> > Regards
> > HJR
> > --
> > Resources for Oracle: http://www.hjrdba.com
> > ===============================
> >
> > "stevek" <stefano1_at_att.net> wrote in message
> > news:3C06E1C0.DAB5FA22_at_att.net...
> > >
> > > Trying to create a new database and continue to get the below error.
> > >
> > > ORA-01501: CREATE DATABASE failed
> > > ORA-01990: error opening password file
'/u01/oracle/OraHome1/dbs/orapw'
> > >
> > > looked up in Oracle manual which states
> > >
> > > ORA-01990 error opening password file 'string'
> > > Cause: An attempt to open the specified password file failed because
of
> > > one of
> > > the following errors:
> > > n An operating system error occurred.
> > > n ORAPWD is already running, so the password file is locked.
> > > The environment variables ORA_sid_PWFILE and ORA_PWFILE are not set.
> > >
> > > Set both variables without any success. How do I tell oracle that I
> > > would like
> > > orapw or oradev1pw placed someplace other than Oracle_Home/dbs/?
> > >
> > > Thanks in advance
Received on Thu Nov 29 2001 - 23:14:57 CST
