JDBC (Java DataBase Connectivity ) in Oracle WebLogic – Overview
This post covers overview of connecting WebLogic Server to Database using JDBC. How to connect to Database from Oracle WebLogic Server : You first create JDBC Datasource (or multi data sources) and then deploy this JDBC datasource (or multi datasource) to WebLogic Server (or cluster) in Domain. Datasource: contains pool of database connections that are […]
Read MoreOracle E-business Suit Network Utilities
Performance issue is one of the most frustrating things in any application . Being a DBA if anything regarding to perfomrace, it comes to us . It is one of the critical task for DBA to make sure that Application is performing as per end users expectation. It is really very complicated to reslove those […]
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 MoreOracle Adaptive Access Manager 10g R3 – Released, New Features
Oracle on 20th Oct. released new version (10g R3 /10.1.4.5) of Oracle Adaptive Access Manager (Why OAAM version 10.1.4.5 is called as OAAM 10g R3 ?) A. Oracle Adaptive Access Manager (OAAM) is product for web access real-time fraud detection and multifactor online authentication. Main Functionality of OAAM is to protect against – Phishing – […]
Read MoreHow to update Workflow Administrator Role in Oracle Applications 11i/R12
If you want to see workflow details (owned by other users) or status diagram in Oracle Applications 11i/R12 then you should belong to one of responsibilities/user listed under WF_ADMIN_ROLE. By default (in 11i & R12) this role is set to user sysadmin (In old versions 11.5.8 or prior, it used to set to *) If […]
Read MoreAWR (Advance workload Repository)Report in Oracle 10G
AWR is an enhancement/upgradation of statspack, which help us to tune the database. Oracle Database 10g uses a scheduled job, GATHER_STATS_JOB, to collect AWR statistics. This job is created, and enabled automatically when you create a new Oracle database under Oracle Database 10g. GATHER_STATS_JOB, to collect AWR statistics every 1 hour . We can disable […]
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 MoreCustom Look and Feel (CLAF) in Apps 11i (Framework Pages)
This post covers overview of Custom Look and Feel (CLAF) in Self Service Pages (Oracle Apps 11i) and steps to troubleshoot look & feel related issues. . Custom Look and Feel functionality in 11i Framework Pages 1.User type in username/password to login to Apps 11i 2. System checks value of profile option Oracle Applications Look and […]
Read MoreOracle Database Recovery Scenario and Solution
The purpose of this article is to get acquianted with some of the recovery scenarios , this topic is useful for the folks who is having less experience and looking for good DBA exposure and preparing for interview . I am trying to jotting down both RMAN and normal database technique :- 1.Complete Closed […]
Read More