Home » RDBMS Server » Server Administration » Ora-01031 error when reading Oracle SGA (Oracle 10g, AIX 6.1)
Ora-01031 error when reading Oracle SGA [message #640771] Wed, 05 August 2015 00:00 Go to next message
waikok
Messages: 9
Registered: August 2015
Junior Member
Hi,

I am using the ID root to run a process to read/logon to the SGA, however, I have Ora-01031 insufficient privileges error. The root is in the oinstall and dba group as per the oracle ID which runs the instance.

Is the an issue for root to access to SGA? If not, what could be the problem?

Regards,
Wai
Re: Ora-01031 error when reading Oracle SGA [message #640772 is a reply to message #640771] Wed, 05 August 2015 00:07 Go to previous messageGo to next message
BlackSwan
Messages: 26183
Registered: January 2009
Location: SoCal
Senior Member
root is OS user & should NEVER be used to access Oracle.
Which OS user who owns Oracle files?
Re: Ora-01031 error when reading Oracle SGA [message #640806 is a reply to message #640771] Wed, 05 August 2015 06:36 Go to previous messageGo to next message
EdStevens
Messages: 976
Registered: September 2013
Senior Member
In addition to BlackSwan's comment about NOT using root to do ANYTHING related to Oracle (good advice there), exactly what do you mean by "read/logon to the SGA"?

What is the end-state you are trying to arrive at?
Re: Ora-01031 error when reading Oracle SGA [message #640962 is a reply to message #640772] Fri, 07 August 2015 04:51 Go to previous messageGo to next message
waikok
Messages: 9
Registered: August 2015
Junior Member
The ID who own the Oracle files is oracle in oinstall group. I know it is not supposed to use root to access Oracle but I am doing a testing and root is the only ID I have that can utilize the AIX library files.

The root is already in oinstall group. Is it possible for root to access SGA?
Re: Ora-01031 error when reading Oracle SGA [message #640963 is a reply to message #640806] Fri, 07 August 2015 04:53 Go to previous messageGo to next message
waikok
Messages: 9
Registered: August 2015
Junior Member
I am running a program which needs to utilize the AIX library and to read the Oracle SGA. The only ID that can run the AIX library is root, but I am having problem for the root to access the Oracle SGA.

Re: Ora-01031 error when reading Oracle SGA [message #640964 is a reply to message #640963] Fri, 07 August 2015 04:57 Go to previous messageGo to next message
gazzag
Messages: 985
Registered: November 2010
Location: Bristol, UK
Senior Member
# su - oracle
$ <set_your_AIX_environment_correctly>
$ . oraenv

etc...
Re: Ora-01031 error when reading Oracle SGA [message #640969 is a reply to message #640963] Fri, 07 August 2015 06:32 Go to previous messageGo to next message
EdStevens
Messages: 976
Registered: September 2013
Senior Member
waikok wrote on Fri, 07 August 2015 04:53
I am running a program which needs to utilize the AIX library and to read the Oracle SGA. The only ID that can run the AIX library is root, but I am having problem for the root to access the Oracle SGA.



Again, what is the business problem you are trying to solve. I've been working with oracle for over 20 years and have never heard of "reading the SGA".
Re: Ora-01031 error when reading Oracle SGA [message #640970 is a reply to message #640963] Fri, 07 August 2015 08:03 Go to previous messageGo to next message
BlackSwan
Messages: 26183
Registered: January 2009
Location: SoCal
Senior Member
waikok wrote on Fri, 07 August 2015 02:53
I am running a program which needs to utilize the AIX library and to read the Oracle SGA. The only ID that can run the AIX library is root, but I am having problem for the root to access the Oracle SGA.


so change the ownership of this library
Re: Ora-01031 error when reading Oracle SGA [message #640980 is a reply to message #640969] Sat, 08 August 2015 01:55 Go to previous messageGo to next message
waikok
Messages: 9
Registered: August 2015
Junior Member
It is an auditing issue. I am running a tool/process to read the shared memory of Oracle to monitoring the DB activities.
Re: Ora-01031 error when reading Oracle SGA [message #640981 is a reply to message #640970] Sat, 08 August 2015 01:57 Go to previous messageGo to next message
waikok
Messages: 9
Registered: August 2015
Junior Member
Due to compliance issue, I can't change the ownership of the library.
Re: Ora-01031 error when reading Oracle SGA [message #640983 is a reply to message #640981] Sat, 08 August 2015 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you are stuck, why don't you ask the editor of the tool?

[Updated on: Sat, 08 August 2015 04:49]

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640989 is a reply to message #640980] Sat, 08 August 2015 06:55 Go to previous messageGo to next message
EdStevens
Messages: 976
Registered: September 2013
Senior Member
waikok wrote on Sat, 08 August 2015 01:55
It is an auditing issue. I am running a tool/process to read the shared memory of Oracle to monitoring the DB activities.


What do you need to "audit" in the SGA that is not exposed in the standard v$* dynamic views? Or with Oracle's own AUDIT capabilities?

what is the "tool/process" you are using to "read the shared memory"?
Re: Ora-01031 error when reading Oracle SGA [message #641008 is a reply to message #640983] Sun, 09 August 2015 03:48 Go to previous messageGo to next message
waikok
Messages: 9
Registered: August 2015
Junior Member
I have, but no answer yet. I have been using other ID to start the tool (in oinstall group) to read the SGA but root is not able to do so. That is why I curious why is that so even though root is in the oinstall group.
Re: Ora-01031 error when reading Oracle SGA [message #641009 is a reply to message #640989] Sun, 09 August 2015 03:51 Go to previous messageGo to next message
waikok
Messages: 9
Registered: August 2015
Junior Member
EdStevens wrote on Sat, 08 August 2015 19:55
waikok wrote on Sat, 08 August 2015 01:55
It is an auditing issue. I am running a tool/process to read the shared memory of Oracle to monitoring the DB activities.


What do you need to "audit" in the SGA that is not exposed in the standard v$* dynamic views? Or with Oracle's own AUDIT capabilities?

what is the "tool/process" you are using to "read the shared memory"?


There are some reasons we can't use the or oracle's own audit. Therefore, we have to use 3rd party tool.

Not sure is suitable to disclose the name of the tool, but it has been running well with other ID (within the oinstall group) to read the shared memory but once root (also in the oinstall group) is used, it can't. That is why I curious to find out the difference and answer.
Re: Ora-01031 error when reading Oracle SGA [message #641020 is a reply to message #641009] Sun, 09 August 2015 09:18 Go to previous messageGo to next message
BlackSwan
Messages: 26183
Registered: January 2009
Location: SoCal
Senior Member
> Therefore, we have to use 3rd party tool.
Then go ask vendor & terminate this thread
Re: Ora-01031 error when reading Oracle SGA [message #641021 is a reply to message #641020] Sun, 09 August 2015 10:15 Go to previous messageGo to next message
waikok
Messages: 9
Registered: August 2015
Junior Member
BlackSwan wrote on Sun, 09 August 2015 22:18
> Therefore, we have to use 3rd party tool.
Then go ask vendor & terminate this thread


Please do not relate this to the other vendor, as per my question, I just want to know if there is any issue for root ID to access Oracle SGA. I am facing and Oracle error 01031.

Shouldn't be all IDs within the same oinstall group with the correct umask can access the shared memory created by the group owner?
Re: Ora-01031 error when reading Oracle SGA [message #641022 is a reply to message #641021] Sun, 09 August 2015 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I just want to know if there is any issue for root ID to access Oracle SGA.


Yes there is, if you do this you will have an "ORA-01031: insufficient privileges" error.

Re: Ora-01031 error when reading Oracle SGA [message #641173 is a reply to message #641022] Tue, 11 August 2015 08:17 Go to previous message
waikok
Messages: 9
Registered: August 2015
Junior Member
Ok, thank you.
Previous Topic: undo tablespace responsibility??
Next Topic: Share tablespace between OLTP and OLAP
Goto Forum:
  


Current Time: Mon Oct 15 15:09:24 CDT 2018