OraFAQ Forum: Server Administration » Ora-01031 error when reading Oracle SGA

Home » RDBMS Server » Server Administration » Ora-01031 error when reading Oracle SGA (Oracle 10g, AIX 6.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ora-01031 error when reading Oracle SGA [message #640771]

Wed, 05 August 2015 00:00

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

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640772 is a reply to message #640771]

Wed, 05 August 2015 00:07

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640806 is a reply to message #640771]

Wed, 05 August 2015 06:36

EdStevens
Messages: 1376
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?

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640962 is a reply to message #640772]

Fri, 07 August 2015 04:51

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?

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640963 is a reply to message #640806]

Fri, 07 August 2015 04:53

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.

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640964 is a reply to message #640963]

Fri, 07 August 2015 04:57

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

# su - oracle
$ <set_your_AIX_environment_correctly>
$ . oraenv

etc...

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640969 is a reply to message #640963]

Fri, 07 August 2015 06:32

EdStevens
Messages: 1376
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".

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640970 is a reply to message #640963]

Fri, 07 August 2015 08:03

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640980 is a reply to message #640969]

Sat, 08 August 2015 01:55

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.

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640981 is a reply to message #640970]

Sat, 08 August 2015 01:57

waikok
Messages: 9
Registered: August 2015

Junior Member

Due to compliance issue, I can't change the ownership of the library.

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #640983 is a reply to message #640981]

Sat, 08 August 2015 04:48

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

EdStevens
Messages: 1376
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"?

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #641008 is a reply to message #640983]

Sun, 09 August 2015 03:48

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.

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #641009 is a reply to message #640989]

Sun, 09 August 2015 03:51

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.

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #641020 is a reply to message #641009]

Sun, 09 August 2015 09:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Therefore, we have to use 3rd party tool.
Then go ask vendor & terminate this thread

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #641021 is a reply to message #641020]

Sun, 09 August 2015 10:15

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?

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #641022 is a reply to message #641021]

Sun, 09 August 2015 10:27

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Ora-01031 error when reading Oracle SGA [message #641173 is a reply to message #641022]

Tue, 11 August 2015 08:17

waikok
Messages: 9
Registered: August 2015

Junior Member

Ok, thank you.

Report message to a moderator

Previous Topic:	undo tablespace responsibility??
Next Topic:	Share tablespace between OLTP and OLAP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:47:29 CST 2025