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…
Enable/Disable Maintenanace Mode from SQLPLUS Session (Without adadmin)
We can enable or disable maintenance mode without using adutility (adadmin), Perform the same from SQLPLUS session. Check the current status of Maintenance Mode: select (‘APPS_MAINTENANCE_MODE’) from dual; MAINT = …
RMAN : Perform Block Recovery
We can perform BLOCK RECOVERY with or without RMAN BACKUP, Here is the demonstration of block media recovery with HOT BACKUP and RMAN BACKUP as well. 1) Create tablespace, user…