Apps DBA Workshop

rman backup script fails to run in crontab where as it will succeed if executed manually. Here i am going to use a simple script just to demonstrate the successful run of rman backup script in crontab. If cronjob failed then it will generate the log information in "/var/mail/ora11g" (here ora11g is username) If the script is not written properly then it will give error messages as below: /home/ora11g/db_scripts/rman_bkp1.sh[6]: RUN: not found [No such file or directory] /home/ora11g/db_scripts/rman_bkp1.sh[7]: ALLOCATE: not found [No such file or directory] /home/ora11g/db_scripts/rman_bkp1.sh[8]: DISK: not found [No such file or directory] /home/ora11g/db_scripts/rman_bkp1.sh[9]: BACKUP: not found [No such file or directory] /home/ora11g/db_scripts/rman_bkp1.sh[10]: RELEASE: not found [No such file or directory] /home/ora11g/db_scripts/rman_bkp1.sh: line 10: syntax error at line 11: `}' unexpected sample script which will run successful in crontab: There is no backup fo

There was on error in accessing ERP Forms though all per-requisites exists on the system. I've encountered this issue on freshly configured system. In earlier post I've discussed about this issue: http://appsdbaworkshop.blogspot.com/2011/02/frm-92101-there-was-failure-in-forms.html This issue will solved only if yo will Install same version of openmotif as mentioned in Installation document. If you have higher version of rpm then its simply not going to workout. Required version of openmotif rpm - openmotif21-2.1.30-11.EL5.i386.rpm Actual version exists on system - openmotif22-2.2.3-18.EL5.i386.rpm If you do not want to Install the old version of rpm and want to access the forms using the same rpm "openmotif22-2.2.3-18.EL5.i386.rpm" then this is the post/article which you're looking for : Form error message: Application Error log: 12/03/24 13:56:12.509 formsweb: Forms session <1> aborted: runtime process failed during startup with errors /u01/applR12/PR OD

Detailed article for upgrade Apps R12 database from version 11gR1 to 11gR2 So many individuals keep on requesting me to post an article about - "Upgrade database to 11gR2 in an Oracle E-Business suite R12.1.1 Environment" Oracle E-Business suite R12.1.1 will be shipped with database version 11.1.0.7. Here is the step-by-step approach for upgrading database version from 11.1.0.7 to 11.2.0.1 1) Pre-Upgrade Steps - perform all OS per-requistes for Installing 11gR2 SW - Install 11gR2 database software only - Install 11gR2 examples CD - copy required file from 11gR1 (11.1.0.7) $ORACLE_HOME to 11gR2 (11.2.0.1) $HOME - perform a full system cold backup - Install all required application and database patches - Run pre-upgrade utlu112i.sql and update changes as required 2) Upgrade - execute dbua to perform an database upgrade - verify the upgrade logfile for any errors 3) Post upgrade steps - start database listener - Run scripts (adgrants.sql, adctxprv.sql, wfaqupfix.sql) on

This article will illustrate how we can deploy an agent on Hosts with Oracle Enterprise manager 12c cloud control. If we want to manage any resources (database, OS, Web Server) then we need to have a management agent on these resources in order to manage them. In Oracle EM these resources will be called as targets. Oracle EM 12c cloud control offers 2 type of agent deployment: 1) Configuring Automatic Discovery 2) Manually Adding targets Here in this post i am going to demonstrate how to manually add an host to Oracle 12c EM. Step 1: Perform Agent deployment pre-reqs on Host Step 2: Deploy agent from EM 12c cloud control console Step 1: Perform Agent deployment pre-reqs on Host: -> create OS user (owner of EM agent) [root@erpappl1 ~]# useradd agent12c You have new mail in /var/spool/mail/root [root@erpappl1 ~]# passwd agent12c Changing password for user agent12c. New UNIX password: BAD PASSWORD: it is based on a dictionary word Retype new UNIX password: passwd: all authentication to