Few frequently used SQL queries related to ASM : 1) Create Disk Group: Create Disk groups using the CREATE DISKGROUP statement and specify the level…
3 CommentsAuthor: Brijesh Gogia
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]
Few good questions on Automatic Storage Management (ASM) 11gR2: (Oracle ASM Interview questions) Q 1 Can an ASM file be contained in more than one disk groups…
4 CommentsWhen we were trying to connect to our upgraded 11.2.0.3 database, below error was thrown and we were not able to connect. $ sqlplus as…
Leave a CommentPosted by Arindam Mukherjee Recently I encountered an interesting performance issue while working with Oracle EBS seeded components and these issues are tied to wrong use…
Leave a Comment11.2.0.3 is the latest release (at the time of writing this post) for the Oracle database. The intent of this guide is to upgrade the current database version from 11.1.0.7 to 11.2.0.3.
The installation procedure for the new Oracle Database 11g Release 2 (11.2) installs the Oracle software into a new Oracle home. This is referred to as an out-of-place upgrade and is different from patch set releases for earlier releases of Oracle Database, where the patch set was always installed in place. Oracle strongly recommends that you follow the steps in this procedure to ensure minimal downtime for the upgrade process and integrity of the new binaries and software libraries.
Leave a CommentBrief Definitions related to Oracle Business Intelligence for novice : ========================================== 1) Oracle Business Intelligence Suite Enterprise Edition (OBIEE) – comprehensive suite of enterprise BI products…
1 CommentSometimes while using IE8 Browser you may get the below error instead of the login page ‘Unable To Authenticate Session” You may see such issue…
Leave a CommentSome useful scripts related to Oracle Apps (11i,R12) are listed. The list is updated regularly so keep coming back for updated version of this webpage.…
Leave a CommentApplication users in Oracle Apps (EBS) can be created from the front end as well as back end. The back end method for user creation can be used when you don’t have sysadmin access to the applciation or also it can be used to speed up the process when there are many userids to be created.
You will require apps access to connect to database to run the package fnd_user_pkg.
5 CommentsFigure 1 SCAN is new Oracle Real Application Clusters (RAC) 11gR2 feature. It gives a single name for clients to access oracle database running in…
3 Comments