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...

In this post, I'll discuss some of the common errors being encountered during connection with MySQL Server and the best possible solution worked for me or someone- Problem-1 JDBC Connection Failure java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted to reconnect 3 times. Giving up  Solution Change JDBC url to include character encoding- jdbc:mysql://localhost:3306/databaseName? useUnicode=true&characterEncoding=utf8&useSSL=false &useLegacyDatetimeCode=false&noAccessToProcedureBodies=true&serverTimezone=UTC Problem-2 Connection Java-MySql: Public Key Retrieval is not allowed Exception in thread "main" java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed Solution Change JDBC URL to include alllow Public Key Retrival true- jdbc:mysql://localhost:3306/databaseName? allowPublicKeyRetrieval=true &useSSL=false; Ref- https://mysqlconnector.net/connection-options/

Recently I have come across an unusual behaviour of Oracle VM Server(Installed on bare metal) where VM manager is able to connect but when I try to start the server, it goes to state 'Starting' for indefinite time. Below are the environment, problem summary and solution worked for our environment- Environment- Oracle Linux 7.5 Architecture- x86-64 Oracle VM Server 3.4 installed on Bare Metal Oracle VM Manager 3.4 Problem Summary- There was some network changes in the environment that caused change in UUID of respective blade server and hence when we tried to start the blade servers, it goes to state 'Staring' continuously for indefinite period of time. Actually the servers were not started. Upon close observation and additional checks it has come to note that the UUID(Universal Unique Identifier) of respective bare metal server was changed. The same was seen in the log when I tried to 'REFRESH' there server via OVM- LOG in O...

Recently I have come across a strange issue while working with Oracle Linux. Below are the environment details, problem summary and solution worked for my environment- Environment- Oracle Linux 7.5 Architecture- x86-64 File System- XFS Type- VM VM running on - Blade Servers VM Manager- OVM 3.4 Problem Summary- There was some issue with network and hence the blade servers that caused my oracle linux startup issue, below error shown during the startup maintenance mode- piix4_smbus 0000:00:01.3: SMBus base address uninitialized - upgrade BIOS or use force_addr=0xaddr Symptoms Server shows this message at the console at boot or in /var/log/dmesg   Cause The warning message is harmless and caused by the device's PCI config register 0x090 being set to 0. When the kernel module i2c-piix4 tries to read the PCI config register, it reads the 0 which causes the i2c-piix4 module's initialization to fail with -ENODEV Solution If you want to av...

Recently I have come across an issue associated with Oracle Webcenter Content 12c(12.2.1.3) content server. Below is the short summary of the same Problem Statement-   Content Server started but issue encountered while accessing the content server and shows an error message-  CONTENT SERVER REQUEST FAILED Unable to execute service GET_SYSTEM_CONFIGURATION_PAGE and function prepareSystemConfigPage. The error was caused by an internally generated issue. The error has been logged. Below is the generated log- <Sep 27, 2018 3:56:45 PM IST> <Warning> <Socket> <BEA-000449> <Closing the socket, as no data read from it on 192.168.0.132:53,326 during the configured idle timeout of 5 seconds.>  <Sep 27, 2018 4:52:37 PM IST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "CSDS" failed with exception: "java.sql.SQLRecoverableException: IO Error: Connection reset...

Recently I have been involved in setting up production environment for oracle WebCenter portal 12c(12.2.1.3) where I have faced the issue of  Portal Server Startup. "Portal Server was started successfully but the Portal Spaces Link shows an empty screen rather than the login screen" Assuming Oracle WebCenter Portal12c product has been installed & respective domain has been configured. Below are the steps to produce the issue- 1. Start Admin Server 2. Start Node Manager 3. Start Managed Server ' WC_Portal'  via WebLogic console 4. Check starts of managed server, RUNNING. Open the Portal Spaces URL- http://10.0.144.207:8888/webcenter but it shows blank screen as shown below- Possible Cause-   Insufficient memory to initialize portal spaces The WC Server cannot allocate additional memory. Java Heap Space Issue Java heap space has been depleted. I have tried below possible solutions to get it working back: Option1: Weblogi...