Oracle Step during Quality refresh

[Former Member]

Dear Team ,

I am doing  refresh my Quality Server (QAS) from Production Server (PRD).

Then create  sucessfull Control File ,then I have run below oracle command.

Oracle is starting sucessfully

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 4676788224 bytes

Fixed Size                  2190320 bytes

Variable Size            2348811280 bytes

Database Buffers         2315255808 bytes

Redo Buffers               10530816 bytes

Database mounted.

Database opened.

SQL> alter user SAPSR3 profile default;

User altered.

SQL> alter user SAPSR3 identified by SAP;

User altered.

SQL> delete SAPSR3.usr02 where mandt like 000 and bname like 'SAP*';

0 rows deleted.

SQL> create user OPS$qasadm identified externally default tablespace PSAPSR3USR temporary tablespace PSAPTEMP;

create user OPS$qasadm identified externally default tablespace PSAPSR3USR temporary tablespace PSAPTEMP

            *

ERROR at line 1:

ORA-01920: user name 'OPS$QASADM' conflicts with another user or role name

SQL> create user OPS$oraqas identified externally default tablespace PSAPSR3USR temporary tablespace PSAPTEMP;

create user OPS$oraqas identified externally default tablespace PSAPSR3USR temporary tablespace PSAPTEMP

            *

ERROR at line 1:

ORA-01920: user name 'OPS$ORAQAS' conflicts with another user or role name

SQL> grant dba,connect,resource to OPS$qasadm;

Grant succeeded.

SQL> grant dba,connect,resource to OPS$oraqas;

Grant succeeded.

SQL>

Please suggest for these step ,How to solve these oracle problem.

Regards

[former_member207186]

Hi,

The ORA-01920 indicates that there is a user or role with the same name/has conflicts.

To verify this you can check dba_users, dba_roles and dba_profiles.

Regards,

Bíborka

[JamesZ]

ORA-01920: user name 'OPS$ORAQAS' conflicts with another user or role name

let us know the user name and role name has conflicts.

please check your production system to see if you have the role and user. To query this, please use dic:

dba_users

DBA_ROLES

By the way for my understanding, there shouldn't be roles named: 'OPS$XXXX'

[thiago_cavalheiro]

Hello,

The error messages are not actually issues - they are only informing that the users you attempted to create already exist. And this is why the "GRANT" command lines worked fine.

Best regards,

Thiago