-
Title
Spotlight on RAC - monitoring of ASM -
Description
There is a problem with communicating with the ASM, what is the additional step required to support ASM?
-
Cause
tnsnames.ora has not included the ASM entry
-
Resolution
1. Configuration on TNSNAMES.ora :
The TNSNAMES entry for the ASM instance must include the
option (UR = A) for the Spotlight connection to work properly.
Add this portion (UR=A) to the tnsnames.ora
For example below:
ASM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Host IP>)(PORT = <port number>))
)
(CONNECT_DATA =
(SERVICE_NAME = ASM.us.oracle.com)(UR = A)
)
)
2. Configuration on Spotlight on RAC (This is available in Spotlight on RAC Chapter 3-19):
{Available only in Oracle 10g and later} Select the Monitor ASM option if you wish to monitor the performance of Oracle's Automated Storage Management (ASM) technology. ASM is built into the Oracle database kernel; it simplifies the creation and space management in Oracle RAC databases.:
- {Available only in Oracle 10g and later} In the ASM Connection String box, enter the connection string required to link to the ASM database instance that is used for storage management for the RAC database under investigation.
- {Available only in Oracle 10g and later} In the ASM Username box, enter the username Spotlight will use when logging on to the ASM database instance. The ASM instance contains only one user - SYS - so only the username and password for the SYS account on a relevant ASM instance will provide access to ASM-specific information. SYS access to an ASM instance does NOT create a security issue for the RAC database as a whole - but still you should limit access to the SYS account to trusted individuals.
Because the SYS password is stored in encrypted format, non privileged users can still access Spotlight on RAC. To do so:
-- Use a pre-configured or shared Spotlight on RAC connection.
-- Use a Spotlight connection without ASM access. Spotlight will display RAC-related data, but the ASM control on the home page, and the ASM Activity and Setup page in the Disk Storage drill-down, will contain no data.
- {Available only in Oracle 10g and later} In the ASM password box enter the user password that Spotlight will use when logging on to the ASM database instance.