Category Archives: Linux - Page 2

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 »

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

Posted by on December 7, 2011 No comments

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

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 »

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 »