IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: May 2008

Oracle Database Recovery Details

5 Comments Posted by on May 29, 2008

Recovery Fundamentals: This post is to give you information about various recovery fundamental details and how recovery works. We will start by looking at various SCNs and where they are stored. There are 3 SCNs basically in control file Checkpoint SCN Stop SCN Thread checkpoint SCN Checkpoint SCN is the datafile checkpoint SCN when checkpoint [...]

Oracle Database 9i , ,

Excess redo log generation during Hot Backup – Oracle 9i

24 Comments Posted by on May 27, 2008

Many of you must have heard or experienced that while taking hot backup of database LGWR process writes aggressively. Meaning that more redo data has been written to redo log file and consecutively more archive logs gets generated. Here is the common misconception we have in our mind. If some one ask, why excessive redo [...]

Oracle Database 9i , , ,

Changing SMTP port in Oracle Collabsuite 10g

Leave a Comment Posted by on May 23, 2008

Some times we encounter a situation where we need to change the SMTP E-mail port after OCS (Oracle Collabsuite) is installed. For example, you have installed collabsuite 10g with SMTP port as 30 and after installation requirement comes to change SMTP port to 25. In such situation you can follow below steps to make the [...]

Oracle Middleware ,

Uploading excel sheet using Oracle Application Express (APEX)

139 Comments Posted by on May 21, 2008

Introduction: Some times we need the flexibility to upload the data to a table from excel sheet. The can be implemented very well in JSP and other application. I was having this requirement to implement the same in Oracle Application Express (APEX). I was going though one of the blog by Ittichai, for the same [...]

Oracle Application Express , , ,

Upgrading Developer 6i with Oracle Applications 11i

Leave a Comment Posted by on May 20, 2008

Introduction: Some times we face problem due to older version or incorrect version of developer 6i in Oracle Applications 11i. For example I can explain my scenario, where I had to upgrade Forms Developer 6i version from Patch level 17 to Patch level 18. I was trying to apply patch 6372396 TXK AUTOCONFIG AND TEMPLATES [...]

Oracle Applications 11i ,

Enabling SSL for Infra Tier – Oracle Application Server 10g

1 Comment Posted by on May 19, 2008

This small post is to let you know, how to enable SSL for for infrastructure tier in oracle application server 10g. When we start the apache server for infra tier, it runs in non SSL mode by default. However we can change from non SSL to SSL by doing a small change in opmn.xml file [...]

Oracle Middleware , ,

Dealing with Oracle Certificate Authority – Oracle Application Server 10g

1 Comment Posted by on May 19, 2008

Introduction: Digital certificates are essential to securing an enterprise infrastructure deployment. Oracle Application Server Certificate Authority generates and publishes X.509 v3 PKI certificates to support uses such as securing network connections, digital signatures, and strong user authentication methods. Key features of Oracle Application Server Certificate Authority include its easy, out-of-the-box deployment and a web-based, self [...]

Oracle Middleware , , , ,

Utility to check techstack components – Oracle Applications

Leave a Comment Posted by on May 16, 2008

There is a good utility for checking all the techstack components and there versions present in e-business application. This is applicable to both 11i and R12 environments. There is a script $FND_TOP/patch/115/bin/txkInventory.pl on apps side which is going to fetch the versions of all components on apps side. This script can be run by giving [...]

Oracle Application R12, Oracle Applications 11i , , , , ,

One Good Year …

3 Comments Posted by on May 14, 2008

First of all, I would like to thank all the visitors of this blog for there support and co-operation extended and making this blog a success !!! THANKS A TON !!! I started this blog exactly an year a go… with an intention to keep notes of the things that I do, so that some [...]

General

Start/Stop LISTENER_ES as Oracle User in Oracle Collabsuite 10g

Leave a Comment Posted by on May 13, 2008

Introduction When we install Oracle Collabsuite 10g, we can administer all the services using oracle user (user who has installed Oracle Collabsuite 10g) except one service, which is LISTENER_ES. LISTENER_ES is a apps side listener which is mainly responsible for bringing up SMTP and IMAP ports. All the ports for apps tier are defined in [...]

Oracle Middleware , ,

← Older posts

Follow

Get every new post delivered to your Inbox.

Join 156 other followers