Sorted by:  

How to Start an Oracle 12c Database

You don’t actually start an Oracle 12c database per se; you start the instance. A database is defined as the actual data, index, redo, temp, and control files that exist on the files system. The [more…]

How to Stop an Oracle 12c Database

Just as there is an order of events to starting an Oracle 12c database instance, there is also an order for how a database instance is stopped. Ideally, this is what happens during a database shutdown: [more…]

Basics of the Oracle 12c Recovery Manager (RMAN) Catalog

When setting up your Oracle 12c Recovery Manager (RMAN) environment, consider the recovery catalog. A recovery catalog is a repository for all your RMAN configuration parameters, backup operations, and [more…]

How to Use the Database Configuration Assistant (DBCA) to Create Databases in Oracle 12c

The database configuration assistant (DBCA) used in Oracle 12c has a lot of screens with all kinds of information. The following steps take you through the process: [more…]

How to Connect to the Oracle 12c Database Instance

An Oracle 12c database instance isn’t much good if you can’t connect to it. Establishing a reliable, persistent, and secure connection to the database from the client is essential. [more…]

How to Create Oracle 12c Tablespaces

Database objects are logically contained within tablespaces. In Oracle 12c tablespace is a logical storage container that houses physical data files in which database tables and indexes are stored. [more…]

Basics of Users and Schemas in Oracle 12c

Users not only access data in Oracle 12c databases, but they own the objects that contain the data. The set of objects owned by a user is its schema. Not all users own objects, so schemas may be empty. [more…]

How to Create Database Objects in Oracle 12c

Multiple object types exist in an Oracle 12c database, and it’s important to know what’s available. Periodically, Oracle adds new object types to extend functionality. New options within each object type [more…]

Object Creation Methods in Oracle 12c

As a database administrator (DBA), you’re expected to create objects, but you seldom create them from scratch, especially when you use Oracle 12c. Typically, the application developer or software vendor [more…]

How to Monitor Space in Your Segments in Oracle 12c

Segments are objects that take up space in the database in Oracle 12c. Segments are objects that, when created, allocated one or more extents from the free space in your tablespaces. The two most common [more…]

How to Check Users and Database Usage in Oracle 12c

Knowing what is going on within the Oracle 12c database is part of your job as a database administrator (DBA). You should regularly log in to your database to understand who is using it, what normal usage [more…]

How to Check Backups in Oracle 12c

Backups are an important, yet sometimes overlooked, part of database management. Checking your Oracle 12c backups should be a regular part of your daily routine. Checking backups includes these things: [more…]

How to Create a Scheduler Job in Oracle 12c

The Oracle 12c Scheduler example here creates a simple job that runs a stored Programming Language/Structured Query Language (PL/SQL) procedure. The procedure selects a count of the number of users on [more…]

Basics of the Oracle 12c Data Pump

Data Pump is modeled after Oracle 12c’s Export/Import tools that were available prior to Oracle 10g. Export/Import is still available, but Data Pump has taken the tasks traditionally done by Export/Import [more…]

Basics of Data Pump Export in Oracle 12c

The command-line program expdb launches Oracle 12c’s Data Pump Export. All Data Pump Export jobs are estimated at the beginning so you see the estimate before it runs the actual export. Remember that estimates [more…]

How to Use the Oracle 12c Data Pump with a Parameter File

A parameter file is a text file listing the parameters for Oracle 12c’s Data Pump Export or Import and setting the chosen values. Data Pump Export and Import parameter files are constructed the same way [more…]

Basic Tools to Tune Your Oracle 12c Database

Knowing what tools are available and how to use them will greatly improve your tuning proficiency with Oracle 12c databases. Have you ever tried to turn a screw with a pair of pliers? Using the wrong tool [more…]

Basics of User and Operating System Authentication in Oracle 12c

Authentication is about making sure your users are who they say they are. This process begins well before users try to access the Oracle 12c database. You need to set up a system or process that allows [more…]

Basics of Password Authentication in Oracle 12c

Password protection is the most common way to protect data in computer systems, including Oracle 12c. This truth applies to bank ATMs, websites, and of course your Oracle database. Password protection [more…]

Basics of Privileges in Oracle 12c

After you create a user, you have to decide what types of things the user can do in the Oracle 12c database. You probably want to allow the user to be able to log in, but you may need to limit whether [more…]

Basics of Object Privileges and Management in Oracle 12c

Deciding who privileges for databases is something every database administrator (DBA) has to determine. One type of privilege in Oracle 12c is object privileges [more…]

How to Create Roles in Oracle 12c

You can group privileges with database roles for ease of management with Oracle 12c. Instead of an object owner individually granting privileges to one or more users with similar job descriptions, the [more…]

How to Find Files with Recovery Manager in Oracle 12c

Recovery Manager (RMAN) is Oracle 12c’s backup and recovery solution to protect the files in your database. It can recover from things like lost rows or lost objects, but its primary purpose is to restore [more…]

How to Analyze Oracle 12c Error Messages

Ever hear the expression “hiding in plain sight”? That phrase often applies when people see an Oracle 12c error message. They see the message, but they don’t actually read it and think about what it says [more…]

How to Automate Chores with the Oracle 12c Scheduler

With the use of the Oracle 12c Scheduler, you can run almost any type of program with a robust resource-management and scheduling system. The Scheduler is intended to help you create and automatically [more…]

Sign Up for RSS Feeds

Computers & Software