Install Oracle Database Client Step by Step

To administer your Oracle Database remotely, you will need to connect to the database instance, especially from an SQL*Plus terminal. To be able to do that, you may install the Oracle Database Client and configure it correctly. The Oracle Client is a software suite allowing you to administer your database remotely, perform basic network configurations, …

Install Oracle Database Client Step by Step Read More »

Configure & Connect SQL Developer to Oracle Database (19c, 18c, 12c)

Oracle SQL Developer is a free Java based integrated development environment (IDE) that offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts. On the other hand, it simplifies database management through its user friendly interface. SQL Developer is available on Windows, Linux and Mac Os and is included in your Oracle …

Configure & Connect SQL Developer to Oracle Database (19c, 18c, 12c) Read More »

Oracle Database 19c installation requirements on Windows

Are you planning to install Oracle Database 19c on Windows? You need to make sure your environment meets the following requirements to avoid any installation issues. Checking the installation prerequisites is a very important step towards the creation of your database. It not only avoids installation errors, but also optimizes the performance of the future …

Oracle Database 19c installation requirements on Windows Read More »

Creating an Oracle Database 12c – Step by step

In this tutorial, we will learn how to create a database in Oracle 12c step by step using DBCA. With Oracle Database, you typically have a single database that hosts multiple applications. You do not need multiple databases to run different applications. Instead, you can separate the objects that support each different application into different …

Creating an Oracle Database 12c – Step by step Read More »

Shutting down and Starting the Oracle Instance

This tutorial describes the processes to shut down and start the Oracle instance. After installation, the Oracle instance is started, and the database is open for access by users with database accounts. At some point, you may want to shut down and restart the instance. This tutorial describes the startup and shutdown processes. Shutting Down …

Shutting down and Starting the Oracle Instance Read More »

Oracle Database 12c Network configuration

Oracle Database 12c Network configuration. This tutorial will help you completely configure your client/server network. For a client application and a database to communicate, the client application must be able to identify the database it wants to connect to, and the database must provide an identification. You can use a service name to connect to …

Oracle Database 12c Network configuration Read More »

Configuring a Listener in Oracle Database (12c, 18c and 19c editions)

In this tutorial, we will learn how to configure a Listener in Oracle Database (12c, 18c and 19c editions) step by step. Note: the same procedure works for the latest versions of Oracle Database (12c, 18c and 19c). Oracle Database Listener configuration Many times, users and applications connect to the database from a machine outside …

Configuring a Listener in Oracle Database (12c, 18c and 19c editions) Read More »