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 your smtp server address>; SQL> shutdown immediate; SQL> startup; SQL> show parameter SMTP_OUT_SERVER; If the SMTP_OUT_SERVER parameter is set then you go to next step. 4.     Connect Oracle Database as sysdba 5.     SQL>grant execute on UTL_TCP TO <SCHEMA_NAME>; SQL> grant exe

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.com in vision.oraebs.com) using Add this website option. ·         Now navigate to Tools à Internet Options à Security. Select Internet and click on Custom Level button. Scroll down till end of the options and Disable the option Enable XSS filter. ·         Navigate to Tools à Internet Options à Security. Select Local Intranet and click on Sites button and then click on Adva

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 by yum clean all and subscription-manager: # yum clean all # subscription-manager clean Check whether you can get the packages list from the DVD repo: # yum list – noplugin   If no problem, you will update: #

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    V_OSUSER    V$SESSION.OSUSER%TYPE;    V_MACHINE   V$SESSION.MACHINE%TYPE;    V_IP    VARCHAR2(20);    V_DATABASE V$PARAMETER.VALUE%TYPE; BEGIN       SELECT VALUE INTO V_DATABASE FROM v$parameter WHERE NAME = 'db_name';                  V_OSUSER   :=S