Author Archives: compitionpoint - Page 2
LOGIN PAGE SHOWS BLANK IN Oracle Applications R12
I have installed 10gR2 on linux environment, When running DBCA it got filed with below error ORA-27125: unable to create shared memory segment SOLUTION: cd $ORACLE_HOME/bin mv oracle …
Generate Public and Private Keys using PuTTYgen
ORA-04068: existing state of packages has been discarded Cause: : ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package “XXX” has been invalidated ORA-04065:…
SIMPLE DATABASE CREATION
CREATION OF DATABASE IN COMMAND LINE: 1) Set Environment file: #su – oracle $pwd export ORACLE_SID=PROD export ORACLE_HOME=/u01/app/oracle/ export PATH=$ORACLE_HOME/bin:$PATH 2) Create Parameter file: $cd $ORACLE_HOME/dbs $ vi $ORACLE_HOME/ db_name…
Find Concurrent manager logs on Oracle Apps
Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location. cd $APPLCSF/$APPLLOG For ICM Log –> ls -lrt *$TWO_TASK* For Standard manager Log –> ls -lrt w*.mgr For…
UNIX Useful Commands
1) Find whether OS is 64/32 Bit Kernel in UNIX. uname -a 2) Find free physical memory in UNIX. free -m 3) Find CPU details in UNIX. cat /proc/cpuinfo 4)…
Imporatant – Concurrent Manager Issues
1) Running Note : In the case of a clone instance, it is strongly recommended to clean the non – existing nodes FND_NODE table contains the node entries of both…
New Feature – AFPASSWD utility in EBS 12.1.2
Oracle has introduced a new utility to change the Oracle E-Business Suite passwords in , AFPASSWD is an enhanced version of FNDCPASS utility. 1) AFPASSWD only prompts for passwords required…
Resolve archive gap between PRIMARY and STANDBY
A Physical Standby database synchs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby is less than 10-15 numbers, We…
Resolve huge archive gap between PRIMARY and STANDBY
A Physical Standby database synchs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby difference is huge (say more than…
Concurrent Manager Issue : FND_DCP.REQUEST_SESSION_LOCK / DBMS_LOCK.Request
Error in Concurrent manager logfile : ========================= Routine received a result code of 1 from the call to Possible resultCall to establish_icm failed The Internal Concurrent Manager has encountered an…