oracle with invalid username & password ?

[carlos_zhang3]

Dear experts,

I am trying to follow the standard system copy guide document to 'clone' my 'Q19' system to my simulate target system 'C11'.

And now i already copy the whole Q19 database into C11 database.

I used the following command to test the oracle database :

sqlplus /nolog

connect /@C11;

It works. But when i am going to use "r3trans -x" this command, it showed me the error information like that :

This is r3trans version 6.09 (release 640 - 02.08.04 - 16:35:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'C11'"

r3trans finished (0012).

When i try to startup the SAP instance, the syslog told me that the DB can not be connected due to the invalid username & password.

Database: > ORA-01017: invalid username/password; logon denied

I checked this on SAP Notes as well, the answer is that there has wrong OPS$ user settings, right ?

Has someone can give me some useful advises ?

Many thanks

Carlos

[Former Member · Accepted solution]

Hi,

1. Ensure ops$ settings are proper. Note: 400241

2. Check the environment variable dbs_ora_schema. It should point to the schema of the souce system as your target system schema will change after system copy.

Regards,

Kiran