Sandeep Panchal Blog

Prepare the DB home for R12 upgrade: Oracle 10gR2 Database Preparation Guidelines for Oracle E-Business Suite Release 12 Upgrade (Doc ID: 403339.1). Upgrade Path for Systems with 11.5.9 CU2 or 11.5.10.2 with a 10.2.0.3 Database Path E is applicable for E-Business Suite systems already on either 11.5.9 CU2 or 11.5.10.2 and currently running 10.2.0.3 of the database. Systems in this category have databases not yet upgraded to 10.2.0.4, and whose administrators plan to continue using version 10.2.0.3 after upgrading to Release 12.0.4. While this is supported, Oracle recommends that users upgrade the database to the latest patch set of Oracle Database 10g Release 2 available (currently 10.2.0.4). Path E follows the R12 upgrade path as documented in the Oracle Applications Upgrade Guide: Release 11i to Release 12.0.4. During the Migrate database to Oracle10g Release 2 step in Chapter 3, apply database patches to the existing 10.2.0.3 Oracle home and perform all tasks documented in the...

GSS for ALL got struck. ( Reason: Gather Schema Statistics concurrent program hung on an external tables. GSS can't collect stats on external tables) SOL: This problem is a known bug and Oracle has given patch 5876047( This patch modifies FND_STATS package to exclude gathering statistics on external tables) for it. Gather Schema Stats Failed With Ora-1 Errors After Applying Patch 5876047 Note:470556.1: Take a backup of the FND_STATS_HIST table Truncate table FND_STATS_HIST Re-submit Gather Schema Statistics program. You do NOT need to truncate this table after each run of Gather Schema Statistics. Doing it once will be enough, because each run of GSS will use a new request_id

SELECT A.KSPPINM FROM X$KSPPI A,X$KSPPSV B WHERE a.indx=b.indx;

Database Name. It is the name of the physical database structure. It is stored at the controlfile and datafile header. It is used to identify all physical structures that belong to the same database. It can be defined at install time. It is originally defined by the static instance parameter database_name, and it cannot be changed, and the only way to change it is by means of rebuilding the controlfile and resetting the log sequence. Instance Name. It is the name of the memory structures + Background process (MEM + BGP) use to mount/open a database. In a RAC environment there are more than one instance opening the same database, and each instance has a different name. On a single instance (non rac) environments, the instance name and the database name are named (generallly) the same. There is no reason to name the instance and the database differently. Instance name is defined by the ORACLE_SID environment variable (unix) and by the windows service name (windows). In a connect stri...

After so many tools and manual removal of vmware...I found the best document for vmware uninstall. http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1308 You can use registry mechanic and revo uninstaller pro for uninstall and registry fix. vmwaresetup.exe /c on windows cleans up any failed installation of vmware server

For applications:(There are many ways to do it...This is one of ...) SELECT product_group_id GroupID, product_group_name GroupName, release_name Release, product_group_type GroupType, argument1 FROM fnd_product_groups; For database. (There are many ways to do it...This is one of ...) SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production PL/SQL Release 9.2.0.6.0 - Production CORE 9.2.0.6.0 Production TNS for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production NLSRTL Version 9.2.0.6.0 - Production SQL> select COMP_NAME,VERSION,STATUS from dba_registry; COMP_NAME VERSION STATUS ---------------------------------------- ------------------------------ ----------- Oracle9i Catalog Views 9.2.0.6.0 VALID Oracle9i Packages and Types 9.2.0.6.0 VALID JServer JAVA Virtual Machine 9.2.0.6.0 VALID Oracle9i Java Packages 9.2.0.6.0 VALID Oracle XDK for ...

Tracing executables has helped me a lot in the past in some difficult scenarios. Tracing is really helpful. This is interesting to read this. The following platforms support a trace utility that can be used to identify what a process is doing: O/S Version Trace Utility ----------- ------------------------------------------------------- Sun Solaris 2.x, truss, e.g.: Unixware 7.0 $ truss -aefo HP/UX 11 tusc, e.g.: @ (Download via: http://eigen.ee.ualberta.ca/hppd/hpux/Sysadmin/ ) $ tusc -afpo IBM AIX 4.x trace, e.g.: Log on as root. # trace -a -L 4000000 -T 2000000 -o ./trace.out; # owsctl start admin # trcstop # trcrpt -O exec=on,pid=on trace.out > trcrpt.1 Or if present sctrace, e.g.: $ sctrace -Amo $ prpt -p Note: 'sctrace' has been discontinued by Veritas Software Corporation Inc. (formerly The Kernel Group Inc) as off Jan. 8, 2002. Linux strace, ktrace/kdump, ltrace e.g.: $ strace -fo SGI IRIX 6.x par, e.g.: $ par -siSSo Compa...

I am trying to apply the developer patch 6194129 As a post patch step, I am trying to relink the forms executables using make make -f ins_forms60w.mk install : trying to fix this....... ld: 0711-773 WARNING: Object /u01/app/oradba01/product/dba01db/8.0.6/lib//libuimotif60.a[uirf.o], imported symbol xmTextFieldWidgetClass Symbol was expected to be local. Extra instructions are being generated to reference the symbol. make: 1254-053 Command "$(GENERICMSG)" expands to empty string. ld -brtl -o f60cgi -L/u01/app/oradba01/product/dba01db/8.0.6/lib/ -L/u01/app/oradba01/product/dba01db/8.0.6/forms60/lib/ /u01/app/oradba01/product/dba01db/8.0.6/forms60/lib/izcgi.o /u01/app/oradba01/product/dba01db/8.0.6/forms60/lib/izc.o /u01/app/oradba01/product/dba01db/8.0.6/forms60/lib/izs0main.o -ld2la60 -lcore4 -lld -lm `cat /u01/app/oradba01/product/dba01db/8.0.6/lib/sysliblist` -lm ; mv f60srvm /u01/app/oradba01/product/dba01db/8.0.6/bin/ mv f60webm /u01/app/oradba01/product/dba01...