This discussion is archived
12 Replies Latest reply: Mar 4, 2013 8:06 AM by user12159859 RSS

OEM keeps logging me out

user12159859 Newbie
Currently Being Moderated
I am using OEM DBConsole (database version 11.2) and it keeps logging me out after so many minutes of inactivity unless I happen to be in one of the performance monitoring screen that automatically refreshes every xx seconds.
I've had the same issue with OEM Grid Control.
Is there a setting someplace to turn this off so it doesn't continue to log me out?
  • 1. Re: OEM keeps logging me out
    BrianP Journeyer
    Currently Being Moderated
    Yes. See MOS note 1170373.1 for DBControl and note 234875.1 for Grid Control. It's also in the Grid Control documentation at http://docs.oracle.com/cd/E11857_01/install.111/e16847/addnl_tasks.htm#i1025313 .
  • 2. Re: OEM keeps logging me out
    user12159859 Newbie
    Currently Being Moderated
    Thank you very much Brian.
    I knew there was a way, but I sure couldn't find it anywhere.
    Thanks again.
  • 3. Re: OEM keeps logging me out
    user12159859 Newbie
    Currently Being Moderated
    Well, crud... I tried what the paper suggested, but it did not work. Also, it said to edit the $OH/sysman/config/emoms.properties file, but we don't have that on any of our servers using DBConsole. Instead, we have emoms.properties.emca, and an emd.properties.

    I edited the emoms.properties.emca file and added the lines below, but it did not fix the logging out. I just tested it again and it logged out in less than one hour.

    #oracle.sysman.eml.maxInactiveTime=time_in_minutes
    oracle.sysman.eml.maxInactiveTime=480

    Then, I stopped and restarted the dbconsole as:

    $OH/bin/emctl stop dbconsole
    $OH/bin/emctl start dbconsole

    Edited by: user12159859 on Mar 1, 2013 12:07 PM
  • 4. Re: OEM keeps logging me out
    BrianP Journeyer
    Currently Being Moderated
    For DBConsole the file should be in $ORACLE_HOME/[hostname_sid]/sysman/config according to note 1170373.1, but it has been a while since I used DBConsole. Editing that file, assuming it exists, then restarting DBConsole should do it. If I remember right, the emoms.properties.emca file is a set of defaults created when you use emca to configure DBConsole, and you can copy that file and save the copy as emoms.properties, then make your edits in the copy. I don't think DBConsole actually looks at the content of the emoms.properties.emca file.

    Good luck!
  • 5. Re: OEM keeps logging me out
    user12159859 Newbie
    Currently Being Moderated
    I think I may have figured it out.
    Very strange, because I'm not as familiar with dbconsole as I am with Grid.
    Anyway, so for kicks, I decided to execute the command: $OH/bin/emctl status agent
    Not thinking it would work because I don't have an OMS Grid agent installed.
    But, low and behold, it gave me typical status as if it were showing me the status of the Grid agent.
    Now this is strange, but then I noticed it is showing me:
    -- server and database names removed --
    
    Also, notice the dbversion, and agent version.
    How does that happen when I'm not running an agent?
    
    Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
    Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
    ---------------------------------------------------------------
    Agent Version     : 10.2.0.4.3
    OMS Version       : 10.2.0.4.3
    Protocol Version  : 10.2.0.4.3
    Agent Home        : /oracle/product/db/11.2.0.2/<sserver>_<dbname>
    Agent binaries    : /oracle/product/db/11.2.0.2
    Agent Process ID  : 28857
    Parent Process ID : 28820
    Agent URL         : https://<server>:3938/emd/main
    Repository URL    : https://<server>:1158/em/upload/
    Started at        : 2013-03-01 15:07:06
    Started by user   : oracle
    Last Reload       : 2013-03-01 15:07:06
    Last successful upload                       : 2013-03-01 15:08:07
    Total Megabytes of XML files uploaded so far :     0.36
    Number of XML files pending upload           :        0
    Size of XML files pending upload(MB)         :     0.00
    Available disk space on upload filesystem    :    56.61%
    Data channel upload directory                : /oracle/product/db/11.2.0.2/<server>_<dbname>/sysman/recv
    Last successful heartbeat to OMS             : 2013-03-01 15:08:37
    ---------------------------------------------------------------
    Agent is Running and Ready
    Okay, so this is not where I changed the emons.properties file.
    Instead, I changed it at $OH/sysman/config.
    So, trying to change this one now and giving it another test...

    Stay tuned....
  • 6. Re: OEM keeps logging me out
    user12159859 Newbie
    Currently Being Moderated
    Yep, I think you are right Brian. I haven't used dbconsole in a while.
    I've mainly used OMS Grid. DBConsole lacks a lot of functionality and reports and things that Grid is much better at.
    Oh well.... more for that later.
  • 7. Re: OEM keeps logging me out
    user12159859 Newbie
    Currently Being Moderated
    Well darn... now I have problems to get it started again.
    I made copies of the file(s) before making changes, and even copied back the original files.
    But when I attempt to start the dbconsole, it says "Failed" and I cannot connect to it using my browser.
    Something is obviously wrong.
    When I check the emctllog file, it shows
    12132 :: Fri Mar  1 15:35:01 2013::AgentStatus.pm:Processing stop agent
    29539 :: Fri Mar  1 15:51:24 2013::AgentStatus.pm:Processing status agent
    29539 :: Fri Mar  1 15:51:25 2013::AgentStatus.pm:emdctl status returned 3
    But when I check emagent.log, it shows:
    2013-03-01 15:44:14,948 Thread-1581773600 Starting Agent 10.2.0.4.3 from /oracle/product/db/11.2.0.2 (00701)
    2013-03-01 15:44:14,993 Thread-1581773600 Invalid expression fc_bykeep_used ) (00101)
    2013-03-01 15:44:14,996 Thread-1581773600 [Oracle Exadata Storage Server] InstanceProperty (MgmtIPAddr2) is marked OPTIONAL but is being used (00506)
    2013-03-01 15:44:15,015 Thread-1581773600 Undefined column name __intervalONNECT_DATA in expression ((gc_cr_recv < _gc_cr_recv) ? 0 : (gc_cr_recv - _gc_cr_recv))/__intervalONNECT_DATA=(SID=%SID%)))
                 (00104)
    2013-03-01 15:44:15,015 Thread-1581773600 Undefined column name __intervalCT_DATA in expression ((gc_cur_recv < _gc_cur_recv) ? 0 : (gc_cur_recv - _gc_cur_recv))/__intervalCT_DATA=(SID=%SID%)))
                 (00104)
    2013-03-01 15:44:15,015 Thread-1581773600 Undefined column name __intervalrvalCT_DATA in expression ((gc_cr_serv < _gc_cr_serv) ? 0 : (gc_cr_serv - _gc_cr_serv))/__intervalrvalCT_DATA=(SID=%SID%)))
                 (00104)
    2013-03-01 15:44:15,015 Thread-1581773600 Undefined column name __intervalCT_DATA in expression ((gc_cur_serv < _gc_cur_serv) ? 0 : (gc_cur_serv - _gc_cur_serv))/__intervalCT_DATA=(SID=%SID%)))
                 (00104)
    2013-03-01 15:44:15,015 Thread-1581773600 Undefined column name __intervalATA in expression ((msg_sent_dir < _msg_sent_dir) ? 0 : (msg_sent_dir - _msg_sent_dir))/__intervalATA=(SID=%SID%)))
                 (00104)
    2013-03-01 15:44:15,015 Thread-1581773600 Undefined column name __intervalinterval in expression ((msg_recv_act < _msg_recv_act) ? 0 : (msg_recv_act - _msg_recv_act))/__intervalinterval=%SID%)))
                 (00104)
    2013-03-01 15:44:15,073 Thread-1581773600 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)
    2013-03-01 15:44:15,844 Thread-1581773600 EMAgent started successfully (00702)
    Like I said, both original files are back in place as they were originally.
    Do I need to remove all the logs and files and clearstate the agent like we do with Grid?
  • 8. Re: OEM keeps logging me out
    BrianP Journeyer
    Currently Being Moderated
    I'm not aware of any clearstate functionality in dbconsole, but it's looking like something else is going on here. Hopefully somebody else with more recent 11g dbconsole experience can help you out. I apologize if I've somehow sent you down a bad path!
  • 9. Re: OEM keeps logging me out
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    user12159859 wrote:
    I am using OEM DBConsole (database version 11.2) and it keeps logging me out after so many minutes of inactivity unless I happen to be in one of the performance monitoring screen that automatically refreshes every xx seconds.
    I've had the same issue with OEM Grid Control.
    Is there a setting someplace to turn this off so it doesn't continue to log me out?
    Post Logs for emctl ?
    Also Post listener.log
  • 10. Re: OEM keeps logging me out
    user12159859 Newbie
    Currently Being Moderated
    Never mind. Problem solved.

    When I looked in the emagent log file, I saw: OALL8 is in an inconsistent state

    I had stopped and restarted the DBConsole agent several times, but every time it still failed.
    I even restarted the database, but still the same results.

    After Goggling several sites, I found that this may be related to a bug that causes memory leaks and restarting the server solves the problem.
    I did that, and everything worked again, which apparently proves it was related to a memory problem.
  • 11. Re: OEM keeps logging me out
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    user12159859 wrote:
    Never mind. Problem solved.

    When I looked in the emagent log file, I saw: OALL8 is in an inconsistent state

    I had stopped and restarted the DBConsole agent several times, but every time it still failed.
    I even restarted the database, but still the same results.

    After Goggling several sites, I found that this may be related to a bug that causes memory leaks and restarting the server solves the problem.
    I did that, and everything worked again, which apparently proves it was related to a memory problem.
    Thanks For sharing ,Please don't forget to mark this thread
  • 12. Re: OEM keeps logging me out
    user12159859 Newbie
    Currently Being Moderated
    Thanks everyone for your help.

Legend

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