Database Blog

Oracle 19c Database Upgrade From 11.2.0.4 to 19.0.0.0 Using DBUA

Description:- There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below: Database Upgrade Assistant (DBUA) Manual…

Read More

Could not initialize the Service Manager FNDSM__ Verify that has been registered for concurrent processing

Cause The issued was found to have been caused by the FND_NODES table having incorrect node entries (old node from the source instance) and that no Service Manager was found…

Read More

SQL Profiles & Baselines

To check SQL Profile : select NAME,SIGNATURE ,STATUS,FORCE_MATCHING from dba_sql_profiles; ENABLE/DISABLE/DROP EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(‘coe_5273fz2cqkk80_3455548535′,’STATUS’,’DISABLED’); exec dbms_sqltune.drop_sql_profile(‘coe_5273fz2cqkk80_3455548535’); SQL Profiles for a sql_id set lines 1000 pages 9999 col name for a30 col…

Read More

Scripts to identify performance related issues.

one script to Identify all performace issue related to sql query Set echo off set trimspool on set define on column filename new_val filename select to_char(sysdate, ‘yyyymmdd-hh-mi-ss’ ) filename from…

Read More

Undo related queries

Undo Related Queries To check retention guarantee for undo tablespace select tablespace_name,status,contents,logging,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace select tablespace_name, status, count(extent_id) “Extent…

Read More

Long running requests

Long running Concurrent Requests:- 1.How to Determine Which Manager Ran a Specific Concurrent Request? col USER_CONCURRENT_QUEUE_NAME for a100 select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c where a.CONCURRENT_QUEUE_ID =…

Read More

Oracle Database Upgrade from 12c to 19c database Using Manual Upgrade

Introduction: There are different methods to upgrade an Oracle database from a lower version to a higher version. Oracle provides multiple methods to upgrade based on the version. A few…

Read More

R12.2 EBS Application Services

Group Services Scripts Purposes Root Services Node Manager adnodemgrctl.sh WLS Node Manager controls server instances within a domain providing automatic restart functionality. Web Administration Services WebLogic Admin Server adadminsrvctl.sh WLS…

Read More

Difference between R12.1 & R12.2

Category 12.1 12.2 Forms & Reports, Developer Home, Tools Home 10.1.2 – ORACLE_HOME 10.1.2 ORACLE_HOME OC4J/OHS/OPMN 10.1.3 – IAS-ORACLE_HOME OPMN, oacore-oc4j, oafm-oc4j, forms-oc4j, etc Fusion Middleware – OHS/WLS OHS –…

Read More

Clone 19c Oracle Home

a. Create a gold image of the 19c Oracle Home. $ cd $ORACLE_HOME/ $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent Successfully Setup Software. Gold Image location: /u03/database19c/db_home_2018-02-26_22-47-54PM.zip…

Read More