Oracle database

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 »

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. Oracle database 12c exploitation Exploiting Oracle requires knowledge of the installation procedures: Prerequisites, pre-installation and post-installation operations. Kernel tree OFA standard Location of the configuration files An Oracle database administrator must know how to install the Oracle Software and identify the …

Installing Oracle Database 12c Software on Windows Read More »