Re: NT Performance Monitor

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Tue, 25 Aug 1998 11:45:48 GMT
Message-ID: <35e6a346.2725969@newshost.us.oracle.com>

On 25 Aug 1998 01:05:00 GMT, "Bob" <bobandbabsy_at_worldnet.att.net> wrote:

>Using Oracle8 Enterprise Edition on NT, I’ve been unsuccessful at getting
>the NT Performance Monitor to display the Oracle objects when the SID is not
>ORCL. I have gotten it to work with the default database as
>ORCL/system/manager….but only after manually loading the Oracle objects with
>the LODCTR command and updating the opctrn80.ini file to contain the full
>path of the opctrn80.h file. With my non-default instance, I have updated
>the registry (Services>Oracle80>Performance) with my new SID name in the
>bequeth entry and used my new userid/password….and it still does not show
>the Oracle objects. I have gone to Oracle with this and have gotten
>nowhere. Has anyone got this to work outside of ORCL/system/manager????
>
>

I've done this successfully before (that is, point to a SID other than ORCL with the NT Performance Monitor). I've done this in 7.3.3, 7.3.4, 8.0.3, and 8.0.4.

Even though it sounds like you have already done this correctly, please review the following steps on your installation:

The registry must be updated to point to the instance you want to monitor using either a two task connect string or a sqlnet alias. Run the Registry Editor (REGEDIT.EXE) and navigate to:

HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Services > Oracle7 > Performance

You will need to add a key called Hostname if it does not already exist. From the Edit menu, choose New, and from the popup menu choose String Value. The value is the SID you wish to monitor, e.g. TEST. If the key already exists, simply change the value to the SID you wish to monitor.

You should also ensure that the same folder contains keys for Username and Password. These are also string values, for example "System" and "Manager".

Exit the Registry Editor and restart Performance Monitor. You will now see the Oracle objects, including Buffer Cache, Data Dictionary Cache and Data Files.

Note that the instance must be running for the Oracle objects to appear in the Object list.

The same principles apply to Oracle8, except that the key will be in the Registry folder Oracle80 rather than Oracle7.

Hope this helps.
Thanks!

Joel

Joel R. Kallman Oracle Government, Education, & Health

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Tue Aug 25 1998 - 06:45:48 CDT