12 Replies Latest reply: Mar 4, 2013 10:06 AM by user12159859 RSS

    OEM keeps logging me out

    user12159859
      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
          BrianPa
          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
            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
              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
                BrianPa
                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
                  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
                    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
                      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
                        BrianPa
                        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
                          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
                            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
                              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
                                Thanks everyone for your help.