As a database administrator, you may need to give someone else access to the database without giving them full control. For instance, you hire developers to maintain your databases, but you don’t want to give them the ability to access, delete or modify sensitive information. In this case, you must give them access to the database through […]
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,
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
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
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 a database. A service name is a logical representation of a database, which is the
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 »
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 »