can not create user "OPS$domainname\SAPSERVICEC11" in oracle

[former_member670924]

Hi all,

I'm installing SAP R3E 4.7 extension set 2 SR1 on Window 2003 , orcle 9.2 (patch 9.2.0.8.0) after finish CI, DB, DI and try to strat SAP with MMC but disp+work.exe didn't run . And the error is "ORA-01017: Invalid username/password; logon denied"

After that i find out solution from SAP Note400241. I need to create user "OPS$domainname\SAPSERVICEC11" but my domain name is 17 charecters long. That make the username is too long (more than 30 characters). So I cann't create this user.

How can i solve this problem?

BR,

Prachya

[former_member204746 · Accepted solution]

create a new domain for your SAP servers and choose a smaller length domain name.

[former_member670924 · Accepted solution]

Hi Eric,

if i create a new domain. Do i need to reinstall SAP again?

BR,

Prachya

[Former Member · Accepted solution]

unfortunately yes.

during the installation a lot of domain resources where created.

Peter

[former_member204746 · Accepted solution]

it might be possible to change domain without re-installing, but this is not documented and will take you a lot of time to figure this out.

a re-install will take you less than 2 hours... this is much easier and you'll make sure you do not forget anything.

[Former Member · Accepted solution]

Hi Eric,

With the note: 400421 I am facing the following problems..... Could you please help me out as where I am going wrong?

1. I could connect through " connect /@sid"

2. select granted_role from dba_role_privs where grantee='ops$_user';

No Rows found..

3. select owner from dba_tables where table_name=T000

gives me SAPDEV

That means the owner is SAPDEV and what is SAPUSER ????

general checks:

select owner from dba_tables where table_name=SAPUSER

gives me OPS$DEVADM and OPS$SANDBOX\DEVADM

so if t000 has SAPDEV then should I check the above command for SAPDEV instead of SAPUSER???? ..

3. select owner, table_owner, table_name from dba_synonyms wghere synonym_name=SAPUSER

give

OPS$SANDBOX\SAPSERVICEDEV OPS$SANDBOX\DEVADM SAPUSER

why here SAPUSER is present..

Do I need to change the T000 table( update it to SAPUSER)???

I you know that have copied the data files (OS level) from anpther DEV server to sandbox..( SID same). It had in DBA_USER with its hostname like

OPS$HPSERVER\SAPSERVICEDEV

OPS$HPSERVER\DEVADM

So I thought it must be bcos of this so I run the script oradbusr.sql to create

OPS$SANDBOX\DEVADM user and managed to create it. Also managed to get OPS$SANDBOX\SAPSERVICEDEV users. The grant to them is also okay.. But then also not able to connect through SAP.

Please suggest where I am going wrong and what to change...

Regards

Prashant

[fidel_vales · Accepted solution]

> Hi Eric,

>

> With the note: 400421 I am facing the following

> problems..... Could you please help me out as where I

> am going wrong?

>

> 1. I could connect through " connect /@sid"

<b>-> OK, then the "OPS$" exists</b>

>

> 2. select granted_role from dba_role_privs where

> grantee='ops$_user';

> No Rows found..

>

> 3. select owner from dba_tables where

> table_name=T000

>

> gives me SAPDEV

>

> That means the owner is SAPDEV and what is SAPUSER

> ????

<b>NO, this is telling you that the schema name is SAPDEV, only. We will need it later</b>

>

> general checks:

>

> select owner from dba_tables where table_name=SAPUSER

>

> gives me OPS$DEVADM and OPS$SANDBOX\DEVADM

<b>The name of your server is SANDBOX, but you mentioned before that you had a domain longer than 17 characters. This does not match.

Have you performed a DOMAIN or a LOCAL installation?

For this output it seems that it is local</b>

>

> so if t000 has SAPDEV then should I check the above

> command for SAPDEV instead of SAPUSER???? ..

<b>NO. The table name is SAPUSER</b>

>

> 3. select owner, table_owner, table_name from

> dba_synonyms wghere synonym_name=SAPUSER

> give

> OPS$SANDBOX\SAPSERVICEDEV OPS$SANDBOX\DEVADM SAPUSER

>

> why here SAPUSER is present..

<b>

Do you know what is a synonym? or what have you queried?

Select owner, table_owner, table_name from

dba_synonyms wghere synonym_name=SAPUSER

It is giving you the

-> Synonym OWNER -> OPS$SANDBOX\SAPSERVICEDEV

-> Table OWNER -> OPS$SANDBOX\DEVADM

-> TABLE NAME -> SAPUSER

This data is correct.</b>

>

> Do I need to change the T000 table( update it to

> SAPUSER)???

<b>NOOOOO. Leave teh "normal" tables alone</b>

>

> I you know that have copied the data files (OS level)

> from anpther DEV server to sandbox..( SID same). It

> had in DBA_USER with its hostname like

>

> OPS$HPSERVER\SAPSERVICEDEV

> OPS$HPSERVER\DEVADM

>

> So I thought it must be bcos of this so I run the

> script oradbusr.sql to create

> OPS$SANDBOX\DEVADM user and managed to create it.

> Also managed to get OPS$SANDBOX\SAPSERVICEDEV users.

> The grant to them is also okay.. But then also not

> able to connect through SAP.

>

> Please suggest where I am going wrong and what to

> change...

>

> Regards

> Prashant

<b>So, Looking at the initial error ( ora-1017 ) and the output of the queries I wonder if you have changed the DB password.

I do think so. and I think you did it at DB level ( alter user identified by ... )

Then the problem seems to be that you do not have the password in SAPUSER table in sync with the password you changed.

In SAP ABAP systems you cannot change the password at DB level. You have to use BRCONNECT to do so, it will keep the passwords in SYNC:

brconnect -u system/<password> -f chpass -o <sapowner> -p

<password>

try it. then execute R3TRANS -x and see if it can connect

</b>

[Former Member]

Hi Cherngchai,

I am facing the same problem, but could not get out of it. From 400421 I am finding problems with belows steps?

1. I could connect through " connect /@sid"

2. select granted_role from dba_role_privs where grantee='ops$_user';

No Rows found..

3. select owner from dba_tables where table_name=T000

gives me SAPDEV

That means the owner is SAPDEV and what is SAPUSER ????

general checks:

select owner from dba_tables where table_name=SAPUSER

gives me OPS$DEVADM and OPS$SANDBOX\DEVADM

so if t000 has SAPDEV then should I check the above command for SAPDEV instead of SAPUSER???? ..

3. select owner, table_owner, table_name from dba_synonyms wghere synonym_name=SAPUSER

give

OPS$SANDBOX\SAPSERVICEDEV OPS$SANDBOX\DEVADM SAPUSER

why here SAPUSER is present..

Do I need to change the T000 table( update it to SAPUSER)???

I you know that have copied the data files (OS level) from anpther DEV server to sandbox..( SID same). It had in DBA_USER with its hostname like

OPS$HPSERVER\SAPSERVICEDEV

OPS$HPSERVER\DEVADM

So I thought it must be bcos of this so I run the script oradbusr.sql to create

OPS$SANDBOX\DEVADM user and managed to create it. Also managed to get OPS$SANDBOX\SAPSERVICEDEV users. The grant to them is also okay.. But then also not able to connect through SAP.

Please suggest where I am going wrong and what to change...

Regards

Prashant

[fidel_vales]

Eric is correct.

With a shorter domain name you could change the parameter "OS_AUTHENT_PREFIX".

But, if you set it to "nothing" you still would have a name of 31 characters ( 17 domain and 14 username )