SAP Host Name changed Oracle shema owner ship how to change.

[former_member186190]

Hello Gurus

I have changed my SAP system Host name after that I am not able to start sap dispatcher is getting down and SAPSR3 user getting locked. Hope I find out 1 issue as follows Just need help to clear:

Old Host Name Was:   SAPGRP

New Host Name Is     :  SAPDUMMY

And SID ADM            :  GEPADM

After changed host name oracle is Up and listener is working fine. but when executing R3trans -d out put error code is (0012)

then I run the Qry in SQL as follows:

sELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

Out Put =

OWNER

------------------------------

OPS$CLUSGRP\GEPADM

Still my  Host name not changed in schema ownership.  I want to change the Owner ship as follows:

OPS$SAPDUMMY\GEPADM 

Please let me know how to Update it in oracle.

Thanks

Engli.

[volker_borowski2]

Still my  Host name not changed in schema ownership.  I want to change the Owner ship as follows:
OPS$SAPDUMMY\GEPADM  
Please let me know how to Update it in oracle.
Thanks 
Engli.

Hi,

this is not possible with Oracle yet.

I mind to remember that there is a CR pending to introduce this for Oracle Version 12.

Since you only like to change th OPS$ User, which has only one segment, simply create a new one.

Volker

[JPReyes]

Why don't you simply drop the OPS$ users and recreate them rather than trying to modify the current ones?

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

to add to that,

Note 8307 - Changing host name on R/3 host: What do you do?

Regards,

Juan

[former_member186190]

Hi Juan

I am ready to drop the existing user which  is OPS$SAPGROUP\GEPADM . but i want to create new user as follows OPS$SAPDUMMY\GEPADM and granted to SAPUSER table. My self i tried but i am not complete. Do you have solutiont to complete this.

Thanks

engli

[JPReyes]

The step by step documentation for that is on,

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

You can also use the script on SAP note 50088 (Windows) and 361641 (Unix).

Regards, Juan

[former_member186190]

Hello Alll

CREATE TABLE "OPS$SAPDUMMY\GEPADM".SAPUSER   (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

  INSERT INTO "OPS$SAPDUMMY\GEPADM".SAPUSER VALUES ('SAPSR3','oracle10g');

  Delete user "OPS$SAPGRP\GEPADM" CASCADE;

  grant dba,connect , resource to "OPS$SAPDUMMY\GEPADM"

   SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

        CREATE USER "OPS$SAPDUMMY\GEPADM" identified by oracle10g default tablespace DBA_TABLES;

CREATE SYNONYM  "OPS$SAPDUMMY\SAPSERVICEGEP".SAPUSER FOR   "OPS$SAPDUMMY\GEPADM".SAPUSER;

GRANT SELECT, UPDATE ON "OPS$SAPDUMMY\GEPADM".SAPUSER TO "OPS$SAPDUMMY\SAPSERVICEGEP";

i created OPS$ user and granted now, r3trans-d is getting (0000) but  My dispatcher still yellow as well as ABAP work process show nothing.

Anyone have idea why work process is null?

Thanks to All for the hell

please clear me above issue too

thanks e

engli

[Former Member]

restart your sap system and, if any problems, check log files for errors

Regards

Roman

[JPReyes]

can you post the errors in dev_w0?

Regards, Juan

[sunny_pahuja2]

Hi,

You can follow SAP note 50088 (Windows) and 361641 (Unix).

Thanks

Sunny

[former_member186190]

HI sunny

I have gone through already and created user but I not able to change the ownership.

SQL> UPDATE DBA_TABLES SET OWNER="OPS$SAPDUMMY\GEPADM" WHERE TABLE_NAME='SAPUSER

';

UPDATE DBA_TABLES SET OWNER="OPS$SAPDUMMY\GEPADM" WHERE TABLE_NAME='SAPUSER'

       *

ERROR at line 1:

ORA-02030: can only select from fixed tables/views

SQL> GRANT SELECT V$DBA_TABLES ;

GRANT SELECT V$DBA_TABLES

      *

ERROR at line 1:

ORA-00990: missing or invalid privilege

SQL> GRATN DBA,CONNECT GEPADM;

SP2-0734: unknown command beginning "GRATN DBA,..." - rest of line ignored.

SQL>

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OWNER

------------------------------

OPS$CLUSGRP\GEPADM

SQL>

thanks

engli

[sunny_pahuja2]

Could you please share what process you have followed to change the hostname and also complete error details ?

Thanks

Sunny

[former_member186190]

Hello sunny

the following step i have been performed:

1. change name in Environemnt variables
2. Host name in computer
3. change in all sap profiles where all mentioned on old computername
4. Registry level  in Oracle,and SAP
5. listener and TNs
6. Re created sap service with New Host name and start-up profile
7. host files

Oracle started listing is working, but while trying to start up sap  SAPSR3 user is getting locked. That is due to OPS$oldname\sapsid.

thaks

engli