Monthly Archives: March 2012

rm: cannot lstat file: Input/output error

Problem:

While attempting to remove a file on Linux, the message ‘rm: cannot lstat file: Input/output error’ appears:

[applmgr@oel5vis3 applmgr]$ cd /u01/VIS3/oracle/vis3db/9.2.0/oem_webstage/oracle/sysman/vbo/vbos
[applmgr@oel5vis3 vbos]$ ls -ltr
total 16
?--------- ? ?       ?      ?            ? VbosLobStorage.class
?--------- ? ?       ?      ?            ? VbosLobSQLList.class
?--------- ? ?       ?      ?            ? VbosLobOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosDimensionOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosArrayTypeOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosClusterOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosDBLinkOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosIndexOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaObjectHelper.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaObjectOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaSourceOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaClassOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosLob.class
.
.
.
[applmgr@oel5vis3 vbos]$ rm VbosLobOperations.class 
rm: cannot remove `VbosLobOperations.class': Input/output error
[applmgr@oel5vis3 vbos]$ rm -f VbosLobOperations.class 
rm: cannot remove `VbosLobOperations.class': Input/output error
[applmgr@oel5vis3 vbos]$ touch VbosLobOperations.class
touch: cannot touch `VbosLobOperations.class': Input/output error

Solution:

Unmount partition with bad file and run fsck on partition (may need to exit Terminal window and open new Terminal window).

 

ORA-12518: TNS:listener could not hand off client connection

Problem:

Unable to connect to SQL:

F:oracleVIS12dbtech_st11.1.0>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 27 11:31:04 2012

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

ERROR:
ORA-12518: TNS:listener could not hand off client connection

Solution:

Increase PROCESSES initialization parameter.

Use the following command to check the value of the PROCESSES initialization parameter in SQL*Plus:

show parameter processes

If the database was started using an spfile, then the following command can be used to change the PROCESSES initialization parameter to 500:

alter system set processes=500 scope=spfile;

If the database was started using a pfile, then the value of the processes parameter must be changed in the pfile and the database bounced.

[amazon asin=0071780262&template=iframe image&chan=default]     [amazon asin=1565922379&template=iframe image&chan=default]     [amazon asin=1430236620&template=iframe image&chan=default]

RW-20003: Error: Unzip failed: unknown reason

Problem:

While installing a Vision instance of 11.5.10.2, the following errors appears:

RW-20003: Error: Unzip failed: unknown reason.
Check log file for details.

General solution:

Verify file owner and group settings for EBS staging area.
Redownload, restage installation media from DVD or E-Delivery.
Verify MD5 checksums for files downloaded from E-Delivery.

Solution (in this case):

/u00/Stage11i/oraApps/Disk4/appl/stage/fnd_WEB3.zip corrupt. Restage.

Read more »

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

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

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.

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

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

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

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!