12c

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 […]

Configure & Connect SQL Developer to Oracle Database (19c, 18c, 12c) 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 »

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 »

Installing Oracle Database 12c Software on Windows

This tutorial explains the different steps for installing Oracle Database 12c Software on Windows. 1. Launch the installation with OUI Launch the Oracle Universal Installer (OUI) to start the installation. Make sure all prerequisites are met to avoid errors during the installation. OUI is a consistant Java application which can be used to install, deinstall,

Installing Oracle Database 12c Software on Windows Read More »