Sanjay Forum

Put these in one file.sql and run. ---------------------------------- set linesize 200 verify off pages 100 accept days char prompt 'How many days(Default - 1 day) :' select to_char(bit,'DD-MON-YYYY') DAY,round(sum(avgredoinmb)/1024,2) "Avg Redo in GB" from ( select         /*+parallel(a,8) parallel(b,8)*/         b.begin_interval_time bit,         b.instance_number inst,         (AVERAGE*60*(ROUND( TO_NUMBER ( CAST(b.end_interval_time as DATE) - CAST(b.begin_interval_time as DATE)) * 24 * 60 )))/1024/1024 AvgRedoInMB from         DBA_HIST_SYSMETRIC_SUMMARY a,         dba_hist_snapshot b where         a.snap_id=b.snap_id         and         b.instance_number=a.instance_number ...

-bash-3.2$ echo $FILE_EDITION run OR -bash-3.2$ grep -i file_edition $CONTEXT_FILE          <file_edition_type oa_var="s_file_edition_type">run</file_edition_type>          <file_edition_name oa_var="s_file_edition_name">fs1</file_edition_name> -bash-3.2$ OR $cd /$TWO_TASK/applmgr . ./EBSapps.env run     ====> Enables RUN filesystem . ./EBSapps.env patch   ====> Enables PATCH filesystem OR select ad_zd.get_edition_type from dual;

1. Node Manager is Weblogic Server utility to start, stop and restart Admin and Managed Server Instances from remote location 2. Node Manager is optional component in WebLogic Server but it is mandatory if you want to start Managed Server from Console 3. Node Manager is installed on physical machine and is not linked to any Domain. If there are multiple domain on one machine , all domains can use same Node Manager. Starting Node Manager: ========================== In R12.1.2 =========== cd $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/bin/ ./startNodeManager.sh OR cd $FMW_HOME/wlserver_10.3/server/bin/ ./startNodeManager.sh & In R12.2 ========== cd $FMW_HOME/wlserver_10.3/server/bin/ ./startNodeManager.sh & Stopping Node Manager: ====================== There is no specific command to stop node manager, you have to kill the process manually to stop the node manager. kill -9 `ps -ef | grep -i nodemanager.javahome | grep -v grep | awk {'print $2'} | head -1` NodeMa...

[AMD64] ormr122i@auohstest131 > md5sum refhost.xml 72530386ddd80d458b725b91c1c61da7  refhost.xml [AMD64] ormr122i@auohstest131 > vi new.txt [AMD64] ormr122i@auohstest131 > cat new.txt 72530386ddd80d458b725b91c1c61da7  refhost.xml [AMD64] ormr122i@auohstest131 > [AMD64] ormr122i@auohstest131 > md5sum -c new.txt refhost.xml: OK [AMD64] ormr122i@auohstest131 >

sqlplus using prelim option: ============================= $ sqlplus -prelim "/as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 15 12:40:50 2010 Copyright (c) 1982, 2009, Oracle.  All rights reserved. SQL> The -prelim option stands for "preliminary connection". What it means is that sqlplus will only complete 2 of the below 3 steps of connection establishment: When you log on normally (even as SYSDBA), this is what happens:     1. A new Oracle process is started (either by the listener or by local sqlplus if using the local BEQ connection)     2. The new process attaches to SGA shared memory segments (so it could access all the needed SGA structures)     3. The new process allocates process and session state objects and initializes new session structures in SGA

Reference: ========== Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1) Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade (Doc ID 761570.1) 1. Patches to be applied on DB Patch 4247037 Patch 9858539 Patch 12834800 Patch 12942119 Patch 12951696 Patch 12985184 Patch 13001379 Patch 13004894 Patch 13258936 Patch 13366268 Patch 13477790 Patch 16706896 2. Refer Document 761570.1 to ensure that all patches for your specific database release are applied on the environment, before upgrading to     Oracle E-Business Suite Release 12.1.3.         Patches to be applied on MT Node (E-Business Suite Release 12.1.3 Upgrade , follow these steps:     1.Use AutoPatch to apply R12.AD.B.DELTA.3 Patch 9239089, before you complete any of the other steps in this section. Do not merge         this patch with any other patch. R12.AD.B.Delta.3 must be applied separately.  ...

    Note 1160285.1 - Application Technology Group (ATG) Product Information Center (PIC)     Note 1304305.1 - Concurrent Processing - Product Information Center (PIC)     Note 1411723.1 - Concurrent Processing Analyzer for E-Business Suite     Note 1499538.1 - Concurrent Processing Sample SQL Statements     Note 1057802.1 - Concurrent Processing - Best Practices for Performance for Concurrent Managers in E-Business Suite     Note 1399454.1 - Tuning Output Post Processor (OPP) to Improve Performance     Note 104452.1 - Concurrent Processing - Troubleshooting Concurrent Manager Issues (Unix specific)     Note 225165.1 - Patching Best Practices and Reducing Downtime     Note 957426.1 - Health Check Alert: Invalid objects exist for one or more of your EBS applications     Note 104457.1 - Invalid Objects In Oracle Applications FAQs  ...

Following query will check dependent table and the dependent constraint name. After that disable child first and then parent constraint. SELECT p.table_name "Parent Table", c.table_name "Child Table", p.constraint_name "Parent Constraint", c.constraint_name "Child Constraint" FROM user_constraints p JOIN user_constraints c ON(p.constraint_name=c.r_constraint_name) WHERE (p.constraint_type = 'P' OR p.constraint_type = 'U') AND c.constraint_type = 'R' AND p.table_name = UPPER('&table_name') / Parent Table                   Child Table                    Parent Constraint              Child Constraint ------------------------------ ------------------------------ ------------------------------ ------------------------------ CFA_ATTRIB ...

* Oracle GoldenGate is used to replicate and integrate transactional data with great speed among a variety of enterprise systems. * Oracle GoldenGate provides the flexibility to move data between like-to-like and heterogeneous systems,   including different versions of Oracle Database, different hardware platforms, and between Oracle and non-Oracle databases   including Microsoft SQL Server, IBM DB2 for open systems and z/OS, Sybase, and more. * URL = http://gavinsoorma.com/2010/02/goldengate-concepts-and-architecture/     http://gavinsoorma.com/category/goldengate/ Installation Videos: ==================== goldengate installation =====> https://www.youtube.com/watch?v=lb3UKpgCA1U Oracle GoldenGate Deep Dive Hands on Lab - Part 1 =====> https://www.youtube.com/watch?v=5Yp6bvGeP2s Oracle GoldenGate Deep Dive Hands on Lab - Part 2 =====> https://www.youtube.com/watch?v=bOnGgnjXdNo Oracle GoldenGate Deep Dive Hands on Lab - Part 3 =====> https://www.yo...

Oracle creates a memory area for processing an SQL statement, which contains all information needed for processing the statement. A cursor is a pointer to this memory area. PL/SQL controls the memory area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. There are two types of cursors:     Implicit cursors     Explicit cursors     Implicit Cursor:     =================     Implicit cursors are automatically created by Oracle whenever DML operations are performed,      Programmers cannot control the implicit cursors and the information in it.     Whenever a DML statement (INSERT, UPDATE and DELETE) is issued, an implicit cursor is associated with this statement.     For INSERT operations, the cursor holds the data that needs to be inserted.     For UPDATE and DELETE operations, the cursor identifies the rows that w...

In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases 1) Immediate 2) DEFERRED 3) False 1. Immediate : We can change the parameter in fly database ie Dynamic.(only need to change the value no need to bounce) 2. DEFERRED : We can change the parameter in fly database but this will effect after restart the database only.(here we need to edit using spfile and bounce the database) 3. False : Compulsory we need to down the database ie Static. Ex:- select name ISSYS_MODIFIABLE from v$parameter;

