Davis Apps DBA

Sometimes we may forget the password we set for weblogic. At such times this method will be very much helpful.   Below is the step by step process to decrypt the password for weblogic. Take a backup of the boot.properties file Note the value of encrypted password Now invoke the WebLogic scripting tool                                                                                            sh wlst.sh Pass the values for Domain, service, encryption and password                                                  wls:/offline> domain = "<Domain Value>" wls:/offline> service = weblogic.security.internal.SerializedSystemIn...

After completed cloning of EBS-12.2.4, working on the post clone activities. When tried to change the APPS and SYSADMIN passwords using FNDCPASS utility faced the below issue. This is the first time I'm facing this issue. I can't understand why this issue has occurred as I didn't face any issues during cloning. Below is the step by step process to overcome this issue. Create two scripts 'rmcorejvm.sql' & 'corejvminst.sql' and execute them on the DB Tier. Content of rmcorejvm.sql connect / as sysdba set echo on set serveroutput on select * from v$instance; select owner, status, count(*) from all_objects where object_type like '%JAVA%' group by owner, status; execute rmjvm.run(false); shutdown immediate set echo off spool off exit Content of  corejvminst .sql set serveroutput on set echo on startup mount alter system set "_system_trig_enabled" = false scope=memory; alter database open; select owner, status, count(*) from all_objects where...

By default EM Express Console is not enabled in 18.1.0.0, 12.2.0.1 and 12.1.0.2 databases.  Below is the step by step process to enable EM Express Console in Oracle Database. In my environment, I had enabled the EM Console at PDB level. Before enabling the console listener status would be To enable the console and set its port Now confirm the listener is listening on the port '5500'. Now to open the port '5500' on DB system, follow the below steps Once the DB port is opened, update your security list in OCI console. To do this on an existing security list, follow the below steps. Open the  navigation menu . Under  Oracle Database , click ( Bare Metal / VM / Exadata)  ---> as per your environment Choose your  Compartment . A list of DB systems is displayed. Locate the DB system in the list. Note the DB system's  Subnet  name and click its  Virtual Cloud Network . Locate the subnet in the list, and then click its security list under...