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

Posted by on December 7, 2011 1 comment

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

Posted by on December 7, 2011 No comments

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

Posted by on December 2, 2011 No comments

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 »

Enabling Archivelog Mode in Oracle9i

Posted by on November 18, 2011 No comments

Problem:

How do I enable archivelog in an Oracle9i database?

Solution:

After logging into the running Oracle9i instance as the SYS user (sqlplus “/ as sysdba”), check the log_archive parameters:

show parameter log_archive

Set the archive log destination directory (note that these commands assume that the database uses the spfile):

alter system set log_archive_start=TRUE scope=spfile;
alter system set log_archive_dest_1='location=/u01/archive/ORCL/' scope=spfile;
alter system set log_archive_format='arch_%t_%s.arc' scope=spfile;

Then shutdown and mount the database, and enable archivelog:

shutdown immediate;
startup mount;
archive log start;
alter database archivelog;
alter database open;

Reference:
http://www.oracle-base.com/articles/9i/ArchivelogModeOnRAC9i.php

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

 

EBS instance running out of processes

Posted by on October 18, 2011 No comments

Problem:

EBS instance running out of processes. Need to increase the database PROCESSES initialization parameter.

Solution:

Change the PROCESSES init parameter in the pfile or scope=spfile. Then restart the database (using addbctl.sh, not using the database stop immediate/startup command as shown below).

Read more »

Updating To Latest CentOS Using yum

Posted by on October 12, 2011 No comments

Problem: How do I update CentOS 5.3 to the latest version (CentOS 5.7)?

Solution:

As root user, issue the following commands:

yum makecache
yum update
yum upgrade kernel
yum install yum-utils
yum-complete-transaction
yum-complete-transaction --cleanup

Disabling sendmail from starting during bootup

Posted by on October 11, 2011 No comments

Problem: The sendmail daemon takes long to start while CentOS is booting. How do I disable it from starting during bootup?

Solution:

Use the chkconfig command.

Read more »

Java HotSpot(TM) Client VM Error When Running dbua

Posted by on October 4, 2011 No comments

Problem:

After installing Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86, sourced the 11gR2 environment and attempted to run dbua to upgrade the 11gR1 database. The following error occurred:

[applmgr@centos53server ~]$ dbua
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x9fdf64d4, pid=3662, tid=3086928080
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode)
# Problematic frame:
# C  [libnnz11.so+0x3c4d4]
#
# An error report file with more information is saved as hs_err_pid3662.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
#
Aborted

 

Solution:

Apply patch p8670579_112010_LINUX.zip.

Read more »

How To Check MD5Sums for R12 Staging CDs

Posted by on September 21, 2011 No comments

How To Check MD5Sums for R12 Staging CDs on Windows

Problem:

How do I check the MD5 checksums for R12 Staging CDs?

Solution:

In MOS document “MD5 Checksums for R12.1.1 Rapid Install Media” [ID 802195.1], download the checksum file for your platform (e.g. Windows). Then execute the following command:

md5sum --check md5sum_Windows.txt > md5sum_result.txt

Note that the md5sum command comes bundled with Cygwin. If the output from the above command shows that all lines contain the word ‘FAIL’, try converting the text file to UNIX format:

dos2unix md5sum_Windows.txt

The above command removes trailing carriage return characters from the end of the lines.

After this, retry the md5sum command.

 

How to Remove an Oracle E-Business Suite Release 12.x Windows Environment

Posted by on September 21, 2011 No comments

How to Remove an Oracle E-Business Suite Release 12.x Windows Environment

The procedure described in this document (Note 567507.1 on Oracle Metalink) lists the steps you must take to remove an E-Business Suite R12 environment or environments from a Windows system.

Step 1. Back up the System and Windows Registry

Refer to Microsoft Article ID 326216:  How to use the backup feature to back up and restore data in Windows Server 2003

Step 2. Alter the Windows Registry

Delete the relevant Oracle components from the Windows registry, as follows.

To delete all Oracle environments on the system:

* Launch the Registry Editor.
* Navigate to the HKEY_LOCAL_MACHINESoftware key.
* Select the Apache Group subkey and delete it.
* Select the Oracle subkey and delete it.
* Navigate to the HKEY_LOCAL_MACHINESystemCurrent Control SetServices.
* Carefully select and delete each service beginning with Oracle.  For example, delete “OraclePROD_<nodename>_ToolsASControl”.
* When you are finished, exit the Registry Editor.

Step 3. Alter Environment Settings

Complete these steps to delete Oracle parameters from the environment.

Navigate to the Environment Variables editing screen according to your system setup.  For example, right-click My Computer and select Properties. From the Advanced tab, click the Environment Variables button.

To remove all Oracle environments from the system:

Select the following system variable if created during the failed installation, and delete it: PERL5LIB.
Select the Path variable, but do not delete it.  Carefully edit it and remove any component with “Oracle” in the name, or that otherwise references the failed install. For example, delete “e:oraclePRODdbtech_st10.2.0bin;”.
Save and exit System Properties.

Step 4. Clean up the Program Menu

Launch the Program menu (Start -> Programs). Delete all Oracle programs groups.

Step 5. Restart your Machine

Step 6. Delete the Oracle Filesystem

Step 7. Delete Programs and Oracle Inventory Entries

To delete the inventory associated with a specific instance:

* Start the Oracle Universal Installer using: Start >> All Programs >> Oracle-<SID>_db102_RDBMS>>Oracle Installation Products>>Universal Installer
* Select Installed Products
* Enable “Show empty homes”

Deinstall the entries in the global inventory associated with the Oracle Applications R12 instance which you removed earlier. For example, for the PROD instance, you would delete:
* * RDBMS ORACLE HOME (e.g. “PROD_DB__oracle_PROD_db_tech_st_10_2_0″)
* * 10gAS ORACLE HOME (e.g.”PROD_WEBOH__oracle_PROD_apps_tech_st_10_1_3”)
* * Developer 10g ORACLE HOME (for example, “PROD_TOOLS__oracle_PROD_apps_tech_st_10_1_2”)
* Exit the Universal Installer

To delete the files associated with all Oracle environments on the system:

* Open a command window and navigate to the C:Program Files directory.
* Delete the Oracle subdirectory.
* If your Oracle Inventory directory was not C:Program FilesOracleInventory and was therefore not deleted in the previous step, locate it and delete it.

Reference:

How to Remove an Oracle E-Business Suite Release 12.x Windows Environment [ID 567507.1]