ORA-28000: The account is locked
Introduction Encountering the ORA-28000: The account is locked error in Oracle databases can be frustrating. This error indicates that a user account has been locked, typically due to too many failed login attempts or security policies enforced by the DBA. In this article, we will explore the causes of this error and provide comprehensive solutions…
AdminDelete/Remove Non-Executing Data Pump Jobs in Oracle Database
Introduction to Data Pump Jobs in Oracle Oracle Data Pump quickly exports and imports large volumes of data between databases. It helps in database migration, backup, and data movement. in this guide, we will learn Remove Non-Executing Data Pump Jobs in oracle database. Understanding Non-Executing Data Pump Jobs Non-executing Data Pump jobs are those that…
Resizing and Extending Disk Space in Linux – A Comprehensive Guide
We want to extend disk space or root partition volume of our server LINUX/CentOS / Oracle Linux without loosing data. Environment: We found this scenario in our environment that development team complaint that CentOS server mount point space is full and need to add additional space to the mount point /dev/centos/root. Server is deployed under…
How to Block Internet for a specific device in pfsense
To block internet access for a particular machine in pfSense, you can follow these steps: Step 1: Identify the IP address of the machine you want to block First, you need to find the IP address of the machine you want to block internet access for. You can do this by checking the DHCP leases…
How to install SQL Developer on Windows Operating System?
What is SQL Developer? SQL Developer is a free, integrated development environment that simplifies development and management. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts. SQL Developer System Recommendations For Windows OS: Following are minimum Recommendations Operating System: (Windows Server 2008 and Windows 10) CPU: Pentium…
How to install a suitable Java Development Kit (JDK 8 or Higher) on Windows?
What is JDK? Java Development Kit(JDK) allows you to code and run Java programs. It’s possible that you install multiple JDK versions on the same PC. But Its recommended installing Java on Windows 10 or higher with latest version. JDK is a java development kit whereas JRE is a java runtime environment that allows the java program to…
Resolving ORA-28040 Error: Fixing Authentication Protocol Mismatch in Oracle Database
In our development environment, users found the issue No matching authentication protocol while connecting to Oracle Database 19c through Oracle Client 8 or 9.2. The ORA-28040 error is an indication of a mismatch between the authentication protocol used by the client and the server. This article aims to provide insights into the ORA-28040 error, its…
How to Install JAVA JDK 16.0.2 in Windows OS?
Following are the Steps for JAVA Installation on windows Step-1: Download JAVA from JAVA Official Website From below links appropriate download JAVA for windows or other OS architecture (x86 or 64) after accepting oracle license agreement. https://www.oracle.com/java/technologies/javase-jdk16-downloads.html Step-2: Installation on windows OS Run the download JAVA installer file and proceed step by step installation process,…