Skip to Content

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

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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 09, 2012 at 08:33 AM

    Hi,

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

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jul 09, 2012 at 03:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded