Thursday, August 16, 2012

Troubleshooting 500 Internal Server Error in Oracle E-Business suite

500 Internal Server Error
The HTTP Response status codes beginning with the digit "5" indicates cases in which the server is aware that it has encountered an error or is otherwise incapable of performing the request. Any client (e.g. the
Web browser ) goes through the following cycle when it communicates with Web server:
* Obtain an IP address from the IP name of the web site .
* This lookup (conversion of IP name to IP address) is provided by domain name servers (DNS).
* Open an IP socket connection to that IP address.
* Write an HTTP data stream through that socket.
* Receive an HTTP data stream back from your Web server in response. This data stream contains status codes whose values are determined by the HTTP protocol. Parse this data stream for status codes and
other useful information. Now this error occurs in the final step when the client receives an HTTP status code of '500'.

Oracle 11g Fusion Middleware Installation on Linux


This note describes the (long) process of installing an 11g Fusion Middleware environment with Forms, Reports, Discoverer and Portal on an Oracle Enterprise Linux 5.6 64 Bit platform.
If you are not using Oracle Portal , then you do not need to configure Identity Management and Single Sign On which is a real big pain as there is no 11g SSO as yet and we have to install, upgrade and configure 10g SSO/DAS as well with a number of patches.
These are the top level steps:
·  Install Java SE Development Kit 6u25

·  Install Oracle Weblogic Server 11g Release 1 ( 10.3.2)

·  Install Oracle 11g R2 Database software (can be on same machine as Middleware or different server)

·  Create the 11g R2 repository database

·  Download the Repository creation for Windows available in 32 bit for Linux and Windows ( ofm_rcu_win32_11.1.1.3.3_disk1_1of1.zip) – change compatibility for Windows 7 to run it

script monitoring

select 'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||''''
from v$session
where sid in (
select SID from v$access
where object like '%NAMA_OBJECTS%')

SELECT objects.owner,
       objects.object_name,
       objects.object_type,
       user1.user_name         locking_fnd_user_name,
       login.start_time        locking_fnd_user_login_time,
       vs.module,
       vs.machine,
       vs.osuser,
       vlocked.oracle_username,
       vs.sid,
       vp.pid,
       vp.spid                 os_process,
       vs.serial#,
       vs.status,
       vs.saddr,
       vs.audsid,
       vs.process
  FROM fnd_logins      login,
       fnd_user        user1,
       v$locked_object vlocked,
       v$process       vp,
       v$session       vs,
       dba_objects     objects
 WHERE vs.sid = vlocked.session_id
   AND vlocked.object_id = objects.object_id
   AND vs.paddr = vp.addr
   AND vp.spid = login.process_spid(+)
   AND vp.pid = login.pid(+)
   AND login.user_id = user1.user_id(+)

Friday, August 3, 2012

R12 RAC Clone using rman


This article details the steps used to clone R12 RAC database to Single instance database using RMAN duplicate command, Notice that we used the control file as a catalog database and the Production will keep up and running.

The databases used here are:
 
Production: PROD 
Cloned: CPCLONE 

1- On the source system; Run the preclone script on both database and apps tiers.

Database:
$ cd ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/
$ perl adpreclone.pl

Application:
$ cd $ADMIN_SCRIPTS_HOME/appsutil/scripts/$CONTEXT_NAME/
$ perl adpreclone.pl