This mailing is in response to a new installation
of Oracle 10g
OS: Windows 2000 Server
Statement:
Application server can not find mail server.
Research:
After installation I looked thru the application server parameters and found smtp is defined on port 25
Problem:
Client ISP blocks port 25
Mail server and port Specification:
WebEnable standand mail package
with alternate port 27.
Mail server installation has been verifed.
How do I change the smtp port?
issue 2:
PL/SQL Packages and Types Reference
10g Release 1 (10.1)
Part Number B10802-01
160
UTL_MAIL
Operational Notes
You must both install UTL_MAIL and define the SMTP_OUT_SERVER.
To install UTL_MAIL:
sqlplus sys/<pwd>
SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.sql
Problem:
I found utlmail.sql and installed
I did not find prvtmail.sql.
Issue 3:
define the SMTP_OUT_SERVER parameter in the init.ora rdbms initialization file. However, if SMTP_OUT_SERVER is not defined, this invokes a default of DB_DOMAIN which is guaranteed to be defined to perform appropriately.
I modified init.ora.1182004185857 rbms
location $ORACLE_HOME\10.1.0\admin\idevusa\pfile
There was no entry for the SMTP_OUT_SERVER parameter
change:
###########################################
# Database Identification
###########################################
SMTP_OUT_SERVER=mail.idevusa.biz:27
db_domain=""
db_name=idevusa
Thank You
MJS