Online Apps DBA

 You have applications (E-Business Suite 11i/R12, Portal, Discoverer, BI Publisher) integrated with Oracle Single sign-On (SSO) and users complain that they receive message ”Your Account is Locked“. Here are few things which can help you in understanding this - First thing to do in case “User account is locked” You should know how to unlock SSO account.  These are various ways using which [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

On one of Oracle Applications 11i cloned instance, OAM (Oracle Application Manager) was showing  ”Application System Name” as source Instance. like http://<url>/oa_servlets/weboam/oam/oamApps$target=source 1. My first thought was to look at FND_NODES to see if any node entry still pointing to source instance. All records in this table were pointing to target instance. If FND_NODES contain entry to source instance, I could [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

If you wish to connect to a machine by hostname (which is not registered in DNS (Domain Name Server)) you need to add <IP> <Fully Qualified Hostname> <Hostname> in Hosts file.    Adding an entry in Non Vista (Microsoft O.S. XP, 2000, NT) is pretty simple. Open hosts file (using text editor like notepad, wordpad..) and hostname entry in [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

Oracle Content Server provide Repository and Core Services required for Oracle Universal Content Management (UCM, Content Management product from Stellent) This post covers key points for Content Server Installation and documentation related to Content Server and UCM - - Installation Requirement Apart from operating system you need following software to install content server 1) JVM 1.5 (This comes by default with content server [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

           Hi Friends, I want to start posting Unix/Linux Administration concepts, as we are gettting lot of requests in the Forum. Since most of the Oracle Databases runs on Unix/Linux Platforms, as an Oracle DBA we need to have some Unix/Linux Knowledge, which we can not entirely depend on Unix/Linux Administrators. Here in coming posts, i [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

We are back with the bang !!! After receiving great response and readers demand we are announcing Oracle Apps DBA online training from 17th May-08. Course contents for the training Oracle Apps DBA Training Day 1 -Oracle Applications Background Oracle Applications E-business Suite Current,Logical, physical and functional components -Operating System Configuration E-Business Suite specific configuration of Oracle Enterprise Linux -Release 11i [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

Oracle SOA Suite 11g technical preview 4 is now available SOA Suite 11g Tech. Preview 4 is part of Jdeveloper 11g Tech Preview 4 which can be downloaded from here   Product documentation is available via Patch 7009059 BAM (Business Activity Monitoring) and B2B (Business 2 Business) are available via Patch 7009057 Related New Fatures in SOA Suite 11g Tech Preview 4  Previous in series [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

 This is last post for Installation of Oracle Role Manager deployed on JBOSS (Open Source J2EE Server) and using Oracle Database as repository. For previous related posts visit related post section at bottom of this page. Prereq. for Deploying Oracle Role Manager Application on JBOSS Ensure that- 1. You have already installed JBOSS Server   More Here 2. Installed Oracle Database 3. [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

Here are few more interview Questions targeted for Apps DBA’s with work exp. ranging from 1 to 3 years.     For answers to these question and many more Interview questions for Apps DBA’s visit http://teachmeoracle.com/forum   If you wish to share interview questions drop me a mail or leave them as comment on this post Q. How you will troubleshoot if concurrent request is [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

Oracle Role Manager is part of Oracle Identity Management Suite to manage various user roles across enterprise. ORM is product from Bridgestream acquired by Oracle in 2007. For overview of Role Manager visit my previous post under related at bottom or Visit Here  Quick Installation Steps for ORM 1) Install Application Server(IBM Websphere or JBoss). This Application Server will host [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

 Oracle Support team has given face lift (via Ajax) to http://metalink.oracle.com and this new look can be accessed via http://csm.oracle.com   You can customize your dashboard and add/remove region on page by clicking “Customize Page ….” on top right. Interesting thing I noticed is “System Health” region which displays any configuration/security related issues but in my opinion there [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

If you are planning to migrate your application server to different machine or changing existing machine’s hostname, domainname or IP address here is list of things you should know in advance. Discussion on this post if for 10.1.2.X and lower (Changing hostname on 10.1.3 and higher coming soon..) Oracle Application Server components Middle Tier- J2EE, Webcache, Portal, Wireless, [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

Universal Content Management (UCM) : is Oracle Solution for Enterprise Content Management ( from Stellent  ) Oracle Universal Content Management Consist of – Content Server( Offers Repository and Coreservices) – Application Modules which further extend capabilities of Content Server —— Web Content Management —— Document Management —— Records Management —— Digital Asset Management —— Imaging and BPM Content Server — There are two components of [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

This post covers installation of Oracle TimesTen In-Memory Database.  I am going to use this TimesTen Database as repository for Oracle Communication and Mobility Server (OCMS ) installation in my future post. What is TimesTen In-Memory Database ? TimesTen is memory resident relational database for fast response and high throughput. TimesTen database is used by applications/industry which require [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

JBOSS is open source enterprise level J2EE Server (similar to Oracle Application Server).                 This post covers installation of JBOSS (Open Source J2EE Application Server) on Linux and Windows. I am going to use this JBOSS as application Server for  Oracle Role Manager Installation in my next port.   Download JBoss Software Download JBoss 4.2.2.GA  from here  (This is platform indepedent [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

###  Read Normal Post in black font ###  Our expert team is providing online Oracle Apps DBA training via Web Conferencing, here is link for course content and Fee  ->  Oracle Apps DBA 11i course content - 26th April to 11th May ###  Read Normal Post from here ### Here are key points If you have to integrate Oracle Applications 11i/R12 with OID (for Single Sign-on access) and migrate [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

Start/Stop Oracle Apps Instance. This looks very simple, hah I know this is just run adstrtal.sh/adstpall.sh, addbctl.sh and addlnctl.sh. I used to think like this, then after gaining experience I came with my own steps. In previous approach, Did I took adequate step for checking any running concurrent requests .. did I took enough precaution to check [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

Key Points about Oracle Role Manager (ORM) –Oracle Role Manager (ORM) is Product from Bridgestream –Oracle Role manager is component of Oracle’s Identity Management product stack. –Oracle Role Manager can be installed interactively or in silent mode (using response file) –There are two options available with role manager installation a) Install Software and configure —- Require two database schemas and connectivity to [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

If you are Apps DBA, I assume you never have to do this but if you are in situation like me (Apps Server running IPTABLES firewall and you handling both Linux server and Apps) then here is quick way to open port from linux based software firewall IPTABLES. 1. Identify Port which you need to open on firewall (For [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com

Hello all, As per the request and with experience I am again returing to Cloning of Oracle Application. I know most of them know what exactly happens in cloning but still here I am trying to touch the depths. Before starting I want to ask question. Why you need to do cloning ? Why we need to [...]

This is summary of post for full content kindly visit http://onlineAppsDBA.com