DBA Arena

Important: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed. Remove the backups after you have confirmed that the changes are successfully completed. Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

 
There are 2 ways to change the APPLSYS password:
Read more...

One of the most visible (and colorful!) user interface enhancements for Oracle E-Business Suite Release 12.2.4 is the new simplified home page:

Enabling the Simplified Home Page

When you first install or upgrade to Release 12.2.4, you will see the home page as it appeared in previous versions of Release 12.2 (configurable home page with tree-based navigator).
Read more...

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...

The changes were not applied because ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "APPS.HR_PERSON_ABSENCE_SWI" has been invalidated ORA-04065: not executed, altered or dropped package body "APPS.HR_PERSON_ABSENCE_SWI" ORA-06508: PL/SQL: could not find program unit being called: "APPS.HR_PERSON_ABSENCE_SWI"

The leave request approval works fine from the notification list but not from within the email and gives an error that the package is invalid.
Read more...

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...