Monthly Archives: December 2011

Viewing Default Oracle Database Properties

Problem:

How do I view the default settings, parameters or properties of the Oracle database?

Solution:

As sys or system user:

select * from database_properties;

 

ORA-20100: File o0150175.tmp creation for FND_FILE failed

Problem:

When running the Diagnostics: Apps Check from the Purchasing responsibility in Oracle Applications E-Business Suite 11i, the concurrent request completes in error and following error appears at the bottom of the output log:

declare
*
ERROR at line 1:
ORA-20100: File o0150175.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at “APPS.FND_FILE”, line 407
ORA-06512: at “APPS.FND_FILE”, line 581
ORA-06512: at line 120

Solution:

Ran out of disk space on the db machine. The temp directory used by EBS is in the /var directory, which is only 1GB in size. The /var directory is being filled by yum updates.

As root user, execute the command ‘yum clean all’. Stop the yum updates by issuing the command ‘/etc/init.d/yum-updatesd stop’.

AC-30202: Unrecognized action specified, Context Value Management Failed

Problem:

After sourcing APPSORA.env on and 11.5.10.2 environment and running AutoConfig, the following error appeared:

$ ./adautocfg.sh appspass=password

The log file for this session is located at: /u01/test3/test3appl/admin/TEST3_uttoratestapp03/log/12070801/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using APPL_TOP location     : /u01/test3/test3appl
        Classpath                   : /u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/u01/test3/test3comn/java/appsborg2.zip:/u01/test3/test3comn/java

promptmsg=hide - AC-30202: Unrecognized action specified. Exiting.

ERROR: Context Value Management Failed.
Terminate.

The logfile for this session is located at:
    /u01/test3/test3appl/admin/TEST3_uttoratestapp03/log/12070801/adconfig.log
$

Solution:

After unsetting LD_ASSUME_KERNEL and applying patch 6365595, applied patch 5903765 (Applications Technology 11i.ATG_PF.H.delta.6). After patch completed, ran AutoConfig without problems.

 

error while loading shared libraries: libc.so.6 while patching

Problem:

After unsetting LD_ASSUME_KERNEL, began applying patch 5903765. The following errors appeared:

Removing $FND_TOP/$APPLBIN from PATH …
uname: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
grep: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
tr: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory

Solution:

Apply patch 6365595: 11IEBS CERT ON OEL5|RH5|SLES10:UNSET LD_ASSUME_KERNEL IN ADGETLNXVER.SH.

This patch fixes all references to the LD_ASSUME_KERNEL environment variable.

Read more »

Error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory

Problem:

After sourcing APPSORA.env on the application tier of an 11.5.10.2 instance, most Linux (non-shell) commands return the following error:

$ . APPSORA.env
$ which which
/usr/bin/which: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory

Solution:

Unset LD_ASSUME_KERNEL

Read more »

ORA-00600, ORA-27301 When Creating 9i Database

Problem:

When creating a new Oracle 9i database using dbca (Database Configuration Assistant), the following error appears when the database is being created (at the ‘Creating and starting Oracle instance (46 %)’ step).

ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], []
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpsemsper

Solution:

Change the semaphore settings.

Read more »