Skip to Content
avatar image
Former Member

Oracle 12.1.0.2 installed by using sap standard user orasid <>

Hello Team,

We have installed Oracle 12.1.0.2 in one of the newly built instance by using sap standard user "ora<sid>".

Please let us know whether it impact any DBA operarion or do we need to move to oracle standard user " ORACLE ".

if so, please provide us the steps to move to ora<SID> user to oracle user "ORACLE" in the newly built instance

This weekend we have to build production system which will be in cluster as well.

Please suggest whether we need to install with oracle user "ORACLE" or with ora<sid> user since our development and quality instance built with ora<sid

Regards

subb

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 18, 2016 at 10:17 PM

    This weekend we have to build production system which will be in cluster as well.

    What kind of cluster are you refering to? Real Application Clusters?

    If you are going to run single instance, both users (oracle, oraSID) are the same and both are supported. As mentioned by James it only depends on you. Some people do not like the "shared" user oracle when they have more than one instance on the same box as they migh run something on the wrong environment. Easy to solve configuring proper promts (I might blog about this, idea)

    But (always a but), if you are going to run a Real Application Cluster then you MUST use "oracle", oraSID is not supported (technically, works)

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 07:03 AM

    Hi Subb,

    SAP notes 1915317 talks user migration. However you can still user orasid in 12c, which is mentioned in sap oracle upgrade.

    Both orasid and oracle are working in the same way, different person has their own opinion on which one is better. You can consider your usage,


    Best regards,
    James


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2016 at 06:56 PM

    Hi,

    We assume you installed your standalone Oracle DB instance and then planning a cluster environment (obviously non RAC).

    For this scenario - As mentioned by Fidel and James, you can use either ORASID or oracle as owner. It matters only if you have RAC installations.

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded