Highlighted
2 Bronze

AIX and Oracle Account Privileges

Jump to solution

Hi,

Hoping someone can help here,

New to SRM and we are in POC with Verision 3.0

Arrays and vMware sorted, but having difficulty on locating account privileges for connecting to AIX via SSH and Oracle Database Privileges in the Solution Packs.

Also, unable to find an AIX agent or is one not required?

Gareth

0 Kudos
Reply
1 Solution

Accepted Solutions
Highlighted
2 Bronze

Hi Gareth,

sorry for the delay. Do you have the Oracle-Database-SolutionPack-Guide.pdf available?

This states the following for account privileges -

Configuring the Oracle Database SolutionPack with an unprivileged account:

The Watch4net collector must connect to each instance of Oracle databases and perform SQL queries. 

You can use either an administrator equivalent system account, or create a dedicated system account for the collector. If you want to use the last option, please ask the DBA administrator to run the following query against every instances/RAC cluster. This will create a "watch4net" account, which specific grant for the Watch4net collector.

create user

watch4net identified by securepassword default tablespace users temporary tablespace temp;

grant connect, resource to watch4net;

grant select on V_$SYSSTAT to watch4net;

grant select on v_$filestat to watch4net;

grant select on v_$database to watch4net;

gr

ant select on dba_data_files to watch4net;

grant select on dba_extents to watch4net;

grant select on dba_free_space to watch4net;

grant select on v_$parameter to watch4net;

grant select on v_$sgainfo to watch4net;

grant select on v_$rowcache to watch4net;

grant select on v_$librarycache to watch4net;

grant select on v_$latch to watch4net;

grant select on v_$rollstat to watch4net;

grant select on v_$dispatcher to watch4net;

grant select on v_$instance to watch4net;

grant select on v_$sesstat to watch4net;

gr

ant select on v_$statname to watch4net;

grant select on v_$session to watch4net;

grant select on v_$sess_io to watch4net;

grant select on v_$asm_disk to watch4net;

grant select on v_$asm_diskgroup to watch4net;

grant select on v_$logfile to watch4net;

gran

t select on v_$log to watch4net;

For Oracle 11g, you'll also need to run:

begin

dbms_network_acl_admin.create_acl (

acl => 'Resolve_Access.xml',

description => 'Resolve Network Access using UTL_INADDR',

principal => 'WATCH4NET',  -- MUST BE IN CAPS

is_grant => TRUE,

privilege => 'resolve',

start_date => null,

end_date => null

);

commit;

end;

begin

dbms_network_acl_admin.assign_acl (

acl => 'Resolve_Access.xml',

host => '*',

lower_port =>

null,

upper_port => null);

commit;

end;

View solution in original post

0 Kudos
Reply
4 Replies
Highlighted
2 Bronze

Hi Gareth,

there is no specific AIX agent for SRM Suite 3.0 at this time, but the Physical Hosts SolutionPack enables users to monitor and generate real-time and historical reports regarding the performance of physical hosts, including AIX hosts.

In order to configure your AIX hosts for discovery and data collection, you should review the SRM Suite 3.0 Installation guide on page 42 and also, check out the Post-install configuration for SolutionPack for Physical Hosts section from page 91.

The guide can be downloaded from https://support.emc.com/docu51319_Storage-Resource-Management-3.0-Installation-and-Configuration-Gui...

If you have any other questions in relation to this, let us know.

regards,
Tomas

Reply
Highlighted
2 Bronze

Hi Tomas,

Thanks for the update. After I posted I found the AIX information but I'm still not able to locate the account privileges for Oracle DB?

Regards,

Gareth

0 Kudos
Reply
Highlighted
2 Bronze

Hi Gareth,

sorry for the delay. Do you have the Oracle-Database-SolutionPack-Guide.pdf available?

This states the following for account privileges -

Configuring the Oracle Database SolutionPack with an unprivileged account:

The Watch4net collector must connect to each instance of Oracle databases and perform SQL queries. 

You can use either an administrator equivalent system account, or create a dedicated system account for the collector. If you want to use the last option, please ask the DBA administrator to run the following query against every instances/RAC cluster. This will create a "watch4net" account, which specific grant for the Watch4net collector.

create user

watch4net identified by securepassword default tablespace users temporary tablespace temp;

grant connect, resource to watch4net;

grant select on V_$SYSSTAT to watch4net;

grant select on v_$filestat to watch4net;

grant select on v_$database to watch4net;

gr

ant select on dba_data_files to watch4net;

grant select on dba_extents to watch4net;

grant select on dba_free_space to watch4net;

grant select on v_$parameter to watch4net;

grant select on v_$sgainfo to watch4net;

grant select on v_$rowcache to watch4net;

grant select on v_$librarycache to watch4net;

grant select on v_$latch to watch4net;

grant select on v_$rollstat to watch4net;

grant select on v_$dispatcher to watch4net;

grant select on v_$instance to watch4net;

grant select on v_$sesstat to watch4net;

gr

ant select on v_$statname to watch4net;

grant select on v_$session to watch4net;

grant select on v_$sess_io to watch4net;

grant select on v_$asm_disk to watch4net;

grant select on v_$asm_diskgroup to watch4net;

grant select on v_$logfile to watch4net;

gran

t select on v_$log to watch4net;

For Oracle 11g, you'll also need to run:

begin

dbms_network_acl_admin.create_acl (

acl => 'Resolve_Access.xml',

description => 'Resolve Network Access using UTL_INADDR',

principal => 'WATCH4NET',  -- MUST BE IN CAPS

is_grant => TRUE,

privilege => 'resolve',

start_date => null,

end_date => null

);

commit;

end;

begin

dbms_network_acl_admin.assign_acl (

acl => 'Resolve_Access.xml',

host => '*',

lower_port =>

null,

upper_port => null);

commit;

end;

View solution in original post

0 Kudos
Reply
Highlighted
3 Argentum

Hi Gareth,

Also have a review of the solution https://support.emc.com/kb/176733 "What does the Oracle SolutionPack require to discover Oracle databases?"

Regards

Conor

0 Kudos
Reply