Digital Transformation . API . Integration . IAM

Problem Recently, my MySQL server 5.7.x wasn't starting rather it throws following error message Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.   MySQL Error Log-   /var/log/mysql/error.log 2020-07-20T14:34:56.131825Z 0 [Note] Server hostname (bind-address): '10.0.0.104'; port: 3306 2020-07-20T14:34:56.131862Z 0 [Note]   - '10.0.0.104' resolves to '10.0.0.104'; 2020-07-20T14:34:56.131895Z 0 [Note] Server socket created on IP: '10.0.0.104'. 2020-07-20T14:34:56.131913Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address 2020-07-20T14:34:56.131920Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2020-07-20T14:34:56.132002Z 0 [ERROR] Aborting 2020-07-20T14:34:56.132037Z 0 [Note] Binlog end 2020-07-20T14:34:56.132157Z 0 [Note] Shutting down plugin 'ngram' 2020...

Recently I have been doing the setup of Oracle Middleware products where I came across two type of data sources that are recommended for RAC database connectivity. They are- Active Grid Link/Grid Link Multi Data Source The question arises which one should I use and why? And, the answer is - Active Grid Link (AGL) Below are some facts provided by Oracle- AGL is a superior implementation to Multi Data Source (MDS) for supporting RAC clusters. The following section provides additional information on the benefits of AGL data sources. AGL: Requires one data source with a single URL. Multi data sources require a configuration with n generic data sources and a multi data source. Eliminates a polling mechanism that can fail if one of the generic data sources is performing slowly. Eliminates the need to manually add or delete a node to/from the cluster. Provides a fast internal notification (out-of-band) when nodes are available so that connections are load-balanced to...

Recently I have faced the issue of Weblogic server start error of my Oracle SOA/BPM environment. The Weblogic server says-  ================================================== Weblogic Server Start Error: Caused by: java.sql.SQLException: ORA-28001: the password has expired ================================================== In my this post, I'll share the details how can you make your Weblogic  overcome this issue by manipulating the database. So let's get started- Login to your SOA machine (My environment Oracle Linux , choose yours) using oracle user. 1. Go to DB home  bin directory-  cd $ORACLE_HOME/bin 2. Connect to sqlplus with / sysdba privileges. ./sqlplus /nolog; SQL>connect / as sysdba; 3. Now check the accounts belonging to SOA Server SQL> select username from  dba_users where account_status='EXPIRED' and username like '%SOA_%'; Result looks like- USERNAME ------------------------------------------- SOA_IAU_APPEND SOA_STB SOA_UMS SOA_MDS SOA_SOAI...

Hi folks, I am going to write some basic MySQL administrative commands in this post. So let's get started- Create New User in MySQL Database Login to MySQL with super user preferably root or user with full rights Execute below command CREATE USER 'username'@'hostname' IDENTIFIED BY 'YourPassword'; Example:  CREATE USER 'fmsuser'@'192.168.0.121' IDENTIFIED BY 'Pass1@210617'; Drop User in MySQL Database Login to MySQL with super user preferably root or user with full rights. Execute below command DROP USER 'username'@'hostname' Example:  DROP USER 'fmsuser'@'192.168.0.121' List All Users in MySQL Database  Login to MySQL with super user preferably root or user with full rights. Execute below command SELECT * FROM mysql.user Create New MySQL Database Login to MySQL with super user preferably root or user with full rights. Execute below command CREATE DATABASE newDBName DEFAULT CHARAC...

In this post I am going to showcase the way we can add a new JDBC connection resource to our Weblogic server and once created we can use the same for our web applications being deployed on this Weblogic server. So let's get started- I have attached all step wise screenshots for easy understanding: I have used settings for Weblogic Server Version 10.3.6. Similar way is to do with other versions. First Login your oracle Weblogic server console- http://192.168.56.101:7001/console/. And now go through the below steps: