Skip to Content

clarify starting/stopping database ora<sid>, <sid>adm, sqlplus, startsap

I confess we have a great deal of uncertainty about the consequences of running the Oracle Database as the ora<sid> user vs. the <sid>adm user, and similarly using simple sqlplus as ora<sid> vs startsap/stopsap as <sid>adm .

What is the potential harm if any in choosing to start/stop the database as ora<sid> using sqlplus, and is there a compelling arguement for using the startsap/stopsap utilities, especially running these as <sid>adm vs. ora<sid> ?

Any input on best practice is greatly appreciated. !!

Thanks in advance

Dave Hays

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 04, 2009 at 06:38 AM

    As long as you start/stop in the correct order I dont see any problem.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2009 at 02:06 PM

    by default, user [sid]adm is not part of "dba" group, so, it might not be able to shutdown Oracle.

    so, if you put user [sid]adm part of group dba, it does not matter.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi David,

      This is purely on the discretion of the person who has installed orset up the SAP system.

      sidadm and orasid users belong to different groups and enjoy different privileges according to that. Once SAP is installed both the users have changes in the enviornment settings as per the user group. SO no harm in using either of the users if you can perform the task succesfluuy.

      For best practices, you can check the SAP installation document for more information.

  • Nov 04, 2009 at 07:35 PM

    Hii

    You said you have observed great deal of uncertainity about the consequences

    of running them with different id's ...can you please specify what are those

    uncertainities you have observed.regarding startup and stop there will no

    problem on behalf of which userid you have choosen.I agree <sid>adm n ora<sid>

    has differences...but not in case of basic start and stop.

    Regards,

    Manjula.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Dave,

      As you said --you mostly support database,I would

      suggest you to carry on with <sid>adm.This is my expereince ..i would like

      to share with you.

      with admin userid

      when working in SAP 4.7EE with Oracle 8i,I observed a thing that when I go for

      start>run>(type as)BRTOOLS ,I didnt get any specifications BUT WITH

      with <sid>adm

      If I give BRTOOLS--I used to get options whether

      to start/stop DB,

      Backup

      Add a tablespace...etc

      After this experience I came to know the importance of <sid>adm userid.

      As you said you concentrate more to support database..so try to work with <sid>adm.

      Hope this answer helps,

      Regards,

      Manjula.