Re: Internal oracle password

>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

Internal isn't a real user. It is provided to start and stop oracle databases.

>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

Under NT, the Internal password is given when the service is created. If none is given, then it is 'ORACLE'.

>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.

If you don't use Os authentification, you have to create a password file (ORAPWDxx) and give the users name
that can log as SYSDBA or SYSOPER. Received on Tue May 11 1999 - 07:23:10 CDT