This discussion is archived
4 Replies Latest reply: Oct 31, 2012 6:24 PM by user735250 RSS

OEM - RAC issue

BSalesRashid Explorer
Currently Being Moderated
Hi fellows,
I am using Oracle RAC 10g, with Database in 10.2.0.5 version. On Linux 2.6.18-92.1.13.el5 #1 SMP Thu Sep 4 03:51:21 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux .
I have a problem regarding OEM:
Last night we joined in the summer-time, and today we saw that the OEM was not working for one node only [2]. Fine, we did some configuration regarding the Timezone [TZ], checked the OS Timezone, and changed the timezone from the database to -2 [just like the OS].
Ok, we saw that the time worked perfectly, and that node [2] was working normally, but the other 2 nodes do not show activity, no graphics.

Then i checked the dbconsole:
[oracle@fastora1:/home/oracle]$ emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://fastora1:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
-----
Logs are generated in directory /u01/app/oracle/product/10.2/db_1/fastora1_cms1/sysman/log


And then i checked the logs:

The most interesting one is emagent.trc that everytime i try to see the graphics at node1 shows this:
2012-10-22 17:02:27 Thread-4095720336 ERROR fetchlets.oslinetok: Process stderr = ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)

2012-10-22 17:02:27 Thread-4095720336 ERROR engine: [osm_instance,+ASM1_fastora1,Response] : nmeegd_GetMetricData failed : ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)

I looked for something related, but did not found nothing good to help me resolving this issue.

I checked the users SYSMAN and DBSNMP and they are not locked [We adjusted here to never lock].

Hope you guys can gimme a little help with this..

Thanks in advance.

Best regards,
  • 1. Re: OEM - RAC issue
    BSalesRashid Explorer
    Currently Being Moderated
    Closing the thread. i did not get any answer.
    Thinking about not to open more thread relationated with Oracle Enterprise Manager.
  • 2. Re: OEM - RAC issue
    BrianP Journeyer
    Currently Being Moderated
    I'm disappointed at the lack of help you're receiving but I think many of us are focused on the Grid Control and Cloud Control environments -- I know that I remember very little about DBControl monitoring. You may get better help here if you can migrate to EM12cR2.

    My only suggestion for you is to re-confirm that the password files on each instance are all set up correctly. Take a look at notes 790214.1 and 778805.1, compare the contents of $ORACLE_HOME/dbs/orapw[SID] on each host to make sure they match. Make sure you can login directly to each instance using the passwords you believe are configured for DBSNMP, SYSMAN, and SYS as SYSDBA; use EZconnect strings to reach each instance directly or add new tnsnames.ora entries if needed.

    Good luck.
  • 3. Re: OEM - RAC issue
    899308 Newbie
    Currently Being Moderated
    Let me connect with engineering to see if we can help you. Stay tuned.

    -Mughees
  • 4. Re: OEM - RAC issue
    user735250 Newbie
    Currently Being Moderated
    Hi,

    What is the monitoring user - dbsnmp or a sysdba user? Go to Monitoring Configuration page and click on Test Connection. Is that successful? Also, try Test Connection against each RAC instance in the instances table at the bottom of the page. Let me know the results of this first and then we can look at next steps.

    Thanks,
    Ravi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points