Change password of user "Internal"

[bluewolf]

I installed Oracle 8.1.7 and when I create a database, an user with name "Internal" and password "manager" is ready. How can I change internal's password or delete it.
I tried with: "ALTER USER internal IDENTIFIED BY test" and got an error: "user 'internal' does not exit" but I still logon SQL*Plus by this user with name and password as above. BW.

 

[lfoata]

Oracle creates a file name pwdSID.ora that is located under ORACLE_HOME/dbs directory.
Look at the command orapwd to change the password for internal.
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 DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.

File:
this option lets you specify the name of the password file. It should
containt the full path, <ORACLE_HOME>\DATABASE, and be of this format
PWD<SID>.ORA. Its content is encrypted.

 

[raygg]

It's a lot simpler than that. In 817 the INTERNAL user takes the password of the SYS user. When you code ALTER USER SYS IDENTIFIED BY FRED, FRED is then made the password for INTERNAL also.

 

[bluewolf]

I find that user INTERNAL has password is any. When I run SQL*Plus, I leave password field empty or type any thing, it accept all regardless of SYS's password changed or not. Is it a bug in Oracle 8.1.7??? (I use Oracle 8.1.7 Enterprise Edition for Windows NT download from

http://www.oracle.com)

BW.

 

[raygg]

There is a parameter that must be put into the init.ora file to address this issue - I forget what it is.

 

[rcurva]

raygg, the parameter that you must be saying is the remote_login_passwordfile

remote_login_passwordfile=EXCLUSIVE

When a database started and the remote_login_passwordfile is set to exclusive it
looks for a passwordfile in the OS. The password file has to exist in the $ORACLE_HOME/dbs
directory and its name is 'orapw<sid>'. If the instance does not find this file it
looks for the default 'orapw' file and uses it.

Create this file just like what lfoata have instructed.

 

[raygg]

Does that work, bluewolf?