Under the Hood of Oracle Clusterware by Alex Gorbachev, Pythian

Brain Splitting Oracle

MOW2010: Under the Hood of Oracle Clusterware by Alex Gorbachev, Pythian

View more presentations from Alex Gorbachev.

High Availability And Oracle Data Guard 11g R2

Check out this SlideShare Presentation:

High Availability And Oracle Data Guard 11g R2

View more presentations from Mario Redón.

Workflow Error

Today we faced a peculiar error the invoices were not being initiated and the approval through work list was erroring out since morning
Looking at alert.log found the following

ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000061324C00040$$ by 16 in tablespace APPS_TS_QUEUES
ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000061324C00040$$ by 16 in tablespace APPS_TS_QUEUES
ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000060902C00036$$ by 16 in tablespace APPS_TS_QUEUES
ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000060902C00036$$ by 16 in tablespace APPS_TS_QUEUES


And the error seen the workflow is

[Mar 23, 2010 10:55:24 AM AST]:1269330924199:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:prd-app1.main.tadmur.com:192.168.200.100:-1:-1:ERROR:[SVC-GSM-WFALSNRSVC-13481-10003 : oracle.apps.fnd.cp.gsc.Processor.performError(ProcessorException)]:Maximum number of errors have occurred for this processing thread.
[Mar 23, 2010 10:55:25 AM AST]:1269330925626:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:prd-app1.main.tadmur.com:192.168.200.100:-1:-1:ERROR:[SVC-GSM-WFALSNRSVC-13481-10002 : oracle.apps.fnd.wf.bes.AgentListenerProcessor.read()]:Could not executeUpdate() on { CALL WF_EVENT.LISTEN ( p_agent_name => :1, p_wait => :2, p_correlation => :3, p_deq_condition => null, p_message_count => :4, p_max_error_count => :5 )} -> java.sql.SQLException: ORA-20002: 3837: An unhandled error '-604 - ORA-00604: error occurred at recursive SQL level 1
ORA-01691: unable to extend lob segment APPLSYS.SYS_LOB0000060902C00036$$ by 16 in tablespace APPS_TS_QUEUES' encountered when dispatching event 'oracle.apps.wf.notification.send' with key '213664'
ORA-06512: at "APPS.WF_EVENT", line 1560
ORA-06512: at line 1


The size of APPS_TS_QUEUES was increased and the workflow components were restarted.

User Notification Preference Update from backend

We have been facing problems when the email address is not properly defined in per_people_f and fnd_user at times the mailer changes the send mail preference to disabled. So this creates a situation where you have to ask the user to change his preference to HTML mail with attachments.

There is another way out doing it from back end.

exec FND_PREFERENCE.put('SYSADMIN', 'WF', 'MAILTYPE', 'MAILHTML');
COMMIT;

as documented in Metalink Note ID 746255.1

How to Install R12.1.1 on OEL 4.x

The steps to be followed in order to install oracle applications R12.1.1 are

1. Download the oracle software from the edelivery website (or order if from metalink)
   
2. Test the downlaoded zip file and unzip it in a directory that will make up your stage
3. check for the pre-requisites on metalink
4. create users
5. start the isntallation with the rapidwiz

Download the oracle software from the edelivery website
www.edelivery.oracle.com



Make sure you download all the parts and save it to a particular directory
once this is done test the download with the command unzip -t .zip
and then unzip it this will automatically create all the required directories

We have followed this metalink noteid 761564.1

The supported versions are OEL 4 update 4 and higher so mine is OEL 4.5 so taht will do

Minimum kernel version required is 2.6.9-42.0.0.0.1.EL

uname -r command as root user will give you the output
2.6.25.1 this is the version that I am working on.

Then there is a list of packages that you need to have installed it on your OS

• glibc-2.3.4-2.25
• glibc-common-2.3.4-2.25
• binutils-2.15.92.0.2-21
• compat-libstdc++-296-2.96-132.7.2
• gcc-3.4.6-3
• gcc-c++-3.4.6-3
• libgcc-3.4.6-3
• libstdc++-3.4.6-3
• libstdc++-devel-3.4.6-3
• openmotif21-2.1.30-11.RHEL4.6**
• pdksh-5.2.14-30.3
• setarch-1.6-1
• make-3.80-6.EL4
• gnome-libs-1.4.1.2.90-44.1
• sysstat-5.0.5-11.rhel4
• compat-db-4.1.25-9
• control-center-2.8.0-12.rhel4.5
• xscreensaver-4.18-5.rhel4.11
• libaio-0.3.105-2
• libaio-devel-0.3.105

You can check them with the help of this command rpm-qa | grep

Then there are softwares that are required to be installed

• ar
• gcc
• g++
• ld
• ksh
• make
• X Display Server

In order to check this type the command

which ar
which gcc
which X so on and so forth

The kernel paramters should be like this

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65535
kernel.sem = 256 32000 100 142
fs.file-max = 6553600
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
#################################
kernel.sem = 256 32000 100 142


you can change it in you /etc/sysctl.conf save it with the help of vi editor and
run sysctl -p

Next is
/etc/resolv.conf

have this entries in the above said location

options attempts:5
options timeout:15

Finally have the right entires in the hosts file in /etc/hosts

127.0.0.1 localhost.localdomain localhost
192.168.200.87 testoel1.erp.com testoel1

This completes the OS preperation

now create a group

groupadd dba

create a user (we will try a single user installation)

useradd -g dba kamalora

create a directory in the file system and make sure u have ample space

cd /p01
mkdir oracle
chmod -R 775 kamalora
chown -R oracle:dba kamalora

once this is done go to the staging area and navigate to the followind location

/startCD/Disk1/rapidwiz
xhost +

./rapidwiz

this will start the installation