15
Oct

Health Check of Oracle E-Business Suite Database

List of tasks to be done as part of the Health Check

 

  1. Check database and application availability
  2. Check status of cluster services
  3. Monitor space availability in all tablespaces
  4. Check for errors in Database Alert log files and take appropriate action
  5. Check Concurrent Managers
  6. Check /tmp for space constraints
  7. Check invalid objects and compile if required
  8. ASM Grid Space Check
  9. Database and Application Mount points check
  10. Verify Backups
  11. Verify Gather Schema Statistics and Purge Concurrent Request and/or Manager Data Concurrent Requests are scheduled and are completing successfully

 

Read more...

10
Jun

User Equivalence Configuration

There are two nodes in a cluster ebsdb01.dbaarena.com, ebsdb02.dbaarena.com

cd $ORACLE_HOME/oui/prov/resources/scripts
[oraprod@ebsdb01 scripts]$ ls -ltr
total 100
-rwxr-x--- 1 oraprod oinstall 1394 Jul 20 2006 validatePaths
-rwxr-x--- 1 oraprod oinstall 6983 Jul 20 2006 ouiSetup
-rwxr-x--- 1 oraprod oinstall 35064 Dec 11 2006 sshUserSetupNT.sh
-rwxr-x--- 1 oraprod oinstall 16520 Mar 31 2009 sshConnectivity.sh
-rwxr-x--- 1 oraprod oinstall 32343 Dec 16 2009 sshUserSetup.sh

./sshUserSetup.sh -user -hosts <"hostname1 hostname 2"> -noPromptPassphrase
Read more...

Back to Top