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

[Former Member]

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.

[Former Member]

Hello,

You are right. Follow the below steps to reset the SYSTEM password:

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" ;

I have never reset the SAP<SID> password myself, but see if the commande works for you:

ALTER USER SAP<SAPSID> IDENTIFIED BY "SAP" ;

But remember to execute the following command through ora<dbsid> to maintain consistency of sap<sid>

brconnect -f chpass -o sap<sid> -p <new_password>;

Regards,
Sonia