Simple Steps to Find Password for an Application User in Oracle Applications
To achieve this you need to create a small package and run a query which I wrote below: Step 1: Create Package Specification CREATE OR…
Category: Others
ORA-32700: error occurred in DIAG Group Service
After applying patch set 7 on existing oracle (9.2.0.5) to upgrade to 9.2.0.8. The “Ora-32700 error occurred in DIAG Group Service “ occurred at the…
Deregister Application node (Apps tier) in Oracle EBS Environment
Case A: Removing a Node that not available for access (Physically not Available) and has been removed and destroyed. Case B: Removing a Node that…
Database Upgrade Problem & Solution List
Database Upgrade Problem & Solution List: 1. Error is related to timezone file (When upgrading 9i to 11g) 2. ORA-24247: network access denied by access control list…
Working with India localization after upgrade to R12
What are the patches required for indian Localization in Release 12? In Release 12, India Localization functionality is included in Base rollup patches itself (For…
Find log history per hours
SELECT TO_CHAR(FIRST_TIME,’YYYY-MM-DD’) DAY, TO_CHAR(FIRST_TIME,’HH24′) HOUR, COUNT(*) TOTAL FROM V$LOG_HISTORY GROUP BY TO_CHAR(FIRST_TIME,’YYYY-MM-DD’),TO_CHAR(FIRST_TIME,’HH24′) ORDER BY TO_CHAR(FIRST_TIME,’YYYY-MM-DD’),TO_CHAR(FIRST_TIME,’HH24′) ASC /
Trick and Tips
Trick and Tips List: 1. How to know total archive generated each houers 2. Find log history per hours 3. How to Change DBID and DBNAME? 4. How…
Section: A Create first Virtual Machine
Section: A (Create first Virtual Machine) 1. Create the windows folders to house the first virtual machines and the shared storage. F:>mkdir RAC1 F:>mkdir SHARED-STORAGE…
Useful Query
Query 1 To determine which databases are currently registered in the recovery catalog: SQL> SELECT * FROM RC_DATABASE; Query 2 To determine which tablespaces are…