How to start and stop PostgreSQL database in windows In this post, going to explaining how to start and stop the PostgreSQL database in windows. PostgreSQL starts and stop is different from the environment to the environment. Open Windows Services Press Windows+R, and type the services.msc and then you can find the PostgreSQL server service […]
Oracle Database User Unlock, Update, and Password Reset In this article, explaining how to unlock Oracle database user, update the password, reset the when the password expired. Unlock the database user Before going to unlock the database user, you can check the user status by using the following query. Syntax select username, account_status from […]
Apache Cassandra Database Installation in Windows In this article, I am going to show how to install Apache Cassandra Database in Windows. Apache Cassandra is a highly scalable, high-performance distributed database designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. It is a type […]
How To fix this issue This issue will occur due to lack of number process configured so that to fix this issue we need to update the Number of Process in this table V$RESOURCE_LIMIT. First of all check the configured number of process using the following query. SELECT * FROM V$RESOURCE_LIMIT WHERE RESOURCE_NAME=’process’; Output RESOURCE_NAME […]
COPYRIGHTS © 2019 - 2023 Narayana Tutorial. ALL RIGHTS RESERVED terms of service | privacy policy | returns and refund policy
