Sunday, April 26, 2009

Empty emoms.properties file - Solution

When Oracle Management Service (OMS) filesystem is 100% full, you may loose /sysman/config/emoms.properties
Actually the file will remain empty with size of zero bytes.
A small file that can cause Grid Control not to function.

emctl start oms
.
.
.
Could not find Console Server Port in /software/oracle/OEM10gR2/oms10g/sysman/config/emoms.properties

Oracle claims that you have to install a new OMS instead of the old one. (Notes: 418453.1, 418159.1)

After some struggles looking for the undocumented syntax of the file,
I managed to make OMS working again.

The lesson
1. Always BACKUP
2. Monitor the filesystem of OMS itself
3. Create some jobs for deleting old logs and not needed archives.

Anyway, This is the file to be created with the following content,

emoms.properties
#Sun Apr 26 7:00:00 2009
oracle.sysman.emSDK.svlt.ConsoleServerName=oragridctl
oracle.sysman.eml.mntr.emdRepPwd= write here an unencrypted password
emdrep.ping.pingCommand=/bin/ping
oracle.sysman.eml.mntr.emdRepPort=1521
oracle.sysman.eml.mntr.emdRepDBName=oem
oracle.sysman.eml.mntr.emdRepPwdSeed= write here an unencrypted password
oracle.sysman.emRep.dbConn.statementCacheSize=30
(ADDRESS\=(PROTOCOL\=TCP)(HOST\=jigles)(PORT=1521)))(CONNECT_DATA\=(SERVICE_NAME\=oem)))
oracle.sysman.db.isqlplusUrl=http\://oragridctl\:4889/isqlplus/dynamic
oracle.sysman.emSDK.svlt.ConsoleServerPort=4889
oracle.sysman.eml.mntr.emdRepRAC=FALSE
oracle.sysman.emSDK.emd.rt.useMonitoringCred=true
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE
oracle.sysman.db.isqlplusWebDBAUrl=http\://oragridctl\:4889/isqlplus/dba/dynamic
oracle.sysman.emSDK.svlt.ConsoleServerHost=oragridctl
oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1156
oracle.sysman.eml.mntr.emdRepSID=oem
oracle.sysman.eml.mntr.emdRepServer=oragridctl
oracle.sysman.emSDK.sec.ReuseLogonPassword=true
oracle.sysman.eml.mntr.emdRepConnectDescriptor=
oracle.sysman.emkeyfile=/software/oracle/OEM10gR2/oms10g/sysman/config/emkey.ora
oracle.sysman.eml.mntr.emdRepUser=SYSMAN
oracle.sysman.db.adm.conn.statementCacheSize=2
oracle.sysman.db.perf.conn.statementCacheSize=30

No comments: