Microsoft Excel is used by almost everybody. Here are some of the cool Excel features that everybody should be aware Excel has a powerful list of functions to solve various problems and tasks. You can use sum, concatenate, average, if. The list goes on 2) Auto Filter This is one of the best functions to use […]
7 easy and powerful feature of Microsoft excel you may not know about Read More »
How to change the weblogic password post-TXK 7 The below command is available only if TXK 7 is applied. 1. Shut down all application tier services except the Admin Server. On the primary node, run the command:$ <ADMIN_SCRIPTS_HOME>/adstpall.sh -skipNM -skipAdminOn all secondary nodes, run the command:$ <ADMIN_SCRIPTS_HOME>/adstpall.sh 2. Change the Oracle WebLogic Server Administration User
How to change Oracle WebLogic User Password in R12.2 Read More »
What is Table Monitoring in Oracle Table monitoring is checking for how many updates, deletes, and inserts happened in the tables so that we can find out if the statistics are stale or good for the table. It is a very useful functionality in gathering stats for the tables in Oracle How to Set the
Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL Read More »
R12.2 is the latest release in Oracle EBS area. The latest Patchset available is 12.2.13 We are presenting here the most sought over 40 question you must know about R12.2 Question 1: What is Online Patching? Answer: Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while
40 question you must know about R12.2 Read More »
Step-by-Step Installation of an EBS 12.2 Vision Instance R12.2 is the latest release in Oracle applications. Here we will be giving the snapshots and steps for the R12.2.0 installation. I will be giving here steps for multi-node installation of an EBS 12.2 Vision Instance The installation is similar to the previous release except for some
How to perform Installation of an EBS 12.2 Vision Instance Read More »
Invalidating all the passwords in the database (1) Start the database clone for the first time startup restrict (2) Clear all production credentials from the cloned database( This step is not mandatory, we can avoid it also) update SYS.user$ setpassword = translate(password,’0123456789ABCDEF’,’0000000000000000′)where type#=1 and length(password) = 16/update APPLSYS.FND_ORACLE_USERID setENCRYPTED_ORACLE_PASSWORD=’INVALID’/update APPLSYS.FND_USER setENCRYPTED_FOUNDATION_PASSWORD=’INVALID’,ENCRYPTED_USER_PASSWORD=’INVALID’/commit; (3)Shutdown the database shutdown
Steps to clear Production credential in cloned EBS instance Read More »
