Re: Cannot change INTERNAL password?!

Hi,

I'm not sure, but I think you'll need a password-file, which is not created, when you leave the internal password blank. The password- file contains the internal-password and is not stored in the DB, because you should connect to the DB without having the instance started.
You can create the password-file with some of the shipped Oracle tool ORAPWD

Copied from the Documentationm which can be found under Administrator_Guide/ Index/ creating password files.

   orapwd
Usage: orapwd file=<fname> password=<password> entries=<users>

      where
        file - name of password file (mand),
        password - password for SYS and INTERNAL (mand),
        entries - maximum number of distinct DBAs and OPERs (opt),
      There are no spaces around the equal-to (=) character.

For example, the following command creates a password file named ACCT.PWD that allows up to 30 privileged users with different passwords. The file is initially created with the password SECRET for users connecting as INTERNAL or SYS:

    ORAPWD FILE=acct.pwd PASSWORD=secret ENTRIES=30

Hope that helped,

bye
Uli

> Install Linux 8.0.5 for Linux in RedHat 6.0. Installation is ok, but
> during setup, I chose not to assign a password to 'INTERNAL' user, so I
> don't have to type password when do 'connect internal' in 'svrmgrl'.
> (There's also no prompt for password)
>
> After installation, I tried to assign a password: 'svrmgrl', then
> 'connect internal', and 'alter user sys identified by xxxx'. No error
> message, but next time when I use 'svrmgrl' and 'connect internal',
> there's still no password prompt, therefore I can log in directly.
>
> What did I do wrong? Help please, kind of emergency!!!!
>
Received on Tue Nov 09 1999 - 03:59:27 CST