How to send mail from OS

-
Required Package must run : utl_smtp.sql which resides under $ORACLE_HOME/rdbms/admin.


Step 1: Create table (mail Configuration table)

Table Name: mail_conf
CREATE TABLE SYS.EMAIL_MESSAGE
(
JOB_ID NUMBER,
RECIPIENT VARCHAR2(200 BYTE),
SENDER VARCHAR2(200 BYTE),
MESSAGE CLOB
)

Comments

Post a Comment

Popular posts from this blog

Supported oracle database upgrade path

-
Table 1-1 Examples of Upgrade Paths for Oracle Database 12 c Current Release Upgrade Options 12.1.0.1, 12.1.0.2 11.2.0.3 or later Direct upgrade is supported.  Perform the upgrade using the current  Oracle Database Upgrade Guide , which is this guide. 11.2.0.1, 11.2.0.2 11.1.0.6, 11.1.0.7 10.2.0.2, 10.2.0.3, 10.2.0.4 and 10.2.0.5 10.1.0.5 9.2.0.8 or earlier Direct upgrade to Oracle Database 12 c  is not supported. Solution:  Upgrade to an intermediate Oracle Database release that can be directly upgraded to the current release. You must upgrade Oracle Database releases that are not supported for direct upgrade in this release to an intermediate Oracle Database release that is supported for direct upgrade. When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release documentation. After you complete an upgrade to the intermediate release Oracle Database, you can upgrade the intermediate relea...
Read more

Oracle Linux Server 6.0 readiness for Oracle Binary

-
Image
Next Screen.... Click on Skip... Click on N ext..... Click on disred lanugage, English by default Selected. Click Next.. Click Next Click Next Click Re-initalize all  Enter Hostname Select Timezone and Click Next Enter Root Password and Click Next Procced with "Create Custom Layout" Base System Base Compatibilty Libraries Console Internet Tools Debugging Tools Directory Client Hardware Monitoring utilites Java Platform Large Systems Performance Network file system client Perfomance Tools Perl Support Storage Availabilty Tools iSCSI Storage Client Servers Server Platform System administration tools Web Services PHP Support TurboGears application framework Web Server Web Servlet Engine Databases MySQL Database client MySQL Database server PostgreSQL Database Client PostgreSQ...
Read more

11.2.0.1 oracle installation on Oracle Linux 6

-
Image
System Configuration: OS : Rhel 5.11 x86-64 RAM - 4G Oracle S/W location : /u02 download software: V17530-01_1of2.zip V17530-01_2of2.zip Unzip files: go to software location cd /backup/11g/ unzip V17530-01_1of2.zip unzip V17530-01_2of2.zip Here , it will create one folder "database" after unzipping both the files. Installation Prerequisite: (please refer  ) Installation: ./runInstaller [oracle@sourcenode01 database]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB.   Actual 13351 MB    Passed Checking swap space: must be greater than 150 MB.   Actual 3999 MB    Passed Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-09-24_08-56-47AM. Please wait ...[oracle@oel66401 database]$     Click "Next" ...
Read more