on 05-27-2012 3:54 PM
Hi all
We are exporting an oracle9.2 database on unix.
The database user "SAP<SAPSID>" is not "SAP" and the password of user "system" is not manager.
because we could not access the oracle database successful using sqlplus.
So.We want to change password of "SAP<SAPSID>" and "system" as below.
a. Log on as user ora<dbsid>.
b. If the password of user system is not manager, enter: sapdba -u system/<passwd> -alter_user system/manager
c. Enter: sapdba -alter_user SAP<SAPSID>/SAP
But we do not know the password of "system"!!
Please tell us can we use sql as below to change the password of "SAP<SAPSID>" and "system"??
or must use <sapdba -u system/<passwd> -alter_user system/manager>
1.log on as user root
2.su - ora<dbsid>
3.sqlplus /nolog
4.connect /as sysdba
5.sql>ALTER USER system IDENTIFIED BY "manager" ;
6.sql>ALTER USER SAP<SAPSID> IDENTIFIED BY "SAP" ;
Thanks a lot in advance.
Best regards.
Hi Akihiro
I would use point 5 as suggested. Then use the sap tools to change th other passwords
kind regards
Duncan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1. For SAP<SID> ( SAP connect user) user always use brtools to change the password as the password is also stored in SAPUSER table for workprocess to use this password when connecting.
if password is set using sql command line then password has to be set to be "SAP" as workprocess when fail to get correct password from SAPUSER table , then it will use SAP as default password.
2. For SYSTEM user , you can use either brtools or use sql command line .
Hope this helps.
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.