Re: Insufficient Privileges with '/ as sysdba'

From: Ravi <ravisista_at_hotmail.com>
Date: 21 Sep 2004 07:57:58 -0700
Message-ID: <2724afff.0409210657.70a08078@posting.google.com>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<414ce348$0$20129$afc38c87_at_news.optusnet.com.au>...

> Re-creating a password file does not require the database to be shut down,
> for the very simple (and obvious) reason that if it did, how would you
> connect to the database in order to issue the shutdown command?!
>
> Just delete it, and use orapwd to re-create it. No shutdown necessary.

I don't mean to question your intelligence here, Howard. Consider this more like additional/related info. When I submitted a TAR with Oracle about the exact same issue last month, this is what I was told (and I quote)

---

"3.If so, can I recreate it with the database being up or do I have to shut it
Ans: Database needs to be shutdown

Here are the step to recreate password file:

To Replace a Password File

---

Note which users have SYSDBA or SYSOPER privileges by querying the V$PWFILE_USERS view.

Shut down the database.

Delete the existing password file.

Follow the instructions for creating a new password file using the ORAPWD utility in "Using ORAPWD". Be sure to set the ENTRIES parameter to a sufficiently large number.

Follow the instructions in "Adding Users to a Password File". "

---

And when asked for confirmation, this is what I was told (and I quote again).

---

"As far as Recerating the password file is concerned, then the process is to SHUTDOWN the database and if not done, then if any problems after that won't be supported."

---

--
Regards,
Ravi Sista

Received on Tue Sep 21 2004 - 09:57:58 CDT