Database Blog

ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [74]

Error : ===== ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [74] Scenario: ======= When we are applying the archives for recovering the database in the middle of a recovery we face this…

Read More

How to check currently active process

Untitled

Read More

Secure Configuration Guide for Oracle E-Business Suite Release 12 From Metalink

Security is very important factors for Oracle Apps DBAs. The Metalink Doc : [ID 403537.1], Secure Configuration Guide for Oracle E-Business Suite Release 12, Shares us the Guide for R12 Security…

Read More

AFPASSWD – New password utility in EBS 12.1.2

AFPASSWD: In R12.1.1 and before oracle EBS Versions EBS passwords are changed using FNDCPASS.AFPASSWD Usage and Syntax:•  -h – Displays help. From R12.1.2 Oracle has come up with another Utility…

Read More

FRM-92095 Oracle Jinitiator version too low

FRM-92095 Oracle Jinitiator version too low: Disable JRE 1.7 Auto-Update for All E-Business Suite and Oracle Forms End-Users Oracle Support advising all Forms and EBS users to urgently disable auto-update…

Read More

Oracle Standard Script to find all the Oralce Applications Product related details

One Stop Oracle Standard Script to find all the Oralce Applications Product related details In AD Top we have script by name adutconf.sql ($AD_TOP/sql/adutconf.sql) file which gives Product Group Information Multi-Org enabled…

Read More

EBusiness Suite Application Techstack component Versions

One Stop Standard Script to Oracle E-BS Application Techstack component Versions: Really Required for Apps DBAs MOS ID :601736.1 On Application Tier Establish the needed environment parameters by sourcing the…

Read More

Recovering Block Corruption when the block does not belong to any segment

Let me Share one of my recent incident , where im suppose to recover the block which was marked as corrupted and the same was found belongs to free extent…

Read More

Purging/Archiving Partial Data from Very Huge Table

Real challange for DBA’s when they archive table , is when they perform partial data archiving from a very huge table. This is my case : I was pushed into a…

Read More

SQL*Loader-128: unable to begin a session , ORA-01017: invalid username/password; logon denied

Description : ========= The Custom upload program which is using the sqlldr was running fine till yesterday and there was no changes made in the server. But all of the…

Read More