Re: Password File problem

Ok sorry..
The reason I got confused was that the dbassist java tool that comes with Oracle 8i
Enterprise creates the orapwOFGUI password file for you (and doesn't mention it). When I ran the scripts the old fashioned way, it didn't like the old orapwOFGUI file for whataver reason. The exact message was the same as below except it said it couldn't open "orapwOFGUI", which was a file that was present from before.
I renamed it, and the message was similar but I don't recall exactly what it was, maybe it
was looking for "orapw"? Anyway I used orapwd and am not having a problem now.
I guess an addendum would be if you recreate the database must you re-create the password file - does some part of Oracle recognize that it has users in it that don't exist? (yet) I suppose my posting was misleading..I hope it wasn't too silly a question.
I apologize..
- Dc.

Sybrand Bakker wrote:

> Of course you can't add users to a public password file, because by taking
> out the parameter it went back to it's default NONE which means 'don't use
> the passwordfile!'
> While the orapwd utility gives the impression you can choose any filename
> for the passwordfile you actually can't.
> It should always be named orapw<SID>
> It would have been helpful if you would have posted the exact message.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> Doug Cowles <dcowles_at_nospambigfoot.com> wrote in message
> news:385B4A09.D848EBAB_at_nospambigfoot.com...
> > I'm having a password file problem after re-creating a database.
> > I shutdown the old database and removed all the redo, data, and
> > control files. I then re-created the database with the same SID
> > name but with less features. (Didn't run a lot of scripts for the
> > special options like intermedia etc.,)
> > When trying to create the database, I got a failure because
> >
> > ORA-01990: error opening password file '/u01 etc.,
> > Granted, the file doesn't appear to exist, but I've never run into
> > this before. I found a line in the init.ora file that I had
> > put in weeks ago
> > remote_login_passwordfile = exclusive.
> > I took it out and now the database has been created and runs.
> > But, I cant add users to a "public" password file.
> > What am I missing?
> >
> > I don't recall ever HAVING to run orapwd when creating a database.
> >
> > - Dc.
> >

Received on Sat Dec 18 1999 - 19:51:52 CST