Posts

Oracle EBS R12.2 Weblogic Admin Server Fails To Start Issue

 -- Oracle EBS R12.2 with Weblogic 11g ------------------------Error Description------------------------------ # While Starting Application With up_app.sh, Following Server Runs 1. OHS  2. NODE Mgr 3. Concurrent  ========================================================================================= But Admin Server Fails with Following Error in =====> adadminsrvctl.txt  ========================================================================================= Checking if the Node Manager is already up.. Connecting to Node Manager ... Successfully Connected to Node Manager. The Node Manager is already up. Starting server AdminServer ... Error Starting server AdminServer: weblogic.nodemanager.NMException: Exception while starting server 'AdminServer' ERROR: Unable to connect the AdminServer. StackTrace:  java.io.IOException at weblogic.management.remote.common.ClientProviderBase.makeConnection(ClientProviderBase.java:196) at weblogic.management.remote.com...
Post a Comment
Read more

Oracle Database Listener Configuration

Image
Since Listener is s Program to establish connection with the Database from other applications. Hence to establish a connection it must have a Database Service to Bind If no Service is binded then it listener will be working but showing no service in the LOG There are two type of  Service Binding in TCP/IP 1. Dynamic Service Registration Through Database . 2. Static Service Registration Through Listenr.ora .   1.  Dynamic Service Registration In this type of Registration,  service name is mapped in database in a way that, we either map listener description in the LOCAL_LISTENER parameter of the database or just add alisas in this parameter. Here I have just added the alias LOCAL_ORCLP and its detail string in mentioned in TNSNAME.ORA . You could also directly mention the string into the LOCAL_LISTENER PARAMETER Anyway, once this all is setup then we have two options to initiate the service,     1. execute the command Alter System Register     2....
Post a Comment
Read more

Oracle Weblogic Repository DB Users Password Reset

Image
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...
Post a Comment
Read more

Emailing With Large Text

 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   ...
Post a Comment
Read more

Migrate Blob Content Between Remote Databases

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...
Post a Comment
Read more

Oracle ORDS Pool User Password Changes

Image
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    ...
Post a Comment
Read more