1 2 3 Previous Next 30 Replies Latest reply on Jul 30, 2012 11:51 AM by Dude! Go to original post
      • 15. Re: Oracle Linux
        What do you receive when you type:

        dig -t MX example.com noall answer
        • 16. Re: Oracle Linux
          any help would be much appreciated on this please. Thanks
          • 17. Re: Oracle Linux
            We understand the issue now...
            We need to configure the relay SMTP between our DB machine to relay host in our DNS. Could you please help how to do this... Thanks
            • 18. Re: Oracle Linux
              The following should do the trick:

              # yum install sendmail-cf

              # vi /etc/mail/sendmail.mc

              dnl define(`SMART_HOST', `smtp.your.provider')dnl
              change to :
              define(`SMART_HOST', `abc.xyz.com')

              # m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf
              # service sendmail restart
              • 19. Re: Oracle Linux
                Thanks, now we are able to receive the test email using the below command

                $ echo "text" | mail -s "Testing the email facility from R12-Apps Machine" me@example.com

                But, while sending as an attachment of backup log file, it just hangs on command prompt.

                $ uuencode -m /u01/appluat/scripts/log/uat_apps__hotbkp_20Apr2012.log | mailx -s "Backup Log file from R12-Apps Machine" me@example.com

                -->> If i press the CTRL+C the below message displays

                (Interrupt -- one more to kill letter)
                Null message body; hope that's ok


                Do, we still need to convert, encode and send the file as like below?

                unix2dos backup.log
                cat backup.log | uuencode -m backup.log > backup.att
                cat backup.att | mailx -s "backup logfile" me@example.com

                Please advise the correct steps. Appreciate your quick help.

                Edited by: user13681259 on May 31, 2012 8:50 PM
                • 20. Re: Oracle Linux
                  There are several ways. For instance:
                  mailx -s "Daily Report" $MAILTO <<-EOM
                  Please find attached file.
                  Kind regards
                  `unix2dos -n $ORIG_FILE $CONV_FILE`
                  `uuencode -m $CONV_FILE $CONV_FILE`
                  • 21. Re: Oracle Linux
                    Zoltan Kecskemethy
                    I know I'm a bit late but FYI I use mpack linux command to send a file as attachment... so no need a script here...
                    • 22. Re: Oracle Linux
                      Mpack does not convert Unix line endings to DOS/Windows, which was one of the required tasks.
                      • 23. Re: Oracle Linux
                        We are managed to email facility working and now the email are working. But, the file attachemnt are NOT working. Below code has been used in script

                        unix2dos -n ${LOGDIR}/Tablespace-Alert.log ${LOGDIR}/Tablespace-Alert.att
                        uuencode -m ${LOGDIR}/Tablespace-Alert.att Tablespace-Alert.att | mailx -s "ALERT - TableSpace With Less Than 20% Available FREE Space on $ORACLE_SID" me@company.com

                        Email received with below body messaeg...

                        begin-base64 644 UAT_Tablespace-Alert.att

                        Appreciate any help Thanks
                        • 24. Re: Oracle Linux
                          There is nothing wrong with the base64 encoding, in fact you can decode the text using http://base64converter.com for instance. The automatic recognizing and handling of email attachments is a task normally performed by the email client. Any sophisticated and modern email client will do. What are you using?
                          • 25. Re: Oracle Linux
                            we are not getting any attachment and email mody is with this message.

                            We need to have the log file attacment facility to eamil. Plese help to provide the steps
                            • 26. Re: Oracle Linux
                              we are not getting any attachment and email mody is with this message.
                              That's perfectly normal and just how email works. Attachments are always part of the original or transmitted SMTP message. Like I said in my previous post, to separate attachments from email you need to have an email client that can handle binary encoding and attachments. The basic Linux or Unix mail utilities will probably only handle text based email - or at least I would never dream of using them for anything else. So again, what are you using?
                              • 27. Re: Oracle Linux
                                we are sending oracle backup log as an attachment to email to support team after backup completion. But they are receiving the email with below code as message body without any attachment.

                                begin-base64 644 /u01/orauat/scripts/log/UAT_Tablespace-Alert.att

                                we would like to send the text log file as an attachment eamil to support. Pleae help us how to achive this. Thanks in advance.
                                • 28. Re: Oracle Linux
                                  I think I have already given you a reasonable answer and possible solution. If there is something you do not understand, please explain. I doubt that repeating your question is going to make it.
                                  • 29. Re: Oracle Linux
                                    I understand your update, but i'm looking the possiblities to have the email attachment facility instead of having text message body in the email.

                                    Can you give me the more deatils on email client that can handle binary encoding and attachments.

                                    Appreciate your help