Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Issues with the Oracle SGA file permissions in Oracle 12102
Divya_93
post May 3 2017, 02:06 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 8-November 16
Member No.: 51,630



I am facing issues with the Oracle SGA file permissions in Oracle 12102 on AIX. I want to give a user which is not an Oracle user the read permissions for the Oracle shared memory. I found the parameter ALLOW_GROUP_ACCESS_TO_SGA and set it True but even after doing that the Group in which the Oracle user and my User are, does not have read permissions for the SGA files. These are the results of the ipcs -m command ->

m 428867627 0x37009593 --rw------- user1dba
m 832569392 0xffffffff D-rw------- user1 dba

Do I need to do anything special other than setting the parameter ALLOW_GROUP_ACCESS_TO_SGA=TRUE to provide the group read permissions ? Anybody please help. Thanks
Go to the top of the page
 
+Quote Post
burleson
post May 3 2017, 01:39 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,438
Joined: 26-January 04
Member No.: 13



Hi Divya,

>> the Group in which the Oracle user and my User are, does not have read permissions for the SGA files.

Yes, the OS use is independent from the Oracle parameter ALLOW_GROUP_ACCESS_TO_SGA.

You need to use a user ID that belongs to the dba group (from /etc/groups).

Please see my notes here:

http://www.dba-oracle.com/t_allow_group_access_to_sga.htm






--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Divya_93
post May 3 2017, 11:54 PM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 8-November 16
Member No.: 51,630



Hi Donald,

Thanks for the reply. So, setting the parameter ALLOW_GROUP_ACCESS_TO_SGA=TRUE is the only thing which need to done to provide access to SGA to users of Oracle owner group? If I set ALLOW_GROUP_ACCESS_TO_SGA=TRUE and try attaching to the shared memory segment with an os user that belongs to the dba group, would that work in Oracle 12c (12.1.0.2 in my case)?

Actually, in one of our env's we have done this, but still the Read access is not being granted to the DBA group. Please help!

Thanks & Regards
Divya Jain
Go to the top of the page
 
+Quote Post
burleson
post May 6 2017, 09:36 AM
Post #4


Advanced Member
***

Group: Members
Posts: 13,438
Joined: 26-January 04
Member No.: 13



Hi Divya,

>> Actually, in one of our env's we have done this, but still the Read access is not being granted to the DBA group.

I would open a service request with MOSC, and see if this is a bug:

http://support.oracle.com




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd June 2017 - 08:53 AM