Skip to Content
avatar image
Former Member

Create special OS user just for TP

Hi,

Attempting to create a user specifically for TP. I'm unable to use default (sid)adm due to some technical reasons.

Platform on AIX + Oracle 11

Done the following but still doesn't work 😔

  • Created OS user abcadm
  • Created DB user "create user ops$abcadm identified externally"
  • Grant DB user resource "grant dba,resource,sapdba,connect to ops$abcadm"

Some tips would be great!

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 28, 2013 at 06:17 AM

    Great my DBA helped me out. Created the synonym for me. I can do R3trans -x now from abcadm

    create synonym "OPS$ABCADM".SAPUSER for "OPS$(SID)ADM".SAPUSER;

    😀

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2013 at 04:11 AM

    Hi Wei,

    whats the issue in using sidadm user ? we can help in resolving the same. I do not see any benefit in created a special user to perform tp operations.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2013 at 05:34 AM

    Hi Wei,

    You need to use the <sid>adm for tp.

    It is not possible to use other users See SNOTE 307122.

    Cheers,

    Shahab

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Shahab,

      It should work if I've set the environment right under OS. Now I'm only lost in setting the right permission for Oracle.

      Cheers,

      WL

  • avatar image
    Former Member
    Mar 01, 2013 at 01:18 AM

    Hi Wei,

    Good to hear that you have solved the issue.

    But what about the files ownership?

    Cheers,

    Shahab

    Add comment
    10|10000 characters needed characters exceeded