Modern Oracle DBA

Step 1: Stop the Application services [testora@vtebz1 apps]$ cd $ADMIN_SCRIPTS_HOME sh adstpall.sh Step 2: Drop the DB links Step 3: Change the APPLSYS password FNDCPASS apps/apps 0 y system/manager SYSTEM APPLSYS <New password> 0 & Y are flags for FNDCPASS ‘0 ’ is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form) 'Y' indicates that this method is directly invoked from the command-line and not from the Submit Request Form. Log filename: L7535322.log Report filename: O7535322.out Step 4: Recreate the DB link  Step 5: Start Admin Server using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. Do not start any other application tier services. step 6: Log in to WLS Administration Console and Click Lock & Edit in Change Centre. In the Domain Structure tree, expand Services, then select Data Sources. On the "Summary of JDBC Data Sources" page, s

STEP 1--> Login to app server STEP 2--> Go to  directory $AU_TOP/forms?US STEP 3--> Move to ".fmb" file STEP 4--> Execute the below command to generate ".fmx" frmcmp_batch userid=apps/<apps_pwd> module=<form_name>.fmb output_file=<form_name>.fmx module_type=form batch=no compile_all=special (EX):-   frmcmp_batch userid=apps/apps module=JAINTAXT.fmb output_file=$JA_TOP/forms/US/JAINTAXT.fmx module_type=form batch=no compile_all= special (O/p):   Created form file /oracle/CLONE/apps/fs2/EBSapps/appl/ja/12.0.0/forms/US/ JAINTAXT.fmx Refer: R12: How to Compile a Form in Release 12 (Doc ID 1085928.1)

Step 1--> Open sqlplus Step 2-->Connect to user/password Step 3-->Following query execute you are command prompt exec DBMS_xdb.sethttpport('8007'); (EX) SQL> exec DBMS_xdb.sethttpport('8007'); PL/SQL procedure successfully complied Step 4-->After you can check oracle home page

[ERROR]:Domain might be locked by some other WLS user process Some validations failed, please check Step 1--> You can check This log file txkADOPValidations.log Step 2-->Start the Web logic Server admin console  Step 3--> Click on (Release configuration ) Button on the top left corner Step 4--> Logout of weblogic console Step 5--> Again run adop phase=prepare Refer: [ERROR]: Domain might be locked by some other WLS user process" and "[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script" (Doc ID 2042785.1)