OraFAQ Forum: Server Administration » Oracle Advanced Security

Home » RDBMS Server » Server Administration » Oracle Advanced Security (Oracle 10GR2)

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

Oracle Advanced Security [message #450477]

Wed, 07 April 2010 09:07

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I want to know whether OAS(oracle advanced security) is enabled in our database or not? Can someone tell me how to verify this?
Thanks

Report message to a moderator

Re: Oracle Advanced Security [message #450488 is a reply to message #450477]

Wed, 07 April 2010 09:22

John Watson
Messages: 8935
Registered: January 2010
Location: Global Village

Senior Member

Hi, there -
opatch lsinventory -detail

Report message to a moderator

Re: Oracle Advanced Security [message #450496 is a reply to message #450488]

Wed, 07 April 2010 09:38

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
Is there any query that i can use to check the installed products in the database?
Thanks

Report message to a moderator

Re: Oracle Advanced Security [message #450497 is a reply to message #450477]

Wed, 07 April 2010 09:38

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select parameter, value
from v$option
where upper(parameter) like '%SECURITY%'
/

If anything is TRUE then option is installed.

Regards
Michel

Report message to a moderator

Re: Oracle Advanced Security [message #450516 is a reply to message #450497]

Wed, 07 April 2010 12:09

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
Here is what I get

SQL> 
select parameter, value
from v$option
where upper(parameter) like '%SECURITY%'

SQL>
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Enterprise User Security                                         TRUE
Oracle Label Security                                            FALSE

But i would like to know what OAS options are configured, how to find that out?
Thanks

Report message to a moderator

Re: Oracle Advanced Security [message #450520 is a reply to message #450516]

Wed, 07 April 2010 12:33

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

OAS is a whole, you install all or nothing.

Regards
Michel

[Updated on: Wed, 07 April 2010 12:33]

Report message to a moderator

Re: Oracle Advanced Security [message #450521 is a reply to message #450520]

Wed, 07 April 2010 12:38

caprikar
Messages: 226
Registered: March 2007

Senior Member

So, how do I find whether OAS is installed or not?
Thanks

Report message to a moderator

Re: Oracle Advanced Security [message #450522 is a reply to message #450521]

Wed, 07 April 2010 12:41

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

By what has been previously posted.

Regards
Michel

Report message to a moderator

Re: Oracle Advanced Security [message #450524 is a reply to message #450522]

Wed, 07 April 2010 12:49

caprikar
Messages: 226
Registered: March 2007

Senior Member

To make it clear

SQL> select parameter, value
from v$option
where upper(parameter) like '%SECURITY%';
 
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Enterprise User Security                                         TRUE
Oracle Label Security                                            TRUE

--this means OAS is installed?

Report message to a moderator

Re: Oracle Advanced Security [message #450526 is a reply to message #450524]

Wed, 07 April 2010 13:10

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes.
This is what means: "If anything is TRUE then option is installed".

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle Version Significance
Next Topic:	High Load on DB Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 05 11:46:04 CDT 2024