Start WebLogic Server on Linux on port 80, 443 <= 1024

On Unix based system (Linux, Solaris ..), only super user (root) can start any process on port <= 1024 . From security reasons its is not desirable to run WebLogic server as root user.  Solution is to start WebLogic process as root (bind on port 80, 443) and then switch process to non privileged user like oraweblogic or nobody. […]

Read More

Oracle Apex Architecture and configure Apex using embedded PL/SQL gateway

Apex (Application Express / earlier HTMLDB) : is web application development tool for Oracle Database. Components in Apex : Oracle Database, tables and PL/SQL code in database, Apex Engine, Oracle HTTP Server (optional from 11.1 database), PL/SQL gateway (from 10g EX or 11.1 and higher only) in place of Oracle HTTP Server Request flow in Apex […]

Read More

Integrate Oracle BI Server with LDAP Server (OID – Oracle Internet Directory)

In this post we are going to cover steps to integrate OBIEE with OID. By default BI users are stored locally and authenticate against BI Server. OBIEE support authentication via LDAP Server (OID, iPlanet, openldap server). . Integration of OBIEE with OID is required if 1. You wish to use OID as user repository for […]

Read More

Oracle WebCenter Suite Installation Overview

Oracle WebCenter Suite is available in Oracle Application Server 10g R3 (10.1.3.2). This post covers technical overview, components and Installation steps for Oracle Web Center Suite. Key Components of WebCenter Suite 1. WebCenter Framework – 2. WebCenter Services – . Technical Components of WebCenter Suite i)   OC4J for Oracle WebCenter Framework  (OC4J_WebCenter) ii)  OC4J for […]

Read More

Interview Questions for Oracle Apps DBA’s (11i/R12) – Part 9

Few more Interview questions for Apps DBA’s Q. I am applying database patch using opatch. I don’t have oraInventory, can I apply database patch ? No, you can’t apply a database patch using opatch if Inventory is missing. Register ORACLE_HOME with global Inventory (in case inventory is missing) using steps mentioned here  “3.6.2 Creating the Central […]

Read More

How to set up SSH for No Password on SunOS

This setup will allow you to log in to another account without having to provide the password.      Identify the Sun Server’s and its user id’s among which you wish to enable secure session without passwords. The below steps concentrates on SSH2, the second version of SSH. Don’t use the first version any longer; it […]

Read More

Share files/folders from Windows to Linux on VMWare

This post is for our Online Apps DBA trainees trying to install Oracle Application on Virtual Linux machine. If you install Linux O.S. as (Guest Operating System) on top of your existing windows machine using VMware virtual Server check here, Next step is to copy R12/11i/oracle software from windows machine to VMware Linux O.S. Steps […]

Read More

User Management in OBIEE using BI Administration Tool

This post covers managing users in Oracle Business Intelligence Server (OBIEE) using Security Manager in BI Administration Tool Security Manager – is used to setup users, groups, synchronize LDAP users and  Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access.                        User Accounts can […]

Read More

Migrating Oracle Applications 11i

Platform Migration of Oracle Applications Migrate Platforms with Oracle Applications 11i to Linux platform While migrating to a new platform, we must make sure that the new platform is certified/supported by Oracle for both the database and the Apps tiers, if migrating both. If migrating just one of the tier to the new platform, then […]

Read More

Is your Single Sign-On (AS-SSO) Server revealing too much information ?

Without going too much into write-up, lets evaluate Oracle’s own implementation of Single Sign-On Server i.e.  https://login.oracle.com  (In use by application like OTN, Conference.. ) Server Name & Identity Management Version If you check screen shot (Oracle’s Login Server i.e. https://login.oracle.com), you can figure out that Login server (Single Sign-On Server) is using Oracle Identity Management (10.1.4.0.1) This […]

Read More