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 your Oracle …

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 »

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 »

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 »