Skip to Content
0

Oracle 12.1.0.2 installed by using sap standard user orasid <>

Oct 17, 2016 at 04:03 PM

123

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

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)

Share
10 |10000 characters needed characters left characters exceeded
James Zhang
Oct 18, 2016 at 07:03 AM
0

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


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 20, 2016 at 06:56 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded