Oracle Apps DBA Issues

After logging into the Oracle Applications R12, some users are complaining about the error "You have insufficient privileges” Error but they click the home button it is working fine.

Solution:-

1. Manually run the Compile Security' concurrent program, set the parameter to YES

2. Restart the Middle Tier (Apache).

3. Retest the issue.

After logging into the Oracle Applications R12.1.2,They get the pop up message:"Number of open notifications Please use the workflow worklist to view and respond to your notification"

Solution:-

Each Application user that has notifications will be notified of them upon login if the Sign-On: Notification System

Profile option was set to yes. If you wish to stop getting these messages, request you to do the following:

1. Log into Oracle Applications.

2. using the System Administrator responsibility perform the following navigation:

/Profile /System /

3. Within the Profile window, enter: Sign-On: Notification and click on Find.

4. Using the list of values, this feature can be enabled setting it to Yes or Disabled setting it to No.

5. After changing the setting to No, log out of Applications and back in where the change will be in place.

Active users Request shows completed error in R12.

When we check the log file it shows below error

There was an error trying to initialize the HPI library.

Please check your installation, HotSpot does not work correctly

when installed in the JDK 1.2 Solaris Production Release, or

with any JDK 1.1.x release.

signal chaining not allowed for VM interrupt signal, try -XX:+UseAltSigs.

Program exited with status 1

Solution:-

At application user level go to $ORACLE_HOME/bin and take the backup of reports.sh file .then

vi reports.sh (under #Solaris Sparc we have to modify)

## Default settings

else

## Solaris Sparc

LD_LIBRARY_PATH=$ORACLE_HOME/jdk/jre/lib/sparc:$ORACLE_HOME/jdk/jre/lib/sparc/native_threads:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:${LD_LIBRARY_PATH}; export LD_LIBRARY_PATH

We have to add the $ORACLE_HOME/jdk/jre/lib/sparc/server: to starting of above path then we can see like below

LD_LIBRARY_PATH=$ORACLE_HOME/jdk/jre/lib/sparc/server:$ORACLE_HOME/jdk/jre/lib/sparc:$ORACLE_HOME/jdk/jre/lib/sparc/native_threads:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:${LD_LIBRARY_PATH}; export LD_LIBRARY_PATH

Note: The above solution is applicable on Solaris platform only

How to purge the bne.log file under $BNE_TOP/log in Oracle EBS R12

Solution:-

>bne.log

The core files shows big size under dbs directory in db oracle home

Solution:-

1. First we have to remove the core files under dbs directory by using >core command

2. Set sqlnet.expire_time=0 in $ORACLE_HOME/network/admin/sqlnet.ora on the server.

Restart the listener to ensure that these changes take effect.