URL: https://docs.oracle.com/cd/E11882_01/server.112/e10839/appi_vlm.htm#UNXAR393 Enabling HugePages makes it possible for the operating system to support memory pages greater than the default (usually 4KB). Using very large page sizes can improve system performance by reducing the amount of system resources required to access page table entries. HugePages is useful for both 32-bit and 64-bit configurations. HugePage sizes vary from 2MB to 256MB, depending on the kernel version and the hardware architecture. For Oracle Databases, using HugePages reduces the operating system maintenance of page states, and increases Translation Lookaside Buffer (TLB) hit ratio. The following are the advantages of using HugePages:     Increased performance through increased TLB hits.     Pages are locked in memory and are never swapped out which guarantees that shared memory like SGA remains in RAM.     Contiguous pages are preallocated and cannot be used for ...

Problem: ========== While applying interim patch, I got Prerequisite check “CheckActiveFilesAndExecutables” failed error and resolved the issue with the help of fuser. Cause: ======= Something is using oracle library. Solution: ========= I had solved the issue first looking at the log file and saw that the in use control made by fuser, this is also a clue for me to find who is using the library file. oracle@biasore>/sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1  /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: 29279m  oracle@biasore> oracle@biasore>ps -ef |grep 29279   oracle   22813  3717  0 21:18 pts/13   00:00:00 grep 29279 Here I found some thing is running 29279 pid.  oracle@biasore>kill -9 29279 After that I had successfully applied the patch.