Oracle Application DBA

Configure and Send EMAIL from Oracle Database             Applies to:             Oracle Enterprise Linux – Version: 7             Oracle Database 11gR2             Description:             How to configure EMAIL from Oracle Database and Send Email from PL/SQL. Solution: Following the simple steps to configure EMAIL from Oracle Database: 1.     Connect Oracle Database as sysdba 2.     Install the following two packages: SQL> @ORACLE_HOME/rdbms/admin/utlmail.sql; SQL> @ORACLE_HOME/rdbms/admin/prvtmail.plb; 3.     To set SMTP parameter: SQL> show parameter SMTP_OUT_SERVER; SQL> Alter system set SMTP_OUT_SERVER=<enter ...

Oracle EBS Open in Internet Explorer 11 on Windows 10             Applies to:             Oracle Enterprise Linux – Version: 7             Oracle EBS R12.1.3             Description:             After upgrade Windows 7 to Windows 10 on client end we face the problem,                Oracle EBS login successfully but unable to open the forms.   Solution:             Following the steps to configure Internet Explorer 11 for Oracle EBS: ·         Open the Internet Explorer 11 and Navigate to Tools à Compatibility View Settings.    Then add Domain name in the URL  (ex: oraebs....

Configure YUM Repository from installation DVD             Applies to:             Oracle Enterprise Linux – Version: 7             Description:             Configuring YUM on OEL 7 from installation DVD Solution: Following the steps to configure YUM from installation DVD: After installation of Oracle Linux 7 configure YUM repository from installation DVD to install other RPMs. Insert installation DVD of OEL 7 into CD/DVD ROM. # umount /cdrom # mount /dev/sr0 /mnt # cd /etc/yum.repos.d/ Create a new file: # vi rhel7dvd.repo Add the following details: [cdrom] name=CDROM Repo baseurl=file:///mnt enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Save the above file Clear the related caches b...

Monitor All DDL Statements at Database Level Applies to:             Oracle Enterprise Linux – Version: 7             Oracle Database 11gR2 Description:             I want to track all DDL statements at Database level. Solution: Following the steps to track all DDL statements at Database level: 1-       First to create a Table that store DDL statements CREATE TABLE DDL_MONITOR_DB (   DATE_TIME   DATE,   DDL_EVENT   VARCHAR2(500),   OS_USER     VARCHAR2(50),   MACHINE     VARCHAR2(100) ) 2-       Create a Trigger at Database level to catches all DDL statements CREATE OR REPLACE TRIGGER DDL_MONITOR AFTER CREATE OR DROP OR TRUNCATE OR ALTER ON DATABASE DECLARE ...