oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: PER_449800_ORA_1436

Posted by on March 21, 2012 No comments

Problem:

After logging on to E-Business Suite R12.1.3 Vision instance as UKHRMS, choosing ‘Self Service for UK Managers’, launching ‘All Actions Awaiting Your Attention’ and then  selecting a notification from the list results in the following error:

Error Page  
You have encountered an unexpected error. Please contact the System Administrator for assistance.  
Click here for exception details.

After clicking here, the following error is displayed:

Error Page  
Exception Details.  
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: PER_449800_ORA_1436:
ORA-06512: at "APPS.HR_UTIL_MISC_SS", line 1161
ORA-06512: at line 1

Solution:

User Melanie Dorat had an active application which, even though it was just an application and not an assignment, had a supervisor listed for the position which was one of her employees. Terminate the application to resolve the issue.

[amazon asin=0070077290&template=iframe image&chan=default]     [amazon asin=1453742735&template=iframe image&chan=default]     [amazon asin=0615238440&template=iframe image&chan=default]

JDK for Linux SQL Developer

Posted by on March 21, 2012 No comments

Problem:

After installing SQL Developer on Linux, which Java JDK should be installed?

Solution:

On the Java SE Downloads page (http://www.oracle.com/technetwork/java/javase/downloads/index.html), locate the Java SE Development Kit 6 Update 31 section (http://www.oracle.com/technetwork/java/javase/downloads/jdk-6u31-download-1501634.html), and download and install the Linux version of the JDK:

Linux x86 (32-bit)    77.07 MB        jdk-6u31-linux-i586-rpm.bin
http://download.oracle.com/otn-pub/java/jdk/6u31-b04/jdk-6u31-linux-i586-rpm.bin

File /etc/oratab is not accessible.

Posted by on March 14, 2012 4 comments

Problem:

After installing 11g on Oracle Linux 5, the database was not automatically created. After exiting OUI and manually running dbca, the following error appears:

File /etc/oratab is not accessible.

Solution:

The script root.sh was not run. Log on as the root user and then run $ORACLE_HOME/root.sh (usually /u01/app/oracle/product/11.1.0/db_1/root.sh).

[amazon asin=0071598758&template=iframe image&chan=default]     [amazon asin=0596514549&template=iframe image&chan=default]     [amazon asin=0071496610&template=iframe image&chan=default]

sqlplus: error while loading shared libraries

Posted by on March 14, 2012 No comments

Problem:

After installing 11g on Oracle Linux 5 and running SQL*Plus, the following error appears:

sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: 
cannot restore segment prot after reloc: Permission denied

Solution:

Turn off SELinux. As root user, issue the following command:

/usr/sbin/setenforce 0

Creating additional Linux swapfile

Posted by on March 12, 2012 No comments

Problem:

After installing Linux in a virtual machine, the memory is increased from 512MB to 1536MB. The swap file must be increased as well, but there is no additional hard drive space or partitions to increase the swap partition.

Solution:

Create a new swap file:

1. As the root user, create a 3072MB swap file (block size=1024 bytes, count=1024*3072 blocks):

dd if=/dev/zero of=/swapfile1 bs=1024 count=3145728

2. Create swap file in swapfile1:

mkswap /swapfile1

3. Set file permissions for swapfile1:

chmod 0600 /swapfile1

4. Turn on swapfile:

swapon /swapfile1

5. Add swapfile to fstab:

Edit /etc/fstab and add the following line:

/swapfile1 swap swap defaults 0 0

Reference:

http://www.cyberciti.biz/faq/linux-add-a-swap-file-howto/

-bash: ulimit: open files: cannot modify limit: Operation not permitted

Posted by on March 8, 2012 No comments

Problem:

While following online instructions for installing E-Business Suite, it is advised to add the following code to /etc/profile:

if [ $USER = "oracle" ]; then
 if [ $SHELL = "/bin/ksh" ]; then
 ulimit -p 16384
 ulimit -n 65536
 else
 ulimit -u 16384 -n 65536
 fi
fi

However, when a user logs on, the following message appears:

-bash: ulimit: open files: cannot modify limit: Operation not permitted

Solution:

Set the limits in /etc/security/limits.conf, not /etc/profile. Follow E-Business Suite installation documentation on My Oracle Support, not online!

 

 

ORA-00604, ORA-01882 While Connecting With SQL Developer

Posted by on February 29, 2012 10 comments

Problem:

While trying to connect to an Oracle 9.2.0.3 database on EBS 11.5.9 (running on Red Hat Enterprise Linux AS release 4) using SQL Developer 3.0.04, the following message appears:

An error was encountered performing the requested operations:
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
OO604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement 
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack 
can be corrected, do so; otherwise contact Oracle Support
Vendor code 604

Solution:

Change the timezone variable in sqldeveloper.conf to a valid one for the database.

Read more »

Notifications Automatically Closing

Posted by on February 17, 2012 No comments

Problem:

A preparer creates a purchase request and send it to the approver, who approves it. The preparer then receives a notification that the PR was approved, but the notification automatically disappears from the list after the browser is refreshed or when the user logs off.

Solution:

The AutoClose_FYI parameter must be changed from ‘Y’ to ‘N’ in Notification Mailer.

Then the Notification Mailer must be stopped and started for the change to take effect.

Outbound Server Unable to Make a Network Connection

Posted by on February 17, 2012 1 comment

Problem:

The Notification Mailer shows the following error:

Navigation: Oracle Application Manager > Site Map > Administration tab >
Notification Mailer (under Workflow)
Click: Workflow Notification Mailer

Component Details: Workflow Notification Mailer: TEST3 shows an error in Status
Information:

This automatic Service Component has been restarted the maximum of 10 times after
stopping with error. Thus, it has been system deactivated ->
oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component;
performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation
failed for the following parameters -> {OUTBOUND_SERVER=Unable to make a network
connection.}.

Solution:

Change Outbound Server from EBS application tier server to mail server. The Outbound Server is usually automatically reset as part of the cloning process.

Change OUTBOUND_SERVER from oratestapps.domainname to 10.x.x.x.

Read more »

Oracle Installer Not Detecting Packages

Posted by on February 17, 2012 No comments

Problem:

While installing 11gR2 64-bit version on Oracle Linux 5.7 64-bit, the installer states that certain RPMs (libaio-devel-0.3.106 and unixODBC-devel-2.2.11)  are missing. After installing the missing RPMs using the ‘rpm -Uvh’ command, the installer still does not detect the newly applied RPMs.

Solution:

Exit the 11gR2 installer, apply the RPMs and then rerun the installer.