Configuring Oracle Apex on 11gR2

Might ask why you would want to run Apex?  Well Apex is a very power sql driven application module that allows even the noob to advanced programmer the ability to code and create useful pages/applications.  I personally don’t have any experience with Apex from a programming standpoint and decided to at least install it to […]

Oracle DBA Interview Questions

Before I started some job searching….around 10 months ago I compiled a list of interview questions for preparation.  Yes I am a seasoned DBA, but not having gone through an interview in 5 years I decided I needed a refresher.  Some questions I came up with, others I found on Google.  I can honestly say […]

Common commands for the Oracle Applications DBA – PART 2

Common commands for the Oracle Applications DBA Part 2 # Shows present working directory pwd # Shows used/available/name of mount points in human readable format df -h # Shows folder size of current folder/subfolders du -sh # Oracle eBiz Applications script to start/stop report server $APPLCSF/scripts/$CONTEXT_NAME/ {start/stop} apps/appspswd # Oracle eBiz Applications script to start/stop […]

Common commands for the Oracle Applications DBA – PART 1

These are common commands for the oracle applications dba.  Random order, but brief description above each. # Stop all services on an application or concurrent manager server $APPLCSF/scripts/$CONTEXT_NAME/ apps/ # Start all services on an application or concurrent manager server $APPLCSF/scripts/$CONTEXT_NAME/ apps/ # Stop Apache on the application server $APPLCSF/scripts/$CONTEXT_NAME/ stop # Start Apache on […]

Create passwordless ssh/scp to two servers for oracle apps

This is a quick example of creating passwordless connection from one server to another.  This can be used for ssh or scp needs. This example was done due to needs with oracle applications and transfer of files in a script from one machine to another # Generate the keys on both machines relp1:/home/relpmgr # ssh-keygen […]

Increasing speed of applying patches (eBusiness)

We recently went through our quarterly Oracle outage and had more than 30+ patches to install on 8 nodes. There are only 2 shared APPL_TOPS and 2 in the DMZ. This makes us have to install each patch 4 times. This process took 8+ hours to complete. We even had 15 rolled into a merge […]

Loss of Oracle Responsibilities – Part 1 VPN & iExpense

Quick background about this post: Oracle eBusiness Suite Oracle Database Cisco AnyConnect VPN Microsoft AD/DNS My company INSTABC uses eBusiness Suite for it’s application front end. We will call it ‘RELP’ for use in this post. Access is granted using the application itself. We do not do LDAP, Single Sign on or OID […]

R12 on OEL5.5 64 bit vm on external hard drive

This is my first venture with R12. I’m rather experienced with 11i Apps, but R12 is new. Since I am limited on resources I am doing the following: Oracle Enterprise Linux 5.5 64 bit R12 (Oracle eBusiness Suite 12.04) VMware Workstation 7.1 Hitachi 500G external harddrive I plan on using a single vm at first […]