FNDFS Error- unable to view Concurrent program LOG and OUT files
Simple way to find out SYSADMIN password in R12, Please review below for the same 1) Connect to APPS USER 2) Create PACKAGE and PACKEGE BODY. 3) Query for PASSWORD…
ORA-01031: insufficient privileges when connect as sysdba
Created new temporary tablespace: CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE ‘/u01/oracle/#8217; SIZE 2g; Make new temporary tablespace as default: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01; Dropping old temporary tablespace, Which is…
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…