Category: OEM – Grid Control

General DBA, OEM - Grid Control

How to view the security status and OMS port information?

Displays OMS port information and security status /u01/weblogic/oms11g/bin $ ./emctl status oms -details Oracle Enterprise Manager 11g Release 1 Grid Control Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : Console Server Host : calora4db01 HTTP Console Port : 7788 HTTPS Console Port : 7799 HTTP Upload Port : 4889 HTTPS Upload Port : 1159 OMS is not … Continue reading How to view the security status and OMS port information?

Alex LimaLeave a comment
General DBA, OEM - Grid Control

How to start/stop Oracle Enterprise Manager (OEM)/ Grid Control (GC)?

To start the Oracle Enterprise Manager/Grid Control components in version 11g (11.1.0.1) $ cd /bin; ./emctl start oms $ cd /bin; ./emctl start agent Where OMS_HOME is /u01/weblogic/oms11g and AGENT_HOME is /u01/weblogic/agent11g Note: This will also start weblogic too To stop Oracle Enterprise Manager version 11g (11.1.0.1) $ cd /bin; ./emctl stop agent $ cd /bin; ./emctl stop oms -all Where OMS_HOME is /u01/weblogic/oms11g and … Continue reading How to start/stop Oracle Enterprise Manager (OEM)/ Grid Control (GC)?

Alex Lima1 Comment
General DBA, OEM - Grid Control, Scripts, Shell, trace, Unix

Job to delete log and trace files from OEM

I use this script to clean up all the log and trace file from each host..  You can schedule a job in OEM to go and execute this in all hosts you want. $cat /etc/oratab ESRTSP:/oracle/app/EPW/rdbms/v10203_ee_suse10:N ESRTSS:/oracle/app/EPW/rdbms/v10203_ee_suse10:N RESTST:/oracle/app/EPW/rdbms/v10203_ee_suse10:N LISTENER_10g:/oracle/app/EPW/rdbms/v10203_ee_suse10:N AGENT_10g:/oracle/app/EPW/agent/v10203_ee_suse10:N #!/bin/ksh export PATH=/usr/bin:$PATH export USERNAME=`whoami` export HOSTNAME=`hostname` # #      Clean up Oracle Export logs # find /work/dba/logs -name ‘*${HOSTNAME}_*’ -mtime +7 -exec rm {} \; … Continue reading Job to delete log and trace files from OEM

Alex LimaLeave a comment
OEM - Grid Control

How to change SYSMAN password in OEM (OMS)

To change the Sysman password: 1. Stop the OMS instances that are associated with the repository a. opmnctl stopall 2. Change the sysman password in the database: a. Logon to sqlplus as a dba user b. Issue the command: alter user sysman identified by newpassword; c. Exit Sqlplus 3. On each management server host, cd to the OMS $ORACLE_HOME/sysman/config directory a. backup the emoms.properties file … Continue reading How to change SYSMAN password in OEM (OMS)

Alex Lima1 Comment