Re: Internal oracle password

Chris,

    Let me try to help you . All that you have to do is run the orapwd utility. To get a glimpse of the parameters you have to supply this executable with , just type down orapwd followed by a return. You should get help on its usage.

Then you have to add an entry into your init<instance-nmae>.ora file, that is REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE. Now restart your database and then log on to svrmgr l. Now you can simply say GRANT SYSDBA TO SYSTEM
This should do the trick hopefully.

sherwin
SIEMENS Chris Call wrote:

> I have a couple of questions that I have wondered about for a while. When I
> install, I have a user auto created called internal that I can use to do
> anything in the database with (startup, shutdown, etc). How can I change
> the password for internal? Also, before I do that I want to give my system
> user (or another user for that matter) full DBA privleges so he can startup
> and shutdown the database. When I try to shutdown the database now as
> system, I get ORA-01031: insufficient privileges. I have tried giving the
> roll DBA, SYSDBA and neither seem to solve the problem. I am sure this is
> probably an easy thing to do.
> Also, what needs to happen so I could log like connect / as sysdba; I
> currently cannot do this and am wondering what I need to do.
>
> Thanks for the help.
Received on Tue May 11 1999 - 06:59:34 CDT