Enterprise Portal J2EE - Lost Oracle passwords

[Former Member]

Hi

Our client has a prior installation of EP 6.0 SP2 on Oracle 9.2 on

Windows 2000 implemented by another vendor.

In order to upgrade to EP 7.0 on Oracle 10g AIX 5.3 eventually, we

understand that there is an intermediate step for migration from EP 6.0

SP2 to Netweaver04 platform EP 6.0 SP9 and above.

During the migration steps described in:

https://www.sdn.sap.com/irj/sdn/nw-portal?rid=/webcontent/uuid/8081bf16-7849-2a10-7e94-972971933283

one of the steps is to hook up the target EP 6.0 SP9 system to the EP

6.0 SP2 source system databases by changing tnsname.ora file. This

connection requires the Oracle SYS and other administrator passwords

which the client no longer has.

Please advise on how to change the passwords or retrieve the passwords

without affecting the EP services. We have tried to reset the

passwords, which no longer allows EP to be started up after that. Since

the source system is part of the production support landscape, it must

be up and running while the project continues to upgrade on the test

target system.

I have seen thread:

but it appears to apply for R/3 or ECC only. Will this work the same way for EP with J2EE engine only?

Thank you!

[Former Member]

... and by the way, to avoid possible misunderstandings:

Don't change sapsr3db's password that way.

Use brconnect instead.

[stefan_koehler]

Hello Joe,

>Don't change sapsr3db's password that way.

>Use brconnect instead.

In a java envrionment you can also not use brconnect.

The password for SAPSR3DB is stored in the secure store and will not be changed through brconnect in that store.

Take a look at here:

http://help.sap.com/saphelp_nwce10/helpdata/en/ec/9432d189c445cdacdc7e520981b4b6/content.htm

So for the java environment:

1) Change password of SAPSR3DB (with sqlplus or brconnect)

2) Set new password in the secure store like described in the link above

Regards

Stefan

[Former Member]

Hello Stefan,

thanks for correcting.

You are right; Sap note 562863 does say so as well.

(I didn't read it thoroughly enough, obviously.)

regards

[Former Member]

Hello,

this other thread is about SAP passwords. It's useless regarding Oracle passwords.

If installation has been done according to SAP guides and good practice, you should be able to do this:

1) Log on to Unix as user ora<sid>.

2) You may connect to Oracle without any password like this:

sqlplus "/ as sysdba"

You are connected as user sys now.

3) Now change password of sys and system:

alter user system identified by new_pw;

hope this helps

Edited by: Joe Bo. on Oct 15, 2008 1:29 PM

(noticed my error: not windows, but Unix)