How to change internal password

[anuj]

Hi
I am facing one problem and i am not clear about this.
when i give connect internal@dbname from the svrmgr propmt.
i have installed typical installtion of Oracle8.1.7 on windows NT.

I have changed sys password, as my understaing internal is alias of sys.
but still i am able to from svrmgr prompt as internal.

i want to change the Internal password. what i have to do for that.

regards
Anuj

[hsbdba]

Internal is another user not same as sys , once you would like to change it you have to delete using oradim80 in winnt
and then create new one.

hsbdba

[nabaig]

I thought that ORADIM is for creating/deleting instance/services and RAPWD for changing internal passwords.

Nizar

[Raminder]

Hi Anuj

Create password file by using ORAPWD utility.
The password you specify while creating pwd file will be password for the internal and sysdba user.

[julian]

Originally posted by Raminder
Hi Anuj

Create password file by using ORAPWD utility.
The password you specify while creating pwd file will be password for the internal and sysdba user.

Neither internal nor sysdba is a user. Internal for example is an alias for sys.

[shailendra]

You have to run the ORAPWD Utility to change the password but this is not sufficient you also have to do the following

Go To
start >> programs >> Administrative Tools >> User Manager For Domain

You will have a group i.e ORA_DBA you just Remove its all member and see will it work or not?

It should work.

[Raminder]

Originally posted by Julian:

quote:
--------------------------------------------------------------------------------
Originally posted by Raminder
Hi Anuj

Create password file by using ORAPWD utility.
The password you specify while creating pwd file will be password for the internal and sysdba user.


--------------------------------------------------------------------------------


Neither internal nor sysdba is a user. Internal for example is an alias for sys.

Excerpt from
http://otn.oracle.com/docs/products/...6/dba.htm#1207

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 SYSOPER or SYSDBA:

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

Following are descriptions of the parameters in the ORAPWD utility.
---------------
--------------
PASSWORD
This parameter sets the password for SYSOPER and SYSDBA. If you issue the ALTER USER statement to change the password after connecting to the database, both the password stored in the data dictionary and the password stored in the password file are updated. The INTERNAL user is supported for backwards compatibility only. This parameter is mandatory.

ENTRIES
---------------------

What say you Julian?

[julian]

Originally posted by Raminder
Originally posted by Julian:

quote:
--------------------------------------------------------------------------------
Originally posted by Raminder
Hi Anuj

Create password file by using ORAPWD utility.
The password you specify while creating pwd file will be password for the internal and sysdba user.


--------------------------------------------------------------------------------


Neither internal nor sysdba is a user. Internal for example is an alias for sys.

Excerpt from
http://otn.oracle.com/docs/products/...6/dba.htm#1207

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 SYSOPER or SYSDBA:

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

Following are descriptions of the parameters in the ORAPWD utility.
---------------
--------------
PASSWORD
This parameter sets the password for SYSOPER and SYSDBA. If you issue the ALTER USER statement to change the password after connecting to the database, both the password stored in the data dictionary and the password stored in the password file are updated. The INTERNAL user is supported for backwards compatibility only. This parameter is mandatory.

ENTRIES
---------------------

What say you Julian?

I would say again the same: Internal is an alias for SYS, SYSDBA and SYSOPER are previligies, not users.