添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接
  • Cloning Oracle Clusterware (Applicable only to 11.2.0.2.0 and not for any previous Releases)
  • 11g RAC | Using Duplicate target database 11g Active Database option
  • Replicating RAC database using RMAN at Remote Server
  • Cleaning up a machine with previous Oracle 11g Clusterware/RAC install
  • ASM ftp/http Access
  • 11gR2 RAC-Dataguard Sync issue Between Primary & Standby
  • DataGuard Monitorable (Read-Only) Database Properties
  • How to Safely Remove a Data Guard Broker Configuration under RAC/NON-RAC setup
  • Script to Collect Data Guard Physical Standby Diagnostic Information [ID 241438.1]
  • Script to Collect Data Guard Primary Site Diagnostic Information [ID 241374.1]
  • Find Index Fragmentation Level
  • Identify All Foreign keys in a Database
  • Index Fragmentation Report
  • Last Time Index Was Rebuilt
  • List Size of Databases
  • List Size Of Tables
  • List SQL Login Information
  • Locate all procedures with a SEARCH string
  • Rebuild Fragmented Indexes
  • ShrinkUserDatabases
  • Tables with column name XYZ
  • Truncate All Tables in DB
  • TSQL Partitioned Queries
  • SQL Server User Scripts

  • Split Surname from Name
  • To prevent unauthorized access to the Grid Control console, Enterprise Manager will automatically log you out of the Grid Control console when there is no activity for a predefined period of time. For example, if you leave your browser open and leave your office, this default behavior prevents unauthorized users from using your Enterprise Manager administrator account.
    By default, if the system is inactive for 45 minutes or more, and then you attempt to perform an Enterprise Manager action, you will be asked to log in to the Grid Control console again.

    11g :

    1. [oracle@EM_BOX config]$ $OMS_HOME/bin/ emctl set property -name oracle.sysman.eml.maxInactiveTime -value -1 -sysman_pwd grid_pwd
    Oracle Enterprise Manager 11g Release 1 Grid Control
    Property oracle.sysman.eml.maxInactiveTime for oms EM_BOX:4889_Management_Service has been set to value -1

    #oracle.sysman.eml.maxInactiveTime=time_in_minutes
    -1 : Unlimited Duration

    2. Restart services to apply changed value

    [oracle@EM_BOX config]$ $OMS_HOME/bin/emctl stop oms
    [oracle@EM_BOX config]$ $OMS_HOME/bin/emctl start oms

    10G :

    1. Navigate to the <OMS_HOME>/sysman/config directory
    2. Make a backup copy of the emoms.properties file. Go to the bottom of the file and add the line
    #oracle.sysman.eml.maxInactiveTime=time_in_minutes
    oracle.sysman.eml.maxInactiveTime=60

    3. Restart services to apply changed value

    [oracle@EM_BOX config]$ $OMS_HOME/bin/emctl stop oms
    [oracle@EM_BOX config]$ $OMS_HOME/bin/emctl start oms

    Pinterest

    Related Posts

    Leave a Reply

    You must be logged in to post a comment.