cancel
Showing results for 
Search instead for 
Did you mean: 

About oracle9.2 user's pw change with database export on unix

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

barclay_duncan
Explorer
0 Kudos

Hi Akihiro

I would use point 5 as suggested. Then use the sap tools to change th other passwords

kind regards

Duncan

Former Member
0 Kudos

Hi Duncan

Really thanks a lot.

We have changed the password with you advices.

Best regards,

Akihiro

Answers (1)

Answers (1)

former_member189725
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Ratnajit

Really thanks a lot.

We changed the system password using sqlplus and changed password of SAP<SID> using brtools.

Best regards,

Akihiro