Wednesday, September 3, 2014

Increase POSTFIX File Sizes

Was getting log entries for postfix failures:
“file too large”
“message file too big”

The fix was to run these commands
sudo postconf -e mailbox_size_limit=0
sudo postconf -e message_size_limit=0
0 is unlimited
To set to another value enter size in bytes for example 30720000 = around 29M

The default is 10240000 bytes (around 9M)

RECONFIGURE ORACLE EM CONSOLE ON WINDOWS HOST AFTER RENAMING HOST

When running Oracle 11g etc on a Windows system the EM Console will quit working if you rename the host.  To fix you have to drop the EM Console and recreate.
Verify these items:
  • listener.ora points and tnsnames.ora files pont to the new host name instead of IP
  • make sure there is a line for the new host name in the hosts file that resolves the current IP
  • If the sysman account is locked unlock it
  • If not in the system enviromental variables already set the SID on the command line
    • c:\> set ORACLE_SID=theSID     (You can get the SID name from the ORACLE Service name in the services panel it will be something like ORACLESERVICEtheSID, the SID is the “theSID” part)
    • Do not close the command window use it to run all subsequent step, if you close it you lose the environmental variable for the ORACLE SID
  • Have the passwords for sys, DBSNMP. and sysman available