How to Make Help Diagnostics Examine be Password Protected OR Not? 1. Login to Applications and choose the System Administrator responsibility. 2. Navigate to Profile System. 3. Search on %diagn%…
Read MoreHow to search for a pattern for all files under a given directory and its subdirectory. Examples with in COMMON_TOP we need to find all files that have the word…
Read MoreHow to get the process id of all active unix process that are related to f60web and build a script at run time to kill them, after executing this unix…
Read MoreSyntax: find {path} –type f –mtime +{days} –ls Eg: find /home/oraapp –type f -mtime +5 –ls
Read MoreSyntax: To find the files for specific size : find {path} -size +{size} –ls For files greater than 100mb find /home/oraapp –size +100000c -ls
Read Morei. To verify whether the patch has been already applied query for the patch number in ad_applied_patches as follows, select APPLIED_PATCH_ID, PATCH_NAME, PATCH_TYPE, CREATION_DATE from ad_applied_patches where patch_name=’patch_number; ii. Or…
Read Morea. Create a user using Create user ‘username’ identified by ‘password’; b. Then execute the following command in the sql prompt as the sys user, spool create_grants.sql set echo off…
Read Morea.Connect to the Oracle EBS b.Select system Administrator responsibility c. Choose Users->Define d. Create a user and give him the corresponding responsibilities e. then choose Profiles->system In that form uncheck…
Read MoreExecute the following query and give the request id when asked, that would display the location and name of the trace file generated. column traceid format a8 column tracename format…
Read More#Script to list the concurrent programs with trace enabled output_log=/tmp/practice/log.txt export output_log sqlplus -S apps/xxxxxxx << EOF spool $output_log set pages 1000 lines 1000 select a.CONCURRENT_PROGRAM_ID, b.USER_CONCURRENT_PROGRAM_NAME “Program_Name”, a.CONCURRENT_PROGRAM_NAME “Short_Name”,…
Read More