All posts by Atul Kumar
Oracle UDDI Registry Login Issue : 500 Internal Server Error when accessing URL
I recently installed Oracle Service Registry V 10.1.3 on Oracle SOA Suite (with Oracle Application Server 10g R3 10.1.3.2) running on Linux box. For step by step installation of Oracle Registry (UDDI) Click Here. Registry application build, including installation was successful and there was no error in install log of registry ($ORACLE_HOME/log/install.log) . After restarting […]
Read MoreHow to find out Schema Passwords in a 10gAS Application Server
There are two basic methods to find out the schema passwords in a Oracle 10gAS Application Server:- A) Steps (through the ODM tool):- 1) Log onto the host that hosts the infrastructure tier (e.g. host is – ausable) using x-windows like Hummingbird. 2) Log on as user “oracle” – the user that did the install. […]
Read MoreLDAP Installation and Migration
How to Migrate LDAP server to another machine with same architecture? The following article explains simple way to install and migrate LDAP server. I have taken two machines (host1.example.com and host2.example.com) with Oracle Enterprise Linux 4, as it is available free. Host1 machine is already installed and running with LDAP server and now we need to […]
Read MoreHow to create user for Read only responsibilites in frontend apps
Steps mentioned below are to create User with Read Only Responsibility and require fair amount of development knowledge 1. Go to $Au_TOP/resource. 2. Copy CUSTOM.pll and open the file in Form builder. 3. If you will open the package body of CUSTOM.pll in the forms builder then you will find the like below : procedure […]
Read MoreManaging Yum @ Redhat / Oracle Enterprise 4
Most of the times while we are installing prerequisites for the oracle installation, its some what painful to get the updated rpms and dependencies, especially in Redhat Enterprise and Oracle Enterpirse version 4. The following document explains us to overcome this issue. Yum is the easiest way to keep all programs up to date. It […]
Read MoreOracle 9i Multi Master Advance Replication setup, testing and troubleshooting
Objective: This paper is related to the Multi Master Replication setup, testing and troubleshooting. Introduction: In this Multi Master Replication testing two machines are being used. There will be two databases on the two different machines i.e. a) Master1 (Master definition Site) This site will be used for the administration of the Replication setup. b) […]
Read MoreStarting Concurent Managers
While teaching in class students told me that they have posted journal entries and the transaction still remains pending even though i have run script ‘./adstrall.sh’ which by default start all the application tier. drilling down i notice that some concurent managers were not started. to solve this ask my student to Alternatively try the […]
Read MoreFonts Demystified in Oracle Application 11i
“Your technical team is reporting that the report they developed in one font, when generated from oracle Applications automatically converts to another font.” The most common architecture which is deployed at customer place is the Oracle Applications server runs on UNIX flavours whereas client machine operates with Windows flavour. Generally developer uses windows machine installed […]
Read MoreRecover an accidentally deleted file when the database is still open.
On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed. But the process can continue to use its file handle, and the file can also be accessible under /proc/<pid>/fd . In the following example, we use […]
Read MoreRAC Storage
Storage Options for RAC CFS (Cluster File System) – Easy to manage but only available on some platforms. Does not address striping and mirroring. RAW – Available on all platforms but difficult to manage. Does not address striping and mirroring. NFS – Easy to manage but only available on some platforms. Does not address striping […]
Read More