Resolution
goal
What are the minimum table permissions needed for an AppManager for UNIX agent to properly run the Oracle Managed Object?
goal
How do I set up the database account privileges to monitor Oracle Database?
fact
AppManager 6.0
fact
AppManager 6.0.1
fact
AppManager 6.0.2
fact
AppManager 6.0.x
fact
AppManager 5.0.1
fact
AppManager for Unix Agent 6.5
fact
AppManager 5.0
fact
AppManager 5.0.1 SP1
fact
AppManager 5.0.1 SP2
fact
Sun Solaris
fact
Red Hat Linux
fact
IBM AIX
fact
HP-UX
fix
note
For more information, see the AppManager User Guide.
What are the minimum table permissions needed for an AppManager for UNIX agent to properly run the Oracle Managed Object?
goal
How do I set up the database account privileges to monitor Oracle Database?
fact
AppManager 6.0
fact
AppManager 6.0.1
fact
AppManager 6.0.2
fact
AppManager 6.0.x
fact
AppManager 5.0.1
fact
AppManager for Unix Agent 6.5
fact
AppManager 5.0
fact
AppManager 5.0.1 SP1
fact
AppManager 5.0.1 SP2
fact
Sun Solaris
fact
Red Hat Linux
fact
IBM AIX
fact
HP-UX
fix
The account refers to the username and password stored in the AppManager Security Manager per-database. Configure the account on the target UNIX computer with SELECT privileges to these Oracle RDBMS tables in the database:
- DBA_DATA_FILES
- DBA_EXTENTS
- DBA_FREE_SPACE
- DBA_ROLLBACK_SEGS
- DBA_SEGMENTS
- DBA_TABLES
- DBA_TABLESPACES
- DBA_USERS
- SYS.FET$
- SYS.TS$
- SYS.SEG$
- V$ARCHIVE_DEST
- V$BGPROCESS
- V$DATABASE
- V$DATAFILE
- V$INSTANCE
- V$LIBRARYCACHE
- V$LOCK
- V$PARAMETER
- V$PROCESS
- V$ROWCACHE
- V$SESSION
- V$SESSTAT
- V$STATNAME
- V$SYSSTAT
- V$VERSION
note
For more information, see the AppManager User Guide.
Additional Information
Formerly known as NETIQKB53616