Oracle Issues & Resolutions

When Repository DB Schema Password  expires, then WEblogic Admin Server Could not be started, hence it will prompt following error in the Weblogic Admin  Console. ------------------------------------------------------------------------------------------------------------------------ Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-28000: The account is locked. Error Code: 28000         at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)         at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)         at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)         at org.eclipse.persistence.sessions.DatasourceLogin.connectToDataso...

 While using conventional PLSQL procedure, the Oracle UTL_SMTP.Write_Data have input parameter as varchar2 -- which has a limit of size, so while emailing large content through single Write_data, is not possible. so the solution is to pass the data to email through chunks. Below is the old Procedure. (Having trouble with size) CREATE OR REPLACE PROCEDURE SUPPORT_PORTAL.send_mail_html_new (    p_to            IN   VARCHAR2,    p_from          IN   VARCHAR2,    p_cc            IN   VARCHAR2,    p_bcc           IN   VARCHAR2,    p_subject       IN   VARCHAR2,    p_text_msg      IN   VARCHAR2 DEFAULT NULL,    p_attach_name   IN   VARCHAR2 DEFAULT NULL,    p_attach_mime   ...

Method #1  create table support_portal.dms_det2 as select * from dms_det@LINK_218 UPDATE support_portal.dms_det a    SET CONTENTSS =            (SELECT CONTENTSS               FROM dms_det2              WHERE     DOCID = a.DOCID                    AND DOCREVID = a.DOCREVID                    AND FILENO = a.FILENO                    AND FILEID = a.FILEID) Method#2 UPDATE support_portal.dms_det a    SET CONTENTSS =            (SELECT CONTENTSS               FROM dms_det@LINK_218              WHERE     DOCID = a.DOCID                    AND DO...

Below Error occurs when, DB Pool user's passwords expires or locked. Way Out 1. Find out your Pool Users, by directly going into the ORDS conf. folder  where you have configured it (Drive:\Oracle\ords\ords\conf), you will find Pool User's in those files. 2. Open These files to find out user name and set you password in PLAN TEXT in password TAG. Note : Do not Forget to Add  !    <---- This Sign before your password, it will instructs ORDS.war service to encrypt this password, if not added as I left in this example, it will not convert this plain text to encrypted form The Plain Text Password Will Automatically Encrypt into Encrypted Form like below, once we Run ORDS.war 3. Repeat Step#2 with all other Files. 4. Now change Password at DB level for these cited users (APEX_PUBLIC_USER & OTHERS) by connecting to database as sysdba and issue      alter user APEX_PUBLIC_USER identified by MYPASSWORD account unlock; 5.Run ORDS Service    ...

  Error While Opening: unable to launch the java virtual machine located at path msvcr100.dll My Architecture: PC : Core i5 5th Gen Windows 10 64bit  Resolutions: Copy   msvcr100.dll File from Any where to computer to the requied location, in my case required location is Java Home/JRE/BIN I copied from Windows/System32 to JavaHome/JRE/Bin Other Solutions : Jdeveloper Is Not Opening MSVCR71.dll is missing  (Doc ID 2732095.1) APPLIES TO: Oracle Applications Framework - Version 12.2 and later Information in this document applies to any platform. SYMPTOMS On : 12.2.6 version, SUPPORT Jdeveloper is not opening Unable to open Jdeveloper. Giving Error MSVCR71.dll is missing ERROR ----------------------- The program can't start because MSVCR71.dll is missing from your computer. Try to reinstall the program to fix this problem. STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Try to start Jdeveloper. BUSINESS IMPACT ---------...