ORA-01920 user name SAPR3 conflicts

[Former Member]

I am stuck at sapinst phase CREATE DATABASE SCHEMA where sapinst is running a script named oradbusr.sql and getting following errors.

I am creating a new Training box by using database copy method from Production. Oracle DBA team has imported the database and DB is up and running when I started sapinst.

Platform = AIX/Oracle 10.2.0.2

Sapinst: ERP 2005 SR2.

Source : Production: SID=SA3, DBSID=SA3 and SCHEMA=SAPR3

Target : Training box: SID=TR2, DBSID=TR2 and SCHEMA=SAPR3

So we want to only change the SID not the Schema ID.

The last error that I am getting are these in the SAPINST running directory:

ERROR at line 1:

ORA-28007: the password cannot be reused

ORA-06512: at "SYS.DBMS_SYS_SQL", line 906

ORA-06512: at "SYS.DBMS_SQL", line 39

ORA-06512: at line 102

ORA-01920: user name SAPR3 conflicts with another user or role name

[former_member184473 · Accepted solution]

Hello Panwar,

As you mentioned in the OSS message, the ISEC was preveting the password to be reused.

Is this correct?

Regards,

Eduardo Rezende

[Former Member · Accepted solution]

Yes, we solved that last night.

We have not got new problem at post load activity step

Now error at a new step and we are stuck again. ORA-12705: Cannot accessNLS Cannot connect to oracle.

Reason is that on Traget TR2: NLS_LANG=AMERICAN_AMERICA.US7ASCI

This is what we chose when starting installation.

Where as on source SA3 it was: NLS_LANG=AMERICAN_AMERICA.US7ASCII

Please suggest if we can do anything at the moment.

[sivakumar_kilari3 · Accepted solution]

Hi,

Use the ALTER SESSION statement to set NLS_LANGUAGE

ALTER SESSION SET NLS_LANGUAGE=xxxxxxxxxx;

Find this site.

[http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch3globenv.htm#i1006480]

Thanks

Siva

[Former Member · Accepted solution]

We set the correct NLS in .dbenv.csh profile and it worked well.

It was a fault of sapinst for SR2.

Closing the thread.

[Former Member · Accepted solution]

Hi,

We having the same issue, can you provide us steps how you resolved the issue?

Thanks,

Kalyan