Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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