Oracle Application Server Vs. Oracle WebLogic Server

Are you working with Oracle Application Server ? If you are familiar with the architecture of Oracle AS then a comparison study would be easy to grasp the Weblogic concepts. Here are some of my observations during my Weblogic study phase – This way it is easy to remember basics. Architecture Comparison In Oracle AS […]

Read the rest of this entry »

How to change ASM SYS Password and Creating SYSASM user 11g.

Things tried: SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We can not change the password for ASM databases via alter user command.Because passwords are managed through password file […]

Read the rest of this entry »

Certification – Oracle Database 11g New Features for Administrator 1Z0-050

Are you Oracle 10g OCP ? Then its time to upgrade for 11g OCP. Its very easy, focus on 11g new features – you can refer to Arup Nanda’s top new features white paper from Oracle web site also go through bellow questions, these are 100% sure questions repeated in all exams. QUESTION 1 Identify […]

Read the rest of this entry »

Oracle WebLogic Server 11g – JVM Diagonostics – Sun JVM & JRockit JVM

Java Virtual Machine (JVM) : The Java Virtual Machine (JVM) is a virtual “execution engine” instance that executes the bytecodes in compiled Java class files. Java programs are compiled into a form called Java bytecodes. To the JVM, a stream of bytecodes is a sequence of instructions. Tuning the JVM to achieve optimal application performance […]

Read the rest of this entry »

Fusion Middleware Overview – Become a Fusion DBA

Fusion Middleware – Portfolio of Oracle Middleware Products Here are the Fusion Middleware  family of products Application Server – Java EE 5.0  Containers SOA Suite – Integration and Process Management User Interaction – Web Center and Portal Identity Management Suite – Broad range of IM products Business Intelligence – Platform for BI and Data Warehousing […]

Read the rest of this entry »

Oracle Application Integration Architecture (AIA) Foundation Pack

Oracle Application Integration Architecture ( AIA) FP: Oracle Application Integration Architecture (AIA) Foundation Pack to integrate heterogeneous application portfolio to build cross-functional business processes. Foundation Pack will help to overcome the most common yet critical application integration challenges by providing you with a set of prebuilt enterprise objects and services, application integration management infrastructure and […]

Read the rest of this entry »

Oracle Primavera P6 Architecture

Primavera P6 Primavera provides a set of integrated components that meet the project management needs of different areas of an organization. It uses standard Windows interfaces, Web-enabled technology with application server and database support. Primavera P6 can be implemented on a standalone or client/server machine. For the client/server implementation requires the installation and configuration of […]

Read the rest of this entry »

Installing Oracle WebLogic Server 11g

WebLogic Server 11gR1 (10.3.0) Oracle WebLogic Server forms part of Oracle Fusion Middleware portfolio and supports Oracle, DB2, Microsoft SQL Server, MySQL Enterprise and other JDBC-compliant databases. Oracle WebLogic Platform also includes: Portal which includes Commerce Server and Personalization Server WebLogic Integration WebLogic Workshop, an Eclipse IDE for Java, SOA and Rich Internet applications JRockit, […]

Read the rest of this entry »

Oracle Performance Tuning – How to Use AWR ?

Here are few silver bullets to use AWR for diagnosing performance issues ….. AWR – Automatic Workload Repository Detailed & comprehensive performance history Based on “snapshot” (time interval) Automatic Database Diagnostic Monitor (ADDM) About 79 DBA_HIST_* “tables” Defaults: Hourly snapshots Weekly retention (month is better) Overview of important AWR tables DBA_HIST_SNAPSHOT PK: SNAP_ID DBID, INSTANCE_NUMBER […]

Read the rest of this entry »

DB Console issue after cloning 11.5.10.2 environment

DB Console issue after cloning 11.5.10.2 environment Issue: – 1 — On Applications 11.5.10.2 with RDBMS 11.1.0.7: After cloning dbconsole cannot start. When Checking the $ORACLE_HOME/bin directory and the following emagent, emdctl programs are missing. Step by Step Solution to start and discover DB target to DB Console in Stat and elabs Environments: 1)     Source […]

Read the rest of this entry »

Oracle E-Business Suite 11i to R12 Quick Transition

Here are some capsules for Oracle E-Business Suite 11i to R12 knowledge transition. Tech Stack Client Sun 1.5 Plug-in Middle Tier Application Server 10.1.3 Application Server 10.1.2 $ORACLE_HOME version (prev 8.0.6): /orachat/product/tech_st/10.1.2 $ORACLE_HOME version (prev 8.1.7): /orachat/product/tech_st/10.1.3 RDBMS Tier Oracle 10g R2 XDK XDB Scripts Also you can refer my previous post @ onlineappsdba …….. […]

Read the rest of this entry »

Tuning High CPU Consumption on Oracle server

For any performance tuning issue, our strategy in diagnosing the problem is to take a “top-down” approach and follow the trail of highest CPU consumption down to the offending processes, and eventually the offending sessions and query. Verify CPU Consumption on the server is the first step any DBA should do for a top-down approach […]

Read the rest of this entry »